How do I export data from One School?
As covered in our Enrolment Portal guide, the most efficient way to get your classes and students enrolled onto Education Perfect is by uploading a file that contains data from your export to our new Enrolment Portal. Check out our handy templates within the portal that can be utilised.
This guide outlines how you can export this data from One School.
1. Dynamic Student List Report
To begin, log into your One School account and select Dynamic Student List Report.
Select the year level or specific class you would like to export details for.
In the Display Fields section, select Year Level, MIS Id, and Roll Class.
For Report Render Type, select Excel. Then, click Generate Report.
If you have selected a single class, once you have downloaded the spreadsheet open it up and add your name and email address. Save your changes.
If you have selected multiple classes or an entire year level, you can skip this step as we’ll get this information from Step 3.
2. Student Class File Export
This information allows us to see which classes students from Step 1 are enrolled in, as well as the class code.
Begin by clicking on the School Management tab at the top of your OneSchool account page, then Timetable.
From here click on Main Timetable in the top left.
In the top right corner, click the Reports dropdown and then Class List Export.
On the screen that appears, select the details to include under Formatting Parameters, and click Generate Report.
- Year level
- Teacher Name
- Display classes
This will download an Excel file, which becomes the second file you need to submit to us in Step 4!
3. Teacher names and email addresses
If you are submitting information for one class or your classes only, you can skip this step.
We require teacher names and email addresses so that we can attach the correct teachers to their classes. You can provide this to us in a separate list, or add the information into an additional tab in the spreadsheet from Step 1.
If you need to export this in bulk, you can do this via mail.mis.eq.edu.au. At the bottom of the page, expand the drop-down Groups I am a member of.
Select the group name you would like to export, and then click the export button at the top of the page, and then Members.
The file should look similar to the below. While email addresses aren’t fully visible, we will use the MSID and add @eq.edu.au in bulk for you.
Next, we need to know which class(es) each teacher is associated with.
In the file you downloaded, add the class codes into the corresponding cells for each teacher listed.
You may be able to export a file from One School which provides teacher names, email addresses and classes in one file, which you are also welcome to provide.
Use your exported files to populate one of our enrolment templates within the Enrolment Portal.
Once you populate one of our enrolment templates with your exported data and upload this to our new Enrolment Portal, you'll be able to instantly add classes, teachers and students to the platform. Check out Step 2 of the guide linked above for more information on the formatting requirements of our portal.