Summary
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.
| 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