When a System Administrator is importing data through CSVs, ZIP or API, now, when a CSV import fails - downloadable reports will be available to assist troubleshooting.
In System Administration, by going to the Data Transactions and clicking on View Transaction three reports will be shown:
- the Valid Rows from the Failed Import, which are the validated rows that are ready for re-import.
- the Invalid Rows from the Failed Import, which are the rows that failed validation due to errors.
a Full Error Report from the Failed Import, which is a full error report for troubleshooting.
Above shows the 'View Transaction' flyout on the Data Transaction Page
Notes
- Available for all import csvs, except the organizations.csv
- In order to produce the Valid Rows Report and the Invalid Rows Report the file must first pass pre-validation, which means:
- all unique_IDs (e.g. term_id, section_id) must be unique in the import csv
- all headers (aka columns) in the file must be correct
- If these two conditions are not met, a PARTIAL error report will be produced displaying specific rows for one error at a time. If the two conditions are met, a COMPLETE error report will be produced displaying all rows for all errors at once.
- To best troubleshoot, cross-reference the Full Error Report against the Invalid Rows Report.