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:

 

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!

Comments

<p>Interesting! Looking forward to hear more about Sugar crm + Drupal!</p>

<p>I am interested too. I dabbled in this for a very brief while but gave up quickly.</p>

Added to <a href="http://DrupalSightings.com">DrupalSightings.com</a>

Now there is a different type of module for Drupal 6 users: http://drupal.org/project/webform2sugar

<p>I have backported this module to Drupal 5. I have more testing to do but it looks promising.</p>

Just wanted to let readers know there is an update to this topic: http://www.elvisblogs.org/drupal/sugar-sweet-simple-webform2sugar-now-available-d5

I recently came across this and was hoping to find a solution for the latest SugarCMS + Drupal 6.13 + SugarWebForm (http://drupal.org/project/sugarwebform). However I see that the SugarForce (http://www.sugarforge.org/projects/sugarondrupal/) seems to be dead, no or little updates since 2007 :(

<p>I recently came across this and was hoping to find a solution for the latest SugarCMS + Drupal 6.13 + SugarWebForm (http://drupal.org/project/sugarwebform). However I see that the SugarForce (http://www.sugarforge.org/projects/sugarondrupal/) seems to be dead, no or little updates since 2007 :(</p>

<p>Dead? nooo.. just sleeping.. please, if you are interested in SugaronDrupal module just go to http://drupal.org/project/sugarondrupal or read the blog in my website to see current development status..</p> <p>Not being updated does mean it doesn't work? :)</p>

Well, Its not working for me. And I'm trying to do a simpler drupal module using leadCapture.php but even that's not working for me. I tried sending data as php GET (leadCapture.php?first_name=Fname&....) Im googling for days now. And I am using the hook_user thing in Drupal.

<p>I really like the above approach to capture simple information from your site. However, its not all that difficult to do more of an integration if you need to. Sugar is the pain to work with and lacks a lot of documentation. Drupal makes things a snap. Examples of integrating Drupal and Sugar, with a bunch of Drupal hooks and some SOAP calls: <a href="http://www.thewebmasterservice.com/dev-blog/integrating-drupal-and-sugarcrm">http://www.thewebmasterservice.com/dev-blog/integrating-drupal-and-sugarcrm</a></p>

Add new comment