CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import Panic
Pages: [1]

Author Topic: Import Panic  (Read 931 times)

markimus

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 0
Import Panic
April 03, 2012, 02:17:22 pm
One of my clients contacted me in a panic hoping to import several thousand contacts  of which some already existed and needed their files updates.  I ran the import to alleviate their stress and informed them the import went through successfully. 
They realized after  they provided me with a wrong list and NOW want to go back to what they previously had.  Is it possible to revert data from before an import [without restoring from a back up]? 

Success is the ability to go from one failure to another with no loss of enthusiasm.

satchmo

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
    • Flying Horse Tech
  • CiviCRM version: 41
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Re: Import Panic
April 09, 2012, 07:45:10 am
I don't believe there's any sort of revert feature. Does their hosting provider offer auto backups since you don't seem to have backed it up manually before the import?
“After one look at this planet any visitor from outer space would say ''I want to see the manager.''” - William S. Burroughs

Jason W

  • I post frequently
  • ***
  • Posts: 197
  • Karma: 12
  • jason@civitrainingtutorials.com
  • CiviCRM version: 4.2
  • CMS version: Drupal 7
  • MySQL version: 5.x
  • PHP version: 5.x.x
Re: Import Panic
October 05, 2012, 10:51:14 am
Hello Markimus,

This should help:

1. Go to Search-->Advanced search.

2. Scroll down and expand the Change Log accordion. Select Added, Choose Date Range, and set the dates (From and to) to the day that you did the import. The search will return all of the contacts that were added on that day.

3. Select all records from the search. From the actions dropdown select Delete permanently (or delete contacts if you want the chance to undelete them).

That will at least remove the contacts that were created that day.

Cheers,
Jason
civiTrainingTutorials
"Helping You Help Others"

davyivins

  • I post occasionally
  • **
  • Posts: 119
  • Karma: 2
    • PURCO SA
  • CiviCRM version: 4.5
  • CMS version: Drupal 6.33
  • MySQL version: 5.5.34
  • PHP version: 5.4.33
Re: Import Panic
October 06, 2012, 12:30:43 am
Hi Jason - my Advanced Search doesn't have the changelog accordion. Is there somewhere I need to enable it?
I have logging active and can track changes on contact records.
There are times I love technology...and then there are times I *love* technology :-)

Jason W

  • I post frequently
  • ***
  • Posts: 197
  • Karma: 12
  • jason@civitrainingtutorials.com
  • CiviCRM version: 4.2
  • CMS version: Drupal 7
  • MySQL version: 5.x
  • PHP version: 5.x.x
Re: Import Panic
October 08, 2012, 11:27:18 am
Hello Markimus,

Go to Administer-->Customize Data and Screens-->Display preferences. Scroll  down to contact search and make sure you have Change Log checked. save and go to your advanced search. Should be there now.

Cheers,
Jason
civiTrainingTutorials
"Helping You Help Others"

davyivins

  • I post occasionally
  • **
  • Posts: 119
  • Karma: 2
    • PURCO SA
  • CiviCRM version: 4.5
  • CMS version: Drupal 6.33
  • MySQL version: 5.5.34
  • PHP version: 5.4.33
Re: Import Panic
October 08, 2012, 01:02:33 pm
Thanks Jason - totally missed it. Must have looked for it 5 times !
Checked the box and now working like a charm. :-)
There are times I love technology...and then there are times I *love* technology :-)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import Panic

This forum was archived on 2017-11-26.