0

Syncing Lotus Notes with Google Calendar

Web Development, General

EDIT:  This post is now over 2 years old.  There are now free tools to help you bring your lotus notes data into the 21st century.  Take what I have written with a grain of salt; there are useful links in the comments.  If you have some tips to add, or helpful links, please post them in the comments.


I'm going to describe how to quickly and reliably synchronize your Lotus Notes and Google calendars without purchasing expensive, buggy software. 

Until now I have not been able to get my Lotus Notes work calendar and my personal Google Calendar synced.  Lotus Notes is a proprietary format, and will not by default import any standard calendar filetypes, so it's a no-go on all fronts.

So today I tripped across a  page on IBM's website titled "Notes iCalendar Support ".  Now, having worked with Notes for a few years, I know by now not to get my hopes up.  But I downloaded and installed the app (it integrates into notes), and now have both calendars synced to each other.  It's a manual process, but I'll take what I can get.  Here are the steps I took:

To add your Notes calendar entries to your Google Calendar :

  • Open Lotus Notes
    • Hold down shift and click each calendar event you want to copy over
    • Click Actions -> iCalendar -> Export
  • Open your Google Calendar
    • Click "Manage Calendars" from the bottom of the left-hand navigation .
    • Click the "Import Calendar" tab.
    • Browse to your newly created iCal file (by default it is in your Notes install folder, under ' \data\iCalendar'.
    • Choose the calendar to import your Notes events into.  I created a new calendar to import into, in order to take advantage of GCal's multi-calendar overlay feature.
    • Click the 'Import' button.
    • Gcal will import your events and display a confirmation summary, and you're done!

To add your Google Calendar entries to Lotus Notes:

  • Open your Google Calendar
    • Click "Manage Calendars" from the bottom of the left-hand navigation
    • Click on the title of the calendar you want to export.
    • Click the green ICAL button located in the "Private Address" region.
    • Copy the link provided to your clipboard - rightclick on the link, then choose "Copy Shortcut" or "Copy Link Location".
  • Open Lotus Notes
    • Click Actions -> iCalendar -> Import from the file menu
    • Paste the url from your clipboard into the "File name:" box of the resulting dialogue box

And that's it, you're done!

tags:
Off-Topic
shawn said:
 
Looks like you're not using Notes 6.5, as it's not working for me (I know, it says it works on R5).

Anyone find an update for this?
 
posted 965 days ago
Add Comment Reply to: this comment OR this thread
 
Francois Monette said:
 
There is an update for version 6, simply follow the original link, and do a search for iCalendar.
 
posted 958 days ago
Add Comment Reply to: this comment OR this thread
 
Paul said:
 
http://support.microsoft.com/kb/310519

Edit the path environment by following the directions on the above link, go to the end of the variable, add a semicolon, then place the path to lotus notes there.
 
posted 860 days ago
Add Comment Reply to: this comment OR this thread
 
Joe H said:
 
Go to the end of what variable? Enter path to notes folder or notes/data folder??
 
posted 589 days ago
Add Comment Reply to: this comment OR this thread
 
C Horne said:
 
Thanks for the information - this is exactly what I have been looking for.

Is there a way to have Google Calendar process more than 1 iCal file at a time? This process can get tedious if you have a lot of various reminders/events/meetings/etc.

Thanks!
 
posted 945 days ago
Add Comment Reply to: this comment OR this thread
 
 
What you want to do is have Notes export all events into a single iCal file. To do this, from the Calendar view in Notes, select View -> Change Format -> One Month, then Edit -> Select All to select every calendar entry. You can then deselect entries you do not want to sync. When you're done, go to Actions -> iCalendar -> Export and it will confirm that you are exporting multiple entries into one iCal file. This takes a long time, especially if you have more than a couple hundred calendar events, but it works!
 
posted 945 days ago
Add Comment Reply to: this comment OR this thread
 
Shima said:
 
Hi,

I am using Lotus Notes 7, however I could note install this tool, give a error not locating the nnotes.dll (but is there)... any help is more then welcome :D

Thx,
Shima
 
posted 931 days ago
Add Comment Reply to: this comment OR this thread
 
Joerg said:
 
Hi,

does anybody know if there is a way to select multiple entries? For example to just select all entries of the actual month?
I'am tired of clicking every single appointment. If I try to export all of my 500+ entires at once using select all, Notes crashes!

Thanks, Joerg
 
posted 930 days ago
Add Comment Reply to: this comment OR this thread
 
Susan said:
 
Paul, are you using Lotus 6.5? I've tried editing the path environment and was able to install the iCal support. However, I'm not seeing Action --> iCalendar on the file menu.

Has anybody gotten this to work on Lotus 6.5?
 
posted 822 days ago
Add Comment Reply to: this comment OR this thread
 
 
Hi Joerg,

Please see my comment above, dated 8/9/07. If that's not what you're looking for, be more specific and I will try to help you out.

Seth
 
posted 930 days ago
Add Comment Reply to: this comment OR this thread
 
Paul said:
 
Susan, I ended up having the same problem. Adding the environment variable allowed me to install it, but I could never get the import/export agents to actually show up in notes. I'm using Notes 6.5.1.
 
posted 822 days ago
Add Comment Reply to: this comment OR this thread
 
Jacky said:
 
I'm having a Fatel Error:Unable to retrieve Notes directory error. Anyone got an idea how to resolve that?
 
posted 812 days ago
Add Comment Reply to: this comment OR this thread
 
unnes said:
 
I'm getting the same installer error as Shima using Notes 7: "This application has failed to start because nNOTES.dll was not found. Re-installing the application may fix this problem."
 
posted 929 days ago
Add Comment Reply to: this comment OR this thread
 
Andy said:
 
The environment variable allowed me to install but an error pops up stating the same as above, "Unable to retrieve Notes directory."

I'm assuming we need to add a new environment variable stating the home directory of Notes but I do not know what name it has to be.
 
posted 799 days ago
Add Comment Reply to: this comment OR this thread
 
Cory said:
 
Found the issue with 6.x install and the notes directory. Go into regedit. HKEY_LOCAL_MACHINE\SOFTWARE\Lotus\Notes
There is a 6.0 key. Create a 5.0 key. Look at the 6.0 key and make a "DataPath" entry in the 5.0 key the exact same as it is in the 6.0 key. The installer works now.
 
posted 713 days ago
Add Comment Reply to: this comment OR this thread
 
Shima said:
 
Hi, I already try make a new installation, the problem continue... I found nnotes.dll (instead of nNOTES.dll), however the installation can not find it.

The problem continues...
 
posted 929 days ago
Add Comment Reply to: this comment OR this thread
 
C Horne said:
 
I have been trying to get the iCal app to export 1 file as opposed to individual files (when selecting multiple entries in the Month view) and have had no luck - I would appreciate any thoughts you might have.

Thanks!
 
posted 909 days ago
Add Comment Reply to: this comment OR this thread
 
candyDaddy said:
 
Hi
I'm trying to set up the Notes iCalendar Support for v6 but my admin closed the write access to the lotus directory on my machine. is there a way I can install it manually, like create the agents manually ?
Thanks for your help
CD
 
posted 676 days ago
Add Comment Reply to: this comment OR this thread
 
Von said:
 
I've been having problems with this converter as well with the error:

"This application has failed to start because nNOTES.dll was not found. Re-installing the application may fix this problem".

Re-installing doesn't fix the problem, the same message appears. I've done a search for this .dll file and it isn't on the PC anywhere. I'm running Lotus Notes 6.5

Any ideas anyone?
 
posted 879 days ago
Add Comment Reply to: this comment OR this thread
 
aaron said:
 
Susan, I ended up having the same problem. Adding the environment variable allowed me to install it, but I could never get the import/export agents to actually show up in notes. I'm using Notes 6.5.1.

Having the same issue as this. Very annoying to log on to google and see an easy import tool for outlook. Lotus sucks.
 
posted 666 days ago
Add Comment Reply to: this comment OR this thread
 
Von said:
 
Ahh, I have found the offending nnotes.dll file but its under c:/program files/lotus/notes - wonder where the installation program thinks this file should be?
 
posted 879 days ago
Add Comment Reply to: this comment OR this thread
 
Cameron said:
 
Adding the Path value and registry value as described in the earlier posts enabled me to install and use the functionality as described, but you weren't kidding when you said it was slow!
Exporting just over 800 entries is taking forever! (45 mins and counting) I don't understand why such a conceivably simple operation is so difficult . . .
On the google end, the first file I tried to import of 25 calendar entries - which did export in a reasonable amount of time - did not import into google calendar as explained in the article. The same iCal file (.ics) did however import into my Macs iCal program thankfully! At least I now have something to work with outside of Lotus Notes!
 
posted 600 days ago
Add Comment Reply to: this comment OR this thread
 
shima said:
 
I managed to do the following:

I installed Outlook Connector for Lotus Notes and then sync my gmail/gcal with it.

is a dirthy work, but works
 
posted 878 days ago
Add Comment Reply to: this comment OR this thread
 
Perry said:
 
For Notes 7.0,I succeeded to import to google calendar without using "Notes iCalendar Support".

I export .ics file in this way:Go to calendar->click 'All Calendar Entries'->Select Meeting threads

then Files->Export-> .ics

Now you can import ics file to your google calendar .
 
posted 581 days ago
Add Comment Reply to: this comment OR this thread
 
Paul said:
 
I had the same program as von, adding the lotus notes folder to the PATH environment variable seemed to help.
 
posted 871 days ago
Add Comment Reply to: this comment OR this thread
 
svm said:
 
It's been imposible for me to get the app installed.. i've been trying for a long time, with regedit, enviroment, path, etc, and nothing happens.. the nnotes.dll error keeps on appearing, even thougthe file is under C:\notes
 
posted 574 days ago
Add Comment Reply to: this comment OR this thread
 
tialoc said:
 
I have the same problem, I cannot get it to install either after the path and reg fixes and reboots. I think I may just give up on this and find a copy of outlook and the OL Connector.
 
posted 268 days ago
Add Comment Reply to: this comment OR this thread
 
Dee said:
 
Paul,
Can you describe how you added the lotus notes folder to the PATH environment?
 
posted 860 days ago
Add Comment Reply to: this comment OR this thread
 
Paul said:
 
http://support.microsoft.com/kb/310519

Edit the path environment by following the directions on the above link, go to the end of the variable, add a semicolon, then place the path to lotus notes there.
 
posted 860 days ago
Add Comment Reply to: this comment OR this thread
 
Joe H said:
 
Go to the end of what variable? Enter path to notes folder or notes/data folder??
 
posted 589 days ago
Add Comment Reply to: this comment OR this thread
 
Mahyar said:
 
Perry is correct. You don't need this additional software. Mine works in 7.0.2 as Perry described.
 
posted 574 days ago
Add Comment Reply to: this comment OR this thread
 
max said:
 
hello posters,
I've also tried to install this feature but I've got the following errors during the installation:
Copying files
Associating.ICS files in Explorer.
Starting Notes Session
Opening Mail Database:
CN=.........nsf
creating new agent, _iCalendar\Export ... ERROR!
creating new agent, _iCalendar\Import ... ERROR!
creating new agent, _iCalendar\Profile ... ERROR!
creating new agent, _iCalendar\Scan selected document ... ERROR!
Closing CN=....nsf
Ending Notes Session

Program completed with 6 errors.
 
posted 569 days ago
Add Comment Reply to: this comment OR this thread
 
max said:
 
Installation succeeded successfully!

The problem was the Lotus Notes Database on the server! For the installation i booted without Network.
The only problem is, that the iCal functionallity is only in the offline mode ("Insel-Betrieb) available.

297 entries to export and it runs over an hour!
 
posted 569 days ago
Add Comment Reply to: this comment OR this thread
 
Hal said:
 
The only issue I see here is duplicates. The software you mention (such as CompaionLink) actually checks for dups. This will just copy everything over and you'll end up with duplicates ALL OVER!@
 
posted 492 days ago
Add Comment Reply to: this comment OR this thread
 
Dmitry said:
 
You can try AweSync beta: http://awesync.com
It is capable of syncing most of the event types, you're welcome to participate in beta-testing.
 
posted 189 days ago
Add Comment Reply to: this comment OR this thread
 
Susan said:
 
Paul, are you using Lotus 6.5? I've tried editing the path environment and was able to install the iCal support. However, I'm not seeing Action --> iCalendar on the file menu.

Has anybody gotten this to work on Lotus 6.5?
 
posted 822 days ago
Add Comment Reply to: this comment OR this thread
 
Paul said:
 
Susan, I ended up having the same problem. Adding the environment variable allowed me to install it, but I could never get the import/export agents to actually show up in notes. I'm using Notes 6.5.1.
 
posted 822 days ago
Add Comment Reply to: this comment OR this thread
 
Jacky said:
 
I'm having a Fatel Error:Unable to retrieve Notes directory error. Anyone got an idea how to resolve that?
 
posted 812 days ago
Add Comment Reply to: this comment OR this thread
 
Abbie said:
 
Very helpful - thanks!
 
posted 431 days ago
Add Comment Reply to: this comment OR this thread
 
Andy said:
 
The environment variable allowed me to install but an error pops up stating the same as above, "Unable to retrieve Notes directory."

I'm assuming we need to add a new environment variable stating the home directory of Notes but I do not know what name it has to be.
 
posted 799 days ago
Add Comment Reply to: this comment OR this thread
 
Cory said:
 
Found the issue with 6.x install and the notes directory. Go into regedit. HKEY_LOCAL_MACHINE\SOFTWARE\Lotus\Notes
There is a 6.0 key. Create a 5.0 key. Look at the 6.0 key and make a "DataPath" entry in the 5.0 key the exact same as it is in the 6.0 key. The installer works now.
 
posted 713 days ago
Add Comment Reply to: this comment OR this thread
 
jOE said:
 
I am trying to install and have the path issue taken care of. When I look in the registry I don't see a key named "Notes 6.0" I have one named "Notes" but that is it. Can someone tell me the exact name of the key please. Is it "Notes5.0" "Notes 5.0" or just "5.0"
Thanks,
jOE.
 
posted 402 days ago
Add Comment Reply to: this comment OR this thread
 
Joy said:
 
This works to sync everything and it's pretty quick:
http://www.companionlink.com/products/companionlin...
 
posted 387 days ago
Add Comment Reply to: this comment OR this thread
 
MarkJ said:
 
Yep, I've used CompanionLink and they work great!
 
posted 386 days ago
Add Comment Reply to: this comment OR this thread
 
candyDaddy said:
 
Hi
I'm trying to set up the Notes iCalendar Support for v6 but my admin closed the write access to the lotus directory on my machine. is there a way I can install it manually, like create the agents manually ?
Thanks for your help
CD
 
posted 676 days ago
Add Comment Reply to: this comment OR this thread
 
aaron said:
 
Susan, I ended up having the same problem. Adding the environment variable allowed me to install it, but I could never get the import/export agents to actually show up in notes. I'm using Notes 6.5.1.

Having the same issue as this. Very annoying to log on to google and see an easy import tool for outlook. Lotus sucks.
 
posted 666 days ago
Add Comment Reply to: this comment OR this thread
 
Cameron said:
 
Adding the Path value and registry value as described in the earlier posts enabled me to install and use the functionality as described, but you weren't kidding when you said it was slow!
Exporting just over 800 entries is taking forever! (45 mins and counting) I don't understand why such a conceivably simple operation is so difficult . . .
On the google end, the first file I tried to import of 25 calendar entries - which did export in a reasonable amount of time - did not import into google calendar as explained in the article. The same iCal file (.ics) did however import into my Macs iCal program thankfully! At least I now have something to work with outside of Lotus Notes!
 
posted 600 days ago
Add Comment Reply to: this comment OR this thread
 
Perry said:
 
For Notes 7.0,I succeeded to import to google calendar without using "Notes iCalendar Support".

I export .ics file in this way:Go to calendar->click 'All Calendar Entries'->Select Meeting threads

then Files->Export-> .ics

Now you can import ics file to your google calendar .
 
posted 581 days ago
Add Comment Reply to: this comment OR this thread
 
svm said:
 
It's been imposible for me to get the app installed.. i've been trying for a long time, with regedit, enviroment, path, etc, and nothing happens.. the nnotes.dll error keeps on appearing, even thougthe file is under C:\notes
 
posted 574 days ago
Add Comment Reply to: this comment OR this thread
 
tialoc said:
 
I have the same problem, I cannot get it to install either after the path and reg fixes and reboots. I think I may just give up on this and find a copy of outlook and the OL Connector.
 
posted 268 days ago
Add Comment Reply to: this comment OR this thread
 
Mahyar said:
 
Perry is correct. You don't need this additional software. Mine works in 7.0.2 as Perry described.
 
posted 574 days ago
Add Comment Reply to: this comment OR this thread
 
max said:
 
hello posters,
I've also tried to install this feature but I've got the following errors during the installation:
Copying files
Associating.ICS files in Explorer.
Starting Notes Session
Opening Mail Database:
CN=.........nsf
creating new agent, _iCalendar\Export ... ERROR!
creating new agent, _iCalendar\Import ... ERROR!
creating new agent, _iCalendar\Profile ... ERROR!
creating new agent, _iCalendar\Scan selected document ... ERROR!
Closing CN=....nsf
Ending Notes Session

Program completed with 6 errors.
 
posted 569 days ago
Add Comment Reply to: this comment OR this thread
 
max said:
 
Installation succeeded successfully!

The problem was the Lotus Notes Database on the server! For the installation i booted without Network.
The only problem is, that the iCal functionallity is only in the offline mode ("Insel-Betrieb) available.

297 entries to export and it runs over an hour!
 
posted 569 days ago
Add Comment Reply to: this comment OR this thread
 
Hal said:
 
The only issue I see here is duplicates. The software you mention (such as CompaionLink) actually checks for dups. This will just copy everything over and you'll end up with duplicates ALL OVER!@
 
posted 492 days ago
Add Comment Reply to: this comment OR this thread
 
Dmitry said:
 
You can try AweSync beta: http://awesync.com
It is capable of syncing most of the event types, you're welcome to participate in beta-testing.
 
posted 189 days ago
Add Comment Reply to: this comment OR this thread
 
Abbie said:
 
Very helpful - thanks!
 
posted 431 days ago
Add Comment Reply to: this comment OR this thread
 
humanbear said:
 
I'm not sure if anyone else is having a similar problem, but when I import the iCalendar entries to Google Calendar, I lose some data. For e.g. if I have multiple lines in the location field, only the first line will show up. Anyone have any idea how to fix this? Thanks!
 
posted 385 days ago
Add Comment Reply to: this comment OR this thread
 
jOE said:
 
I am trying to install and have the path issue taken care of. When I look in the registry I don't see a key named "Notes 6.0" I have one named "Notes" but that is it. Can someone tell me the exact name of the key please. Is it "Notes5.0" "Notes 5.0" or just "5.0"
Thanks,
jOE.
 
posted 402 days ago
Add Comment Reply to: this comment OR this thread
 
Joy said:
 
This works to sync everything and it's pretty quick:
http://www.companionlink.com/products/companionlin...
 
posted 387 days ago
Add Comment Reply to: this comment OR this thread
 
MarkJ said:
 
Yep, I've used CompanionLink and they work great!
 
posted 386 days ago
Add Comment Reply to: this comment OR this thread
 
humanbear said:
 
I'm not sure if anyone else is having a similar problem, but when I import the iCalendar entries to Google Calendar, I lose some data. For e.g. if I have multiple lines in the location field, only the first line will show up. Anyone have any idea how to fix this? Thanks!
 
posted 385 days ago
Add Comment Reply to: this comment OR this thread
 
Saketh said:
 
I have been synching my LN Calendar to Google calendar. Please refer to my blog for details:
http://lntoiphone.blogspot.com/
 
posted 289 days ago
Add Comment Reply to: this comment OR this thread
 
Antonio S. said:
 
Thanks Saketh, that works great. Here is the direct link: http://lngooglecalsync.sourceforge.net/index.html

This is still beta, so it is still buggy. A few things not supported. At this writing, it's at Beta Release 0.3

1. You need to have Inotes support. If you don't, then this will not work for you.
2. Use your Inotes URL when it asks
3. Use your Inotes id and password when it asks.

 
posted 210 days ago
Add Comment Reply to: this comment OR this thread
 
Saketh said:
 
I have been synching my LN Calendar to Google calendar. Please refer to my blog for details:
http://lntoiphone.blogspot.com/
 
posted 289 days ago
Add Comment Reply to: this comment OR this thread
 
Antonio S. said:
 
Thanks Saketh, that works great. Here is the direct link: http://lngooglecalsync.sourceforge.net/index.html

This is still beta, so it is still buggy. A few things not supported. At this writing, it's at Beta Release 0.3

1. You need to have Inotes support. If you don't, then this will not work for you.
2. Use your Inotes URL when it asks
3. Use your Inotes id and password when it asks.

 
posted 210 days ago
Add Comment Reply to: this comment OR this thread
 
Dmitry said:
 
There's a simpler solution called AweSync: http://awesync.com

It's still in beta, though already capable of syncing most of event types.

You're welcome to participate in beta-testing
 
posted 189 days ago
Add Comment Reply to: this comment OR this thread
 
Dmitry said:
 
There's a simpler solution called AweSync: http://awesync.com

It's still in beta, though already capable of syncing most of event types.

You're welcome to participate in beta-testing
 
posted 189 days ago
Add Comment Reply to: this comment OR this thread
 
Kevin said:
 
This really should be called exporting and not sync. There's no mechanism to keep them in sync, instead it's a manual one-time export/import.
 
posted 112 days ago
Add Comment Reply to: this comment OR this thread
 
Kevin said:
 
This really should be called exporting and not sync. There's no mechanism to keep them in sync, instead it's a manual one-time export/import.
 
posted 112 days ago
Add Comment Reply to: this comment OR this thread
 

Search