CiviCRM Community Forums (archive)

So I'm aware of the Synchronize Users-to-Contacts function (http://wiki.civicrm.org/confluence/display/CRMDOC/Synchronize+Users-to-Contacts).  And I'm also aware that civicrm_uf_match is where the links between users and contacts are kept.  I'm wondering if there is a built-in way to link only selected contacts to users.

I have a Drupal install that we've been using since 2005.  We wrote a custom membership module to make some users members.  I want to migrate from our custom code to CiviCRM.  Specifically, I want to import all those members into CiviCRM as contacts, but I don't want the non-member Drupal users to create contacts... most of them are long-abandoned accounts that people created to post one comment or the like (I'm sure some are also spam-bots).  I am happy to write a script to insert all of the right data into civicrm_uf_match.  I just don't want to reinvent the wheel or break something by doing this.

I tried importing the Drupal id for the members in the external_identifier field... the numbers imported fine, but create no link between the contact and the Drupal users that I could see.  I wasn't really expecting this to work, but I figured it was worth a shot.

Thanks!

Kurund,

So you're saying that if I import their email address that when they log into a our CiviCRM enabeled version of Drupal it'll automatically link their Drupal user with their CiviCRM contact record? 

Thanks.

You can export drupal's "mail" field along with other data for members ( in your module) and then import that data in CiviCRM. So whenever those member logs in "civicrm_uf_match" table will automatically link civicrm and drupal.

Does this make sense ?

Kurund