Lexia

Lexia Tech Note #100305

Creating a Tab-Delimited File for Import into a pre-Lexia Reading Product

Lexia Programs

Early Reading 3.x
Primary Reading 1.x
Phonics-Based Reading 4
Strategies for Older Students 4.x
Quick Reading Test 2.x
Cross-Trainer 1.x

Version

Early Reading 3.x
Primary Reading 1.x
Phonics-Based Reading 4
Strategies for Older Students 4.x
Quick Reading Test 2.x
Cross-Trainer 1.x

Platforms Affected All
Description

To import a non-Lexia file into a pre-Lexia Reading database, you need a tab-delimited file. Tab-delimited files can be created from Excel files, other spreadsheet programs, or database programs, but they must be converted to text files, with a .txt extension. The field headers are essential to the import process and are case-sensitive; therefore, be sure to enter your header line to match the labels in bold, listed below. Your file must include every field, though some of the fields can be empty.

In addition, the fields must be in the following order:

  1. Student ID - Data required, any number from 1 to 99,999
  2. First Name - Data required
  3. MI - No data required (an empty field is sufficient.)
  4. Last Name - Data required
  5. Username - Data required (must be unique)
  6. Password - No data required (an empty field is sufficient)
  7. Date of Birth - Format is mm/dd/yyyy. No data required, an empty field is sufficient
  8. Sex - Value is M or F. No data required, an empty field is sufficient
  9. Grade - Value is K-12. No data required, an empty field is sufficient
Note that student data can include upper- and/or lower-case letters, whereas the field labels on the first line must match the labels listed in bold exactly.

Keywords import, export, tab-delimited