October 27, 2008
Duplicate SugarCRM Bugs to TestTrack Pro
Works with TestTrack 2008
Works with SugarCRM 5.1
This article includes the steps to add a hook to your SugarCRM interface, which will automatically generate a defect in TestTrack every time a Bug is created in SugarCRM.
- Your TestTrack Web server to be accessible from the SugarCRM deployment.
- The path to your TestTrack Web server installation. If you're familiar with how web servers work and your IT environment, you can probably guess this. If not, ask the TestTrack administrator or IT staff for help.
- A valid TestTrack projed id. This can be obtained from the TestTrack Admin Utility, or by contacting your TestTrack administrator.
- Necessary permissions & knowledge to customize the back-end source code.
- A back-end logic hook that duplicates a newly created SugarCRM Bug to TTP.
DownloadThe download contains the source files needed for this sample integration. Download the Duplicate Bug Hook zip file.
- logic_hooks.php - Logic hook that triggers the Bug deuplication.
- CreateTTDefectFromBug.php - PHP script that does the Bug duplication.
Add the CodeThe first (and only) order of business is to add the code to your SugarCRM installation. This is the dangerous part, where you copy the downloaded code into your SugarCRM installation.
- Browse to your SugarCRM installation directory.
- Copy logic_hooks.php into the ...custommodulesBugs directory (create if necessary).
- Copy CreateTTDefectFromBug.php into the ...custominclude directory (create if necessary).
Update CreateTTDefectNext up, we need to make a couple minor changes to the defect creation script.
- Line 7 - Update yourserver with the location of your SugarCRM installation.
- Line 13/14 - Update the user/pwd to a SugarCRM account with permissions to login through Soap and pull Case data.
- Line 40 - Update yourserver/cgi-bin with the location of your TTP web installation.
- Line 40 - Update databaseid=??with the id of the TTP project you want to insert data to.
- This project must have SoloSubmit access enabled.
Try it Out!The only thing left to do is try it out.
- Log into your SugarCRM account.
- Open the Bugs module.
- Create a Bug, you should then see a new defect appear in TTP.