Add Users via Bulk Upload: Overview

LEA and test site coordinators can use the Upload Users screen to add TOMS users in bulk. LEA and test site coordinators can either edit the file of assigned users from the previous year’s test administration or download a template from TOMS, and then manually enter all users’ information on the Excel spreadsheet.

Quick Instructions

Detailed Instructions

1. Prepare a User File—Prepare a file of users to upload to TOMS by either editing the previous year’s file or downloading the Excel template.
2. Validate the User File—Initiate the validation of the prepared file before uploading it to TOMS.
3. User File Validation Results—Review the file validation results.
4. Uploaded User File Status—Review the status of the file upload.

Quick Instructions

1. Prepare a file of users to upload to TOMS by either editing the previous year’s file or downloading a template.
   • Option 1: Edit the file of assigned users from the previous year’s test administration as follows:
     1. Select the [LEA Reports > User List] link in the “Modify File from Previous Administration” section on the Prepare a File progress step.
     2. On the LEA Reports screen, select either the “CAASPP LEA User List Report” or the “ELPAC LEA User List Report.”
   • Option 2: Select the [DOWNLOAD TEMPLATE] button to download the Excel template from TOMS.
2. Take the following steps to prepare the file:
   • Save the downloaded file to a local device.
   • Complete the file in Excel.
   • Save the completed file in.xlsx file format to the local device. Make a note of the file’s location on the local device.

   After the template has been completed, select the [NEXT] button to move to the Validate File progress step.

   In the Select File to Validate field, select the [Browse] button (Internet Explorer and Edge or Firefox) or the [Choose File] button (Chrome) to navigate to the location—on the local device—of the completed file, and then highlight the file.

   • To validate the file and view the results displayed under the File Validation Results progress step of the Upload Users screen, select the [NEXT] button.
   • Otherwise, to return to the Prepare a File progress step to check or correct the file before validation, select the [PREVIOUS] button.

Detailed Instructions

Follow these steps to create several new TOMS users at once using bulk upload. (For more details about any step, select its link.)

1. Prepare a User File—Prepare a file of users to upload to TOMS by either editing the previous year’s file or downloading the Excel template.
2. Validate the User File—Initiate the validation of the prepared file before uploading it to TOMS.
3. User File Validation Results—Review the file validation results.
4. Uploaded User File Status—Review the status of the file upload.

When adding users, coordinators should keep the following in mind:

• Each TOMS user can be assigned multiple roles using the same email address, even across sites. For each user, add one line per role to the template. For example, if User A is assigned two roles at Site One and one role at Site Two, add three lines to designate all three roles for User A (one for each role).
• LEA coordinators can submit user information only for schools within their LEA; test site coordinators can submit user information only for the school site with which they are associated.

To open the Upload Users screen (figure 1), select the [Users] navigation tab from the top navigation bar, and then select the [Upload] action tab.

Figure 1. Upload Users Navigation

1. Prepare a User File

   Use the Prepare a User File progress step to either edit the file of assigned users from the previous year’s test administration or to download a template from TOMS, and then manually enter all users’ information.

   1. Do one of the following:
      • Option 1: Edit the file of assigned users from the previous year’s test administration:
        • Select the [LEA Reports -> User List] link in the “Modify File from Previous Administration” section on the Prepare a File progress step.
        • On the LEA Reports screen, select either the “CAASPP LEA User List Report” or the “ELPAC LEA User List Report.”
          • Make sure to change the administration year to “Previous School Year” to retrieve the previous test administration users.
      • Option 2: Select the [DOWNLOAD TEMPLATE] button (figure 2) to download the template from TOMS
   2. Take the following actions to prepare the file:
      1. Save the downloaded file to a local device.
      2. Complete the file in Excel.
      3. Save the completed file in.xlsx file format to the local device. Make a note of the file’s location on the local device.

      After the template has been completed, select the [NEXT] button to move to the Validate File progress step.

      

      Figure 2. Prepare a File

2. Validate the User File

   Use the Validate File progress step to validate or check the format of the completed.xlsx file to be uploaded to TOMS (figure 3). Validation file results will be displayed when file validation finishes.

   1. Upon returning to TOMS, in the Select File to Validate field, select the [Browse] (Internet Explorer and Edge or Firefox) or [Choose File] (Chrome) button to navigate to the location—on the local device—of the completed file, and then highlight the file.
      • To validate the file and view the results displayed under the File Validation Results progress step of the Upload Users screen, select the [NEXT] button.
      • Otherwise, to return to the Prepare a File progress step to check or correct the file before validation, select the [PREVIOUS] button.

   

   Figure 3. Validate File

3. User File Validation Results

   Use the File Validation Results progress step to view the validation results of the file upload(s) (figure 4). When a file is successfully validated, the [UPLOAD] button is displayed. Select it to upload the file to TOMS. A red “Errors” message indicates that the file contains errors. The number of errors is displayed alongside, in parentheses. To download the list of errors, select the [Download Errors] down arrow [] icon. Depending on the size of the file, validation may take up to one hour.

   

   Figure 4. File Validation Results

   Table 1 describes each field on the File Validation Results progress step.

   Table 1. Fields on the File Validation Results Progress Step

   Name	Description
   #	The row sequence number for each row in the list.
   Date and Time	The date and time the file was validated.
   Filename	The name of the.xlsx file validated.
   Status	The status of the file validation. The status can be any of the following: Processing—The file validation is in process. Errors—If errors are present in the file, this status will appear along with the number of errors found during file validation. The number is an active hyperlink. Select the link to view a pop-up list of the errors. Uploaded—The file was validated and uploaded successfully. Expired—If the validated file is not uploaded before the next day, the file will expire and will no longer be available for upload.
   Actions	The [Download Errors] down arrow [] icon is displayed when errors are found during file validation. Select this icon to download the list of errors found during file validation. The [UPLOAD] button is displayed for a file that was successfully validated. Select it to upload the file to TOMS.

4. Uploaded User File Status

   The Uploaded Files progress step shows LEA and test site coordinators the status of their uploaded files (figure 5). Table 2 describes each field on the Uploaded Files progress step.

   Successfully uploaded files will display a status of “Uploaded.” If a file is not listed in the status column of uploaded files, it may have failed to upload, or it may not have been uploaded before the next business day. These files can be found on the File Validation Results screen (figure 4). The user will need to upload these files again.

   • To return to the Prepare a File progress step of the Upload Users screen, select the [DONE] button.
   • Otherwise, to go back to the File Validation Results progress step, select the [PREVIOUS] button.

   

   Figure 5. Uploaded Files

   Table 2. Information Displayed on the Uploaded Files Progress Step

   Name	Description
   Uploaded Files List	The list of files uploading to TOMS after the file upload is initiated (This list displays the status of the file upload along with the other information described next.)
   #	The row number for each row in the list
   Date and Time	The date and time the file was uploaded
   Filename	The name of the.xlsx file uploaded
   Status	The status of the uploaded files including the following: Processing Error—A system-related issue prevents the file from fully uploading. Processing—The file is being processed. Uploaded—The file upload is successful and complete.
   Actions	The [Download Errors] down arrow [] icon that indicates errors in the file (Select the icon to download an Excel file listing the errors.)