...
- Column 1 = SSID, required
- Column 2 = Local student id, optional. This is currently only used by the Assessment export if includedThis column will vary depending upon which export option is being used. This column is optional for each of the extract options.
- File must have a .txt or .csv extension
...
Assessment data is exported in flat file format.
CSV Upload File
If desired, the local ID may be supplied in the second column of the input CSV file. If the local student ID is included, that value will be used in the resulting flat file export for the student id element. If a local student ID is not provided, the SSID will be used for the student id element of the extract file.
...
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 cohort year. If there is data in any additional columns of the CSV file, it will be ignored.
...
The user has the option to include the cohort year on each row in the second column of the CSV file.
If the year is provided, grad cohort data data from 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.
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
FF1234567,2019 CC1234567,2022 DD1234567, EE1234567,2022 GG1234567, HH1234567,2020 |
| Code Block | ||
|---|---|---|
| ||
FF1234567
CC1234567
DD1234567 |
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.
...