Interfaces

User Tools

Site Tools

Trace:
student:lms_export

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
student:lms_export [2020/10/02 22:19] – lrosdahlstudent: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/TCC Extracts/Schoology
  
 ====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.</div>
  
 ^ 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.\\  StudentPortal User Name for students.| | 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. Students email.|+| 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.| | 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'.| | 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.\\ Campus ID for students. |+| 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. | | 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 (%%|%%).| |Additional Schools| Char | Y | char(3) each campus | Campus ID of any other campuses associated with a teacher. Separated with pipes (%%|%%).|
Line 24: Line 27:
 Example file including headers: Example file including headers:
  
-^ FirstName ^ LastName ^ UserName ^ Email ^ UserUniqID ^ Role ^ Building ^ GradYear ^ 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 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  101|0050|01|0010050-011|C1%%|%%C2%%|%%C3%%|%%C4|001| +|English  101|0010050|01|20210010050-011|C1%%|%%C2%%|%%C3%%|%%C4|001| 
-|English  101|0061|02|0010061-021|C1%%|%%C2%%|%%C3%%|%%C4|001| +|English  101|0010061|02|20210010061-021|C1%%|%%C2%%|%%C3%%|%%C4|001| 
-|English  101|0083|03|0010083-031|C1%%|%%C2%%|%%C3%%|%%C4|001| +|English  101|0010083|03|20210010083-031|C1%%|%%C2%%|%%C3%%|%%C4|001| 
-|English  101|0104|04|0010104-041|C1%%|%%C2%%|%%C3%%|%%C4%%|%%C5%%|%%C6|001| +|English  101|0010104|04|20210010104-041|C1%%|%%C2%%|%%C3%%|%%C4%%|%%C5%%|%%C6|001| 
-|English  201|0214|01|0010214-012|C1%%|%%C2%%|%%C3%%|%%C4|001| +|English  201|0010214|01|20210010214-012|C1%%|%%C2%%|%%C3%%|%%C4|001| 
-|English  201|0335|02|0010335-022|C1%%|%%C2%%|%%C3%%|%%C4|001|+|English  201|0010335|02|20210010335-022|C1%%|%%C2%%|%%C3%%|%%C4|001|
  
  
Line 64: Line 67:
 | Section School Code | Char | Y | char(19) | Must be unique. School Year, Campus ID, Course Number, Section Number, and Semester Code 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.| | 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 | Staff with FSP Salary Class Code 'T' or 'A' are extracted as 'Teacher'.\\ Students are coded as 'Student'.|+| 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. | | 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: 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|
 |0010083|20210010083-03-1|E_737792|Teacher|C1%%|%%C2%%|%%C3%%|%%C4| |0010083|20210010083-03-1|E_737792|Teacher|C1%%|%%C2%%|%%C3%%|%%C4|
-|0010104|20210010104-04-1|E_389277|Teacher|C1%%|%%C2%%|%%C3%%|%%C4| +|0010104|20210010104-04-1|S_389277|Student|C1%%|%%C2%%|%%C3%%|%%C4| 
-|0010214|20210010214-01-2|E_927763|Teacher|C1%%|%%C2%%|%%C3%%|%%C4%%|%%C5%%|%%C6|+|0010214|20210010214-01-2|S_927763|Student|C1%%|%%C2%%|%%C3%%|%%C4%%|%%C5%%|%%C6|
student/lms_export.1601677199.txt.gz · Last modified: 2020/10/02 17:20 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.