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.
...
actor,verb,object,timestamp,expires,finalgrade
jdoe,completed,WHMIS,2016-06-28,2017-06-28,90
jsmith,completed,WHMIS,2015-04-21,2016-04-21,100
jsmith,completed,Accessibility,2015-04-21,,85
jsmith,completed,Privacy,2017-07-21T15:19:21+00:00,2018-07-21T15:19:21+00:00,85
jsmith,completed,Privacy,2017-07-21T17:22:45+00:00,2018-07-21T17:22:45+00:00,95
New in 3.5.4.2: Please note that the "expires" column is required as of version 3.5.4.2. This column was not available in earlier version. If a learning record never expires, the value can be left empty. If it does expire, the value must be a valid date/time. See the Assumptions section below for more details on the date/time format.
...
While it is possible to generate your file by hand, we recommend that you go to the Learning Records 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.
When uploading LRS voids, ensure you select 'Update the void status only' for the 'Upload mode' on the upload screen.
Sample File
The text file to void learning records must be a CSV file. Here is an example of a simple valid upload file:
actor,verb,object,timestamp,expires,finalgrade,voided
jdoe,completed,WHMIS,2016-06-28,2017-06-28,90,1
jsmith,completed,WHMIS,2015-04-21,2016-04-21,100,1
jsmith,completed,Accessibility,2015-04-21,,85,1
jsmith,completed,Privacy,2017-07-21T15:19:21+00:00,2018-07-21T15:19:21+00:00,85,1
jsmith,completed,Privacy,2017-07-21T17:22:45+00:00,2018-07-21T17:22:45+00:00,95,1