Migration from Oracle Collaboration Suite via REST

Printable View

02-27-2007, 04:41 PM
dmangot

Migration from Oracle Collaboration Suite via REST

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:

Code:

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

This spit out an ical file that starts like this:

Code:

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:

Code:

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:

Code:

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!
02-27-2007, 07:09 PM
jhahm

Can you post your .ics file?
02-28-2007, 07:07 AM
DanCody

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

Dan
02-28-2007, 09:56 AM
dmangot

Quote:

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.
02-28-2007, 10:31 AM
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.
02-28-2007, 11:24 AM
dmangot

Quote:

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.
02-28-2007, 01:31 PM
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.
02-28-2007, 01:33 PM
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.
03-02-2007, 03:07 PM
dmangot

1 Attachment(s)

Script to convert Oracle ical to Zimbra ical

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

(remove .txt extension required by the forums software)