Zimbra and SugarCRM

[ebailey]

Has any more work been done to integrate sugarcrm into zimbra?

Thanks

[KevinH]

Nothing that I know of. A good place to start would be to edit the Zimlet page for SugarCRM and start to form a list of requirements for Crawl, Walk, Run type stages. This way there is at least an idea of what functionality is needed first or deemed most important.

http://wiki.zimbra.com/index.php?title=Top_Projects

[vetterm]

We are Zimbra and SugarCRM partners, and will be embarking on this project in the near future. Right now we are in the planning stage of the project, and are looking to find out who is interested in this integration, and what feature requirements look like.

At this point we are focused on email archiving and bi-directional calendar and contact syncing.

We have already created a project titled "Zimgar" on the SugarForge website. We will be making changes to the Zimbra wiki page for SugarCRM as well.

If you are interested in contributing to this project or have specific feature requirements please get in contact with me. We are excited to see this integration become a reality, and look forward to your input.

Regards,

-Mike

[cheros]

.. and then nothing happened since.. Why? No demand or need? Other project found doing the job?

[vetterm]

Actually a lot has happened since, my apologies for not staying current on the Zimbra forums. We're in the process of developing the email archiving plugin right now. It will be released by the end of this quarter. Additional integration (calendar/contacts) will follow later. We will post on our blog when this comes out, and I'll try to get out on the forums and let people know as well.

Our overall integration project, DataSync Suite, is open source and available on our website as well. Zimbra/Sugar integration is a part of our overall strategy to mash up open source applications.

I'll keep this thread posted as the Zimbra/SugarCRM integration is released. If you're interested in learning more about what we're doing, feel free to drop me a line.

Regards,

-Mike

[cheros]

To be honest, I would be interested but I think we're more in need of calendar syncs. We can fudge email via various IMAP and mailbox hacks (at least, that's what I've been told :-)) but I have yet to find anyone who has idea where to start on cal syncs. So far I've only heard mainly SyncML based ideas. One even proposed to use ScheduleWorld.com as intermediary which would obviously fix any mobile requirements in one go but creates confidentiality questions for us (great site, though).

I look forward to updates, thans for the quick response.

[vetterm]

We've already investigated the calendar syncing, and will be using Zimbra's "wait-sync" feature and hooking that into SugarCRM's "logic hooks". This will allow bi-directional on demand syncing with no database scanning or 3rd party plugins.

So the issue now is programming time. We are building the integration bus that allows the apps to sync, then we'll add the plugins for both applications.

Regards,

-Mike

[quixote1024]

Hi all,

I have been trying to figure out the simplest way of syncing the calendars between Zimbra and Sugar CRM (5.0). I have been adapting a Sugar CRM plugin that successfully syncs Sugar CRM and Google Calendar, and I think I am pretty close to getting it to work with Zimbra instead.

It is successfully querying our Zimbra server, but it fails trying to post the event from Sugar to Zimbra with an error message being generated by Zimbra (see below). I am willing to share the Sugar CRM module I have been working on if anyone is interested.

I was hoping someone may be able to shed some light on the error below and provide some direction for fixing it.

Thanks in advance!

Error message generated by Zimbra and displayed within Sugar CRM when trying to add a new meeting:


HTTP ERROR: 500

parse error: Caught ParseException parsing calendar: net.fortuna.ical4j.data.ParserException: Expected [BEGIN], read [<atom] at line 1
<atom:entry xmlns:atom="http://www.w3.org/2005/Atom"><atom:title type="text">test3</atom:title><atom:content type="text"/><gd:when xmlns:gd="http://schemas.google.com/g/2005" startTime="2008-05-22T00:00:00.000+01:00" endTime="2008-05-22T00:15:00.000+01:00"/><gd:where xmlns:gd="http://schemas.google.com/g/2005"/></atom:entry>

RequestURI=/service/home/gareth/Calendar
Caused by:

com.zimbra.common.service.ServiceException: parse error: Caught ParseException parsing calendar: net.fortuna.ical4j.data.ParserException: Expected [BEGIN], read [test3

ExceptionId:btpool0-17:1211402058657:47f8420a70dbf9ae
Code:service.PARSE_ERROR
at com.zimbra.common.service.ServiceException.PARSE_E RROR(ServiceException.java:271)
at com.zimbra.cs.mailbox.calendar.ZCalendar$ZCalendar Builder.parse(ZCalendar.java:1000)
at com.zimbra.cs.mailbox.calendar.ZCalendar$ZCalendar Builder.buildMulti(ZCalendar.java:956)
at com.zimbra.cs.service.formatter.IcsFormatter.saveC allback(IcsFormatter.java:150)
at com.zimbra.cs.service.formatter.Formatter.save(For matter.java:102)
at com.zimbra.cs.service.UserServlet.doPost(UserServl et.java:547)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:177)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1093)
at org.mortbay.servlet.UserAgentFilter.doFilter(UserA gentFilter.java:81)
at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:132)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:716)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:406)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
Caused by: net.fortuna.ical4j.data.ParserException: Expected [BEGIN], read [

Caused by:

net.fortuna.ical4j.data.ParserException: Expected [BEGIN], read [

Powered by Jetty://

[Scrotboy]

If you don't mind, what is the plug-in that successfully syncs Sugar & Google Calendar? Is it a plug-in in Outlook or do the Sugar & Google servers sync?

Thanks!!!! I've been looking for a good solution to this problem.

[quixote1024]

Originally Posted by Scrotboy

If you don't mind, what is the plug-in that successfully syncs Sugar & Google Calendar? Is it a plug-in in Outlook or do the Sugar & Google servers sync?

Sorry about that - I should have mentioned it before. It is a Sugar CRM plugin - Google Calendar Synchronisation - that is available in Sugarforge:

SugarForge: Google Calendar Synchronisation: Project Info

I managed to get it installed under Sugar CRM 5.0c (a small edit in the manifest.php to allow 5.0x flavors of Sugar CRM to install) and had it working with Google Calendar with little difficulty after that.