student:lms_export
Differences
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:33] – 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==== | ||
| Line 17: | 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 26: | Line 27: | ||
| Example file including headers: | Example file including headers: | ||
| - | ^ Firs tName ^ Last Name ^ User Name ^ Email ^ User Unique ID ^ Role ^ Building ^ Grad Year ^ Additional Schools ^ | + | ^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 49: | 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 71: | 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| | ||
student/lms_export.1602603221.txt.gz · Last modified: 2020/10/13 10:33 (external edit)