When uploading learning records, either to create them or void them, the first step is to create your CSV file. Below are some instructions and guidelines to help you create your CSV file.
...
Optionally, you can specify the time as long as you follow the ISO 8601 format, such as 2022-12-01T15:19:21+00:00, where:
- 2022-12-01 is the date in YYYY-MM-DD format (based on the Gregorian calendar)
- (optional) 15:19:21 is the time in hh:mm:ss format (based on the 24-hour clock system). If you omit the time, the system will log the time as 12:00 AM. If including optional time you MUST include a time offset from UTC.
- (optional) +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. If you omit the the timezone, the system will use the system's default timezone.
- Alternatively, because Microsoft Excel automatically converts dates from YYYY-MM-DD to MM/DD/YYYY, you can specify your dates in the MM/DD/YYYY format, if and only if you do not need to specify the time of the learning record. If you need to specify the time / timezone of the learning records when importing them, you need to continue to use the ISO 8601 format described above.
...
In the past, this field was called "expires". The field name of "expires" will still work, but for consistency, our documentation now refers to "expires_on".
Final Grade Field
The final_grade field must appear in the 1st row of the CSV, but the value is optional. In other words, if the column is not in your CSV file, the upload will fail. But it's ok to leave the value empty for a learning record if you do not track grades.
final_grade
If specified, the final grade must be a float value. Do not include a % symbol, ex: 93.75. It is based out of 100. In other words, if you enter "9", the system will report that the user has a final grade of "9 out of 100".
...
If you add this column, a value of "1" will void a learning record while a value of "0" will unvoid a learning record. Leaving the value blank will leave the learning record's status unchanged. It is not possible to delete a learning record. You can only void / unvoid it.
When voiding (or unvoiding) learning records, the "completed_on" field must have the full UTC (e.g. 2022-12-01T15:19:21+00:00). Simply specifying YYYY-MM-DD will not void a learning record. For this reason, while it is possible to generate your file by hand, we recommend that you go to the Learning Records (System Level) report, find the records you want to void, and export them in a CSV file. Then, simply add the "voided" column to that exact same spreadsheet with a value of 1 for each record, and re-upload it as per the steps above.
Other Rules
There are a few other rules to keep in mind when preparing your CSV file:
...