If you are missing some students data within HolidayActivities, you will need to assign your vouchers and then upload the missing children's details using a CSV file.
In order for you to order vouchers using a CSV upload, firstly you will need to log in to your HolidayActivities account.
Press Select applicable students.
Click Download CSV template.
Please enter the required details in the table and then save the document as a CSV file (please Google this if you are unsure as it varies depending on the program you are using). You do not need to provide an email address and phone number if the parent does not have both.
Please ensure the ‘Child date of birth’ column is formatted to show as a date format of DD/MM/YYYY (please Google this if you are unsure as it varies depending on the program you are using).
Click Browse and find your CSV file.
IMPORTANT: If there are any errors in your CSV file, it will not upload. Please see the top tips at the bottom of the article which may explain why it is not uploading.
HolidayActivities will flag if you have potential duplicates between your CSV file and the children on HolidayActivities (from your MIS). If this happens, you should edit your CSV file to remove any children who are already shown in HolidayActivities, and check there are no duplicate listings within the file.
Your CSV file is uploaded, and vouchers assigned to eligible children.
- Make sure the headings do not contain capital letters.
- Make sure you upload the file in CSV format.
- No spaces before or after text or between numbers.
- No extra punctuation or special characters other than full stops or @.
- Make sure the date of birth column is formatted as a date.