Student assessment records may be imported into LACES via a "generic" assessments import. This allows users to import assessments with different instruments/forms/levels on one import file for multiple students rather than entering the assessment records manually. This import is intended for state clients and independent literacy agencies who are not integrated with 3rd party assessment vendors. Keep in mind that the number of assessment records you need to enter may determine whether or not you should import, since preparing the import file can be time consuming. For example, it may be quicker to manually enter 5 assessment records than to prepare an import file.
The import file must contain the following column headings and be saved as a .CSV file before importing. Assessments are imported by Student ID. Student ID must be on the import file.
Assessments (Generic) Import Column Headings
Agency ID
Student ID (*Required unless using alternate matching)
Person ID
Student Unique Number
Student External ID
Instrument (*Required)
Form (*Required)
Level (*Required)
Test Date (*Required)
Score (*Required)
Subtest (*Required)
Essay
Percentile
Raw Score
SPL/GLE
Site
Staff Name
Min Hours Override Reason
Same Form PostTest Reason
ABE/ESL
Test ID
First Name
Last Name
Birthdate
Sex
SSN
Address1
Address2
Phone
Alternate Phone
Work Phone
Mobile Phone
Home Phone
Other Phone
Pearson Student ID
DRC Student ID
ETS Student ID
Casas Student ID
Additional Info:
Student ID, Instrument, Form, Level, Test Date, Subtest, and Scaled Score are required data for the record to import. All other fields are optional.
The instrument, form, and level must display exactly as they appear when adding the assessments manually. Make sure there are no extra leading or trailing spaces in the column headings or in the assessment information in the cells. If you get an import error, check to make sure there are no extra spaces on the import file.
Step 1:
Prepare the import file.
You may download the template from the Import Data page after you select an import type.
If creating your own file:
Open Excel or other spreadsheet program.
In the new file, enter the column headings shown above and in the screenshot below. Make sure the heading names are correct and exact with no additional spaces either before or after the column heading.
Add the assessment data to be imported.
Save the file to your computer in .CSV format. You may name the file anything you want, but the file type MUST be .CSV.
If downloading the Assessments (Generic) Import Template:
Download the template.
Save the file to your computer in .CSV format. You may name the file anything you want, but the file type MUST be .CSV.
Add the assessment data to be imported.
Make sure to save the file.
Step 2:
Import the file.
Go to the Imports area.
Click the Import Data button.
Select "Assessments (Generic)."
Not all users have import access.
Click Select File.
Locate the import file on your computer.
Select the file and then click Open.
Click the Import button.
A success message will briefly display if the import has begun successfully.
Step 3:
Check the status of the import at the Imports grid.
Open the import record.
Go to the Import Messages tab to see the status of each row of the import.
An error will be returned on the import file if the student did not have enough hours to be assessed when imported in clients with assessment and hours customizations.
Step 4:
Go to the All Assessments area and search by Creation Date to see the imported assessments.