Relation Between Joomla User and CRM CONTACT

[Shashank Garg]

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]

try the sync users to contacts functionality

the table is; civicrm_uf_match

lobo

[Shashank Garg]

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]

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

[Shashank Garg]

Thank you so much

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



Thanks