How to use the Edrolo CSV template 2.0

Note: This article is about a new Edrolo feature coming soon 🎁

Use this article if:

Your school does not have a Timetable Integration with Edrolo (LISS, Compass, Wonde), or cannot export data via Timetabling Solutions, TES (E10) or Griddle.

1. Download and fill out the Edrolo CSV template

1. In Admin Hub, go to Timetabling and click Upload CSV

   

2. Click Download template to get Edrolo's CSV template

   

2. Fill in the Template with your school’s timetable data

1. Open the downloaded CSV file and input your school’s timetable data

   1. The downloaded file includes an example row, you can delete this row once you understand the required format

      

2. At minimum, every row needs a Student First Name, Student Last Name, Course Name, Class Name, and year levels

3. If you need further insight into each column’s requirements, you can click the drop down next to “What goes in each column” for guidance

   

4. Each time timetable data is uploaded after the first time, it MUST contain ALL the teachers, students and class details for all of your schools Edrolo classes
   1. Missing classes, teachers or students will result in them being removed when the data is processed as will be flagged in errors
5. Admin Hub will not accept your CSV if the columns are re-arranged

3. Upload your complete CSV file

1. Once you’ve filled out the CSV template with the school’s timetable data you can proceed to upload the file

2. To upload your file, drag your completed CSV file into the ‘Drop CSV file here’ area, or click to browse and select it. The files must be in .csv format and under 10MB.

   

3. Click Confirm

   

Note: If your file upload returns errors, please follow this article to resolve before proceeding

1. After uploading, check for the green ‘Validation passed’ message confirming your file has been validated

   1. Click confirm again to complete the data upload

      

2. You’re then ready to move onto Class Mapping

   

Continue on to Class Mapping

Open this article to commence Class Mapping

Still having trouble?

If your file keeps failing validation or you're not sure how to fix an error, email us with:

• Your school's name.
• A copy of the CSV file you're trying to upload.
• A screenshot of the error shown on the Review data screen.

If you have any questions, please feel free to contact us at help@edrolo.com.au and our friendly Customer Care team will be happy to help.