Integrate Trac with SugarCRM bug module

[anonymous]

I would be interested in having an integration between SugarCRM's Bug module and Trac tickets. A two-way integration would be great, but even if tickets created in Trac were added to SugarCRM would be good. I would like to be able to use Trac for bug tracking, but would also like to link bugs to Cases, Accounts, Contacts, etc. in SugarCRM.

[glenn]

Sounds very interesting, I actually would love to see some integration as well, both are quite excellent packages. Even a sort of synchro script would be a nice thing to have.

[graham@…]

Great idea, as Glenn has already stated integration between these two superb packages can only add icing to the cake.

[alex.trac-hacks@…]

++ on this from me.

Very interested anyone got a chipin/reverse bounty running on this?

[rh@…]

++ also from me

would be a great thing

[agcantarelli@…]

++ also from me... very usefull.

[mc]

Go for it. Very good idea.

[kuba]

++ and also for me

[carlos.migliavacca@…]

how can I help to develop? I want an integration with SugarCRM!

[delia]

++ on this for me too!

[anonymous]

Oh I would like this too!

[Ben]

This would be amazing! Please update this if someone finds/builds it.

[lara@…]

i too would love this. i love Trac and am beginning to use SugarCrm CE and find that the bug tracker that comes with sugar is not up to par. any updates to this request?

please let me know!!

:)

[munichrich]

Hi there,

Does anyone know if this was ever attempted?? I could REALLY do with a way of linking my TRAC / SVN & Sugar Bug modules together.

If you need additional up-votes on this one to push it up the queue count me in!!

:)

[anonymous]

I have incomplete integration, on both the trac and sugarcrm side, but it's something... on the trac side, I can select an account from sugar, and on the sugar side, i can see a read-only copy of the ticket and work log.

It's incomplete for a number of reasons:

1. sugar and trac DBs have to be on the same server
2. I needed to patch trac, following ​http://trac.edgewall.org/ticket/4549
3. a few small hacks on the sugar side

i'm not sure if this will help anyone

[jkrueger57]

Any more movement on this recently ? I have recently been tasked with maintaining SugarCRM for our tech support group and high on the list of wanna haves is integration with our development group's Trac tool.

@rjollas - any details on steps 1 and 3 ? Why do the DBs need to be on same server ? And what were the minor hacks on sugar ?

Thanks

[russell@…]

I posted the anonymous comment, sorry.

I am using MySQL as my backend; I created a VIEW of the sugarcrm accounts table in my trac database, so I'd be able to run an SQL SELECT on it to pull the accounts. I'm not an expert on trac at all, and I didn't find any other way to create a dynamic drop down box for accounts. The other limitation I have is that you can't set value/label combinations for drop downs in trac, so you can't have two accounts with the same name in sugarcrm.

On the sugar side, I followed directions I found on the sugar forums to integrate JIRA in: ​http://www.sugarcrm.com/forums/129802-post10.html and just (heavily) modified it to use the XML-RPC plugin of trac. It would have probably been better to create a module, but this served our purposes, and I didn't really want to get into learning SugarCRM plugins at this point.

If people are interested in my work, I'll be happy to post it as attachments to this ticket, as well as to start a project somewhere if it is maintainable.

[jkrueger57]

Thanks for the info, gives me a place to start thinking about what we may be able to do as well.

[munichrich]

@russell

Hi Would you be so kind as to post the attachments ?? I for one would be VERY happy if you started this as a project..

Thanks for the Help..

Rich