Creating Rosters Through File Uploads

If you have many rosters to create, 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.

To upload rosters:

1.From the banner, click Upload Rosters. The Upload Rosters page appears.

2.On the Upload Rosters page, click Download Templates and select the appropriate file type (e.g., Excel or CSV).

3.Open the template file in a spreadsheet application.

4.Using Table 9 as a reference, fill out the template and save it.

5.On the Upload Rosters page, click Browse and select the file you created in the previous step.

6.Click Next. The Preview page appears. Use the file preview on this page to verify you uploaded the correct file.

7.Click Next to validate the file. The Validate page appears displaying any errors (

) or warnings (

Note: About the Validation Process

If a record contains an error, that record will not be included in the upload. If a record contains a warning, that record will be uploaded, but the field with the warning will be invalid.
If your file contains a large number of records, ORS processes it offline and sends you a confirmation email when complete. While ORS is validating the file, do not press Cancel, as ORS may have already started processing some of the records.

Optional: Click the error and warning icons in the validation results to view the reason a field is invalid.

Optional: Click Download Validation Report in the upper-right corner to view a CSV file listing the validation results for the upload file.

8.On the Validate page, do one of the following:

Click Continue with Upload. ORS commits those records that do not have errors.

Click Upload Revised File to upload a different file. Follow the prompts on the Upload Revised File page to submit, validate, and commit the file.

The Confirmation page appears, displaying a message that summarizes how many records were committed and excluded.

9. Optional: To upload another roster file, click Upload New File.

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

Table 9: Columns in the Rosters Upload File
Column Name	Description	Valid Values
District ID^a	District associated with the roster.	Any valid District ID that exists in TIDE and is associated with the user uploading the file.
School ID^a	School associated with the roster.	Any valid School ID that exists in TIDE and is associated with the user uploading the file and the District ID.
User Email ID^a	Email of teacher associated with the roster.	Any standard email address that exists in TIDE.
Roster Name^a	Name of roster.	Up to 255 alphanumeric characters.
SAISID^a	Student's ID.	Nine digits.
^aRequired field.

Table 9: Columns in the Rosters Upload File

Column Name

Description

Valid Values

District ID^a

District associated with the roster.

Any valid District ID that exists in TIDE and is associated with the user uploading the file.

School ID^a

School associated with the roster.

Any valid School ID that exists in TIDE and is associated with the user uploading the file and the District ID.

User Email ID^a

Email of teacher associated with the roster.

Any standard email address that exists in TIDE.

Roster Name^a

Name of roster.

Up to 255 alphanumeric characters.

SAISID^a

Student's ID.

Nine digits.

^aRequired field.