So you’ve learnt how to mark a course as completed for an individual, here’s a reminder.
Imagine you’ve just created a new course and decided that not everyone has to complete it from scratch. And what if there are literally hundreds of people to update?
The good news is that you just need to prepare a CSV file that will do the heavy lifting for you! The better news is that there are just 3 columns of data in it:
The course code for the new course
The username of the person to force pass
The date that you want the reporting to show when they “passed” the course
… and it looks like this:
Here’s a quick way to get the information for this file.
Step 1
Get your data for the “old” course by using Report Builder:
Obviously yours will be different, but you’ll need 3 columns:
Course ID
Username
Last Completed
Filtered using:
Account Active
Course ID (for the “old” course that you want to replace)
Course Status (include if matches “Completed”)
… and then Export this as a csv file.
Now open your CSV file using your file editor of choice:
… and replace the old Course IDs with the new ones (and remove the headers row):
Now you should remove your old course from any learning profiles and then switch it off because we don’t want anyone else completing this course when we’ve just created our list of forced passes!
Make sure that your new course is available! If you don’t complete this crucial step then when you try and import your forced passes CSV file, it won’t actually do anything.
Step 2
Import your CSV file
From your Courses menu search for your chosen course and pick Complete Courses for Many from the 3 dots:
You’re almost there, all you need to do now is…
Step 3
Assign your new course to the relevant learning profiles:
… and any rules you’ve created using Link attributes to Courses
It’s always best to do this after you’ve completed the forced passes so that you don’t enable a learner to start a course from scratch that you’re going to force pass anyway.