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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • HELP: Must recover ~1000 deleted contacts and related data
Pages: [1]

Author Topic: HELP: Must recover ~1000 deleted contacts and related data  (Read 1801 times)

ssetvik

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.1
  • CMS version: Drupal 6
  • MySQL version: 5.1
  • PHP version: 5.2.17
HELP: Must recover ~1000 deleted contacts and related data
December 12, 2011, 05:29:21 pm
The situation:

CiviCRM 3.1 Install
1 month ago, ~900 contacts & all related civicrm data were deleted and need to be recovered.
We have a backup from 1 month ago, however, much data has changed in the interim, so we can't simply restore the db.

I see there's an import/export feature for contacts.

Can we use the built-in civi import/export functionality to export the deleted contacts from our 1 mo old backup and restore them to the live site? Will the original internal contact_id's be retained?

I ran a quick check to see what database tables lost data from the deletion 1 month ago:
civicrm_activity                             
civicrm_address                               
civicrm_contact                               
civicrm_contribution                           
civicrm_email                                 
civicrm_entity_tag                             
civicrm_group_contact                         
civicrm_log                                   
civicrm_membership                             
civicrm_membership_copy                       
civicrm_membership_log                         
civicrm_participant                           
civicrm_phone                                 
civicrm_preferences                           
civicrm_relationship                           
civicrm_subscription_history
civicrm_uf_match
plus a bunch of civicrm_value_* tables

We need all the above data. Will export/import successfully restore all the contact and related data in the above tables for us?

Or do I need to look at doing this manually?

Thanks a million in advance for any help or advice!

Stein

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: HELP: Must recover ~1000 deleted contacts and related data
December 13, 2011, 09:59:33 am
Quote from: ssetvik on December 12, 2011, 05:29:21 pm
Can we use the built-in civi import/export functionality to export the deleted contacts from our 1 mo old backup and restore them to the live site? 

Yes.

Quote from: ssetvik on December 12, 2011, 05:29:21 pm
Will the original internal contact_id's be retained?

No, definitely not.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

ssetvik

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.1
  • CMS version: Drupal 6
  • MySQL version: 5.1
  • PHP version: 5.2.17
Re: HELP: Must recover ~1000 deleted contacts and related data
December 13, 2011, 11:45:16 am
Quote from: Hershel on December 13, 2011, 09:59:33 am
Quote from: ssetvik on December 12, 2011, 05:29:21 pm
Can we use the built-in civi import/export functionality to export the deleted contacts from our 1 mo old backup and restore them to the live site? 

Yes.

Will export/import successfully restore the related contact data in the tables I mentioned (e.g. contributions, memberships, activities, events, relationships, groups, notes, tags, change log)?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: HELP: Must recover ~1000 deleted contacts and related data
December 13, 2011, 11:58:32 am
The built in Export facility can export most of these data, but I do not think it can do all. You would probably have to export many of these, such as those that are multiple items per person like Contributions, separately and then import all separately.

Depending on how much data you have, it might be easier to hire someone to write a script to use the API to transfer the data from the old to the new DB. That can be done to certainly include all of your data.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • HELP: Must recover ~1000 deleted contacts and related data

This forum was archived on 2017-11-26.