/
**OneSchool

**OneSchool

Owned by Educonnex Support
10 Jan, 2025
3 min read

This page provides instructions for EQ schools on how to extract the data required by PTO from OneSchool.

 

If you are using another method for obtaining parent and student consent to store data in PTO, then you may wish to add student and parent names to the data upload file before uploading to PTO.

More information about this is available on the Checklist page in PTO using the information icon shown below.


One School (EQ Privacy Safeguard Compliant)

Step 1.

Navigate to the Reports area of OneSchool and select Data Export Reports.




 

 

 



 

Step 2.

Run the “Student Class Export” and “Timetable Export” and save these files.

The results should be two CSV (Comma Separated Values) files with names along the lines of (numbers will differ each time):

• Export_Student_Class-3011100747159754.csv

• Export_Time_Table-3011100745163801.csv

Important:

When running the extracts, you are prompted for a date range. Please enter dates for the beginning and end of your NEXT timetable period (i.e., the next week or fortnight depending on whether your school has a one or two-week timetable cycle).

If you enter dates for the current period or earlier, you may get data that is out of date and incomplete.




Step 3.

Merge these files into a single file for upload of your data to PTO using the custom macro file we have developed to assist automate the data merge process.

 

 

  • Open this Microsoft Excel file.













  • Enable the Content (if this warning appears)





  • Click the button “Import One School Files”.







  • Follow the instructions shown on screen.


  • The resulting file can be uploaded to PTO as-is and will provide PTO with the data it requires to establish an event using Education Queensland’s data privacy protections.

 

 

Data Merge Macro File

Simply click this file to open it on your computer.



You may need to use the download icon in the top right of your screen
to download the file to your computer.







Step 4.


Within PTO navigate to:

Data > Upload Data

 

 

 

 

The resulting file can be uploaded to PTO as-is and will provide PTO with the data it requires to establish an event using Education Queensland’s data privacy protections.


 

 

 

 

Related content