Trac Hacks - Plugins Macros etc.: Ticket #2659: Integrate Trac with SugarCRM bug modulehttps://trac-hacks.org/ticket/2659
<p>
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.
</p>
en-usTrac Hacks - Plugins Macros etc.https://trac-hacks.org/chrome/hacks/png/trachacks_banner.pnghttps://trac-hacks.org/ticket/2659
Trac 1.2.2glennThu, 26 Jun 2008 10:10:29 GMThttps://trac-hacks.org/ticket/2659#comment:1
https://trac-hacks.org/ticket/2659#comment:1
<p>
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.
</p>
Ticketgraham@…Fri, 27 Jun 2008 14:44:39 GMThttps://trac-hacks.org/ticket/2659#comment:2
https://trac-hacks.org/ticket/2659#comment:2
<p>
Great idea, as Glenn has already stated integration between these two superb packages can only add <a class="wiki" href="https://trac-hacks.org/wiki/icing">icing</a> to the cake.
</p>
Ticketalex.trac-hacks@…Fri, 27 Jun 2008 20:11:46 GMThttps://trac-hacks.org/ticket/2659#comment:3
https://trac-hacks.org/ticket/2659#comment:3
<p>
++ on this from me.
</p>
<p>
Very interested anyone got a chipin/reverse bounty running on this?
</p>
Ticketrh@…Fri, 04 Jul 2008 13:22:39 GMThttps://trac-hacks.org/ticket/2659#comment:4
https://trac-hacks.org/ticket/2659#comment:4
<p>
++ also from me
</p>
<p>
would be a great thing
</p>
Ticketagcantarelli@…Tue, 08 Jul 2008 18:27:50 GMThttps://trac-hacks.org/ticket/2659#comment:5
https://trac-hacks.org/ticket/2659#comment:5
<p>
++ also from me... very usefull.
</p>
TicketmcWed, 27 Aug 2008 23:08:56 GMThttps://trac-hacks.org/ticket/2659#comment:6
https://trac-hacks.org/ticket/2659#comment:6
<p>
Go for it. Very good idea.
</p>
TicketkubaTue, 02 Sep 2008 09:38:01 GMThttps://trac-hacks.org/ticket/2659#comment:7
https://trac-hacks.org/ticket/2659#comment:7
<p>
++ and also for me
</p>
TicketCarlos Eduardo Nissola MigliavaccaThu, 20 Nov 2008 13:35:51 GMThttps://trac-hacks.org/ticket/2659#comment:8
https://trac-hacks.org/ticket/2659#comment:8
<p>
how can I help to develop? I want an integration with SugarCRM!
</p>
TicketdeliaTue, 14 Apr 2009 15:51:31 GMThttps://trac-hacks.org/ticket/2659#comment:9
https://trac-hacks.org/ticket/2659#comment:9
<p>
++ on this for me too!
</p>
TicketanonymousTue, 30 Jun 2009 14:18:41 GMThttps://trac-hacks.org/ticket/2659#comment:10
https://trac-hacks.org/ticket/2659#comment:10
<p>
Oh I would like this too!
</p>
TicketBenWed, 03 Mar 2010 02:57:42 GMThttps://trac-hacks.org/ticket/2659#comment:11
https://trac-hacks.org/ticket/2659#comment:11
<p>
This would be amazing! Please update this if someone finds/builds it.
</p>
TicketlaraThu, 02 Dec 2010 22:48:23 GMTrelease, priority, severity changedhttps://trac-hacks.org/ticket/2659#comment:12
https://trac-hacks.org/ticket/2659#comment:12
<ul>
<li><strong>release</strong>
changed from <em>0.11</em> to <em>0.12</em>
</li>
<li><strong>priority</strong>
changed from <em>normal</em> to <em>high</em>
</li>
<li><strong>severity</strong>
changed from <em>normal</em> to <em>major</em>
</li>
</ul>
<p>
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?
</p>
<p>
please let me know!!
</p>
<p>
:)
</p>
TicketmunichrichMon, 05 Sep 2011 11:31:44 GMThttps://trac-hacks.org/ticket/2659#comment:13
https://trac-hacks.org/ticket/2659#comment:13
<p>
Hi there,
</p>
<p>
Does anyone know if this was ever attempted?? I could REALLY do with a way of linking my TRAC / SVN &amp; Sugar Bug modules together.
</p>
<p>
If you need additional up-votes on this one to push it up the queue count me in!!
</p>
<p>
:)
</p>
TicketanonymousSun, 11 Dec 2011 13:59:27 GMTcc changedhttps://trac-hacks.org/ticket/2659#comment:14
https://trac-hacks.org/ticket/2659#comment:14
<ul>
<li><strong>cc</strong>
<em>russell@…</em> added; <em>anonymous</em> removed
</li>
</ul>
<p>
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.
</p>
<p>
It's incomplete for a number of reasons:
</p>
<ol><li>sugar and trac DBs have to be on the same server
</li><li>I needed to patch trac, following <a class="ext-link" href="http://trac.edgewall.org/ticket/4549"><span class="icon">​</span>http://trac.edgewall.org/ticket/4549</a>
</li><li>a few small hacks on the sugar side
</li></ol><p>
i'm not sure if this will help anyone
</p>
TicketRyan J OllosWed, 14 Dec 2011 07:45:43 GMTcc changedhttps://trac-hacks.org/ticket/2659#comment:15
https://trac-hacks.org/ticket/2659#comment:15
<ul>
<li><strong>cc</strong>
<em>Ryan J Ollos</em> added
</li>
</ul>
TicketJeffFri, 30 Dec 2011 20:11:15 GMThttps://trac-hacks.org/ticket/2659#comment:16
https://trac-hacks.org/ticket/2659#comment:16
<p>
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.
</p>
<p>
@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 ?
</p>
<p>
Thanks
</p>
Ticketrussell@…Sat, 31 Dec 2011 17:46:49 GMThttps://trac-hacks.org/ticket/2659#comment:17
https://trac-hacks.org/ticket/2659#comment:17
<p>
I posted the anonymous comment, sorry.
</p>
<p>
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 <acronym title="Structured Query Language">SQL</acronym> 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.
</p>
<p>
On the sugar side, I followed directions I found on the sugar forums to integrate JIRA in: <a class="ext-link" href="http://www.sugarcrm.com/forums/129802-post10.html"><span class="icon">​</span>http://www.sugarcrm.com/forums/129802-post10.html</a> and just (heavily) modified it to use the <acronym title="Extensible Markup Language">XML</acronym>-<acronym title="Remote Procedure Call">RPC</acronym> 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.
</p>
<p>
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.
</p>
TicketJeffSat, 31 Dec 2011 23:34:25 GMThttps://trac-hacks.org/ticket/2659#comment:18
https://trac-hacks.org/ticket/2659#comment:18
<p>
Thanks for the info, gives me a place to start thinking about what we may be able to do as well.
</p>
TicketmunichrichFri, 27 Apr 2012 13:37:48 GMThttps://trac-hacks.org/ticket/2659#comment:19
https://trac-hacks.org/ticket/2659#comment:19
<p>
@russell
</p>
<p>
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..
</p>
<p>
Thanks for the Help..
</p>
<p>
Rich
</p>
TicketfigaroFri, 11 Aug 2017 22:55:13 GMTseverity changedhttps://trac-hacks.org/ticket/2659#comment:20
https://trac-hacks.org/ticket/2659#comment:20
<ul>
<li><strong>severity</strong>
changed from <em>major</em> to <em>normal</em>
</li>
</ul>
Ticket