Zimbra

drhughes · #1 (**permalink**) 04-14-2009, 06:58 AM

My Version of Zimbra: Release 5.0.13_GA_2791.SLES10_64_20090206110511 SLES10_64 NETWORK edition

I am trying to migrate data from Messaging Architects Groupwise Archiver into Zimbra. I have the Calendar items converted to ical, but when I use curl to inject them into Zimbra I get the following error.

Code:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
<title>Error 500 </title>
</head>
<body><h2>HTTP ERROR: 500</h2><pre>system failure: ics formatter failure</pre>
<p>RequestURI=/service/home/drhughes-archive/calendar</p><h3>Caused by:</h3><pre>com.zimbra.common.service.ServiceException: system failure: ics formatter failure
ExceptionId:btpool0-3175:1239717295454:9b806e0ce4990e30
Code:service.FAILURE

Example of my ical file:

Code:

BEGIN:VCALENDAR
PRODID:-//SVSU GWArchive Converter//1.0//EN
VERSION:2.0
METHOD:PUBLISH
BEGIN:VEVENT
UID:10654429981499277@example.edu
SUMMARY:Vacation Day
LAST-MODIFIED:20031006T122318Z
DTSTAMP:20031006T122318Z
TRANSP:OPAQUE
PERCENT-COMPLETE:0
CREATED:20030120T133841Z
DTSTART:20030120T130000Z
CLASS:PRIVATE
LOCATION:Home
DTEND:20030120T133000Z
DESCRIPTION:
SOURCE:personal
ORGANIZER;MAILTO:userid@example.edu
BEGIN:VALARM
TRIGGER:-P0M
ACTION:REMINDER
END:VALARM
END:VEVENT

Any thoughts on what my problem could be?

Thanks

*dustys* · #2 (**permalink**) 04-14-2009, 07:24 AM

I ran into a similar issue a while back. (Exporting calendars from SunBird and then importing)

Since iCal on Mac seems to work with Zimbra, I imported the ics file into iCal and then re-exported it. Once I did this, I was able to push it to Zimbra without error.

What is the output from this account in your mailbox.log?

Thanks
Dusty

drhughes · #3 (**permalink**) 04-14-2009, 07:34 AM

mailbox - UserServlet received file unknown - 240 request bytes

thorng · #4 (**permalink**) 04-14-2009, 09:41 PM

Missing an END:VCALENDAR?

Not sure if it is just your incompleted copy, but All BEGIN: must be completed with an END:

drhughes · #5 (**permalink**) 04-15-2009, 05:19 AM

Quote:

Originally Posted by thorng

Missing an END:VCALENDAR?

Not sure if it is just your incompleted copy, but All BEGIN: must be completed with an END:

It actually does have the END:VCALENDAR on the end. Some how I didn't get the whole thing pasted into my message.

Here's the interesting part.

I logged into web interface and exported my calendar as a ICS and then tried to use curl to bring it over and I get the same message as above. Zimbra doesn't even like it's own exports.

I think it is time to open a case with Zimbra.

nrc · #6 (**permalink**) 04-15-2009, 10:51 AM

One of my recent tickets was about an ICS event that wouldn't load and it turned out that WebEx simply generates invalid ICS. So I've started validating ICS files before I complain if they don't work.

According to the validator below, that ICS isn't valid. It complains that "SOURCE" is an invalid property. If you remove that, it will complain about the ORGANIZER line. If you then change the ";" in the ORGANIZER line to a ":" it validates. MAILTO is part of the value, not a parameter so it should be a ":".

iCalendar Validator

ab5602 · #7 (**permalink**) 09-20-2009, 01:52 PM

I found this issue to be related to if the imported appointments spanned daylight savings time. I fixed it by adding a TZID in the iCal header:

Code:

BEGIN:VTIMEZONE
TZID:US-Eastern
BEGIN:STANDARD
DTSTART:20071104T020000
TZOFFSETTO:-0500
TZOFFSETFROM:-0400
RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20070311T020000
TZOFFSETTO:-0400
TZOFFSETFROM:-0500
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT
END:VTIMEZONE

Where "US-Eastern" is the TZID specified in the appointments.

Zimbra

Downloads

Product Information

Toolbox

Why Join?