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
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
- Job/Offer Status (Jobs and Internships only)
- Reported Date
- Knowledge Source
Please note if using Outcome ID instead of email address as Unique Identifier - Excel’s automatic formatting may be converting your 12twenty Outcome IDs into scientific notation, causing the system to not recognize them. To resolve this, please ensure that before you paste or import your data, the column containing the 12twenty ID is formatted as "Text".
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.
Frequently Asked Questions
I added the 12twenty IDs to a Data Upload but I'm still getting an error about the 12twenty IDs, why?
This most likely indicates that the data upload is using the wrong 12twenty IDs. This most often happens with an Outcome Data Upload because Outcomes, Employers, and Contacts have 12twenty IDs in addition to Students. The best way to make sure you're pulling the correct 12twenty IDs is to create a Custom Report for the specific thing you're uploading - for example, an Outcomes Custom Report. You can find more information on creating Custom Reports here.
Once you've begun creating a custom report, make sure that you're adding the 12twenty ID from the correct entity - in this example that's the Outcome, we can see it highlighted in dark gray:
What does it mean when admins get the error: The selected education is not that of the student?
The students has multiple linked accounts, so we suggest you use students 12twenty ID instead of their email address.