Table of Contents

How do I import student data?

The “Import Data” feature gives Super Administrators the ability to import student data directly into the SpEd Forms database from a “comma delimited” text file. The fields must match exactly with the order of the fields in your import file-

You must contact SpEd Forms to setup a transfer folder. The transfer folder will allow you to upload files containing the comma delimited data to be imported into your SpEd Forms database. Once the transfer folder has been setup, follow the instructions on this page for details about accessing your transfer folder:

http://www.spedforms.com/guide/webfolders.asp

Importing student data:

  1. Navigate to the main administration “Reporting” menu.
  2. Click the “Super Admin” tab.
  3. Click the “Import data” report.
  4. Click the “Import Student Data” link.
  5. Upload the import file to the transfer folder naming it “data_custom.csv”.
  6. Select the IEP Manager for the newly imported students.
  7. Select which fields to include in the import.
  8. Click the “Preview Data File” button.
  9. Review the data that will be uploaded.
  10. Click the “Upload this Data” button.

Important rules for import files:

  1. The import file must be a comma delimited text file.
  2. Text fields should start and end with double quotes.
  3. If a record in the import file already exists in SpEd Forms, the record will be updated with information contained in the import file.
  4. If a record in the import file does not exist in SpEd Forms, the record will be added to SpEd Forms and assigned to the default IEP managers.
  5. If an import field is empty, the corresponding field in SpEd Forms will not be updated.
  6. If an import field contains the word “NULL”, the corresponding field in SpEd Forms will be set to null (erased).