This article will introduce you to the Outcome Upload Tool, which allows admin users to upload or update outcomes for any job phase in bulk. This article also includes the required fields for the Outcome Upload.
Sections
1. Required Fields
2. Uploading New Outcomes
3. Updating Existing Outcomes
Required Fields
When uploading an Outcome using the Outcome Upload Tool, some fields are required and will cause the Upload to fail if not included. You will need to ensure the following fields are entered into the CSV:
- Student Identifier (typically an email address of a student uploaded to the system)
- Outcome Type
- Job Phase
- Reported Date
- Knowledge Source
The following are suggested fields, but are not required for the upload to be a success:
- Employer
- Start Date
- End Date (if there is one)
Uploading New Outcomes
- Navigate to the Data Uploads page by selecting Site Management > Data Uploads from the left hand navigation panel.
- Download the CSV template via the Download CSV Template button. Be sure to select Outcomes, the Job Phase you are uploading, and Add New as the Upload Method.
- Add your data to the downloaded template, making sure to leave the column headers unchanged. To find the valid values for the columns in your file, navigate to the Picklist tab of the Outcome Survey site settings page and select a picklist that aligns with a column in the upload template. For example, to view the values the upload tool will accept for the Outcome Type column, select "Outcome Type" from the Picklist tab of the Outcome Survey site settings page.
- Save your file in CSV format.
- On the Data Uploads page, select New Upload. Attach your file and be sure to choose Outcomes, the Job Phase you are uploading, and Add New as the Upload Method.
- Select Upload to begin the upload process.
- You will be taken to a dedicated detail page for your upload. Upon completion, the upload will display as Successful, Partial, or Invalid.If your upload was invalid or Partial, select the "hide rows without errors" box to view the rows in your file that contained formatting errors. Once you have corrected the errors in these rows, return to step 4 to continue uploading your data.
Updating Existing Outcomes
- Navigate to the Data Uploads page by selecting Site Management > Data Uploads from the left hand navigation panel.
- Download the CSV template via the Download CSV Template button. Be sure to select Outcomes, the Job Phase you are uploading, and Update Existing as the Upload Method.
- Add your data to the downloaded template, making sure to leave the column headers unchanged. To find the valid values for the columns in your file, navigate to the Picklist tab of the Outcome Survey site settings page and select a picklist that aligns with a column in the upload template. For example, to view the values the upload tool will accept for the Outcome Type column, select "Outcome Type" from the Picklist tab of the Outcome Survey site settings page.
- Save your file in CSV format.
- On the Data Uploads page, select New Upload. Attach your file and be sure to choose Outcomes, the Job Phase you are uploading, and Update Existing as the Upload Method.
- Select Upload to begin the upload process.
- You will be taken to a dedicated detail page for your upload. Upon completion, the upload will display as Successful, Partial, or Invalid.If your upload was invalid or Partial, select the "hide rows without errors" box to view the rows in your file that contained formatting errors. Once you have corrected the errors in these rows, return to step 4 to continue uploading your data.