How do I revert a CSV import?
Overview
If an import brought in the wrong data, you can revert it instead of cleaning up records one at a time. Revert archives the new records an import created and restores the existing records it updated to their previous values. Only the imported rows are affected, and only if they haven't changed since.
Important things to know
-
New Import only: Revert is available for imports run through the New Import tool (V2). Legacy imports appear in Import History list but can't be reverted there. Revert them from the legacy import overview page instead.
-
Only the person who ran the import can revert it: This applies to Administrators too. If someone else ran the import, ask them to revert it.
-
Imports with at least one imported row can be reverted: Imports with a status of Imported or Completed with errors are eligible. For Completed with errors, only the imported rows are reverted — rows that failed are not touched.
-
New records are archived, not deleted: Records created by the import are removed from active lists but not permanently deleted.
-
Updated records are restored: Records the import changed return to their previous values and stay active.
-
Records changed after the import are skipped: A record can be reverted only if it hasn't been updated in any way since the import. If you edited, deleted, or archived a record after the import, revert leaves it as it is and counts it as Could not be reverted.
-
Large imports revert in chunks: The import shows a status of Reverting while it runs, then Reverted when it finishes.
Revert an import
Step 1: Find the import
-
In Apricot, select the Administrator tab.
-
In the left navigation, expand Record Manager and select Imports.
-
In the Recent Imports list, locate the import. To find an older import, select View all to open Import History.
Step 2: Start the revert
-
Select ... next to the import.
-
Select Revert import.
If Revert import doesn't appear, see section titled When an import can’t be reverted below. The revert import action can also be taken from within the Import History.
Step 3: Review the results
When the revert finishes, the import status changes to Reverted and Apricot shows how each row was handled:
| Count | What it means |
|---|---|
| Archived | New records created by the import that the revert archived |
| Reverted | Existing records the import updated, restored to their previous values |
| Could not be reverted | Rows the revert skipped, with a reason for each |
When an import can't be reverted
Revert import only appears when the import is eligible.
| Situation | Can you revert? | What you see |
|---|---|---|
| Status is Imported, with at least 1 row imported | Yes | Revert import appears in the actions menu |
| Status is Completed with errors, with at least 1 row imported | Yes | Only imported rows are reverted; failed rows are not touched |
| Create import (new records) | Yes | New records are archived |
| Update import (changes to existing records) | Yes | Records are restored to their previous values |
| Import created Draft records | Yes | Draft records are archived |
| Import is still In progress or queued | No | Revert import doesn't appear |
| No rows were imported (all rows failed) | No | Revert import doesn't appear |
| Status is Failed | No | Revert import doesn't appear |
| Status is Reverted | No | Revert import doesn't appear |
| Status is Reverting | No | You can't start a second revert while one is running |
| Someone else ran the import | No | Only the person who ran the import can revert it |
| Legacy import | No | Revert it from the legacy import overview page |
Records that can't be reverted
Even when an import is eligible, Apricot reverts each row individually. A record is skipped and counted as Could not be reverted if you changed it after the import:
-
Edited records: The record is left as it is now, with the edits intact.
-
Deleted or archived records: The record is counted as Could not be reverted (or as already archived), and the revert still finishes.
Edits and deletions are treated the same way. If you need those records changed back, update them manually.
Troubleshooting checklist
Pre-checks
- Did you run this import yourself? Only the person who ran an import can revert it, including Administrators.
- Is it a New Import (V2) session? Legacy imports can't be reverted from the new Imports list.
- Is the status Imported or Completed with errors? Imports that are still in progress, failed, already reverted, or reverting can't be reverted.
- Did at least one row import? Imports where every row failed can't be reverted.
Post-change verification
- Does the import status show Reverted?
- Do the Archived, Reverted, and Could not be reverted counts add up to the number of rows imported?
- For any Could not be reverted rows, have you reviewed the reason and updated those records manually if needed?
