Learn what data you can migrate for training histories
The format and specification of the migration template file, for each training history migration to LearnUpon.
File format specification
For your own CSV, include all columns in the template: leave a column blank if you have no data, but keep it in the file.
Make sure the CSV file uses UTF-8 encoding. Your uploaded file is more likely to import cleanly when encoded in UTF-8, rather than ISO or equivalent formats.
See Character encoding in CSV files: troubleshooting
| Column name | Description | Logic | Notes |
|---|---|---|---|
| Login ID | The unique identifier that your user will be using to log in to LearnUpon | This value finds the user in your portal, by their email address or username | Mandatory |
| Course Name | The name of the course that the user has been enrolled onto | LearnUpon creates an enrollment for this course name, for this user | This field cannot be blank. A blank entry makes the file invalid |
| Enrollment Created Date | The date the user was enrolled on the course, defined in the Course Name column in this row | LearnUpon sets the enrollment created date from this value | Optional field: if added, cannot predate 1970. Use d/m/yyyy format, with zero-padding optional. If left blank, LearnUpon inserts the migration date, by default |
| Enrollment Started Date | The date the user started the course, defined in the Course Name column in the same row | LearnUpon sets the enrollment started date from this value |
Optional field: if added, cannot predate 1970. Use d/m/yyyy format, with zero-padding optional. If left blank, LearnUpon inserts the migration import date, by default |
| Enrollment Completed Date | The date the user was completed the course, defined in the Course Name column in the same row. | LearnUpon sets the enrollment completed date based on this value | Required for enrollments that carry a completed, passed or failed status. Can be left blank for other enrollment statuses. If added, cannot predate 1970. Use d/m/yyyy format, with zero-padding optional |
| Enrollment Score | The score achieved for the enrollment on the course, defined in the Course Name column in the same row | LearnUpon sets the enrollment score based on this value | Required for enrollments that carry a passed or failed status. Do not use for a completed status. Format is a whole number between 0-100 inclusive: no decimal values accepted |
| Enrollment Status | The status of the enrollment being imported: indicates completion, pass, fail, etc | LearnUpon sets the enrollment status based on this status |
Valid values are:
Note: that if there is a score awarded and the status is not Passed or Failed, the application will reject the record |
| Enrollment Access Expires Date | The date the user's access to the course is revoked, and the learner can no longer launch the course | LearnUpon sets the enrollment access expiry date, based on this value |
Optional field: if left blank, the default is whatever expiry is set on the course itself, if any. If added, cannot predate 1970. Use d/m/yyyy format, with zero-padding optional |
Sample CSV template
The following template is available from this page:
Migration Templates - Training History Migration: a CSV file with columns which match the data specification