To import learning resources into CompetencyCore, you need to create a file that CompetencyCore can read. A separate import file is needed for each resource type. If competency and level names don't match the names in CompetencyCore, the import will fail.
Step 1. Open a new excel file
Enter 'Competency' in Column A as the header. Enter 'Level' in Column B as the header and leave the rest of the column blank. You only need to fill this column out if you're importing resources mapped to specific proficiency levels, which we'll explain in step 3.
Step 2. Add headers
Change the remaining field headers to your desired names such as Duration, Format, and Link. These fields do not need to already exist in CompetencyCore. They will appear in order from left to right, so the first field should be 'Name', followed by the others. The content you enter in these fields appears in PDF feedback reports. The more fields and content you add, the more space they'll take up in the reports.
Step 3. Map to specific levels
Contact your Client Success Specialist at HRSG to turn on the hidden setting so you can map to levels.
- To map a resource to one proficiency level, enter the name of the level in column B.
- To map a resource to multiple levels, enter the name of each level in column B, separating each with a forward slash (Level 1/Level 2/Level 3).
Step 4. Save the file in UTF-8 CSV format
Once you've completed the spreadsheet, click Save as and select CSV UTF-8 (Comma delimited) (*.csv).
Step 5. Go to learning resources
In CompetencyCore, click the menu icon on the top left of your screen and click Learning Resources in the main menu.
Step 6. Choose import
Click the 3-dot icon the to right of the page and choose Import from Excel.
Step 7. Select the file
Click Choose File, select the Excel file, and click the Import button.
Step 8. Select a resource type (or create new)
Select a category for the resources. Select an existing resource type or select Create New.
Step 9. Select field types
Create new: If you're creating a new resource type, enter a name and description and click Next. A list of the columns in your Excel file appears. Select a field type for each one. To use embedded hyperlinks or text formatting, select a text area. For plain text in small amounts, select a text box.
Add to resource type: If you're adding learning resources to an existing resource type, a list of the fields on that resource type appears. Select an Excel field to map to each one.