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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • How are CiviCRM contacts and Drupal users related?
Pages: [1]

Author Topic: How are CiviCRM contacts and Drupal users related?  (Read 1158 times)

Krist

  • Guest
How are CiviCRM contacts and Drupal users related?
August 03, 2009, 04:20:18 am
When a Contact is created based on a Drupal user what field actually relates the records in civicrm_contact with drupal's user table?

I'm trying to figure out a good strategy to migrate our current website (with about 800 users) to a drupal/civicrm combo. I have a csv  text file, with amongst other things a unique membership ID (which I'd like to use as both Drupal and CiviCRM ID) and a unique username. For that I need to know how both user databases are related.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How are CiviCRM contacts and Drupal users related?
August 03, 2009, 08:17:03 pm
Quote
When a Contact is created based on a Drupal user what field actually relates the records in civicrm_contact with drupal's user table?
civicrm_uf_match stores uf_id (drupal user id) and civicrm_contact id.

Quote
I'm trying to figure out a good strategy to migrate our current website (with about 800 users) to a drupal/civicrm combo. I have a csv  text file, with amongst other things a unique membership ID (which I'd like to use as both Drupal and CiviCRM ID) and a unique username. For that I need to know how both user databases are related.
Do you have unique email addresses for all your contacts ? If yes then you should check: http://forum.civicrm.org/index.php/topic,3868.0.html

HTh

Kurund
Found this reply helpful? Support CiviCRM

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: How are CiviCRM contacts and Drupal users related?
August 04, 2009, 10:38:40 am
Yo.

Done this many times.  What you do with your CSV is:

1) Import all those people into CiviCRM as Contacts.
2) Export all your Contacts from CiviCRM into a new CSV (including their email address)
3) Use the "user import" module for drupal http://drupal.org/project/user_import to import those people into Drupal and give them an account

Now!  One of the wacky things I had to learn in this situation is that you can "Sync" your drupal users and turn then all into CiviCRM contacts using the CiviCRM "sync" feature in the Administration panel.  This is easy.

The other way, taking Contacts from CiviCRM into Drupal is not so easy or automatic.  Each time you wish to grant a Drupal account you must use the user_import module.

Helpful?  Applauds meh karma!
Try CiviTeacher: the online video tutorial CiviCRM learning library.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • How are CiviCRM contacts and Drupal users related?

This forum was archived on 2017-11-26.