Time for action – preparing the CSV file
In order to enroll our students with existing accounts, we can use the spreadsheet that we used for the account creation. Follow these steps to prepare the CSV file that we'll use to bulk enroll our existing users:
Open the spreadsheet that we used for the bulk account creation and delete all of the columns except for those with the following three headings:
username
course1
course2
Simply delete the unneeded columns from the spreadsheet used earlier and add the information for the new course enrollments, as shown in the following screenshot. Note, the formatted file used for this example can be downloaded from www.packtpub.com/support.
What just happened?
Using the spreadsheet file that we used to create accounts, we have quickly modified the information contained in the file in order that it may now be used as a CSV file to enroll existing users in courses. We will use the Upload users tool again to accomplish this enrollment task.