CSV Upload to Mark Courses Complete for Users

I’ve never seen an LMS not allow completions to be loaded via CSV - let’s face it, just about everything superadmins do could compromise the data integrity if we didn’t do it correctly. 

I totally agree with what is said. I have worked on more than 6 LMSs and in all i was able to import completions via CSV being an admin. APIs are not known by all and it poses a challenge for most. Docebo should rethink about bringing it to SUPERADMIN role.

Yeah I would like to point out that every other LMS that I have had experience with has the ability to upload enrollment data via a CSV. And this is not even superadmin access in most, it is learning administrators. I have encountered many situations in which a company may only have a list of learners that are taking a course and that comes from a third party so it needs to be loaded in. Most now days are via API but the backup plan should always be the ability to CSV upload.

And it should also be where one CSV can handle multiple courses/sessions and not the current setup where you have to have a separate CSV for each course you want to enroll multiple people.

Just out of curiosity, I have built a pretty simple setup using the api to do this role of thing for some of our admins, if this was offered as a tool add-on our service for your instance, would groups be interested?

Totally understand, I should have been more clear. I understand this background, most of the members of my team are similar, so what I do is build tools for them that allows them to use things like CSVs to do what they need. I have done this for updating enrollemnts, completion status, add bulk users to manual groups, etc. For them I have a shared sharepoint site which they simply upload their file to and then it is processed in the background using the APIs and they are notified when complete and of any errors. I was thinking last night if this could be abstracted and packaged as a service for others.

Agree on the bulk enrollment update, when we did that main historical data migration docebo helped us with the large files that needed to include start date, completion date, score, time, etc. but for the smaller cleanup files that we just wanted to show completion, I loaded the users via csv and then bulk updated the enrollment status to complete. 

Where I can sincerely understand concerns with data integrity (heck I have lived with an LMS showing problems with its data - #hotmess)?

There needs to be some give on this one. Not being able to import course completions via CSV with completion dates and times (that are not external learning) needs to be thought through a bit more carefully...the “productized” solutions need to be expanded to meet the ongoing need as well as historical loading.

My game for the next few years is going to be helping people “see the light” and bringing them towards an implementation that involves migrating records as a one off as well as scheduled job.

Is there someway to resurface this idea and bring it back up?

Thanks @angel.maenza 

Well put...loading historicals now-a-days is a pretty standard function….

I’ve had to do this a couple of times and this is the way I’ve found that’s a few extra steps than having a CSV uploader would be, but still saves a lot of manual effort. Before figuring out this process, I hadn’t really even known that APIs existed, so I hope that most of us LMS admins without technical backgrounds won’t be intimidated by this!

NOTE that this only works if users haven’t been enrolled already. If you need to do this for specific learning objects instead of just the course level, you can do almost the exact same thing but with the call Batch insert of Tracking for Learning Objects and updating your CSV headers accordingly.

Historical Load Process using API:

1. Create course shell with unique Course Code

   

    

2. Create CSV file with the following headers: course_code, username, status, enrollment_date, completion_date, score
3. Fill out the columns with the data you need to import with a few notes:
   1. username - make sure it’s the docebo username, not the old username. sounds obvious but i’ve messed that up a few times.
   2. status should be “completed”
   3. enrollment_date needs to be in YYYY-MM-DD hh:mm:ss format
   4. completion_date needs to be in YYYY-MM-DD hh:mm:ss format
   5. score is a number between 0 and 100, also adding the score is optional. If you don’t need it just leave this column out.
4. Fill in the CSV with each record as a new row

   

    

5. If you have a CSV splitter tool, use that to split this file into many different files with 100 lines and have the headers in each file. Otherwise do this manually :( 
6. Open the API explorer in one tab/window. Scroll down to Enrollment > Batch import enrollments.
7. Authenticate by clicking OAUTH button and following the prompts
8. Click on the body sample so that it fills out the box, and then remove most of the body so that it looks like this
   {
     "items": 
   }

   

    

9. Open this CSV to JSON converted in another tab/window https://www.convertcsv.com/csv-to-json.htm
10. Upload your first file into the converter and then copy the output.

    

     

11. Paste the output after "items": in the API explorer

    

     

12. Click TRY
13. Hopefully if all goes well, it will tell you that it worked! If it gives you a syntax error, ask for help from someone who understands programming if you have to :(

    

     

14. Repeat steps 7-11 until you’ve run all of your CSV files. Put on some nice music and mindlessly click for a while - it will take less time than you think!

    

I have found this process super useful, hope this helps someone else :)

@gfenton never tried it for ILT but if you poke around in there, there’s lots of calls regarding sessions. Also there is a call to “Update enrollment of users to courses (Multiple update)” but it’s waaaay less nice :( You need the user IDs, not usernames, and works to update multiple records but with the same information - so you would need to run it for every day where a completion happened. I would definitely go for starting fresh if it’s possible.