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 (Moderator: Dave Greenberg) »
  • Getting Ready to Launch
Pages: [1]

Author Topic: Getting Ready to Launch  (Read 456 times)

PrincessAng417

  • I post occasionally
  • **
  • Posts: 50
  • Karma: 2
  • CiviCRM version: 4.5.4
  • CMS version: Drupal 7.34
Getting Ready to Launch
April 09, 2014, 04:55:58 pm
We are getting ready to go live with our Drupal/CiviCRM portal.

I have junk data sitting in my database from testing and playing with features.

I have a considerable number of custom fields, and I have CiviCase configured.

What is the best way to clear out the junk contacts, activities, and other data to start fresh before beginning to import real data?

stuart

  • I post occasionally
  • **
  • Posts: 41
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6
  • MySQL version: 5.0.77
  • PHP version: 5.3
Re: Getting Ready to Launch
April 10, 2014, 08:01:59 am
I'd delete the custom data fields/sets normally through the User Interface, and the corresponding columns/tables in the database will be automatically removed.

For the junk Contacts, I would suggest searching through the UI, and then permanently deleting. Foreign keys will automatically cascade the deletion to all related fields.

If you have thousands and thousands of junk Contacts, it may take a while through the User Interface (and possibly hit timeout limits on your webserver). An alternative approach is to use the API instead: http://wiki.civicrm.org/confluence/display/CRMDOC/Using+the+API
« Last Edit: April 10, 2014, 08:03:30 am by stuart »

Gordon Fern

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37
  • PHP version: 5.4.29
Re: Getting Ready to Launch
June 12, 2014, 10:50:49 am
I'm in a similar position will have spent considerable time configuring and customizing CiviCRM and will want to just remove the junk contacts, memberships...  Is there anywhere the database is documented so that I can just clear down the relevant tables and leave the configuration alone by creating an SQL script?
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Getting Ready to Launch

This forum was archived on 2017-11-26.