03 March 2025

Canvas LMS Integration

The Canvas Export schedule trigger, once enabled, allows you to automatically generate a zip file containing the following files for courses that have online content:

  • accounts.csv
  • courses.csv
  • enrollments.csv
  • sections.csv
  • users.csv

Canvas Export workflow

The SQL code used to populate the files can be edited using the Canvas interfaces in Interface Designer, if required.

Canvas interfaces in Interface Designer

Courses with online content can be defined by selecting the Has Online Content check box for a UIO in one of the following locations:

  • The Details tab on the UIO Details screen in Curriculum Details
  • The UIOs tab in Curriculum Manager

    Has Online Content check box

Once the workflow is triggered, the zip file is then exported to the location specified in the Canvas export folder institution setting (on the Integration screen). This file can then be imported into the Canvas software.

Canvas export folder institution setting

You can also specify the Canvas Term ID institution setting (on the Integration screen) that the courses are for. Leaving the field blank imports the data into the default term.