E10 - Synchronisation to Canvas (Instructure) via Export (CSV)

Modified on Thu, 5 Feb at 9:37 PM

TABLE OF CONTENTS

Preamble

Timetabling data that exists in E10 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 outlines the synchronisation process to Canvas (Instructure).


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 Canvas (Instructure).
The Canvas (Instructure) export function will export following CSV files:
  1. Courses.csv 
  2. Enrollment.csv
  3. Section.csv
  4. Users.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.


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 feature.

Tes featureNotes on feature
Is this feature received by the other system?
Other notes
Bell timesBell times as per Grid structuresNo
CampusesCampuses and their associated roomsNo
ClassesClass Code, Subject nameYes
Class lists
Yes
Composite classes (linked classes)One teacher teaching more than one class at the same timeNo
Duty roster
No
Faculty data
Yes
Grid structure codes
Yes
Multi-fileTwo (or more) timetable filesUnsure
Multi-gridMultiple grids with different bell timesNo
On-call roster
No
Priority classesThe priority class that shows on student's timetables where they have class clashesNo
Room dataRoom CodeYes
Rotation classesClasses from particular rotationsYes
RTO roster
No
Student dataStudent Code, Name, Year level, Letter group, HouseYes
Study rosterStudy classes, staffing and rooming rosterNo
Sub-classes
No
Teacher dataTeacher Code, NameYes
Teacher days off (Unavailable)
No
Timetable data
Yes
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

Steps to Synchronise data

Step 1: Check if any Canvas (Instructure) set up is required

Many systems require some set up prior to receiving timetable data from the timetable. Check with Canvas (Instructure).

Step 2: Configure the Timetable file

  1. Go to File > Synchronise > Configure

  2. Select the ‘Sync’ sub-tab

  3. Click the '+' and select "Canvas (Instructure)" from the dropdown

  4. Go to the ‘Connection’ sub-tab

  5. Ensure that “Canvas (Instructure) ” is selected in the top-right corner

  6. In the Connection tab, select Browse to choose the output destination folder on your computer or network.
  7. If you would like to have the files exported every time a save is done, you can tick the 'Sync each time you save' box



Step 3: Perform the sync export

  1. Go to File > Synchronisation > Sync now.
  2. Select / ensure that the Canvas (Instructure) option is chosen in the Filter menu in the top right.
  3. Select Create TT publish file



Configuring the sync is usually a one-off set up, but can be altered at any time.


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.

A number of files will be created which will be used to import into Canvas (Instructure) 



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

File NameData column (A)Data column (B)Data column (C)Data column (D)Data column (E)Data column (F)Data column (G)
Courses.csv
(Courses data)
Course ID
(Course  Code)
Subject name (Short)Subject name (Long)Status (Courses)NANANA
Enrollment.csv
(Enrolment data)
Course ID (Course code)User ID (Teacher code)Role (Teacher)Section ID (Course code with class ID)Status (Courses)NANA
Section.csv
(Section data)
Section ID (Course code with class ID)
Course ID (Course code)
Name (Subject name)
Status (Classes)
NA
NA
NA
Users.csv
(Teacher data)
User ID (Teacher code)
Login ID (Teachers email)
First Name (Teacher)
Last name (Teacher)
Short name (Teacher)
Email (Teachers email)
Status (Teachers) 


For the process on how to import this to Canvas (Instructure) (CSV), please contact the Canvas 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

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