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 »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Transferring Civicrm data from Drupal to Wordpress
Pages: [1]

Author Topic: Transferring Civicrm data from Drupal to Wordpress  (Read 3098 times)

Leslie

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 4.1.1
  • MySQL version: 5.5
  • PHP version: 5.4.24
Transferring Civicrm data from Drupal to Wordpress
February 24, 2012, 07:51:41 am
We have been running Civicrm for a couple of years on Drupal without really doing much with Drupal.
We are now setting up a website with WordPress and would like to transfer our Civicrm data over to a new Civicrm installation in WordPress.
Can this be done and how? We do not have a dedicated tech guy at our small nonprofit so this needs to be pretty straightforward.
Thanks.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Transferring Civicrm data from Drupal to Wordpress
February 24, 2012, 08:12:17 am
Hi,

The only problem will be that the links between a user and its contact will be lost (obviously, because all drupal users will be removed and you will get new WP users)

If you migrate civi first and then create WP users with the proper email, it should work, otherwise might be more complex (having to update manually the database to change the user-contact relationship)

I would suggest you to copy your database and try and keep an eye if the user id is updated properly on the contact records

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Leslie

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 4.1.1
  • MySQL version: 5.5
  • PHP version: 5.4.24
Re: Transferring Civicrm data from Drupal to Wordpress
February 24, 2012, 09:14:34 am
Thanks Xavier for replying.
Besides the user ID dilemma, I just want to make sure that we install all the new programs correctly. Right now I have Drupal and Civicrm (for Drupal) installed. How would I proceed to eventually delete(uninstall) these files and install WP/Civicrm 4.1 with our databases that we were using under Drupal?

nnangeroni

  • I’m new here
  • *
  • Posts: 27
  • Karma: 2
  • CiviCRM version: 3.4.0
  • CMS version: Drupal 6.20
  • MySQL version: 5.5.x
  • PHP version: 5.3.x
Re: Transferring Civicrm data from Drupal to Wordpress
March 08, 2012, 09:43:30 am
Henry, I too was confronted with this issue.  For me, the trick was in getting the data export right.   After creating a fresh CiviCRM install under WP, I exported my data from the Drupal/CiviCRM install using PHPMyAdmin.  I had to select "Custom" export method to gain access to all options, then I went with the defaults EXCEPT:

- check "Disable Foreign Key Checks"
- Dump table: "structure and data"
- Add Statements, check: "Add Drop Table / View... "

Then I imported the file into my existing WP/CiviCRM database, which seems to have worked fine.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Transferring Civicrm data from Drupal to Wordpress

This forum was archived on 2017-11-26.