TABLE OF CONTENTS
Preamble
Timetabling data that exists in Tes Timetable files are usually sent on to one or more other non-Tes systems, such as student learning management systems, reporting systems, administration systems, and many more. The Tes integration team works with other systems to make sure that the data required to be sent is in the correct format.
This document can be referenced for:
- New school file set up
- Synchronisation processes
While Tes takes all care to ensure any mention to the other system is correct and up to date, it is the user's responsibility to check with the other system prior to an initial sync. If the user becomes aware of any changes to the other system, we would very much appreciate this feedback.
Type of sync
This sync is performed by exporting a txt file that has been correctly formatted, ready uploading into Accelerus (MarkBook).
The Accelerus (MarkBook) export function will export following CSV files:
- Classes.csv
- Cohorts.csv
- Enrolments.csv
- Students.csv
- Subjects.csv
- Teachers.csv
Which data is sent to the other system?
This table lists many of the data and features found in Tes Timetable and, where known by Tes specialists, whether they are also understood by the other system.
Note that Tes builds many excellent features to help users build high quality timetables, and while these features can be sent onto the other system through the synchronisation process, not all systems have built the capability on their end to receive/display these features.
| Tes feature | Notes on feature | Is this feature received by the other system? | Other notes |
Bell times | Bell times as per Grid structures | No | |
Campuses | Campuses and their associated rooms | No | |
Classes | Classes as per Class data screens | Yes | |
Class lists | Yes | ||
Composite classes (linked classes) | One teacher teaching more than one class at the same time | No | |
Duty roster | No | ||
Faculty data | No | ||
Grid structure codes | No | ||
Multi-file | Two (or more) timetable files | No | |
Multi-grid | Multiple grids with different bell times | No | |
On-call roster | No | ||
Priority classes | The priority class that shows on student's timetables where they have class clashes | No | |
Room data | Room Code, Name, Size, Campus, Comment | No | |
Rotation classes | Classes from particular rotations | Yes | Only the classes of the 'Current rotation'. |
RTO roster | No | ||
Student data | Student Code, Name, Preferred name, Year level, Letter group, House, Gender, StatewideID, Email, Phone | Yes | |
Study roster | Study classes, staffing and rooming roster | No | |
Sub-classes | No | ||
Teacher data | Teacher Code, Name, Preferred name, Faculty, Gender, Email, Phone | Yes | |
Teacher days off (Unavailables) | No | ||
Timetable data | No | ||
Two (or more) rooms at once | No | ||
Two (or more) teachers at once | No | ||
Year levels (non-numeric) | Year levels such as SPT, LSUP, ROLL, Yr9+10 etc | Yes |
Yes - The data is sent from our end and is being received and processed by 3rd party system.
No - The data is not supported by 3rd party systems and is not sent from Tes.
Unsure - The data is being sent from Tes but we are unsure if it is being processed and supported by 3rd party system.
Steps to synchronise data
Step 1. Configure the Accelerus (MarkBook)
Configuring the sync is usually a one-off set up, but can be altered at any time.
- In Tes timetable, select File > Synchronise > Configure
- In the Configure tab, select Accelerus (MarkBook) from the drop down list of options.
Multiple systems can be set up to sync. It is common to have both the Edval webserver and the school's learning management system configured, along with any other systems the school wishes to regularly sync to.
- In the Connection tab, select Browse to choose the output destination folder on your computer or network.
- ‘Sync timetable and class-lists each time you save’ option to be helpful. This will send only the timetable and class membership data to Accelerus (MarkBook) each time you save the file.
Step 2. Sync (export) the data
This step should be performed each time data changes in the timetable file and needs to be sent to Accelerus (MarkBook).
- Navigate to File > Synchronisation > Sync now.
- Select Create TT publish file.
- You can navigate to the file location to look at the data if desired.
The below table explains what type of data each csv file contains when exported.
| File Name | Data column (A) | Data column (B) | Data column (C) | Data column (D) | Data column (E) |
| Classes.csv (Classes data) | Class Codes | Subject Codes | Class Names | Teachers | Teacher 2 |
| Cohorts.csv (Cohorts data) | Group Code (I.e. 10A, 10B) | Group Names (Same as group code in column A)) (I.e. 10A, 10B) | NA | NA | NA |
| Enrolments.csv (Enrolments data) | Student Codes | Class Codes | NA | NA | NA |
Students.csv (Student data) | Student Code | Student Family Name | Student Given Name | student preferred Name | Gender |
Subjects.csv (Subjects data) | Class Code | Subject Name | Subject level (Year level) | NA | NA |
Teachers.csv (Teachers data) | Teacher Code | Teacher Family Name | Teacher Given Name | NA | NA |
For the process on how to import this to Accelerus (MarkBook), please contact the Accelerus (MarkBook) support team.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article