Resolving Errors when Importing Learning Records
Problem
When importing learning records, the preview mode or final results may display error messages, which visually can be identified by a red X in the "Result" column and a detailed message in the "Status" column as per the screenshot below.
Solution
The error message in the "Status" column is self explanatory. The first part of the message explains the error and/or suggests a solution, and the second part shows the data that was included in the CSV file that resulted in that failure. Using the screenshot above as an example:
Timestamp must be in YYYY-MM-DD or ISO 8601 format: 2017-06-28T15:19:2122+00:00
The first part of the message (in red) explains that the timestamp is not in the appropriate format and suggests the format to use. The second part (in blue) gives the erroneous data that was in the CSV file (e.g. 2017-06-28T15:19:2122+00:00). In this example, the time of 15:19L2122 is erroneous because there are 4 digits where the seconds would be (e.g. 2122).
The preview mode only displays a subset of the results. You may get no errors in the records you are previewing (e.g. the first 10 records) but may get errors when you're actually importing the records in other records. You must address each and every error in your CSV file. If the error is not resolved, the learning record will not be imported into the learning environment.
If you have multiple errors, you can download the results in a CSV format by clicking on the link illustrated in the screenshot below. Once you exit that web page, the results cannot be downloaded, so make sure you download the results before exiting the page.
Important Notes
- You should always try to upload learning records to your staging server until the file is perfect. Only once the file is error-free should you upload it to the production server.
- Learning records cannot be deleted. They can only voided. So once again, only upload learning records to your production server once your file is error-free to save you from having to void learning records.
- If you get the following error message, it means there is something drastically wrong with the file. This error message for example would be presented to you if you tried to upload a Microsoft Excel spreadsheet instead of a CSV file.
- There is something wrong with the format of the CSV file. Please check the number of headings and columns match, and that the delimiter and file encoding are correct: Invalid CSV file format - number of columns is not constant!