Skip to content
  • There are no suggestions because the search field is empty.

Importing historical Student completion records

Bring completion history from another LMS into CourseMill in the right order without triggering emails or bad due dates.

You can import historical student completion records from another LMS. Follow these steps and considerations so the imported data is created correctly.

Before you begin

  • Be sure all users already exist in CourseMill. For users not currently in CourseMill (both active and inactive), load them into CourseMill with as much information as possible before 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 exist in CourseMill. If they do not, create the courses before 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.

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.

Import historical records
  1. If any of the courses have due dates and/or re-enrollment days, turn them off (remove them) before the historical data import. This is recommended.
  2. Turn off the course enrollment notification so emails do not go out for this history. Check all other notifications as well.
  3. Import the students' 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 for the next step, importing the completion statuses, pass dates, and scores.
  4. Import the students' historical course completion statuses, pass dates, and scores. When a student has multiple completion statuses for a single course (a repeated course over a period of time), import the records from oldest to newest. See the examples below.
  5. If a course previously had due dates or re-enrollment days, you can now put them back (turn them on) on the appropriate courses. The next time the user logs in, the due date is calculated on the newest course completion record.

Ordering records for the same course

Columns in the import file: OrgID, ID, LastName, FirstName, CourseID, SessionID, PassDate, CourseStatus, Score.

Incorrect ordering for the same Course ID (newest first)

  • OrgID TestOrg, ID Ipra1234, LastName Prather, FirstName Linda, CourseID History101, SessionID 869, PassDate 2013-02-15, CourseStatus Completed, Score 100
  • OrgID TestOrg, ID Ipra1234, LastName Prather, FirstName Linda, CourseID History101, SessionID 567, PassDate 2012-06-30, CourseStatus Completed, Score 82

Correct ordering for the same Course ID (oldest first)

  • OrgID TestOrg, ID Ipra1234, LastName Prather, FirstName Linda, CourseID History101, SessionID 567, PassDate 2012-06-30, CourseStatus Completed, Score 82
  • OrgID TestOrg, ID Ipra1234, LastName Prather, FirstName Linda, CourseID History101, SessionID 869, PassDate 2013-02-15, CourseStatus Completed, Score 100

Related articles