Follow

Can I Import Users with Existing Course Data?

Absolutely! We provide the option to import all of your users' previous course progresses, including the days they started and finished the courses. You can also update your existing users' course progresses with this method -- just include their information as shown in the SkyPrep platform.

To do this, click on People, then click on Users. In the new page, click on Bulk User Management.

 24.png

 

In the Upload section, click on CSV Bulk Upload Template. This will download an Excel spreadsheet to your computer. 

 

 

Open the file, and delete the placeholder information. Fill in the spreadsheet as you would any other Bulk Upload, and if you are unsure how to do that, you can refer to this article. In cell P1 enter "Course 1", in cell Q1 enter "Course 1 Status", in cell R1 enter "Course 1 Date Started", and in cell S1 enter "Course 1 Date Finished". Continue this for your remaining courses, with each additional set of cells being named "Course 2", "Course 3", and so on.

 

 

In the Course X columns, enter the names of the courses exactly the way they're spelled in your platform. You want to do this for every user, even if they are not enrolled in the course. You can quickly do this by selecting a cell that has the course name in it, clicking on the dot in the lower right corner, then dragging it down to include all of the rows. If your course name ends with a number, you will need to highlight two cells with the name included instead of one.

 

 

In the Course X Status columns, you will need to enter either not-enrolled for users that are not enrolled in the course, not-started for users that are enrolled but have not started the course, passed for users that have passedand failed for users that have failed the course.

 

 

In the Course X Date Started and the Course X Date Finished columns, enter the corresponding dates in dd/mm/yyyy format. For example, September 15th, 2016 would be entered as 15/09/2016. If a user has not been enrolled in a course, leave these two columns blank, if they are enrolled but have not completed the course, only fill in the Course X Date Started column, and fill in both the Course X Date Started and the Course X Date Finished columns if they have finished the course.

 

Once this has been done, save the document. Go back to the Bulk User Management section, and click on the Update (Prefilled) secton, NOT the Upload section. Click on Choose File (this may differ depending on the browser that you are using), and select the file. Next, click on the Update Users button. If you have more than 500 users, it is recommended to split the CSV file up into parts that contain 500 users (just ensure that all parts contain the first row with the headers).

 

Once that's done, all of your new users will be imported into your platform with their course progresses saved. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments