Friday, August 6, 2010
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.
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
Download bridge files