VFA Bulk Upload Instructions

Click here for a PDF of these instructions.​​​​​​​​​​
 

 VFA Bulk Upload Files

 

The four bulk upload files below correspond to the four VFA cohorts:

    1. Six Year Cohort (2010)​
    2. Two Year Cohort (2014)
    3. CTE Cohort (2013-14)​
    4. ABE Cohort​ (2013-14)

Review the instructions below on how to prepare and upload the bulk file(s).

VFA Bulk Upload Instructions


After you have
Set-Up Data Input, uploading your files is easy:

  1. For the upload of your data to work, the file needs to be converted into a comma delimited (.CSV) file. The upload process will not work with an Excel file. CSV
    • To convert your file to a comma delimited file:
      • Create a CSV file directly from your ERP using the format specified; or
      • Input your data into the bulk upload file and then save the bulk upload file as a CSV (comma delimited) file.

  2. From the Data Landing page, click Bulk Data Files Upload. Only the cohorts chosen in Set-up Data Input will be available for upload.

  3. Click “Choose File” to find your prepared bulk upload file. Click “Submit” to begin the upload process.

  4. After the file is processed, the Status note will update to indicate if the file uploaded successfully.

Read the following information carefully PRIOR to uploading your data.


  1. Colleges can only upload one file at a time. VFA will supply four bulk upload files corresponding to the four VFA cohorts (Two Year Cohort, Six Year Cohort, CTE, and ABE). Users are unable to upload all four cohorts in one, combined file.

  2. Within each of the four files (Two Year Cohort, Six Year Cohort, CTE, and ABE) data are sectioned into blocks.
    • Each block begins with two lines:
      • Title of the block (e.g.  COHORTS_DISAGGREGATED)
      • Names of the fields (measures) associated with that data block

    • The data blocks are as follows:
      • Developmental Math
      • Developmental English
      • Developmental Reading
      • Any Developmental
      • Two-Year Progress
      • Six-Year Outcomes
      • Career and Technical Education
      • Adult Basic Education

  3. Data blocks being used must be left UNALTERED. All the labeling, columns/rows, and ordering must be present. Altered data blocks will cause the upload to fail.

  4. HOWEVER, data blocks can be removed in their entirety from the file if the user wishes to not report a block of data or to prevent the system from overwriting data that are already entered in that block.

  5. The bulk upload will OVERWRITE any data previously uploaded or manually entered for that cohort. Therefore:
    • Any data left blank in an uploaded file will load as null and delete any previously loaded data.
    • In order to prevent data loss, colleges can download and edit a .csv file of your college’s previously entered data. This bulk download is in the same format as the bulk upload file.

  6. Data with data entry and validation errors will be uploaded. Errors will appear on the Data Entry Online Forms and in the Data Validation Report.

  7. Data entered through the bulk upload process are to be reviewed through the Data Entry Online Forms; the user can make changes and edits online.

 Important Notes:

  1. Bulk uploads will OVERWRITE any data previously uploaded or manually entered for that cohort.
  2. The upload process will fail only if the file is not set-up properly.
    • See below for instructions on how to troubleshoot upload errors.
  3. Once the file data is uploaded, you can see your data in the Data Entry Online Forms and in your dashboards.
Troubleshooting Upload Failures
  • The file must be saved and uploaded as a comma delimited (.CSV) file.
  • Each file must begin with COLLECTION_CYCLE line. (For Year Three, the COLLECTION_CYCLE should read 2015-16). 
  • All headers and fields should be in the order they appear in the original file; Do NOT remove or reorder. 
  • Cells should only contain numbers and should be formatted in a ‘general’ format. Do NOT change the format of the cells. 
  • No non-numeric values ("#", “-“) should be entered into the file. To keep a value null, please leave the cell blank. 
  • If a field is left blank, then the value is null. 
  • If the user enters a 0, then the value is 0.