Migration from Oracle Collaboration Suite via REST

[dmangot]

Hi. I'm trying to migrate a bunch of calendars from an Oracle Calendar installation to Zimbra. Supposedly Oracle is able to export in ical format

I ran the following on my Calendar server:

uniical -export -u S=Mangot -n 1 -f davecal.ics

This spit out an ical file that starts like this:

BEGIN:VCALENDAR
VERSION:2.0
PRODID:Oracle/Oracle Calendar Server 9.0.4.2.8
BEGIN:VEVENT
X-ORACLE-EVENTINSTANCE-GUID:I1+16782403+1+1+465856026
X-ORACLE-EVENT-GUID:E1+16782403+1+465856026
X-ORACLE-EVENTTYPE:DAY EVENT
UID:20051005T202706Z-11fd-1-4517b896-Oracle
TRANSP:TRANSPARENT
SUMMARY:**FYI\, Joe in office 1-5**
STATUS:CONFIRMED
SEQUENCE:0
PRIORITY:1
ORGANIZER;X-ORACLE-GUID=000010026586913420889875;CN=Joe Walla:mailto:joe@terracottatech.com
LOCATION:
DESCRIPTION:
DTSTART;VALUE=DATE:20051018
DTSTAMP:20070227T230343Z
DTEND;VALUE=DATE:20051018
CREATED:20051005T202706Z
CLASS:PUBLIC
ATTENDEE;X-ORACLE-GUID=000010026586913420889875;CUTYPE=INDIVIDUAL;RSVP=FALSE;CN=Ralph  Walla;PARTSTAT=ACCEPTED:mailto:ralph@terracottatech.com

I then try and import this into my Zimbra calendar as follows:

 curl -vvv -u dmangot:mypass --data-binary @davecal.ics http://mail.30
mtv.com:8080/home/dmangot/Calendar?fmt=ics
* About to connect() to mail.30mtv.com port 8080
*   Trying 66.243.150.134... * connected
* Connected to mail.30mtv.com (66.243.150.134) port 8080
* Server auth using Basic with user 'dmangot'
> POST /home/dmangot/Calendar?fmt=ics HTTP/1.1
Authorization: Basic ZG1hbmdv3330d2333WI5Mw==
User-Agent: curl/7.13.1 (powerpc-apple-darwin8.0) libcurl/7.13.1 OpenSSL/0.9.7l zlib/1.2.3
Host: mail.30mtv.com:8080
Pragma: no-cache
Accept: */*
Content-Length: 722145
Content-Type: application/x-www-form-urlencoded
Expect: 100-continue

< HTTP/1.1 100 Continue
< HTTP/1.1 200 OK
< Server: Apache-Coyote/1.1
< Set-Cookie: ZM_AUTH_TOKEN=0_f8bf2ec223dcddd7a70c4f3be05ad6f1ead8863c_69643d33363a65643564396535302d393233642d346430322d396566662d6538356234313630303933373b6578703d31333a313137323739353538383636303b
< Content-Length: 0
< Date: Wed, 28 Feb 2007 00:33:09 GMT
* Connection #0 to host mail.30mtv.com left intact
* Closing connection #0

The only thing my mailbox.log shows is:

2007-02-27 16:33:08,660 INFO  [http-8080-Processor99] [mid=44;ip=66.243.150.130;name=dmangot@30mtv.com;] mailbox - UserServlet (POST): http://mail.30mtv.com:8080/service/home/dmangot/Calendar

But I get ZERO appointments imported into my Calendar.

1. Is there any way to get more info about where the problem is? The mailbox log doesn't even tell me 500 error or anything.

2. Is it possibly all the X-ORACLE stuff in there? Should I write a Perl regex to strip it all out? How do I know?

I will gladly write up a wiki page on how to migrate from Oracle Calendar to Zimbra if someone will help me get my iCal calendar imported. Thanks!

[jhahm]

Can you post your .ics file?

[DanCody]

I'd also be interested in this as we have a huge Oracle -> Zimbra migration coming up.

Dan

[dmangot]

Originally Posted by jhahm

Can you post your .ics file?

There is far too much proprietary information in there for me to post on a public forum. All our email addresses, meetings we've had with any client, who are customers are, future strategies of the company, etc.

I would much rather go another route (increased logging?) if possible.

Sounds like if Dan is going to be interested too, it's worth figuring out.

BTW, I stripped out every line that began with X-ORACLE* and no difference.

[jhahm]

Can you file a bug and post the .ics there? You can pre-sanitize it, and mark the attachment as private. I don't know why it's not working for you and why nothing is getting logged. I need to try importing your data.

[dmangot]

Originally Posted by jhahm

Can you file a bug and post the .ics there? You can pre-sanitize it, and mark the attachment as private. I don't know why it's not working for you and why nothing is getting logged. I need to try importing your data.

Bug created.

[jhahm]

Thanks. See the bug for analysis and workaround:

http://bugzilla.zimbra.com/show_bug.cgi?id=15057

Please use the bug for any follow-up.

[jhahm]

BTW, the X-ORACLE- lines are not needed and will be ignored during import.

I'd love to hear about success or any further issues with Oracle calendar migration.

[dmangot]

Usage: cat OracleFile.ics | ./ocs2zim.pl > ZimFile.ics

(remove .txt extension required by the forums software)