Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The bulk export option provides a means for an LEA to mass export data for any given number of students at one time.  The user will be required to provide a comma separated value (csv) file that contains the SSID's of the students to be included in the data export. If the user has access to multiple LEA's, the desired LEA will need to be selected. 

Table of Contents

Image RemovedImage Added

General Bulk Export Information

...

The following error messages may be seen if there was a problem during the export process.


Image RemovedImage Added

In this case, verify there are no blank lines/SSIDs in the CSV upload being used. 

Image Removed

In the case of the 'Unable to process' error, verify the format of the CSV upload file.  Ensure the SSID is in the first column.  Each SSID needs to be it's own row within the file.  See the CSV format examples above for further details.
Image RemovedVerify there are no blank lines/SSIDs in the CSV upload being used. 


Image Added

In the case of 'No records matched', ensure that the correct Agency has been selected to coincide with the SSID's provided in the CSV file.  Verify that all nine characters of the SSID are present in the first column of the CSV file.


Assessment Export
Anchor
assessment
assessment

Assessment data is exported in flat file format as defined in the EMIS Guide for the FA records.

Image RemovedImage Added

CSV Upload File

...

After selecting any filter options and selecting the CSV upload file, clicking on the Upload button will begin the export process.  The default file name will be in the format of FA-xxxxxx-yyyymmddhhmmss.txt where 'xxxxxx' is the selected agency IRN.

Special Education

...

Export 
Anchor
specialed
specialed

The special education data export will include the full details of the special education records in tab delimited format. The special education bulk export option will only use the first column of the CSV upload file, containing the SSID's to be included in the extract.  If there is data in any additional columns of the CSV file, it will be ignored.

Image RemovedImage Added


Filter Options

...

After selecting any filter options and selecting the CSV upload file, clicking on the Upload button will begin the export process.  The default file name will be in the format of Special-Education-Extract-xxxxxx-yyyymmddhhmmss.txt where 'xxxxxx' is the selected agency IRN.


Special Education Grad Required

...

Export 
Anchor
grad-specialed
grad-specialed

The special education grad required export will include the full details of the special education event and the grad requirements for that event in tab delimited format.  This data includes, but is not limited to, event date and type, exemption flag, manifest code from which the data was last reported and when it was previously reported.

The grad required bulk export option will only use the first column of the CSV upload file, containing the SSID's to be included in the extract.  If there is data in any additional columns of the CSV file, it will be ignored.  If there are SSID's included in the upload file that do not have grad requirement data, those SSID's will not be included in the resulting export. 

Image RemovedImage Added

Filter Options

...

Grad Event Type allows the user to select a specific event type to be included in the extract.  This is a drop down selection that will list all the valid event types, past and present.
Image RemovedImage Added

Using the Grad Event Date Since option, any special education event records with qualifying Grad Required data for the specified SSID's that have an event date beginning with the date entered up through the current date will be included in the extract.

...

After selecting any filter options and selecting the CSV upload file, clicking on the Upload button will begin the export process.  The default file name will be in the format of Grad-Special-Education-Extract-xxxxxx-yyyymmddhhmmss.txt where 'xxxxxx' is the selected agency IRN.


Grad Cohort

...

Export 
Anchor
grad-cohort
grad-cohort

The grad cohort data export will include the full details of the grad cohort records in tab delimited or comma separated format (depending on user selection). The grad cohort bulk export option will use the first and second columns of the CSV upload file, containing the SSID's to be included in the extract, and the optional cohort year.  If there is data in any additional columns of the CSV file, it will be ignored.

Image RemovedImage Added

File Output Format

The user can choose the file output format. The options are Tab Delimited (.txt) and Comma Separated (.csv). Tab Delimited is selected by default. 

Image RemovedImage Added


CSV Upload File

...