/
OneSchool

OneSchool

Owned by Educonnex Support
Last updated: 12 Jan, 2025
3 min read

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

 

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

More information about this is available on the Checklist page in Booked 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 Booked 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 Booked as-is and will provide Booked 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 Booked navigate to:

Data > Upload Data

 

 

 

 

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