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) »
  • Relation Between Joomla User and CRM CONTACT
Pages: [1]

Author Topic: Relation Between Joomla User and CRM CONTACT  (Read 561 times)

Shashank Garg

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Joomla 3.3
  • MySQL version: 5.5.37-cll
  • PHP version: 2.3.27
Relation Between Joomla User and CRM CONTACT
November 27, 2014, 11:58:17 am
Hi ---

Is there any way to add the relationship between the Joomla User and particular contact in CIVICRM through database.

 ( or )

Which table should be used in database to do the mapping between the Joomla user and CIVICRM Contact. 

Please provide some solution

Thanks

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: Relation Between Joomla User and CRM CONTACT
November 27, 2014, 02:04:14 pm

try the sync users to contacts functionality

the table is; civicrm_uf_match

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

Shashank Garg

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Joomla 3.3
  • MySQL version: 5.5.37-cll
  • PHP version: 2.3.27
Re: Relation Between Joomla User and CRM CONTACT
November 27, 2014, 02:46:16 pm
Hi Lobo,

Thanks for your quick response and immediate attention towards this issue.

This table is used only to show the Joomla user id on contact summary page.

Here is the case what we need to do

We are creating a Joomla user and at the same time user contact is created in CRM. Then we are deleting the user from Joomla. Now we are again registering the user with same email address but new contact get created with the same email address in CRM that was already present.So we want to map the new Joomla user with the CRM contact having same email address.So we do not that duplicate contacts should get created.

We want to map the joomla user with previously created CRM contact.

So that if we update the name of a user in Joomla it should update the name of the user in CRM.

I hope you may understand what we want.


Thanks
   

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: Relation Between Joomla User and CRM CONTACT
November 27, 2014, 03:12:51 pm

you might want to read the developer sections on civicrm specifically the section on hooks on how to accomplish what you want to do

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

Shashank Garg

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Joomla 3.3
  • MySQL version: 5.5.37-cll
  • PHP version: 2.3.27
Re: Relation Between Joomla User and CRM CONTACT
November 28, 2014, 02:15:31 pm
Thank you so much

We are able to sync the CRM ID and Joomla ID .



Thanks

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Relation Between Joomla User and CRM CONTACT

This forum was archived on 2017-11-26.