Timetable Daily - Synchronisation to iScholaris via Export

Modified on Thu, 14 Aug at 1:01 AM

TABLE OF CONTENTS

Preamble

Timetabling data that exists in Timetable Daily 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:
  1. new school Daily set up
  2. synchronisation processes
  3. synchronisation troubleshooting
Info


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

Timetable Daily currently has a flat file export function for iScholaris. The flat file export creates the following data files:
  1. Export Student
  2. Export Class lists
  3. Export Daily Timetable
  4. Export Teachers
  5. Export Cyclical Timetable
  6. Export Event Membership

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
Alert


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 featureNotes on feature
Is this feature received
by the other system?
Other Notes
Classes
Class code, Subject name, Teacher code, room code
Yes

Class lists
Student code, Class code, Subject name, Teacher code
Yes

Composite (linked) classes
One teacher teaching more than one class at the same time
Yes

Duty roster
Yes
Grid structure codes

Yes
Multi-file
Two or more .etz timetable files
No
Multi-gridMore than one bell times structures set up
No
On-call roster
No

Priority classesThe chosen class on a student's timetable where they have class clashes.
Yes

Room data
Room Code, Name, Size, Campus, Comment
Yes

Rotation classes
Classes from particular rotations
Yes
All rotations are exported.
RTO roster
Yes

Student data
Student code, Student full name, Year level, House, gender, StatewideID
Yes

Study roster
Study classes, staffing and rooming roster
Yes

Sub-classes

No

Teacher days off (Unavailables)

No

Timetable data
(Cyclical timetable)
Day number, Year levels, Periods, Class code, Teacher code, Room code, Class type e.g. (Duty and study class), Subject name
Yes

Two (or more) rooms at once
Self-explanatory
No

Two (or more) teachers at once
A class with two or more teachers at the same time
No

Year levelsYear levels such as SPT, LSUP, ROLL etc
Yes

Publish Daily Timetable
Sends the following Daily data: Events, Covers, Absences, Assigned teachers, Assigned rooms, Cancelled classes.
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 iScholaris. 

Steps to synchronise data

Step 1: Check if any iScholaris flat file set up is required

Many systems require some set up prior to receiving timetable data from Tes. Check with iScholaris.

Step 2: Configure the Timetable Daily Sync

  1. Go to  Daily > Synchronise
  2. Choose 'Add sync system' and select iScholaris Flat file from the system dropdown.

Step 3: Perform the sync export

Go to Daily --> Synchronise > Choose iScholaris from the 'Sync configs'
There are two sync options: Basic or Advanced.




Advanced Sync

This sync type is normally used for the first time when needing to perform a full sync which could be a very first time setup or new academic year or new semester with major changes coming from timetable file. This sync type would not only send the daily data but also any timetable related will be synced.
To perform a advance sync:
  1. Go to Daily > Synchronise  and select the iScholaris sync configuration.
  2. Select 'Advanced sync' from the actions panel.
  3. Select the data that is required to be exported.
  4. Select 'Sync' to complete the process which will export the flat files that you have selected in the below screen.

 The data files that will be exported are shown in the below screenshot.


Basic Sync

The basic sync can be performed on daily basis and this would sync the basic daily information with some extra information but not the extend that Advanced sync is sending. The recommended approach for school is to peform Advanced sync at first and then moving forward continue doing Publish & Sync.
To perform Basic sync:
  1. Go to Daily > Synchronise  and select the iScholaris Flat file configuration.
  2. Select Basic sync from the actions panel.
  3. Enter the dates required.
  4. Select Sync to complete the process which will export the flat files in a zip compressed folder.


    5. The compressed zip folder will consist of all the exported files as per screenshot below. 


Publish & Sync

Publish & Sync option is the recommended approach used daily by daily organisers. This will sync all the daily variations happening for the date range.
To perform Publish and Sync:
  1. Go to Daily > Cover  and Click on the Publish.
  2. Select Publish and Sync with other system from the Publish covers panel.
  3. Enter the dates required.
  4. Select Sync to complete the process.


For more information on this feature please see the following document: Edval Daily: Covers Tab 

The below table explains what type of data each csv file contains when exported when performing an advance sync:

File NameData 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)
Data Column (J)
Data Column (K)
Data Column (L)
Data Column
(M)
CLASSLESSONS.TXT
(Cyclical timetable)
DayYear LevelPeriodClass CodeTeacher CodeRoom Code
Class Type
(E.g. Study, Duty
Subject NamePrecedenceClassN/A
N/A
N/A
N/A
CLASSLISTS.TXT
(Class lists)
Student CodeClass CodeSubject NameTeacher CodeN/AN/AN/AN/AN/A
N/A
N/A
N/A
N/A
DAILYTIMETABLE.TXT
DateClass Code e.g. 12GEO1Course Code e.g. 12GEO
CourseId
(e.g. GEO
Type
(E.g. Duty, Study))
Subject nameTeacher CodeRoom Code
Date From
(E.g. 08:10)
Date To 
(E.g. 08:40
Period 
Cancelled classes
PrecedenceClass
EVENETMEMBERSHIP.TXT
(Students in the event with the date stamp)
DateClass CodeStudent CodeN/AN/AN/AN/AN/AN/A
N/A
N/A
N/A
N/A
EVERYONE.TXT
(Student data)
Student Code
Student Full Name
Year Level
House
(E.g. Red, Blue, Green
Sex
(Gender)
StatewideID
N/A
N/A
N/A
N/A
N/A
N/A
N/A
TEACHERS.TXT
Teacher Code
Teacher Full Name
Teacher Email 
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A

Step 4: Upload/Import the TXT files into iScholaris

Info


Please refer to iScholaris documentation for instructions on how to upload/import the TXT files.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article