Once a group enrolment has been created, use the Upload Students feature to automatically upload student information from a CSV file. This article will outline this process, discuss how to present the data and to ensure the data uploads successfully.
Instructions
Prepare the data in an Excel spreadsheet. To achieve a successful upload, areas to watch out for:
Data file column headings must exactly match the wording of the column headings in the Group Member section of the Group Enrolment. e.g. First Name, Last Name, Date of Birth
For Group Leaders (GL), type Yes in the Group Leader column for the selected Group Member(s) in the spreadsheet.
The data will load in the order of the data file; Group Leaders should always be placed at the top of list of Group Members in the data file.
If specific bookings have been created before the data is uploaded, e.g. Student Number 2 on the system has a different accommodation or meal type to the rest of the group, the student affected on the data file must appear as second on the list (in order to be linked to their specific booking).
The order of the columns in the data file does NOT need to match the order of the columns in the Group Members section.
A typical data file, in Excel, could look like this:
Once happy with the data, save as a CSV file.
In the Group Members section, click Upload Students:
Choose the file saved earlier as a CSV file and then click Upload File.
Once uploaded the screen will show:
(The system will present a message if there is an error in the data, e.g. a misspelling of Male or Female, allowing it to be corrected in your data file and uploaded again.)
Click Update Group Students and this will save the data.
Making Amendments to individual students
It is possible, from this point, to edit the list of students in the Group Members section. The options are:
Edit - to edit or add to any of the information for individual Group Members.
New - add new students (or Group Leaders) to the list.
NB if you have added students (Group Leaders) to different services (e.g. Course, Transfer, Accommodation), the new Group Members will need to be added into the bookings that apply to them. If you have set bookings to apply to STUDENTS (or GROUP LEADERS) the system will do this automatically.
3. Delete Students - allows individual Group Members to be selected to be removed from the group (and the bookings / finance adjusted accordingly)
Once the changes are made, Click Update Students
When to use Upload Students
It is recommended that the data upload of Group Member data is completed when the group is unlikely to change, to avoid the need to change the data too often. It is possible to upload the data more than once; any attempt to do will deliver the following message:
IMPORTANT - uploading student data more than once
We recommend only uploading the student data once. However, it is possible do this more often; however, if you upload again, the information in your data file WILL OVERWRITE the information already entered. This is acceptable if NO specific bookings have been made for specific students and everyone has the same course, accommodation and transfers booked.
To retain specific bookings against the correct student, they must appear in the same place on the data file that they do on the system. e.g. if student 3 in the Group Members section has a special diet already entered, then this student must appear in position 3 in the data file before it is uploaded. The same applies for Group Leaders.
To be certain that all bookings are retained against the same student we recommend that a check is undertaken to ensure that the order of students match on the data file to the Group Members section. And new students in the group should appear at the end of the data file. If students are no longer coming, they should be deleted from the Group Members section before uploading the data.
NOTE: once data has been uploaded once, the system will place the Group Leaders at the top alphabetically, based on First Name and Last Name. THEN, it will list students alphabetically, based on First Name and Last Name. If uploading a new file, please ensure the data file is sorted alphabetically prior to uploading (as per the above).
Student Uploads can be undertaken before and after Student Accounts have been created; however, new uploads should not be done once you have started to place students in their accommodation, as fresh uploads could change the student names in the Group Members section (if not in the same order), but it will NOT update the placements already made. This could create confusion with which student is staying with which host.
If you are attempting to upload data for more group members than in your Group Size, the following messaged will be presented:
IMPORTANT - the columns in your data file must match those in the Group Members exactly e.g. If the column in the system is headed Date of Birth, having a column heading of DoB will not work.
However, Schoolworks will ignore columns in your data that do not exist in the Group Members section, so these do NOT need to be deleted from your data file before uploading.
Schoolworks will also upload the data if there are sections of data missing; so if you are missing a Date of Birth, you can still upload the rest of the data (and add the missing one later by using the edit function).