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

Modified on Thu, 14 Aug at 12:52 AM

TABLE OF CONTENTS



Step 1. Configure the Canvas (Instructure) (CSV) sync export

Info


The following information has been provided by the Canvas  team and was correct at the time of publication. Please check the Canvas  documentation for any changes to the process. Please contact them for any support required in the set up in this system, as Tes consultants are not able to advise.

Configuring the sync is usually a one-off set up, but can be altered at any time.
  1. In Tes timetable file, select File > Synchronise > Configure
   
  1. In the Configure tab, select Canvas (Instructure) (CSV) from the drop down list of options.


Info


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.
  1.  In the Connection tab, select Browse to choose the output destination folder on your computer or network.
  2. ‘Sync timetable and class-lists each time you save’ option to be helpful. This will send only the timetable and class membership data to Canvas (Instructure) (CSV) 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 Canvas.
  1. Navigate to File > Synchronisation > Sync now.

  1. Select Create TT publish file.  

  1. 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 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) 

Alert


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