How to connect different database for single module

[chad.hutchins]

That is an extremely informative post. Thank you so much!

It will take me a little bit to take that in and see how it will work for us.

But, I am curious: Why did you all switch from FogBugz to JIRA?

Thanks again,

chad

[eggsurplus]

1. Cost
2. Workflow
3. Ease of customization
4. API development
5. Integration with whole Atlassian suite (Confluence -wiki, Crowd - sso [used with Sugar for sso], Bamboo - distribute build, etc)

Let me know if you have any other questions.

[chad.hutchins]

Those are definitely compelling reasons, but I think I am out voted at this point on the selected tool...

Thanks again. I'll post back if I have anymore questions. You have been very helpful.

[janeataylor]

Hi eggsurplus,

I'm trying to set up our system the same way you have your set up. I downloaded your JIRA.php file but am not sure what to do with the following lines:

$jira_config = $sugar_config['jira'];

$jira_url = 'http://' . $jira_config['host'] . '/services/jiraJson';

Where are the $sugar_config['jira'] values set? And for jiraJson, are you using a custom service? Is this a plug-in that can be downloaded? Also, for the jira_call() function... I haven't found anywhere in the code you provided where this function is actually being called. Am I missing a major piece of the puzzle?

Thanks,
Janea

[eggsurplus]

Hello Janea,

The sugar_config array is defined in config.php in your root Sugar directory. The jiraJson service is a part of JIRA and is available through their software. You're best bet is checking their documentation for setting that put. Atlassian does a great job with documentation so you should find your answer there.

[janeataylor]

Awesome, thanks! I added the Jira info to the Sugar config file. So far no luck finding info on the jiraJson service though. I've gone through their documentation quite a bit but can't seem to find anything. Unfortunately Google doesn't seem to know what I'm looking for either. I'll keep digging into the Jira docs... it has to be in there somewhere!

[eggsurplus]

I take that back. We made our own custom JIRA service using Mule. Just substitute that code with JIRA's api calls to make it work.

[ledruide]

Any way you could help :-D

I'm trying to implement your solution against CE 5 + Jira 4.

I updated sugar config.php with host, username, password for jira
I updated nusoap not to see all the ereg notice ( php 5.3 )
I updated the jira_url to <server> /rpc/soap/jirasoapservice-v2

Undefined property: Bug::$jira_key_c in modules/Bugs/Bug.php on line 23, referer: http://sugarcrm/index.php?module=Bugs&action=index

Undefined index: JIRA_KEY_C in modules/Bugs/Bug.php on line 81, referer: http://sugarcrm/index.php?module=Bug...ilView&record=......

I can see some
bugs_cstm.jira_key_c
bugs_cstm.number_c

Did I miss something.....in creating a new Bug module ( cstm_ ) or should I manually create a new table ?

Merci / Thank you for your time !

-G

[eggsurplus]

Yeah, you'll need to add those custom fields in Studio as varchars.

[mjoyner]

Jason,

Really nice work on the JIRA classdesign pattern. I like how you are return a reference to a static instance of the JIRA object.