Importing Learning Records

Many hospitals and healthcare organizations that implement the Dual Code learning environment need to migrate learning records from their legacy LMS or in some cases, from spreadsheets that they've manually managed. The learning records can easily be imported into the Dual Code learning environment by uploading a CSV (comma separated value) file.

Assumptions

There are a few rules that need to be respected in order for the data migration to work:

• The encoding of the CSV file must be in UTF-8
• The first row in the CSV file must contain the name of the columns to be imported, These are:
  • actor
  • verb
  • object
  • timestamp
  • finalgrade

• The next rows in the CSV file will contain the learning record information that needs to be imported in the learning environment (one row per learning record)
• The actor must be the user's username as it exists in the learning environment
• The verb must be "completed" 
• The object must be the shortname of the course as it exists in the learning environment
• The timestamp must be in the following ISO 8601 format: 2016-06-28T15:19:21+00:00, where:
  • 2016-06-27 is the date in YYYY-MM-DD format (based on the Gregorian calendar)
  • 15:19:21 is the time in hh:mm:ss format (based on the 24-hour clock system)
  • +00:00 is the time offset from the UTC (Coordinated Universal Time). For example, an organization located in Ottawa or Toronto would write -04:00
• The finalgrade is a float value. Do not include a % symbol, ex: 93.75

Sample File

Here is an example of a valid file:

actor,verb,object,timestamp
jdoe,completed,WHMIS,2016-06-28T15:19:21-04:00
jsmith,completed,WHMIS,2015-04-21T10:00:00-04:00
jsmith,completed,Accessibility, 2015-04-21T13:00:00-04:00