−Table of Contents

How do I import MARSS 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.

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 MARSS Data:

  1. From the Administration Menu, go to “Reporting”.
  2. Click the “Super Admin” tab.
  3. Click the “Import data” report.
  4. Click the “Import MARSS file” link.
  5. Upload the import file to your transfer folder.
  6. Enter the name of the import data file in the transfer folder.
  7. Select the IEP Manager for the newly imported students.
  8. Click the “Preview Data File” button.
  9. Review the data to 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 manager.
  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).