Skip to end of metadata
  • Created by Former user, last modified by Former user on Mar 11, 2020
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

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.  Currently assessment data is the only bulk export option available.  The data is exported in flat file format.


If the user has access to multiple LEA's, the desired LEA will need to be selected. 

CSV Upload File

A comma separated value (CSV) file will need to be uploaded to the application to indicate the students to be included in the export. 

  • Column 1 = SSID, required
  • Column 2 = Local student id, optional
  • File must have a .txt or .csv extensio

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 following are examples of CSV file formats that are valid for upload and processing by the Bulk Export option. 

SSID and Local Student ID
YY1234567,ABCDEFGHI
WW1234567,SHORT321
XX1234567,000001101
AA1234567,NAN000100
SSID only
AB1234567
BB1234567
CC1234567
Mixed Format
FF1234567,STUDENT15
CC1234567,SHORT8
DD1234567,
EE1234567,000123456
GG1234567,
HH1234567,880001010


Local Student ID Format

If the student data source system uses local student ids with leading zeroes or spaces, it will be necessary to include the leading zeroes/spaces in the CSV file.  If, for example, only five characters/digits are supplied for the local id in the CSV file, the result in the export file will be the five characters/digits with four trailing spaces.
'ABCDE    '
'12345    '
If the local student id '12345' has leading zeroes, it needs to be supplied in the CSV file as
AA1234567,000012345


Filter Options

For the export of assessment data, the type of assessments to be included in the export may be defined using the filter options.

The Clear button will reset all the filter options to an empty state, resulting in all assessments for the students being included in the export.

Assessment Type allows for selection of a specific assessment type.  This includes assessments that may have been given in the past and are no longer assessed.  The drop down list includes all available assessment types, past and present.

Subject allows for selection based on a subject area.  The list of available subjects will include all available subject areas for all assessment types, past and present.  Care will need to be taken to select the appropriate subject area based on the assessment type being targeted.  For example, there are several math related subject areas

'M' is valid for many of the assessment types; AC, GA, GD, GN, GO, GX, SA and WK whereas 'MTH1' and 'MTH2' are valid for the GE assessment type only.
If 'GX' was selected for the assessment type and 'MTH1' was selected for the subject, this would result in nothing being found as there will never be an MTH1 subject area for a GX (OGT) assessment type.
The subject filter may be used standalone.  For example, selecting 'M' for Math, leaving the other filter options clear would result in any assessment type with a subject area of 'M'.

Test Grade Level allows for selection by test grade level.  The list includes all possible testing grade levels.

Assessment Group allows for selection of assessments based on a grouping category.  Available options are:

  • Graduation Tests = AC, AP, GE, GW, GX, IB, SA, and WK assessment types
  • Other Tests = All other assessment types not listed above for Graduation


Process/Save Export File

After selecting any filter options and selecting the CSV upload file, clicking on the Upload button will begin the export process.  Depending on the browser used and settings within the browser determines if the user will be prompted where to save the file and file name to be used. The default file name will be in the format of FA-xxxxxx-yyyymmddhhmmss.txt where 'xxxxxx' is the selected agency IRN.

Possible Errors


In this case, verify there are no blank SSIDs in the file being used. 


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

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.


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.



  • No labels