Like us!

Joomla!™ Disclaimer

Joomla!™ is a registered trademark of Open Source Matters.
Tekdi Web Solutions, tekdi.net and techjoomla.com are not affiliated to Joomla!, Open Source Matters or any of its subsidiaries.

Home Displaying items by tag: crm
Friday, 06 August 2010 23:22

SugarCRM & redmine integration

At Tekdi we've been using SugarCRM since long to manage all the customers leads and other possible data. The part after that - a solid project management system has always been a point of contention and we've switched to and fro with many systems, notably dotproject (DP). Recently I got to know about redmine and since then have shifted over to the same.

To ease things, previously I had created a small bridge between Sugar and dotproject that automagically creates a project in DP once an opportunity is marked as 'closed won'. This was easily managed since both systems are PHP.

Enter redmine and I was looking at a something written in ruby/rails - hieroglyphics to me ! I soon realised that it had a rest api that allowed creating projects. However when I tried to use the API it kept on giving errors and I was left with directly dealing with the MySQL db. Upon seeing that redmine uses the Nested set model to store data I simply gave up  the idea of creating a bridge.

Redmine then released v1.0.0in late July and the API is dramatically improved and works well. Now I could get my bridge to work. Creating a custom override in Sugar did the trick and I was now able to create projects in redmine.

To use the  bridge, place the Opportunities folder in the following folder in SugarCRM
[sugarcrm root]/custom/modules

Download bridge files

Published in CRM