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 |
|---|
General Bulk Export Information
...
Assessment data is exported in flat file format.
CSV Upload File
...
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.
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.
Grad Cohort Export
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 only use the first and second columns of the CSV upload file, containing the SSID's to be included in the extract, and the optional year. If there is data in any additional columns of the CSV file, it will be ignored.
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.
CSV Upload File
The user has the option to include the year on each row in the second column of the CSV file.
If the year is provided, grad cohort data only from that year will be included in the output file. If a year is not provided, grad cohort data for all years will be included in the output file.
The following are examples of CSV file formats that are valid for upload and processing by the Grad Cohort Bulk Export option in addition to the SSID only example shown above in the General Bulk Export Information section.
| Code Block | ||||
|---|---|---|---|---|
| ||||
YY1234567,2021
WW1234567,2022
XX1234567,2020
AA1234567,2019 |
| Code Block | ||||
|---|---|---|---|---|
| ||||
FF1234567,2019
CC1234567,2022
DD1234567,
EE1234567,2022
GG1234567,
HH1234567,2020 |
Process/Save Export File
After selecting the file output format and 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-Cohort-Extract-xxxxxx-yyyymmddhhmmss.txt where 'xxxxxx' is the selected agency IRN.
...