Legacy Assessments Importer 1.0

The Assessments Importer tool helps load student assessment data into the data warehouse and address data matching issues before the data is loaded.

You can upload one or more files in a single batch (file set) for processing into the data warehouse.

File Format

• The upload file must in the right format with the correct extension (.csv, .txt).

• Use a text editor (for example, Notepad++) to view the raw assessment file. Do not use Microsoft Excel.

• Ensure the file has a header, or, if it does not have a header, the file needs to have a fixed width. Make sure you are using the file directly from the vendor and that there are no erroneous rows (anything that does not look like a header row) at the top of the file.

• The file must have UTF-8 encoding. Notepad++ or other programs allow you to update this.

• Make sure the filename has no spaces in it.

Upload a File

To upload an assessment file:

1. Select Applications in the Navigation tree.

2. Choose Assessments Importer.

3. On the landing page, click Upload Assessment.

4. Enter details for the following:

   1. District: For single-district implementations, the district is automatically selected. For multi-district implementations, you can select a single district.

   2. Assessment: The assessment for which you are importing data.

   3. School Year: The school year for which you are importing data.

   4. Time Period: The period for which you are importing data (for example, Fall, Spring, Winter, BOY, MOY, All).

5. Click Next.

6. On the Manage File Set screen, click-and-drag or select the assessment file you wish to upload.

   1. The assessment file is validated against a predefined signature file when the file is loaded.

7. After the file completes loading and the status displays File validated, click Add to fileset.

   1. If there is an issue with the file, an error displays. Common errors include duplicate filename, failed validation, exception, and incorrect file type.

8. The added file appears in a viewing panel with the following information:

   1. Status: The status of the file.

   2. File Name: The name of the file.

   3. Rec Count: The number of records on the file.

   4. Date/Time: The date/time the file was loaded.

   5. Uploaded By: The username for who uploaded it.

9. To delete a file:

   1. Select the trashcan icon on the file record, or:

   2. Select the checkbox and click Delete Selected.

10. Repeat Steps 6 and 7 to add more files.

11. When the file set is complete, select the X to close the Manage File Set screen.

Load to Staging

After the file set is created, you are directed to the Assessments in System screen.

1. Locate the file set in the left view panel. Details about the file set include:

   1. Batch name

   2. Batch status. Possible statuses are:

      1. Ready for Staging: File Staged to server assessment directory.

      2. File queued: File is queued for ETL to pick up.

      3. Loading: Assessment ETL running.

      4. Needs attention: There are student or school records that could not be matched.

      5. Ready to Process: File Loaded into assessment XTBLs all valid matches.

      6. Processing: Build running.

      7. Processing Complete: Build complete.

      8. Dashboard Status Error: Catch-all error in case something unexpected occurs.

   3. Batch Created date.

   4. Map: Student-school not mapped count.

   5. User: Student-school user mapped count.

   6. Skipped: Student-school skipped mapped count.

   7. Load: Loaded test admin count.

   8. Val: Not validated test admin count.

2. If needed, click Upload if you want to load another file set or batch.

3. Select the hamburger menu to take actions (available actions depend on the batch status):

   1. Manage File Set: Users can select this to make changes to the batch on the Manage file set screen.

   2. Run Staging on Batch: Users can select this to load the data from their file set to staging. When this option is selected, the batch status updates to either Needs Attention (unresolved issues) or Ready to Process.

   3. Run Process on Batch: After a batch has completed the Run Staging on Batch action, users can select this to load their data to the data warehouse.

Load to Data Warehouse

If the file set has a batch status of Ready to Process, you are ready to process the file into the data warehouse.

1. From the hamburger menu, select Run Process on Batch.

2. Click Yes to confirm.

   1. While the file is processing, the status is Processing.

   2. After processing completes, the status updates to Processing Complete.