Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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:

...