User Tools

Site Tools


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
Last revisionBoth sides next revision
student:lms_export [2020/10/13 15:14] lrosdahlstudent:lms_export [2020/10/13 16:49] 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 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|0010050|01|20210010050-011|C1%%|%%C2%%|%%C3%%|%%C4|001| |English  101|0010050|01|20210010050-011|C1%%|%%C2%%|%%C3%%|%%C4|001|
 |English  101|0010061|02|20210010061-021|C1%%|%%C2%%|%%C3%%|%%C4|001| |English  101|0010061|02|20210010061-021|C1%%|%%C2%%|%%C3%%|%%C4|001|
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|
student/lms_export.txt · Last modified: 2020/10/13 19:42 by lrosdahl