I have a Blackberry which does a great job staying in sync with my Lotus Notes calendar. My goal is to have this calendar info available on my Outlook calendar which is on a different, disconnected computer. My initial thought was to use Google calendar as a go-between these 2 calendars (Notes & Outlook). Lotus Notes is my main calendar, and unfortunately, it doesn’t allow for 2-way sync’ing with a Google calendar.
Another constraint is that I cannot install any apps or plug-ins to my Blackberry (IT policy prevents it). So my Lotus Notes calendar is the main source calendar. This calendar syncs wirelessly with my Blackberry, so changes can be made to either of these two calendars. From there, a few one-way sync’s are done to keep my Outlook calendar updated.
Here’s how it works…[list:23uchxm5]
[*:23uchxm5]Periodically, my Lotus Notes calendar is exported to a .CSV file using a Lotus Notes agent. [/*:m:23uchxm5]
[*:23uchxm5]I then import this file into my Google calendar. Luckily, the import process is able to recognize duplicate items and handles them fine. [/*:m:23uchxm5]
[*:23uchxm5]With my Google calendar updated, I use the Google Calendar sync program on my computer with Outlook installed to keep them in sync. The Google Calendar sync program can be found here:
http://www.google.com/support/a/users/b … opic=14096 [/*:m:23uchxm5]
[*:23uchxm5]The only limitations are that changes cannot be made on the Outlook calendar because they won’t be sycn’ed back to Lotus Notes. So changes must be made either on my Lotus Notes or Blackberry calendars. [/*:m:23uchxm5][/list:u:23uchxm5]
[b:23uchxm5]Here’s what the setup looks like…[/b:23uchxm5]
[img:23uchxm5]http://localgeek.is-a-geek.com/forum/richedit/upload/2k114ae1c489.jpg[/img:23uchxm5]
Lotus Notes – Create an Agent[list=1:23uchxm5]
[*:23uchxm5]In Lotus Notes, open your Calendar view. [/*:m:23uchxm5]
[*:23uchxm5]Go to [b:23uchxm5]Create | Agent…[/b:23uchxm5] [/*:m:23uchxm5]
[*:23uchxm5]Name the agent (for this example, it’s named [b:23uchxm5]Notes Calendar Export[/b:23uchxm5]). [/*:m:23uchxm5]
[*:23uchxm5]In the [b:23uchxm5]Runtime [/b:23uchxm5]section, be sure that the [b:23uchxm5]Target [/b:23uchxm5]menu is set to [b:23uchxm5]All selected documents[/b:23uchxm5]. [/*:m:23uchxm5]
[*:23uchxm5]Close the agent dialog box. [/*:m:23uchxm5]
[*:23uchxm5]In the [b:23uchxm5]Run [/b:23uchxm5]section at the top of the page, select the pulldown menu option called [b:23uchxm5]LotusScript[/b:23uchxm5]. [/*:m:23uchxm5]
[*:23uchxm5]In the left pane, click to select the [b:23uchxm5]Initialize [/b:23uchxm5]item. [/*:m:23uchxm5]
[*:23uchxm5]In the right page, you’ll see 2 lines of code labeled [b:23uchxm5]Sub Initialize [/b:23uchxm5]and [b:23uchxm5]End Sub[/b:23uchxm5]. [/*:m:23uchxm5]
[*:23uchxm5]Paste the agent code (see [url=http://localgeek.us/Forum/tabid/290/forumid/3/threadid/170/scope/posts/Default.aspx:23uchxm5]this thread[/url:23uchxm5]) between these 2 lines. [/*:m:23uchxm5]
[*:23uchxm5][b:23uchxm5]Save [/b:23uchxm5]and [b:23uchxm5]close[/b:23uchxm5]. [/*:m:23uchxm5][/list:o:23uchxm5]To run the Agent[list=1:23uchxm5]
[*:23uchxm5]Open your Lotus Notes calendar. [/*:m:23uchxm5]
[*:23uchxm5]Click on the [b:23uchxm5]Meetings[/b:23uchxm5] tab. [/*:m:23uchxm5]
[*:23uchxm5]Select ALLitems.
Note: Selecting all items using [b:23uchxm5]CTRL+A [/b:23uchxm5]or [b:23uchxm5]Edit | Select All [/b:23uchxm5]caused an import error, but if I manually check each item to select it (start at top and run to the bottom of the list), it works ok. [/*:m:23uchxm5]
[*:23uchxm5]Go to [b:23uchxm5]Actions | Notes Calendar Export[/b:23uchxm5]. [/*:m:23uchxm5]
[*:23uchxm5]The file will be saved as [b:23uchxm5]c:\MyNotesCalendar.csv[/b:23uchxm5]. [/*:m:23uchxm5][/list:o:23uchxm5]To import into Google Calendar[list=1:23uchxm5]
[*:23uchxm5]Sign in to your Google account. [/*:m:23uchxm5]
[*:23uchxm5]Select the [b:23uchxm5]Calendar [/b:23uchxm5]link at the top. [/*:m:23uchxm5]
[*:23uchxm5]In the [b:23uchxm5]My Calendars [/b:23uchxm5]section, click the pulldown menu next to [b:23uchxm5]Add, [/b:23uchxm5]and select [b:23uchxm5]Import Calendar[/b:23uchxm5]. [/*:m:23uchxm5]
[*:23uchxm5]Browse to the [b:23uchxm5]MyNotesCalendar.csv [/b:23uchxm5]file and click [b:23uchxm5]Import[/b:23uchxm5]. [/*:m:23uchxm5][/list:o:23uchxm5]
[b:23uchxm5]Help for Google Calendar sync can be found here:[/b:23uchxm5]
http://www.google.com/support/a/users/b … opic=14097