User Tools

Site Tools


student:lms_export

Schoology LMS Export

The LMS Export will export three files: Users, Courses, and Enrollment. It is currently being used for Schoology.

Notes:

  • This extract is used by clients who use Student applications.
  • This is an external process set up by technician that is run nightly.
  • Scripts for technicians can be found on the SFTP site: Third Party Extracts/TCC Extracts/Schoology

Users

This file contains and updates Schoology users. Students and teachers are included.


Either the User Name or the Email are required for this file. You may include both.

Column Name Data Type Required Column Width Notes
First Name Char Y char(17) First Name.
Last Name Char Y char(25) Last Name.
User Name Char Y char(25) Teacher
char(30) Student
TeacherPortal User ID for teachers.
StudentPortal User Name for students.
Email Char Y varchar(45) Teacher
varchar(64) Student
Teacher/Administrator email.
Student email.
User Unique ID Char Y char(8) A unique identifier for the user record. Staff Employee Numbers will have E_ prepended to them.
Student IDs will have S_ prepended to them.
Role Char Y 'Teacher', 'Administrator', 'Student' Staff with FSP Salary Class Code 'T' are extracted as 'Teacher', and with 'A' are extracted as 'Administrator'.
Students are coded as 'Student'.
Building Char Y char(3) Campus ID for teachers from the instructors table.
Campus ID for students from the student enrollment table.
Grad Year Char Y blank Teacher
char(4) Student
Proposed Graduating Date of the student.
Additional Schools Char Y char(3) each campus Campus ID of any other campuses associated with a teacher. Separated with pipes (|).

Example file including headers:

First NameLast NameUsernameEmailUser Unique IDROLEBuildingGrad YearAdditional Schools
JennyBrownjbrown28jenny_brown15@district.eduS_805860Student0012022 ' '
KatieStevenskatie_stevenskatie_stevens14@district.edu8S_82606Student0412026 ' '
PatrickBlackpblack88patrick_black15@district.eduS_789568Student0012023 ' '
JamesSmith21jamsmithjames_smith@district.eduE_T156279Teacher001' ' 002|003
SusieMurphysusie_murphysusie_murphy@district.eduE_867457Teacher004' '

Courses

This file contains course sections.

Note: The courses file does not create course content. Content will need to be either created in or migrated to the course section from a Legacy LMS.

Column Name Data Type Required Column Width Notes
Course Name Char Y char(15) Title of the course.
Course Code Char Y char(11) Campus ID and Course Code combined. This is a unique identifier and cannot be used across multiple schools.
Section Name Char Y char(2) Section Number.
Section School Code Char Y char(19) School Year, Campus ID, Course Number, Section Number, and Semester Code combined.
Grading Periods Char Y char(11) or char(17) Standard “term.” Multiple grading periods are separated with pipes (|). Derived based on the Number of Semesters and the Number of Cycles per Semester.
Building Char Y char(3) Campus ID.

Example file including headers:

CourseNameCourseCodeSectionNameSectionSchoolCodeGradingPeriodBuilding
English 10100100500120210010050-011C1|C2|C3|C4001
English 10100100610220210010061-021C1|C2|C3|C4001
English 10100100830320210010083-031C1|C2|C3|C4001
English 10100101040420210010104-041C1|C2|C3|C4|C5|C6001
English 20100102140120210010214-012C1|C2|C3|C4001
English 20100103350220210010335-022C1|C2|C3|C4001

Enrollments

This file contains users in course sections (associates teachers and students to course sections).

Column Name Data Type Required Column Width Notes
Course Code Char Y char(11) Campus ID and Course Number combined.
Section School Code Char Y char(19) Must be unique. School Year, Campus ID, Course Number, Section Number, and Semester Code combined.
User Unique ID Char Y char(8) A unique identifier for the user record. Staff Employee Numbers will have E_ prepended to them.
Student IDs will have S_ prepended to them.
Role Char Y 'Teacher', 'Student' Staff with FSP Salary Class Code 'T' or 'A' are extracted as 'Teacher'.
Students are coded as 'Student'.
Grading Periods Char Y char(11) or char(17) Standard “term.” Multiple grading periods will be separated with pipes (|). Derived based on the Number of Semesters and the Number of Cycles per Semester.

Example file with headers:

Course CodeSection School CodeUser Unique IDROLEGradingPeriod
001005020210010050-01-1E_203584TeacherC1|C2|C3|C4
001006120210010061-02-1E_489267TeacherC1|C2|C3|C4
001008320210010083-03-1E_737792TeacherC1|C2|C3|C4
001010420210010104-04-1S_389277StudentC1|C2|C3|C4
001021420210010214-01-2S_927763StudentC1|C2|C3|C4|C5|C6
student/lms_export.txt · Last modified: 2020/10/13 13:42 by lrosdahl