Creating and Editing Rosters Through File Uploads

If you have many rosters to create or edit, it may be easier to perform those transactions through file uploads. This task requires familiarity with composing comma-separated value (CSV) files or working with Microsoft Excel.

Tip: You can pull the information you need from TIDE to edit existing rosters through file uploads by exporting the roster information from the View/Edit/Export Roster page, including the teacher’s email address.

To upload rosters:

1.From the Rosters task menu on the d ears.

2.Following the instructions in the section Uploading Records and using Table 14Table 15 as a reference, fill out the Roster template and upload it to TIDE.

Table 14Table 15 provides the guidelines for filling out the Roster template that you can download from the Upload Roster page.

Table 14: Columns in the Rosters Upload File.

Column Name	Description	Valid Values
District IDNa	District associated with the roster.	sixFour digits. Must exist in TIDE, and must be associated with the user uploading the file.
School IDNa	School associated with the roster.	Seven digits. Up to 21 alphanumeric characters or underscore. Up to 20 printable ASCII characters. Must exist in TIDE, be associated with the district, and be associated with the user uploading the file. Can be blank when uploading district-level rosters.
Emaila	Email of teacher associated with the roster.	Any standard email address. Must exist in TIDE.
Roster Namea	Name of roster.	Up to 50 characters.
StateIDa	Student’s 10 Digit State Student Identifier (SSID). Student’s unique Native American Student Information System ID. Student’s Registration Number. State-assigned student identifier, which is unique within the district associated with the student.	Ten digits. Up to 30 characters. Ten digits, [0-9]
Action	Action column to add or delete students from the roster.	Add – adds student to roster. Delete – deletes student from roster.
aRequired field.

Table 15: Columns in the Rosters Upload File.

Column Name	Description	Valid Values
District_ORG_IDb	District associated with the roster.	Up to 10 digits.
ORG_IDb	A system generated number used to uniquely identify the school associated with the roster.	Up to 10 digits.
Proctor's Emailb	Email of proctor associated with the roster.	Any standard email address. Must exist in TIDE. Up to 50 characters.
Roster Nameb	Name of roster.	Up to 50 characters.
SSIDb	Student’s 10 Digit State Student Identifier (SSID). Student’s unique Native American Student Information System ID. Student’s Registration Number. State-assigned student identifier, which is unique within the district associated with the student.	Ten digits. Up to 30 characters. Ten digits, [0-9]
Action	Action column to add or delete students from the roster.	Add – adds student to roster. Delete – deletes student from roster.
bRequired field.