Canvas Export

Modified on Mon, Nov 20, 2023 at 2:33 PM

Canvas Export

Click here for Canvas guide on integration with Genesis

Options

Export File Options:

Include the following files:

Users
Accounts
Terms
Courses
Sections
Course Enrollments
Parent Observer Accounts (creates canvas_observers and parent_observers files)

User File Options:

Populate student Logon ID with - Select either Email or the student user text of your choice to display in the Logon ID column for student users.
When populating Logon ID, use full email address - If Email is selected for the above option and this is selected, the complete email address (including the @ symbol) will be printed for both students and teachers.
Populate student email with - Select either Email or the student user text of your choice to display in the Email column for student users.
Mark inactive students as "Deleted" - If this is selected, the Users file will list all inactive students with a status of "deleted", otherwise they will all be marked as "active".

Accounts File Options:

Custom departments - Example: G100=Gym,LA=Language Arts

Scheduling Files Options

Detect and combine inclusion courses: This option allows it to combine a regularly scheduled section with any other section that is set as a special ed course (on the curriculum) that has the same course description and meets on the same days in the same room and the same print period. When we export to canvas, they will both be exported as the same class. All the students will appear in the same canvas class. The "regularly scheduled section" will be the one exported with that teacher as the teacher of record.
Excluded courses (comma-separated course codes):
Included non-graded courses (comma-separated course codes): (non-graded courses are normally excluded)
Only Include these courses (comma-separated course codes): (All other courses will be excluded)
Exclude online courses: Where Course Instruction Type is 'Online course taught by staff assigned or not assigned to your district'
Include elementary homerooms:
Exclude elementary schedules by school: Excludes courses that are in elementary schools
Exclude elementary schedules by course: Excludes courses that are flagged as elementary courses
Include Semester code in Course ID field: In Courses, Sections, and Course Enrollments files
Include section number in section names (Sections File):
Replace shared teachers with individual co-teachers (Enrollments File):
Populate courseId column with sectionId (Course, Section, and Enrollments files):

Include Semester Code in Course ID Field - In the Courses, Sections, and Enrollments files, the Semester Code will be included as part of the Course ID.

Selected Grade Levels - Lets you select which grade levels to include in the Users and Enrollments files. All will be included if none are selected.

Exported Files

Users
Each row corresponds to a teacher or student. Students' status of "deleted" can be overridden with a new option to mark those users as "deleted" or "active".
Column	Notes
user_id
login_id	Teachers: email address (up to but not including the @ symbol) Students: same as above or may be pulled from a student user text.
password	blank
first_name
last_name
email
status	"active"
Accounts
Each row corresponds to a department.
Column	Notes
account_id	schoolCode-departmentCode
parent_account_id	schoolCode + schoolTypeCode
name	schoolCode departmentName
status	"active"

Terms
Contains a single record for the current school year. Also includes a row for each semester in each selected school that is flagged for use in scheduling
Column	Notes
term_id	schoolYear
name	schoolYear
status	"active"
start_date	district's schoolStartDate
end_date	district's schoolEndDate
term_code	schoolCode - semesterCode
Courses
Each row corresponds to a course section in Genesis. TeacherId comes from the first teacher listed in the course section.
Column	Notes
course_id	schoolCode-courseCode-teacherId-schoolYear (-semesterCode)
short_name	courseDescription
long_name	courseDescription
account_id	section's schoolCode - departmentCode
term_id	schoolYear
status	"active"
term_code	schoolCode - semesterCode

Sections
Each row corresponds to a course section in Genesis. TeacherId comes from the first teacher listed in the course section.
Column	Notes
section_id	schoolCode-courseCode-teacherId-schoolYear-courseSection
course_id	schoolCode-courseCode-teacherId-schoolYear (-semesterCode)
name	courseDescription
status	"active"
Enrollments
Each row corresponds to a student's enrollment in a course section. Status is either "active" for active students, or if they dropped the section, it's either "inactive" if they drop the section after the fifth day, or "deleted" if they drop before that drop window. The start day of a section is determined by looking up the School Attendance Cycle of the semester of the course section.
Column		Notes
course_id		schoolCode-courseCode-teacherId-schoolYear (-semesterCode)
user_id		studentId
role		"student"
section_id		schoolCode-courseCode-teacherId-schoolYear-courseSection
status		"active"

Canvas Observers
Each row represents a Parent Portal Account of type GUARDIAN
Column	Notes
user_id	Parent Portal user logon
integration_id	<blank>
login_id	Parent Portal user logon
password	<blank>
first_name	First Name of User
last_name	Last Name of User
full_name	<blank>
sotable_name	<blank>
authentication_provider_id	"canvas"
short_name	<blank>
email	Parent Portal user logon
status	Active or Inactive
Parent Observers
Each row represents a student tied to a Parent Portal Account
Column	Notes
student_id	Student belonging to Parent Portal account
observer_id	Parent Portal user logon
status	Active or Inactive