This is an old revision of the document!
The LMS Export will export three files: Users, Courses, and Enrollment. It is currently being used for Schoology.
Notes:
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. |
Char | Y | varchar(45) Teacher varchar(64) Student | Teacher/Administrator email. Students 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:
Firs tName | Last Name | User Name | User Unique ID | Role | Building | Grad Year | Additional Schools | |
---|---|---|---|---|---|---|---|---|
Jenny | Brown | jbrown28 | jenny_brown15@district.edu | S_805860 | Student | 001 | 2022 | ' ' |
Katie | Stevens | katie_stevens | katie_stevens14@district.edu8 | S_82606 | Student | 041 | 2026 | ' ' |
Patrick | Black | pblack88 | patrick_black15@district.edu | S_789568 | Student | 001 | 2023 | ' ' |
James | Smith | 21jamsmith | james_smith@district.edu | E_T156279 | Teacher | 001 | ' ' | 002|003 |
Susie | Murphy | susie_murphy | susie_murphy@district.edu | E_867457 | Teacher | 004 | ' ' |
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:
Course Name | Course Code | Section Name | Section School Code | Grading Periods | Building |
---|---|---|---|---|---|
English 101 | 0010050 | 01 | 20210010050-011 | C1|C2|C3|C4 | 001 |
English 101 | 0010061 | 02 | 20210010061-021 | C1|C2|C3|C4 | 001 |
English 101 | 0010083 | 03 | 20210010083-031 | C1|C2|C3|C4 | 001 |
English 101 | 0010104 | 04 | 20210010104-041 | C1|C2|C3|C4|C5|C6 | 001 |
English 201 | 0010214 | 01 | 20210010214-012 | C1|C2|C3|C4 | 001 |
English 201 | 0010335 | 02 | 20210010335-022 | C1|C2|C3|C4 | 001 |
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 Code | Section School Code | User Unique ID | Role | Grading Periods |
---|---|---|---|---|
0010050 | 20210010050-01-1 | E_203584 | Teacher | C1|C2|C3|C4 |
0010061 | 20210010061-02-1 | E_489267 | Teacher | C1|C2|C3|C4 |
0010083 | 20210010083-03-1 | E_737792 | Teacher | C1|C2|C3|C4 |
0010104 | 20210010104-04-1 | S_389277 | Student | C1|C2|C3|C4 |
0010214 | 20210010214-01-2 | S_927763 | Student | C1|C2|C3|C4|C5|C6 |