Be sure all users already exist in CourseMill. For those users not currently in CourseMill (both active and inactive), load them into CourseMill with as much information as possible prior to importing any of their historical course data (sub-org values, personal information if any, demographics such as address, and so on).
Be sure the course IDs and content already exists in CourseMill. If they do not, you will have to create the courses prior to importing the historical course completion data. Each course must have at least one content item (this could be as simple as a Graded-No-Content attendance record).
|
If any of the courses have due dates and/or re-enrollment days, it is recommended that you turn them off (remove) prior to the historical data import.. |
Import the student’s historical course enrollments first, using the old enrollment date (courses must already exist in CourseMill). Performing the enrollments first is a good way to ensure the data was created as expected. This file can then be used as a template to perform the next step importing the completions statuses, pass dates and scores.
|
|
Be sure the course enrollment notification is turned off so the emails do not go out for this history. Check all other notifications as well. |
Next, import the student’s historical course completion statuses, pass date and scores.
|
|
.When importing historical records with students that have multiple completion statuses for a single course (a repeated course over a period of time), import with the oldest record to newest. |
If a course previously had Due Dates or re-enrollment days, you can now put them back in (turn on) on the appropriate courses. The next time the user logs in the due date will get calculated on the newest course completion record.
|
|
.Warning: Failure to remove due dates on a course prior to importing the historical data will result in incorrect data entered in the expiration date. Incorrect ordering for the same Course ID:
Correct ordering for the same Course ID:
|