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) »
  • Managing link between CMS user and civicrm contact data
Pages: [1]

Author Topic: Managing link between CMS user and civicrm contact data  (Read 614 times)

Durruti

  • I post occasionally
  • **
  • Posts: 49
  • Karma: 1
    • The Kindling Trust
  • CiviCRM version: 3.4
  • CMS version: Drupal 6.20
  • MySQL version: 5.0.77
  • PHP version: 5.2.17
Managing link between CMS user and civicrm contact data
March 24, 2011, 04:42:04 am
Hello all,

I'm having a bit of a nightmare establishing links between my drupal users and my civicrm contact data. I made the mistake of using contact sync and have found that it sync'd CMS users to both individuals and organisations (as pete davis previously reported http://forum.civicrm.org/index.php/topic,15400.msg65996.html). This seems to break the users can't be organisations rule and brings up lots of permission issues.

I've been using an event registration form with mandatory drupal user account creation, but in about 25% of cases, drupal users are being linked to contact records that are not their's (where the email and name are completely different).

In short, I've sullied my dataset and want to take back control manually. Is there a way to manually control (i.e add and remove) the link between cms user and civicrm data record? It seems a bit too important to leave to an automated process.

Many thanks,
Matt

« Last Edit: March 24, 2011, 05:55:08 am by Durruti »
http://feedingmanchester.org.uk

Durruti

  • I post occasionally
  • **
  • Posts: 49
  • Karma: 1
    • The Kindling Trust
  • CiviCRM version: 3.4
  • CMS version: Drupal 6.20
  • MySQL version: 5.0.77
  • PHP version: 5.2.17
[Solved] Managing link between CMS user and civicrm contact data
March 24, 2011, 05:49:33 am
Found this from Rajan as part of this thread: http://forum.civicrm.org/index.php/topic,18941.msg78656.html#msg78656
Quote
Mapping between drupal users and civicrm contact stored in table 'civicrm_uf_match', field 'uf_id' specify the drupal user id and  'contact_id' specify civicrm contact id.

It seems that my the reason some of my contacts were out of sync was to do with my experimentation with the 'me' drupal module.

So I have a way to resolve the issue now, which is great, but perhaps such a crucial connection should be exposed through the user interface in some way?

Many thanks,
Matt
« Last Edit: March 24, 2011, 05:55:27 am by Durruti »
http://feedingmanchester.org.uk

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Managing link between CMS user and civicrm contact data
March 24, 2011, 07:14:27 am

Currently this is exposed at the contact view level where u see the corresponding drupal uid and can click on it to go to the drupal user record. There is also a setting in search where u can see all contacts what have/do-not-have a CMS record

Any other places u'd like to see this exposed? Maybe a custom search? Would be good if you can spec this out and then potentially create a patch to do the needful :)

lobo

A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Managing link between CMS user and civicrm contact data

This forum was archived on 2017-11-26.