Answers.Body: <p>Note that if you have advanced logging turned on, there's an option to revert - though changing an import would require you know the names of all the tables touched by the import.  See <a href="https://civicrm.stackexchange.com/a/35435/12">the script on this answer</a> for doing the reversion.</p>
  
  <p>The tables you'd revert would always include <code>civicrm_contact</code>, but also potentially <code>civicrm_address</code>, <code>civicrm_email</code>, <code>civicrm_phone</code>, <code>civicrm_website</code>, <code>civicrm_im</code>, and <code>civicrm_relationship</code>.  Fortunately there's no real harm in specifying tables that weren't touched.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-21T17:07:03.867Z
Answers.LastActivityDate: 2020-04-21T17:07:03.867Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>To revert an import done with the import functionality at <strong>Contacts > Import Contacts</strong>, you will need to restore from your backed up database file. As far as I know, there is no automatic "undo" on imports.</p>
  
  <p>To your point, it might be worthwhile to add a new warning to the import "Are you sure" verification message that pops up right before the import fires:
  <img src="https://i.sstatic.net/2whZF.jpg" alt="Import warning"></p>
  
  <p>For example, "Are you sure you want to import now? Be sure you have backed up your database as there is no 'undo' for this." <em>(Update: <a href="https://issues.civicrm.org/jira/browse/CRM-16778" rel="nofollow noreferrer">I submitted a patch</a> so if the core team agrees this will be added in future versions)</em></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-02T18:14:31.850Z
Answers.Text: Complete answer and then some. Luckily, I regularly backup my database but was hoping there was a quicker fix.
Answers.UserDisplayName: Vito Mantese
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-30T20:46:00.453Z
Answers.LastActivityDate: 2015-06-30T22:26:46.897Z
Answers.LastEditDate: 2015-06-30T22:26:46.897Z
Answers.UserDisplayName: Laryn
Body: <p>Does anyone know how I can revert a contact import (via the upload contacts script included in the site). The process included merges with existing contacts.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-30T17:28:51.770Z
Comments.Text: Did you back up your database before clicking "Import"?
Comments.UserDisplayName: Laryn
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-30T20:31:43.320Z
Comments.Text: Yes, I was just curious if there was a way inside the actual civicrm interface.
Comments.UserDisplayName: Vito Mantese
Tags: <contacts><import>
Title: Error uploading CiviCRM contacts. Can I revert?
ThreadText: # Error uploading CiviCRM contacts. Can I revert?
  
  (Asked by: username_0 on 2015-06-30)
  
  Does anyone know how I can revert a contact import (via the upload contacts script included in the site). The process included merges with existing contacts.
  
  **Tags:** contacts, import
  
  > **Comments:**
  > **username_1**: Did you back up your database before clicking "Import"?  
  > **username_0**: Yes, I was just curious if there was a way inside the actual civicrm interface.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-06-30. Score: 4 | Accepted answer
  
  To revert an import done with the import functionality at **Contacts > Import Contacts**, you will need to restore from your backed up database file. As far as I know, there is no automatic "undo" on imports.
  
  To your point, it might be worthwhile to add a new warning to the import "Are you sure" verification message that pops up right before the import fires:
  ![Import warning](https://i.sstatic.net/2whZF.jpg)
  
  For example, "Are you sure you want to import now? Be sure you have backed up your database as there is no 'undo' for this." *(Update: [I submitted a patch](https://issues.civicrm.org/jira/browse/CRM-16778) so if the core team agrees this will be added in future versions)*
  
  > **Comments:**
  > **username_0**: Complete answer and then some. Luckily, I regularly backup my database but was hoping there was a quicker fix.  
  
  ---
  
  ### Answer by username_2 on 2020-04-21. Score: 1
  
  Note that if you have advanced logging turned on, there's an option to revert - though changing an import would require you know the names of all the tables touched by the import. See [the script on this answer](https://civicrm.stackexchange.com/a/35435/12) for doing the reversion.
  
  The tables you'd revert would always include `civicrm_contact`, but also potentially `civicrm_address`, `civicrm_email`, `civicrm_phone`, `civicrm_website`, `civicrm_im`, and `civicrm_relationship`. Fortunately there's no real harm in specifying tables that weren't touched.
  
  
  ---
  
  