E10 - Synchronisation to iSAMS via Export

Modified on Thu, 14 Aug at 1:05 AM

TABLE OF CONTENTS

Preamble

Timetabling data that exists in 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:
  1. new school file 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

This sync is performed by exporting a csv file that has been correctly formatted, ready uploading into iSAMS.
The iSAMS export function will export five TXT files:
  1. Edval_classes.csv
  2. Edval_timetable.csv

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 Timetable featureNotes on feature
Is this feature received
by the other system?
Other Notes
Bell times
No

Classes
Classes as per Class data screens
Yes
Class lists

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

Duty roster
No
Faculty data

No

Grid structure codes

Yes
Multi-file
Two or more timetable files
No
Multi-gridMore than one bell times structures set up
Yes
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
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
Yes
Sub-classes

No
Teacher data
Teacher Code, Name, Preferred name, Faculty, Gender, Email, Phone
Yes

Teacher days off (Unavailables)

No

Timetable data

Yes
Timetable data is exported in the exported file. Unsure if supported by iSAMS. 
Two (or more) rooms at once
No

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

Year levels (non-numeric)
Year levels such as SPT, LSUP, ROLL etc
No

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 the timetable file. 
Unsure - The data is being sent from the timetable file but we are unsure if it is being processed and supported by iSAMS. 


Steps to synchronise data

Step 1: Check if any iSAMS set up is required

Many systems require some set up prior to receiving timetable data from the timetable file. Check with iSAMS.

Step 2: Configure the Timetable file

  1. Open the relevant Timetable file, and go to File > Synchronise > Configure > Sync tab
  2. Select the + button and choose 'iSAMS' (csv) from the drop down menu.
Info


Multiple systems can be set up to sync. It is common to have both the Edval webserver, the schools learning management system configured, along with any other systems the school wishes to regularly sync to.
  1. Select the Configure button, which will move you to the Connection tab. A destination folder must be selected to direct where the .csv files will be saved. Select Browse and locate or create the desired location.
Select Connection
  1. Enter the name of the folder where the export csv is to be stored.

  2. Choose the ‘Edit period mappings’.




Edit period mapping: When you click on Edit period mapping a grid structure view will be displayed as shown below. In this screen you set up a mapping from timetable file periods to iSAMS“ period numbers”. 

It is necessary to fill this out in a way that timetable file periods are matched to the correct iSAMS period.
Each and every timetable file period, across all days in the cycle, must be mapped to a valid iSAMS period number, if that period will be referenced in iSAMS.
In this example, Mon0 maps to 1, Tue0 maps to 11, etc.




Notes


NOTE. If the school has an Timetable Multi Grid license and the file is setup with multiple sets of bell-times for different campuses, first select the required ‘campus’ from the View dropdown before mapping the periods for that campus.  iSAMs will accept a very basic version of multigrid where all grids have the same period times but the period types vary (E.g.. Some year groups have lunch period 3 and some period 4).

 


Step 3: Perform the export

  1. Go to File > Synchronisation > Sync now.
  2. Ensure ‘iSAMS’ is selected from the dropdown in the top-right corner.
  3. Select Create TT publish file


  1. Select OK

Exports

The timetable file will create 2 csv files which are stored in the Destination folder nominated in Configure > Connection.



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)Data column (F)
edval_classes.csv
(Publish Class and Class list data)
Student Id
(Student code)
Course CodeClass CodeForm e.g. Year LevelSubject
(English Advance)
Teacher
(Teacher Code)
edval_timetable.csv
(Timetable data)
Period IdSet Code e.g. Class CodeYear levelSubject
(Class code with class ID)
Teacher
(Teacher code)
Room
(Room Code)

Step 4: Upload/Import the TXT files into iSAMS

Alert


Please contact iSAMS for information regarding the rest of the import and the setup process in iSAMS.

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