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 CiviMember (Moderator: Deepak Srivastava) »
  • Durpal User attached to wrong CiviCRM profile
Pages: [1]

Author Topic: Durpal User attached to wrong CiviCRM profile  (Read 1456 times)

magdmartin

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: CiviCRM4.2
  • CMS version: Drupal
  • MySQL version: 5.5
  • PHP version: &
Durpal User attached to wrong CiviCRM profile
September 25, 2013, 07:45:49 am
Hey,

We use CiviCRM with Drupal and are new to CiviCRM.

Looks like I accumulated bad scenario and end up in the following situation:
- One of the staff have a drupal account but no profile in CiviCRM (I guess this is not a best practice)
- The same staff person register an invitee to an event using the front end interface (and not from the back end where you can add event registration - again not best practice)

Results are :
- the drupal account of the staff have now the registrant information including the email address (this raise issue for password reset and mailing event update)
- the CiviCRM profile of the registrant (CiviCRM ID / User ID) is attached to the drupal account of the staff

I created a CiviCRM profile for the staff person. Now how can I attached the right Drupal profile with the right CiviCRM profile?

Bonus questions: all activities of the staff have been logged on the participant profile. Any chance to fix that?

Thanks for your help!

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: Durpal User attached to wrong CiviCRM profile
September 25, 2013, 11:23:51 am

Not the best solution, but the simplest solution might be to delete the contact and user records of both the staff an the invitee and recreate the records manually and ensure you do it the right way this time :)

You can try tweaking the DB if you are sql savvy, but i suspect that might be a lot more work than the above solution

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

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Durpal User attached to wrong CiviCRM profile
September 25, 2013, 11:39:28 am
I would
- create a new contact record for the Participant - add their name, email, event registration data
- correct the contact record that is connected to Drupal so it again has your staff person's name and email etc
- teach your staff about using the 'register another person' feature that is available from the event front end registration page
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

magdmartin

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: CiviCRM4.2
  • CMS version: Drupal
  • MySQL version: 5.5
  • PHP version: &
Re: Durpal User attached to wrong CiviCRM profile
September 25, 2013, 09:25:29 pm
Thanks it is fixed now.
For the record, I used the method describe by petednz and so far so good.


silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Re: Durpal User attached to wrong CiviCRM profile
October 30, 2013, 09:14:44 am
I have an issue where the Drupal admin account is linked with a contact, I need to add myself as the contact. The site was transferred from a previous maintainer to myself and now can't setup the contact drupal relationship properly. If possible I do not want to delete anything, but this needs to be changed for proper operations to continue.

Thanks in advance for any help...

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Durpal User attached to wrong CiviCRM profile
October 30, 2013, 11:31:43 am
can you access the db - if so you need to look at the entries in the uf_match table

each row is a link between a drupal user and a civi contact

so if you have eg (not actual field names) user#1 connected to civi#51 and you want to change this to civi#151 then you can do this

hope that helps
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Re: Durpal User attached to wrong CiviCRM profile
October 30, 2013, 11:41:10 am
Thanks for the reply petednz.

I will check that out... and will let you know if it worked...

silvereagle

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 4.3.3/4.4
  • CMS version: Drupal 6.28/7.22
  • MySQL version: 5.0.77/5.5.32
  • PHP version: 5.2.17/5.3.27
Re: Durpal User attached to wrong CiviCRM profile
November 24, 2013, 05:53:04 pm
Sorry for responding so late,
It worked editing the database field
Thanks....

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Durpal User attached to wrong CiviCRM profile

This forum was archived on 2017-11-26.