Sidebar
testscores:utilities:importtestscores
Import Test Scores
Test Scores > Utilities > Import Test Scores
This utility imports and updates records from a fixed-length text file (unless otherwise noted) created by third-party testing software.
The utility also imports the testing data into the most current enrollment record for students who were enrolled in a prior year but are not enrolled in the current year. The Maintenance > Individual Maintenance page can also be used to add or update test data.
File Layouts:
- Click here to view ASCENDER Interfaces that can be used to import and export ASCENDER data from and to third-party products, including file layouts for each test. (Click the Student Interfaces tab.)
- For TELPAS, click here to view the file layout provided by TEA.
- For more information about data file formats, see the Data File Formats page at the TEA website.
Click here to view information for ASCENDER ParentPortal Single Sign-on.
Import test data:
❏ Select the Test Type to import:
| ACT Test |
Students who test more than once will have multiple records imported with the same month and year; however, the test location will vary. Warning: If imported records have the same administration date and test location as existing records in the ACT table, the imported records will overwrite the existing records, and all manual updates will be lost. |
|---|---|
| ACT Plan Test |
The import file must be a DAT file. |
| AP Test |
NOTE: To edit an AP data file from a testing center before importing it, use a text editor only. |
| EOC/STAAR Alternate 2 EOC Test |
For admin year 2014 and later, the import compares the student's Texas Unique Student ID with the ID in the import. If they do not match, the student is not imported. If they do match, or if an ID is not included in the import, the
program verifies that the student's SSN, DOB, and last name match the values on Registration > Maintenance > Student Enrollment > Demo1. If any of these fields do not match, the student is not imported, and a list of errors is generated. |
| EOC Cumulative Hist Test |
This is applicable for test admin year 2014 and later. |
| EOC English Trans Test |
Pearson provides LEAs with a .csv file of students who passed either the reading or writing assessment for previous English I and/or II exams, met the minimum score on the other, and achieved at least a combined scale score of 3750. If the combined total on the reading and writing assessments is less than 3750, the file is not imported. |
| ITBS Test |
You must use the file import Form RPC12 to prevent errors when importing data. The file must be delimited by either comma or tab (not pipe), or use fixed width. Do not use the custom option. |
| PSAT Test |
The data import is typically a fixed-length text file format. |
| SAT Test |
The import allows both a fixed-width positional and a comma-delimited (CSV) file import. |
| STAAR 3-8/STAAR Alternate 2 3-8 Test |
For admin year 2014 only, the import compares the student's Texas Unique Student ID with the ID in the import. If they do not match, the student is not imported. If they do match, or if an ID is not included in the import, the program verifies that the student's SSN, DOB, and last name match the values on Registration > Maintenance > Student Enrollment > Demo1. If any of these fields do not match, the student is not imported, and a list of errors is generated. |
| TAKS Test |
The Ignore record length validation field is displayed if you select TAKS Test. Select the field if you want to be able to import a file that has fewer than 500 characters. The standard import record length is 500 positions; however, if the field is selected, the import program bypasses the length validation and accepts any length record without generating an error. Therefore, if you create a file to import that has fewer than 500 characters, you do not have to space out the remaining positions. Even if the Ignore record length validation field is selected for the TAKS test, position 500 of the test record must contain a period. |
| TELPAS/TELPAS Alternate Test |
The data is typically a fixed-length text file format. The file extension is .txt. |
| TSI Assessment |
This option imports the Texas Success Initiative Assessment (TSIA) scores from a CSV file and generates an error report for invalid records found in the import file.
WARNING: If imported records have the same Test Start Date and Test End Date as existing records in the TSIA table, the imported records will overwrite the existing records, and all manual updates will be lost. |
❏ Click Choose File to locate the file on your local computer or network, and click Open.
The file name is displayed.
❏ Click Import.
When the process is complete, if no errors were encountered, a message is displayed indicating the number of rows imported with no errors. Click OK to close the window.
If errors were encountered, a message opens displaying with total count of records not imported, total warnings, and total records imported. Click OK to close the window. Then, click Show Error Rpt to view the error report.
• If the Severity column displays “Warning,” the record was imported; however, you should review the record for accuracy.
• If the Severity column displays “Error,” the record was not imported.
WARNING: The error report is only available at the time of the import. You must save or print the report at this time; it will not be available to view or print after you close the report window.
testscores/utilities/importtestscores.txt · Last modified: 2023/10/16 19:59 by apape