Results 1 to 9 of 9

Thread: Migration from Oracle Collaboration Suite via REST

Hybrid View

  1. #1
    Join Date
    Feb 2007
    Location
    San Francisco
    Posts
    19
    Rep Power
    8

    Default 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!

  2. #2
    Join Date
    Sep 2005
    Posts
    57
    Rep Power
    10

    Default

    Can you post your .ics file?
    Bugzilla - Wiki - Downloads - Before posting... Search!

  3. #3
    Join Date
    Oct 2005
    Location
    Milwaukee, WI
    Posts
    34
    Rep Power
    10

    Default

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

    Dan

  4. #4
    Join Date
    Feb 2007
    Location
    San Francisco
    Posts
    19
    Rep Power
    8

    Default

    Quote Originally Posted by jhahm View Post
    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.
    Last edited by dmangot; 02-28-2007 at 09:59 AM.

  5. #5
    Join Date
    Sep 2005
    Posts
    57
    Rep Power
    10

    Default

    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.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  6. #6
    Join Date
    Feb 2007
    Location
    San Francisco
    Posts
    19
    Rep Power
    8

    Default

    Quote Originally Posted by jhahm View Post
    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.

  7. #7
    Join Date
    Sep 2005
    Posts
    57
    Rep Power
    10

    Default

    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.
    Bugzilla - Wiki - Downloads - Before posting... Search!

Similar Threads

  1. Zimbra Collaboration Suite 4.5.2 GA Released
    By brian in forum Announcements
    Replies: 0
    Last Post: 02-21-2007, 11:38 AM
  2. Zimbra Collaboration Suite 4.0.3 Released
    By KevinH in forum Announcements
    Replies: 0
    Last Post: 10-17-2006, 03:04 PM
  3. Replies: 1
    Last Post: 08-14-2006, 03:33 AM
  4. Zimbra Collaboration Suite 3.0 Released
    By KevinH in forum Announcements
    Replies: 8
    Last Post: 02-08-2006, 09:11 AM
  5. Replies: 1
    Last Post: 10-02-2005, 06:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •