Featured Guide Pages

Featured Guide Pages

Start of Year Advice

Helpful Advice

Password Advice

Student List Filters

Activity Log Time Entry

Exclusive Rights explanation

User Guides

Educator's Guide Contents

Getting Started

Getting Started

Managing Students

Managing Students

Managing Forms

Managing Forms

Evaluation Reports (ER's)

Evaluation Reports (ER's)

Enrollment and Attendance

Enrollment and Attendance

User Tools

User Tools

Frequently asked questions (FAQ)

Administrator Guide Contents

Getting started

Getting started

Administrative Features

Administrative Features

Searchable Administrative Reports

Searchable Administrative Reports

Enrollment and Attendance

Enrollment and Attendance

Built-in Reports

Built-in Reports

Custom Reports

Custom Reports

User Tools

User Tools

Frequently Asked Questions (FAQ)

MA Guide Contents

MA Guide

MA Guide

MA Admin Guide

MA Admin Guide

Submitting support requests

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).
sa_reports_import_student_data.txt · Last modified: 2021/03/03 11:36 by 127.0.0.1
CC Attribution-Noncommercial 4.0 International
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0