Import Accommodations

Last Updated on May 7, 2026

Before you begin

  • Imported Accommodations must use a CSV accommodations import file layout that can be read by the portal. To access the CSV accommodations import sample file and information to help you complete it, see  Accommodations Import Layout Instructions.
  • DRC recommends importing designated supports and accommodations early in the test setup window.
  • Always verify designated supports and accommodations prior to printing and distributing test tickets.
  • To remove all Accommodations for a student through Import Accommodations, upload the student with no designated supports and accommodations.

When the CSV file(s) are complete, follow these steps

To import an Accommodation file, do the following:

  1. From the My Applications menu, click Import Management.
  2. Click  Select a Site … and enter the name or code of the school or district to which you want to import.
  3. On the Import Management page, click the Start New Import button and the New Import window displays.
  4. Complete the fields as follows:
    • Import Job Title: Enter a recognizable name.
    • Select Import Type: Select Accommodations.
    • Import Action (either of the Import Actions below can be used for the first file import):
      • Update/Replace Accommodations: Select this option to update or replace designated supports and accommodations that have already been assigned. This option will overwrite previously assigned designated supports and accommodations for all participants that are included in the file and should therefore include all needed designated supports and accommodations.
      • Append Accommodations: Select this open to add additional designated supports and accommodations. This option may be used for adding additional designated supports and accommodations for a participant.
    • Click Browse to navigate to the files on your system or you can drag and drop the files into the drag and drop area of the window.
  5. Click the Start Import button to import the files into Import Management. The import job displays in the Import Management grid. While the job is being processed, the status for the job is In Progress.
  6. When the import job completes, it will be in COMPLETED status or  VALIDATION ERRORS status.
    • If the job is in VALIDATION ERRORS status, click the job to display the error report. Update your CSV file to fix all of the errors shown in the error report. Once you have corrected the errors in the CSV file, restart the import process (return to Step 2).
    • If the job is in COMPLETED status, click the job to display the Details report.

Accommodations Import Layout Instructions

This topic shows you how to complete the CSV Accommodations Import file layout. First, download the sample extract file and save it to your system.

Note: The file downloads as an .xlsx file. You must save it as a CSV file after downloading it (See Save the Excel File as a CSV File).

Use the table and rules listed below to help ensure the Accommodations Import file is completed correctly and will upload. When the CSV file is completed and saved to your system, you can import the Accommodations file into Import Management.

Accommodations Import File Layout Guide and Rules
Ref Data Field Max Length Acceptable Values Description
1 District Code 10
  • Alpha/Numeric
  • 0-9, T; leading zero(s) required
  • Must be ten char/digits exactly; If leading zeros are not included, DRC shall pad the value with leading zeros
 DPI assigned 10 digit system code.

The district code must match the district code displayed in the DRC INSIGHT District dropdown menu.

The district code must be the same for all records in the file.
2 State ID 10
  • Numeric
  • 0-9
Student’s State ID (WISE ID)
Must be 10 digits exactly
3 Last Name 35
  • Alpha/Numeric
  • A-Z, a-z, 0-9, blank, hyphen/dash (-), apostrophe (‘), period (.), space ( )
 Last Name of Student
4 First Name 35
  • Alpha/Numeric
  • A-Z, a-z, 0-9, blank, hyphen/dash (-), apostrophe (‘), period (.), space ( )
 First Name of Student
5 Date of Birth 10
  • Alpha/Numeric
  • MM/DD/YYYY; M/D/YYYY; M/D/YY
  • MM = 01-12; 1-12
  • DD = 01-31; 1-31
  • YYYY = 2004-2019; 04-19
  • Leading zero for month and day is not required
 Date of Birth for the student.
Min year = 2004; Max Year = 2019
6 Content Area 21 English Language Arts
Mathematics
Science
Social Studies		 For each student, one row for each Content Area for which Accommodations the student is assigned.
7 Designated Supports and Accommodations N/A Online.ContrastingColor
Online.Masking
Online.SpanishEnglishAudio
Online.SpanishAudio
Online.HATS
Online.BD
Online.CO
Online.MAG
Online.NB
Online.RA
Online.RAS
Online.SC
Online.SS
Online.SGT
Online.TI
Online.SignLanguageASL
Online.Abacus
Online.ARO
Online.Braille
Online.NEC
Online.MT
Online.PrintTest
Online.RAP		 Choose all designated supports and accommodations that apply for this content area, separated with a pipe delimeter (|)EX: Online.Abacus|Online.ContrastingColor

Below is a list of the available designated supports and accommodations that map to the acceptable values in Column D:

DS – Color Preferences [CP or CTC]
DS – Masking [MSK]
DS – Stacked Translation (Spanish) English Audio [STE]
DS – Stacked Translation (Spanish) Spanish Audio [STS]
DS – Hearing Assistive Technology [HATS]
DS – Word-to-Word Bilingual Dictionary [BD]
DS – Color Overlay [CO]
DS – Magnification [MAG]
DS – Noise Buffers [NB]
DS – Read Aloud (Human Reader) in English [RA]
DS – Read Aloud (Human Reader) in Spanish [RAS]
DS – Scribe [SC]
DS – Separate Setting [SS]
DS – Small Group Translation [SGT]
DS – Translator/Interpreter [TI]
A – Video Sign Language (VSL) [VSL (ASL)]
A – Abacus [AB]
A – Alternate Response Options [ARO]
A – Braille [BRL]
A – Non-embedded Calculator [NEC] – Math grades 6-8 only
A – Multiplication Table [MT] – Math grades 4-8 only
A – Print on Demand [POD] – Requires DPI approval
A – Read Aloud (Reading Passages for Visually Impaired) [RAP] – Requires DPI approval

Rules for the CSV file

  1. The CSV file must contain a header row that includes all Column Name Titles in the table above.
  2. If a header row is not included, the first student will be removed from the file.
  3. The CSV file must contain data in the order listed in layout.
  4. The fields cannot be longer than the value in the Maximum Length Column in the table above.

Save the Excel file as a CSV file

To save the Excel file as a CSV file do the following:

  1. Open file in Excel.
  2. On the menu bar, click File, then Save As.
  3. Choose a location you want to save the file.
  4. Click on the down arrow in the Save as type box and select CSV (Comma delimited) (*.csv).