Site Recipe: SugarCRM + Drupal + Webform + SugarCRM Webform Integration

A client recently asked for SugarCRM integration with Drupal. I just wanted to report my findings.

There are two SugarCRM + Drupal solutions:

• SugarOnDrupal - which is really used for Drupal sites who want user profile information sent to Sugar.
• SugarCRM Webform Integration - which is used in conjuntion with the Drupal Webform module.

As mentioned above, we are using the following in this recipe:
SugarCE-5.2.0a (community edition) + Drupal 5.x + Webform module + SugarCRM Webform Integration.

I discoverd the SugarCRM software has upgraded their code since May 2008 - when the SugarCRM Webform Integration module was made. When using this recipe "out of the box" - the leadCapture_override.php is not providing the correct array structure for the $users array. Sugar just dies and redirects you as directed by Drupal.

Once that issue was fixed though, the basic Sugar fields from webform were not populated. The sugarwebform module README and INSTALL do not explain how to pass these fields correctly from webform to Sugar. After some digging in the Sugar code I found the Sugar field names to use within webform.

These are some of the main issues I found so far. In the coming days I will push up a patch to the issue queue. Keep your eyes open! Afterward posting the patch I will write a small tutorial on how to get this recipe working on Drupal 5.x and Sugar 5.2. This is a neat recipe that hasn't received much attention.

Stay Tuned!