...
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.
It is possible to add additional columns, e.g. Nationality. To do this please raise a ticket in the Schoolworks Service Desk or email support@schoolworks.co.uk
...
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.
It’s possible to check/uncheck the student data that will be uploaded by using the “Update” checkbox column on the left-hand side.
Typically on the first upload, ALL students are updated.
Click Submit to upload the data to the Group Members section.
Then click “Udate “Update Group Members” to commit the changes:
...