Multiple Child Upload file for services using the DE Arrival system for attendances

PLEASE NOTE - This help article is only for EnrolNow services that DO NOT use EnrolNow SISO. If you are using EnrolNow SISO for attendances, please refer to this help article


The Department of Education has created two seperate multiple child upload files, with two different formats:

Template 1) For services using the DE Arrival system for attendances
Template 2) For services using an third party attendance system, such as EnrolNow SISO for attendances 

We have requested that the Department consider removing the differentiation between theses two file formats to ensure the most streamlined processes for all our customers. In the meantime, we expect that our customers who are not using EnrolNow's Digital SISO product will still reap some benefits of the Multiple Child Upload file (exported from your EnrolNow system) but with some manual updates to this exported file prior to uploading it into the Arrival system. 

We understand that services who have elected to use the DE Arrival System for Attendances will be need to follow one of two paths to complete the upload process

Option 1: Export and Upload the file as per the standard format and make add additional data points (parent name, phone and auth nom name and phone) in the Arrival system manually

Option 2: Export and Upload the file as per the standard format and make adjustments to the bulk upload file prior to uploading the data to the Arrival system.


Regardless of the option taken, the additional data required can be exported from EnrolNow for ease of update in Arrival. Please view this help video for more information on how to generate a report with Parent and Authorised Nominee details. 




The remainder of this help article explains the steps you will need to take to update the exported Multiple Child Upload file (csv) with the extra data required by DE. Please note: 

  • You will need some excel competency to complete these steps,
  • EnrolNow do not have access to the ARRIVAL system,

Instructions:


1. In the Children module in EnrolNow, use the top righthand button titled 'Arrival Export' to export the Multiple Child Upload file:




2. Once you have received the exported file via email, download and then open the file in excel.


3. Make the below changes to the file:


In summary you will be replacing (updating) 2 columns and then adding additional columns, specific instructions here, complete them in the order listed below:


COLUMN REFERENCE
(this must be competed in this order)
REQUIRED EDIT NEW DETAILS
AFchange column header titleParent/guardian 1's first name
AFremove all data from column and replace it with parent guardian 1's first name dataadd parent guardian 1's first name data
AGchange column header titleParent/guardian 1's last name
AGremove all data from column and replace it with parent guardian 1's last name dataadd parent guardian last name data
AHinsert a new column immediately after column AH and add title to new columnParent/guardian 1's phone number
New AI Columnadd dataadd parent guardian 1's phone number data
AQinsert a new column immediately after column AQ and add title to new columnParent/guardian 2's first name
New AR Columnadd dataadd parent guardian 2's first name data
ARinsert a new column immediately after column AR and add title to new columnParent/guardian 2's last name
New AS Columnadd data

add parent guardian 2's last name data
ATinsert a new column immediately after column AT and add title to new columnParent/guardian 2's phone number
New AU Columnadd dataadd Parent/guardian 2's phone number data
BCinsert 6x new columns immediately after column BC
BDadd column header titleAuthorised Nominee 1's first name
BDadd data
add Authorised Nominee 1's first name data
BEadd column header titleAuthorised Nominee 1's last name
BEadd dataadd Authorised Nominee 1's last name data
BF
add column header title
Authorised Nominee 1's phone number
BF
add data
add Authorised Nominee 1's phone number data
BGadd column header title
Authorised Nominee 2's first name
BG
add dataadd Authorised Nominee 2's first name data
BHadd column header title
Authorised Nominee 2's last name
BHadd data
add Authorised Nominee 2's last name data
BIadd column header title
Authorised Nominee 2's phone number
BIadd data
add Authorised Nominee 2's phone number data



4. Next delete the final 2 columns with group & program information, these are included for information purposes only and to support an easier process for our customers. Please use these columns to filter the report as required, but be sure to delete them before upload. 


5. When all columns edits have been completed and the data required updated, save the file as a csv and upload into the ARRIVAL system as per the Department of Educations instructions.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article