CiviCRM Community Forums (archive)

I am testing CiviCRM 4.0 with Joomla 1.7.  So far everything is working well, including the user synch tool.  It appears, however, that CiviCRM synchronization does not equate to actually changing the Joomla user profile or vice-versa?  For example, when I change the e-mail address in the Joomla profile of user Johnny, synch the users in CiviCRM (CiviCRM » Administer CiviCRM- Synchronize Joomla Users) it does not error, but it also does not update the Joomla profile with the new CiviCRM user e-mail.  I've also found the reverse to be true:  Changing the e-mail in the CiviCRM profile of a user does not update the Joomla profile with the new e-mail.  My questions:

Is this the correct behavior?

If that is the correct behavior, how does CiviCRM link Joomla and CiviCRM users if changes are made to either profile (such as username, e-mail address, etc.)?

Does anyone know of a 3rd party extension, CiviCRM plug-in, or PHP script that can add the ability to propagate changes back and forth?

yes that is correct. The user sync process does not process a matched ID

if you can trap via a plugin whenever a user changes their email address on the joomla side (a hook in drupal/civi terminology) then u can make the same change on the civi side (u can check the drupal code for this).

In 4.1, we update the joomla email address if the contacts primary email has changed

lbo

check the code here:

http://svn.civicrm.org/civicrm/branches/v4.1/drupal/civicrm_user.inc

function civicrm_user_update

see the first 10 lines or so of the function.

lobo

Matt -- I've been working on this the past couple evenings (I'm a DBA by day...not much of a coder by night!).  In any case, I'm starting to figure it out.  I think if someone can help me with my piece of code below I can probably get the answer for both of us (maybe you can help me).  Thanks to lobo's push I've been studying the Drupal approach.  To answer your question, I think the correct approach is to use this CiviCRM API:

http://civiapi.idealworld.org/api/civicrm/CRM--Core--BAO--UFMatch.php/function/CRM_Core_BAO_UFMatch%3A%3AupdateContactEmail/3.1.5

In short, it's a matter of trapping the current Joomla user ID and NEW e-mail (after update) then calling the CRM_Core_BAO_UFMatch::updateContactEmail($contactId, $emailAddress) API.

There is a second approach...use brute force and update the civi tables directly using a MySQL trigger on jom_users table or something.  This will work, but probably a bad idea.

With that, I've been using the "blank_module" Joomla module (Joomla v1.7) to easily publish the following PHP code.  My goal is simply to get the CRM_Core_BAO_UFMatch::getContactId API to work before I go forcing e-mail updates.  All I want to do is display the CiviCRM user ID based on the Joomla user ID.  Again, I know I can accomplish this same task using SQL and querying tables directly, but I'm trying to learn and understand the Civi API.

If anyone can help me understand why my PHP code below doesn't work I would appreciate it!

This script is embedded in 'blank_module' inside Joomla.  I'm logged into my site so I'm authenticated.  I get no errors, but what happens is I will get the first echo command, but after I make the API call it's as if the PHP code is exited.  No echo occurs.  No even my final echo.

Anyone?

<?php

require_once 'administrator/components/com_civicrm/civicrm.settings.php';
require_once 'administrator/components/com_civicrm/civicrm/CRM/Core/Config.php';
require_once 'administrator/components/com_civicrm/civicrm/CRM/Core/DAO/UFMatch.php';
//require_once 'administrator/components/com_civicrm/civicrm/api/v3/UFMatch.php';

echo 'Logged in as "' . JFactory::getUser()->username . '"';

$ufID = 42;

$ufmatch =& CRM_Core_BAO_UFMatch::getContactId( $userid->uid );

echo $ufmatch;
echo "Done.";

?>

i would add:

require_once 'administrator/components/com_civicrm/civicrm.settings.php';
require_once 'CRM/Core/Config.php';
$config = CRM_Core_Config::singleton( );

lobo

Fixed the "DB" problem (typo).

This line:

CRM_Core_BAO_UFMatch::updateContactEmail($contactID,'$ufEMAIL');
Should be (no single-quotes):

CRM_Core_BAO_UFMatch::updateContactEmail($contactID,$ufEMAIL);
With that fix, my test script is working.  My Joomla e-mail changes now update civi using the civi API's.  If anyone is interested in this my full script is below.

So my initial questions are answered and problems resolved, but this task is still not complete.  The next step is to take this script and "embed" it in Joomla either as a plugin or through a call that is fired by a Joomla event (like e-mail update).  If anyone is interested in helping out with this or has resources for me to review I would appreciate it!  Thanks for your help lobo.

<?php

//
// This is my test script that will update the CivicCRM contact e-mail when the corresponding
// Joomla contact e-mail is updated.  My thought for this is that it would be implemented as
// a Joomla plug-in that only fires after the e-mail has been updated (not even sure if this
// is possible).  Alternative approach would be to create an 'after update' trigger on the
// jom_users table that calls the PHP script...not nearly as elegant an approach.
//
// But, for now, since I don't know how to write Joomla plugins yet, I'm tesing the idea by
// using the Joomla extension "blank_module" that allows PHP code to be placed inside a Joomla
// module.  This is a clumsy way of doing this, but it's a simple test.  My blank_module
// contains this PHP code.  I've positioned it on the front page of my test website.  Therefore,
// if you are not logged into the site nothing happens, but as soon as you log in this code will
// fire and it will update the CiviCRM e-mail with the Joomla e-mail of the connected user.  At
// least that is how it is supposed to work.
//

require_once 'administrator/components/com_civicrm/civicrm.settings.php';
require_once 'administrator/components/com_civicrm/civicrm/CRM/Core/Config.php';
require_once 'administrator/components/com_civicrm/civicrm/api/v3/UFMatch.php';
require_once 'administrator/components/com_civicrm/civicrm.settings.php';
require_once('CRM/Core/DAO.php');

$config = CRM_Core_Config::singleton( );

// These are the values of the Joomla session.
$user    =& JFactory::getUser();
$ufID    =& $user->id;
$ufUSER  =& $user->username;
$ufNAME  =& $user->name;
$ufEMAIL =& $user->email;
$ufTYPE  =& $user->usertype;
$ufGUEST =& $user->guest;

// Just showing our values so we know this thing is doing something.
// echo "$ufID -- $ufUSER -- $ufNAME -- $ufEMAIL --$ufTYPE -- $ufGUEST";

// This if statement is just confirming that we are actually logged into Joomla.  If I don't include this
// and if we aren't logged in, then my approach of making this a module on the front page that 
// fires every time will blow up and basically make the site unusable.  This $user check allows
// my testing approach to function without breaking my site.
if($user->id)
{
$contactID =& CRM_Core_BAO_UFMatch::getContactId($ufID);
$query  = "select email from civicrm_email where contact_id = $contactID";
$daoResult =& CRM_Core_DAO::executeQuery( $query, $params);
$daoResult->fetch();

if ( $daoResult->email <> $ufEMAIL )
{
CRM_Core_BAO_UFMatch::updateContactEmail($contactID,$ufEMAIL);
echo "<br>";
echo "Updating CiviCRM e-mail with Joomla e-mail.";
}
else
{
echo "<br>";
echo "Joomla and CiviCRM e-mails match.  No updated required.";
}
}
else
{
echo "You are not logged into Joomla.  Doing nothing...";
}
?>