2 Replies Latest reply: May 14, 2007 8:19 AM by 577484 RSS

    Oracle Calendar MacOSX and SyncML

    526703
      Hi!
      I am a bit lost after reading tons of threads and links...
      Here my questions:

      1. I sync my Pocket PC running WM5 and SyncML client from Synthesis.ch to sync with Space2go.com, which works fine. On the other side I would love to sync that server with Oracle Calendar. Unfortunately the server address given is not being accepted by Oracle Calendar.
      What could be the issue? The server address is http://sync.sync2go.com/sync/ml.dll
      Could it be that Ocal does not support SyncML?

      2. I have no clue why I cannot import any ics files from iCal into my agenda. I get the error message: There are no valid entries to import!

      Am I completely on the wrong track or could someone enlighten me?

      cheers Nicolas
        • 1. Re: Oracle Calendar MacOSX and SyncML
          441260
          Hi

          I don't have any experience with SyncML but my experience of trying to doing any of the iCal import or export stuff is that it is broken. I have been doing `hand sync' where I enter the entries onto the Palm by hand. Not very high tech!

          Michael
          • 2. Re: Oracle Calendar MacOSX and SyncML
            577484
            I had the same problem using Oracle's iCalendar Import option with some iCAL files, this is what I learned:

            Using: Oracle calendar client V10.1.2.0.0.710 for Mac OS X (I have not tested on Windows client).

            The iCAL (.ics) file was generated from IBM Lotus Notes 7.
            ie. "PRODID:-//Lotus Development Corporation//NONSGML Notes 7.0//EN"

            Issues:

            -- 1. Time zone string using by IBM was not supported by Oracle in format "Eastern".
            needed: America/New_York
            -- 2. If the event has "RECURRENCE-ID" line it will not import into Oracle
            -- 3. Events with RDATE line and "VALUE=PERIOD" in will not import into Oracle

            Details:

            I have found solutions four problems in the iCS file from IBM that stop the import:

            1. Time Zone not valid:
                 DTSTART;TZID="Eastern":20070529T140000
                 DTEND;TZID="Eastern":20070529T150000
            Change in to:
                 DTSTART;TZID=America/New_York:20070529T140000
                 DTEND;TZID=America/New_York:20070529T150000
            fixes the problem.

            2. Time zone not valid ie.:
                 TZID:Eastern
            changed to:
                 TZID:America/New_York
            fixes the problem.

            3. deleting the line:
            RECURRENCE-ID;RANGE=THISANDFUTURE:20070529T173000Z

            4. PROBLEM: "PERIOD" format not support converting to "DATE" works.

            RDATE;TZID="Eastern";VALUE=PERIOD:20070529T140000/20070529T150000
            ,20070612T140000/20070612T150000,20070626T140000/20070626T150000
            ,20070710T140000/20070710T150000,20070724T140000/20070724T150000
            ,20070807T140000/20070807T150000,20070821T140000/20070821T150000
            ,20070904T140000/20070904T150000

            and change to:

            RDATE;TZID=America/New_York;VALUE=DATE:20070529T140000
            RDATE;TZID=America/New_York;VALUE=DATE:20070612T140000
            RDATE;TZID=America/New_York;VALUE=DATE:20070626T140000
            RDATE;TZID=America/New_York;VALUE=DATE:20070710T140000
            RDATE;TZID=America/New_York;VALUE=DATE:20070724T140000
            RDATE;TZID=America/New_York;VALUE=DATE:20070807T140000
            RDATE;TZID=America/New_York;VALUE=DATE:20070821T140000
            RDATE;TZID=America/New_York;VALUE=DATE:20070904T140000

            works... AND

            RDATE;TZID=America/New_York;VALUE=DATE:20070529T140000,20070612T140000,20070626T140000,20070710T140000,20070724T140000,20070807T140000,20070821T140000,20070904T140000

            ALSO WORKS.

            RDATE;TZID=America/New_York;VALUE=PERIOD:20070529T140000/20070529T150000
            ,20070612T140000/20070612T150000,20070626T140000/20070626T150000
            ,20070710T140000/20070710T150000,20070724T140000/20070724T150000
            ,20070807T140000/20070807T150000,20070821T140000/20070821T150000
            ,20070904T140000/20070904T150000

            does not.

            Oracle could at least give some "console log" message or feedback in eeror dialog saying what wrong with events when they import or at least at what Line the first error occurs!


            Mark