3 Replies Latest reply: May 14, 2007 9:49 AM by 577484 RSS

    Lotus Notes

    402467
      Has anyone know how to convert Lotus Notes Calendar to Oracle Calendar/CorporateTime?
      Or how to sync both Calendar?

      Thanks.
        • 1. Re: Lotus Notes
          55511
          Most of the people that use lotus notes calendar here also use a palm pilot. What we did is sync from lotus to the palm, then uninstall the lotus client. Then install the oracle sync client and sync from the plam to oracle.

          Works like a cham!

          There is a company that has a conversion utility I saw at Open World. www.wingra.com
          • 2. Re: Lotus Notes
            3541
            There is a company in europe which has created a migration-tool to convert calendar-data from Lotus Notes to ORACLE Collaboration Suite. You can find the product and pricing information at http://ias2.kuttig.com/kibawww/kibawww.p_getfilePreview?P_path=3667.

            Best regards,
            Ingo.
            • 3. Re: Lotus Notes
              577484
              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"

              Using Oracle's iCalendar Import option, this is what I learned:
              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

              ps. I have an applescript that modified the .ics file to allow importing...


              -- IBM Calendar iCalendar (.ICS) format to Oracle Calendar iCalendar (.ICS) V1.0
              -- By Mark Fleming <markf at queensu.ca>
              -- Converts IBM .ics file to format that Oracle calendar will import.
              --
              -- Requires:
              http://www.barebones.com/products/textwrangler/
              --
              -- This script works on front most document.
              --
              -- WARNING: It has had limited testings and word for example I had. When item zone is Eastern.

              -- It fixes the follow issues:
              -- 1. Time zone string not supported by Oracle in format "Eastern".
              -- 2. Events with "RECURRENCE-ID" lines will not import into Oracle
              -- 3. Events with "VALUE=PERIOD" in RDATE lines will not import into Oracle converts to VALUE=DATE

              tell application "TextWrangler"
                   activate
                   replace ";TZID=\"Eastern\"" using ";TZID=America/New_York" searching in text 1 of text document 1 options {search mode:literal, starting at top:true, wrap around:false, backwards:false, case sensitive:false, match words:false, extend selection:false}
                   
                   
                   replace "TZID:Eastern" using "TZID:America/New_York" searching in text 1 of text document 1 options {search mode:literal, starting at top:true, wrap around:false, backwards:false, case sensitive:false, match words:false, extend selection:false}
                   
                   replace "RDATE;TZID=America/New_York;VALUE=PERIOD" using "RDATE;TZID=America/New_York;VALUE=DATE" searching in text 1 of text document 1 options {search mode:literal, starting at top:true, wrap around:false, backwards:false, case sensitive:false, match words:false, extend selection:false}
                   
                   replace "RECURRENCE-ID;(.*)" using "" searching in text 1 of text document 1 options {search mode:grep, starting at top:true, wrap around:false, backwards:false, case sensitive:false, match words:false, extend selection:false}
              end tell

              -- convert RDATE to one line so we can use on it.
              tell application "TextWrangler"
                   activate
                   set theLines to every line of text document 1
                   set f to false
                   set tline to ""
                   repeat with i in theLines
                        set textLine to i as text
                        if (textLine contains "RDATE") then
                             set rdate to i
                             set tline to textLine
                             set f to true
                             
                        else
                             
                             if (f is true) then
                                  if ((length of textLine > 1) and (first character of textLine is " ")) then
                                       set tline to tline & textLine
                                       set text of i to ""
                                  else
                                       exit repeat
                                  end if
                             end if
                        end if
                        
                   end repeat
                   if (f is true) then
                        -- convert to supported format.
                        -- from: "RDATE;TZID=America/New_York;VALUE=PERIOD:20070529T140000/20070529T150000 ,20070612T140000/20070612T150000,20070626T140000/20070626T150000 ,20070710T140000/20070710T150000,20070724T140000/20070724T150000 ,20070807T140000/20070807T150000,20070821T140000/20070821T150000 ,20070904T140000/20070904T150000"
                        -- to: RDATE;TZID=America/New_York;VALUE=DATE:20070529T140000,20070612T140000,20070626T140000,20070710T140000,20070724T140000,20070807T140000,20070821T140000,20070904T140000
                        -- Assumes meeting length is the same for all repeating meetings.
                        set tid to AppleScript's text item delimiters
                        -- remove spaces.
                        set AppleScript's text item delimiters to " "
                        set MW to text items of tline
                        set AppleScript's text item delimiters to ""
                        set MW to MW as string
                        set AppleScript's text item delimiters to ":"
                        set MW to text items of MW
                        set cmd to item 1 of MW
                        set dlist to item 2 of MW
                        -- debug
                        -- display dialog "cmd: " & cmd & return & "dlist: " & dlist
                        
                        set AppleScript's text item delimiters to ","
                        set MW to text items of dlist
                        set dd to {}
                        set AppleScript's text item delimiters to "/"
                        repeat with i in MW
                             -- for each date range ie. 20070821T140000/20070821T150000
                             -- change it to date ie. 20070821T140000
                             
                             set d to text items of (text of i)
                             -- debug
                             --     display dialog "d1: " & item 1 of d
                             
                             --     set text of item 2 of d to ""
                             
                             set end of dd to (item 1 of d)
                        end repeat
                        set AppleScript's text item delimiters to ","
                        set MW to dd as string
                        -- display dialog "MW: " & MW
                        
                        set AppleScript's text item delimiters to tid
                        
                        set text of rdate to cmd & ":" & MW
                        
                   end if
                   
              end tell