Import Scores From File Page

On this page:

Use this page to use an import definition to load test data from a file to the database. This utility has two modes. Run the utility in verify mode to check that data will be loaded correctly. Then run it in update mode to update and (or) insert eSchoolPlus records.

Prerequisite

Use the Test Score Import Definition option to create the import definition that specifies how the data should be loaded to eSchoolPlus test tables.

Transfer the data file to your report directory

Select Administration from the main menu, select Utilities submenu, select Download & Upload, and then select Upload File.
In the File field, click the Choose File button to search for and select the file you want to upload.
Click
(Upload Records).
Click Tasks/Reports to verify that the file was uploaded to your report directory.

Run the Test Score Import

Select Test Scores from the main menu, select All submenu, select Utilities, and then select Import Scores from File.
Verify that your import interface is defined correctly for the data file by setting the Run Mode to Verify upload data without updating database and click Run.
Click Tasks/Reports and open the Test Score Import Log and review the SQL to verify that data will be correctly updated or inserted.
If the SQL is not correct, review the data file and the import definition. Then make the necessary corrections to the definition. After you have changed the import definition, repeat steps 1 - 3 until the SQL is correct.
Select Test Scores from the main menu, select All submenu, select Utilities, and then select Import Scores from File to open the Run Test Score Import page.
If you want to back up test data before you run the import, click
(Additional options), and then select Backup.
Run the import in update mode by setting the Run Mode to Run Test Score Import, updating the database and click Run.
Click Tasks/Reports and open the Test Score Import Log to review any errors.
Check test records that were loaded to verify that records are correct. Select Test Scores > All > Office > Test History by Test. Search for the test you just imported and then click the Test Date link for a student to review the data on the Student Test Detail page.
If you are not satisfied with the results of the import and you ran a backup before you imported data, you can restore data from the backup.
Select Test Scores from the main menu, select All submenu, select Utilities, and then select Import Scores from File. Click
(Additional options), and select Restore.

Caution

Use caution when using the Backup and Restore options if more than one user runs uploads or updates testing information within the district. The backup option backs up all data in the tables processed by the interface. It does not selectively process a building or test. Thus, if another user updates testing data between the time of the backup and restore, the user's data will be lost.

Fields

Prompts Panel

Field	Description
Interface ID	Import definition you want to run.
Test - Level - Form	Displays the test, level, and form for which you are loading data.
Test Date	Date that the test was taken. This field is inaccessible if the import definition has the test date defined as a field to import.
Run Mode	Select the mode in which you want to run the upload. Select: Verify upload data without updating database: to run the upload in verify mode. The Test Score Import Log file will include the SQL statements that will be used to update the database. You can review the SQL to make sure that there are no errors. Run Test Score Import, updating the database: to run the upload to insert records or update existing records.
Insert New Records	Checked if you want the upload to create new records based on data in the file.
Update Existing Records	Checked if you want the upload to update existing records.
Only Update Blank Fields	Checked if you want the upload to only update fields that are blank.
Import Directory	Path where the source file is stored. Select: User's report directory: to indicate the file is stored in your report directory. This directory: to enter the directory where the file is stored. To specify a different computer, enter the path as follows: \\machinename\DriveLetter$\path
File Name	Filename of the source data including file extension. Character (255) The default comes from the Test Score Import Definition, but you can change it.

The existing Test Score Import Files (Import Score from File) option can be used with the Student Portal Access Code (SPAC) upload processing in the Run Upload utility to load the Student Portal Access Code from the Assessment Score files directly into the District Defined PEIMS Demographics page. The SPAC file name must be SPACUpload.txt.