Follow

Exporting Roster Data

District Admin Accounts have the option of downloading a specific school year's roster data into three files: teachers, students and rostering. These files can be used in a number of ways:

  • Quick access to a list of all teachers and students currently rostered in a school year
  • Comparing ESGI data and data in another SIS (student information system)
  • Comparing district rostering between different school years
  • Custom reporting and analysis

To get this data:

1. Click Profile

2. Click District Info

get_data.jpg

3. Select the school year (current year is the default). Click "Get Data".

get_data2.jpg

4. Click "Download Files" on the next screen that pops up

Similar to the files used for importing, the download contains 3 files:

Teachers file: contains all teacher accounts currently assigned to schools in the school year.

Students file: contains all students that are assigned to a class for the school year.

Roster file: contains all students, the teacher they are rostered against, and the school the student is rostered to. The file also contains the Grade Level of the student.

Below are the descriptions for each file's column headings:

  1. Teachers.txt
    1. TchID – Teacher Unique ID (alpha – numeric)*
    2. SchCode – School Unique ID (alpha – numeric)
    3. TchFN – Teacher Firstname
    4. TchLN – Teacher Lastname
    5. Email – Teacher Email
    6. UserName – Teacher Login
  2. Students.txt
    1. StuID – Student Unique ID (alpha – numeric)
    2. FirstName - Student Firstname
    3. LastName - Student Lastname
    4. Gender – Gender.
    5. HomeLang – Student Home Language
  3. Rostering.txt
    1. StuID – Student Unique ID (alpha – numeric)**
    2. TchID – Teacher Unique ID (alpha – numeric)
    3. SchCode – School Unique ID (alpha – numeric)
    4. Grade – Grade Level

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk