Totara Learn Open Discussions

Uploading course completion records

 
Natalia Kurikova
Uploading course completion records
door Natalia Kurikova - Sunday, 25 February 2024, 19:09 PM
Groep Most helpful contributor 2023

Hi

I'm having trouble with uploading course completion records.

My csv file looks something like this: username,courseidnumber,courseshortname,customfield_sessionnumber,customfield_cousestartdate,completiondate,grade,customfield_duration

email@domain.com,HHHH01,First Aid,0001,13/10/2023,13/10/2023,Completed,1 Day

Previously, files with similar format would upload correctly (with Completed in Grade), but now I'm getting "The grade value is invalid".

What am I doing wrong? Has something changed recently? We're now on Version 15.27 (Build: 20240126.00).

Daniel Bond
Re: Uploading course completion records
door Daniel Bond - Monday, 26 February 2024, 00:50 AM
Groep Most helpful contributor 2023

I believe "grade" in this context is numeric, because the settings for the upload give you the options of "real" or "percentage" for the format. If there's no graded item in the course, you can pick 0 or 100 depending on personal preference (but it can't be null).

Natalia Kurikova
Re: Uploading course completion records
door Natalia Kurikova - Wednesday, 28 February 2024, 19:27 PM
Groep Most helpful contributor 2023

Thank you very much, Daniel, that has worked!

I do wonder, though, what changed recently, as we had 14000+ records that had been uploaded without any errors (still visible in the Course import report) with Completed in the grade and now it's only working with a numeric value. The learners are actually not assigned any grades for the training, but we'll have to settle on giving them 100 anyway.