Import Skills Process Overview

From SmartWiki
Revision as of 15:32, 3 January 2008 by Julia Decker (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The import process consists of four steps:

  • Copy the information to the Windows Clipboard.
  • Paste the information into the SmartSimple Import Window from the Clipboard.
  • Map the fields in the import data to the fields: category, skill and optionally the skill description fields.
  • Validate the information mapping before uploading.
  • Upload the data to SmartSimple.

1. Launch Microsoft Excel.

2. Open the spreadsheet Simple Skill List.xls. (or any spreadsheet applicable to you for this purpose)

Apl33.png

3. Review this data.

This spreadsheet consists of two columns: Category and Skill. When you upload this data into Applicant Tracking, the categories will be automatically created and the skills added.

Pasting Information into SmartSimple

  • Once the required information has been copied to the clipboard, it is pasted into the data window in the first step of the import wizard.
  • The Browser Edit Paste menu is used to paste the copied information into the SmartSimple import wizard data window.
  • Delimiters - The import process requires that a delimiter separate each field of information. This delimiter can be a comma “,”, a semi-colon “;” or a tab, with each row of information delimited by a “return”.
  • The delimiter is selected from the combo box at the top of the data window.
  • Field Names in the First Row.
  • In some instances, the data will contain the field names in the first row. Clicking the check box can indicate this: First row contains field names will enable this feature.
  • Removing Double Quotes - If the export process from the other application placed double quotes around each value, these are removed by clicking the Values enclosed by double quote check box.
  • Once the data is pasted into a window, and the appropriate options set, the Analyze button is clicked and SmartSimple will determine the fields

1. Select all the data – use Edit, Select All or press Control + Shift + End.

2. Select the Edit Copy menu or press Control + C.

3. Switch back to SmartSimple.

4. Click Applications, Applicant Tracking menu.

5. Click the Skills tab.

Apl34.png

The Categories and Skill window is displayed.

Apl37.png

  • You can use this window to manually add categories and skills, or use the import skills tab to add skills.
  • The Questions check box is used to indicate a question category.

6. Click the Import Skills window.

The Import Skill Wizard is displayed.

Apl36.png

7. Press Control + C or use browser Edit Paste.

The categories and skills are added to the import box.

8. Press Control + Home to move to the top of the list.

Apl38.png

This data contains the field names and is delimited by tab.

9. Set the Column delimiter to Tab.

Apl39.png

10. Click the First row contains field names check box.

Apl40.png

11. Click the Analyze button.

Apl41.png

The analyzed data is displayed.

Apl42.png

12. Map the second field to Skills.

Apl43.png

13. Click the Parse data button.

Apl44.png

The Category and Skill information is displayed.

Apl45.png

You can now de-select any skill that you do not wish to load.

14. Click the Upload button.

Apl46.png

The skills are uploaded, and the categories created from these skills are displayed.

Apl47.png

This skill list will be used when:

  • You manually add skills to an applicant profile.
  • An applicant creates a skill profile using a career site.
  • SmartResume scans a resume for applicant skills.
  • You use SmartSearch to match applicants to jobs.