Every import is listed with what went in and what didn't. A failed import names the row and the reason, which is what you fix before trying again.
The table
The history sits under the import steps on Settings, then Data Imports, newest first, with Load more for older ones.
| Column | Shows |
|---|---|
| Created | When it was started, and by whom |
| Datasource, Format, Location | What was imported, in which format, into which location |
| File | The uploaded file's name |
| Rows | Rows in the file |
| Status | Pending while queued or running, then completed or failed |
| Result | Rows added, updated and skipped, or the error that stopped it |
Reading a failure
A file is one batch, so one bad row stops the lot: Nothing was imported — the whole batch was rolled back after an error. The Result names the row: Row 57: duplicate of existing record #1043, Row 12: duplicate key also seen earlier in this file, or the field problem on that row. Fix the row in the file, or choose a different If a row already exists option, and import again; with Skip duplicates a repeat run is safe. A file that could not be read is usually the wrong format for the datasource, or a spreadsheet saved as something other than CSV.