E10 - Synchronisation to RC-Online via Export

Modified on Thu, 14 Aug at 1:03 AM

TABLE OF CONTENTS

Preamble
Type of sync
Which data is sent to the other system?
Steps to synchronise data
- Step 1: Set up the RC-Online sync
Navigate to File > Synchronise > ConfigureSelect the 'Sync' tabClick on the blue plus button and select "RC-Online" from the dropdown
- Step 2: Perform the export
On the Connection Tab click ‘Browse’ to configure a destination folder (This is where the CSV file is saved)
- Step 3: Upload the four files to the RC-Online portal

Preamble

Timetabling data that exists in the 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
synchronisation troubleshooting

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 correctly formatted files, usually TXT formats, ready uploading into the other system.

Which data is sent to the other system?

This table lists many of the data and features found in Tes 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 Timetable feature	Notes on feature	Is this feature received by the other system?	Other notes
Bell times	Bell times as per Grid structures	Unsure
Campuses	Campuses and their associated rooms	Unsure
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	Unsure
Duty roster		Unsure
Faculty data		Unsure
Grid structure codes		Unsure
Multi-file	Two (or more) timetable files	Unsure
Multi-grid	Multiple grids with different bell times	Unsure
On-call roster		Unsure
Priority classes	The priority class that shows on student's timetables where they have class clashes	Unsure
Room data	Room Code	Yes
Rotation classes	Classes from particular rotations	Yes
RTO roster		Unsure
Student data	Student Code, Name, Year level, Letter group,Gender,	Yes
Study roster	Study classes, staffing and rooming roster	Unsure
Sub-classes		Unsure
Teacher data	Teacher Code, Name	Yes
Teacher days off (Unavailables)		Unsure
Timetable data		Yes
Two (or more) rooms at once		Unsure
Two (or more) teachers at once		Unsure
Year levels (non-numeric)	Year levels such as SPT, LSUP, ROLL, Yr9+10 etc	Unsure

Steps to synchronise data

Step 1: Set up the RC-Online sync

Step 2: Perform the export

On the Connection Tab click ‘Browse’ to configure a destination folder (This is where the CSV file is saved)

'Sync each time you save' - This means, sync will occur automatically on a ctrl-S save. In this case, data is first saved locally to disk, and then an attempt is made to sync with all external systems. This is simple, but you may want to disable this if the external systems or your network is slow to sync, or you want more control about 'when' you publish data through to other systems. No message is shown on a sync-on-save, as it is done quietly. Only active sync via menu/ctrl-K will show a completion message.

Go to File>Synchronise>Sync now and then click on ‘Create TT publish file’. You will be prompted to select Rotation which you wish to export from E10 file.
The relevant files will be saved in the folder that you specified earlier

The below table explains what type of data each TXT file contains when exported.

File Name

Data column (A)

Data column (B)

Data column (C)

Data column (D)

Data column (E)

Data column (F)

Data column (G)

Data column (H)

Data column (I)

Student.txt

Student Name

Year Level

Gender

Student Code

Letter

Classes

Subject.txt

Class Code

Year Level

Subject

N/A

Teacher.txt

Teacher Code

Teacher Name

N/A

Ttable.txt

Day

Period number

Class code

Teacher Code

Room Code

N/A

Step 3: Upload the four files to the RC-Online portal

Please refer to RC-Online's documentation for instrcutions on how to upload/import the files.