How do I export data from One School?

As covered in our Enrolment Guide, the best way to get your students on EP is to send us an export of their details from your school's system. 

To get everything set up, from One School we need the following information:

  1. Dynamic Student List File (Containing student names and email addresses)
  2. Export Student Class File (Containing class names, students in the class, and associated teacher(s))
  3. Teacher names and email addresses from MIS

1. Dynamic Student List Report

To begin, log into your One School account and select Dynamic Student List Report.

Dynamic student list report option in Oneschool

Select the year level or specific class you would like to export details for.

SEt the year level and class

In the Display Fields section, select Year Level, MIS Id, and Roll Class.

For Report Render Type, select ExcelThen, click Generate Report.

Showing the Year Level, MIS ID, Roll Class, and render type options.

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.

Example of what the file looks like

2. Export Student Class File

This information allows us to see which classes students from Step 1 are enrolled into, as well as the class code and the name of the associated teacher.

Begin the same process as Step 1 again, however, select Class List instead of Dynamic Student List Report. 

Then, select the Year Level and Faculty

Setting options for student class file downloadHit Generate Report, and you will receive a PDF similar to the below.

Example of the PDF that will be downloaded

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 ofGroups options

Select the group name you would like to export, and then click the  export button at the top of the page, and then Members.

Export button for groupsThe file should look similar to the below.Example of what the file will look like

Note: While email addresses aren't fully visible, we will use the MSID and add @eq.edu.au in bulk for you.

4. Submit your files to us

Once you have completed the above steps, you can then send your files through to us by following the instructions in our article How do I enrol my classes?

If you run into any issues, please feel free to reach out to our Support Team for assistance at support@educationperfect.com.

Did you find this article helpful? Thanks! Click the speech bubble below to tell us more. There was a problem submitting your feedback. Please try again later.