This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
student:lms_export [2020/10/13 15:14] – lrosdahl | student:lms_export [2020/10/13 19:42] (current) – lrosdahl | ||
---|---|---|---|
Line 6: | Line 6: | ||
* This extract is used by clients who use Student applications. | * This extract is used by clients who use Student applications. | ||
* This is an external process set up by technician that is run nightly. | * 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/ | ||
====Users==== | ====Users==== | ||
- | This file contains and updates Schoology users. Students and teachers are included. | + | This file contains and updates Schoology users. Students and teachers are included. |
+ | |||
+ | <div important round>\\ Either the User Name or the Email are required for this file. You may include both.</ | ||
^ Column Name ^ Data Type ^ Required ^ Column Width ^ Notes ^ | ^ Column Name ^ Data Type ^ Required ^ Column Width ^ Notes ^ | ||
Line 15: | Line 18: | ||
| Last Name | Char | Y | char(25) | Last Name. | | | Last Name | Char | Y | char(25) | Last Name. | | ||
| User Name | Char | Y | char(25) Teacher\\ char(30) Student | TeacherPortal User ID for teachers.\\ | | User Name | Char | Y | char(25) Teacher\\ char(30) Student | TeacherPortal User ID for teachers.\\ | ||
- | | Email | Char | Y | varchar(45) Teacher\\ varchar(64) Student | Teacher/ | + | | Email | Char | Y | varchar(45) Teacher\\ varchar(64) Student | Teacher/ |
| 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.| | | 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 | ' | | Role | Char | Y | ' | ||
Line 24: | Line 27: | ||
Example file including headers: | Example file including headers: | ||
- | ^ FirstName | + | ^First Name^Last Name^Username^Email^User Unique ID^ROLE^Building^Grad Year^Additional Schools^ |
|Jenny|Brown|jbrown28|jenny_brown15@district.edu|S_805860|Student|001|2022| ' ' | | |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| ' ' | | |Katie|Stevens|katie_stevens|katie_stevens14@district.edu8|S_82606|Student|041|2026| ' ' | | ||
Line 47: | Line 50: | ||
Example file including headers: | Example file including headers: | ||
- | ^Course Name^Course Code^Section Name^Section School Code^Grading Periods^Building^ | + | ^CourseName^CourseCode^SectionName^SectionSchoolCode^GradingPeriod^Building^ |
|English | |English | ||
|English | |English | ||
Line 69: | Line 72: | ||
Example file with headers: | Example file with headers: | ||
- | ^ Course Code ^ Section School Code ^ User Unique ID ^ Role ^ Grading Periods | + | ^Course Code^Section School Code^User Unique ID^ROLE^GradingPeriod^ |
|0010050|20210010050-01-1|E_203584|Teacher|C1%%|%%C2%%|%%C3%%|%%C4| | |0010050|20210010050-01-1|E_203584|Teacher|C1%%|%%C2%%|%%C3%%|%%C4| | ||
|0010061|20210010061-02-1|E_489267|Teacher|C1%%|%%C2%%|%%C3%%|%%C4| | |0010061|20210010061-02-1|E_489267|Teacher|C1%%|%%C2%%|%%C3%%|%%C4| |