Using MOSS 2007 to index and search Lotus Notes databases

Microsoft Office SharePoint Server 2007 ships with a protocol handler for indexing Lotus Notes databases. But it requires some post-installation steps to enable. Mapping Lotus Notes user identification numbers to Windows users is also a little tricky - but possible to enable security trimming of Lotus Notes search results. However, the entire topic of using SharePoint for indexing Lotus Notes databases has always seemed to be poorly documented. I have at least never been able to find a lot of useful information online on the topic. But today I just stumled upon three Microsoft blog post that sheds a lot more light on this topic.

How to setup the MOSS 2007 Protocol Handler for Lotus Notes to search multiple Domino Databases. Part 1 of 3
How to setup the MOSS 2007 Protocol Handler for Lotus Notes to search multiple Domino Databases. Part 2 of 3
How to troubleshoot MOSS 2007 Protocol Handler for Lotus Notes and other tips/tricks. Part 3 of 3

The third and last article in the series provides information about important hotfixes for the Lotus Notes protocol handler.

Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks
Published Tuesday, November 06, 2007 7:23 PM by lars
Filed under: ,

Comments

# re: Using MOSS 2007 to index and search Lotus Notes databases

Wednesday, April 09, 2008 1:55 AM by whatiwantmost

Thanks for the links. A recent client has mentioned something about maybe indexing lotus notes into MOSS. I'll file these away for future reference.

# re: Using MOSS 2007 to index and search Lotus Notes databases

Monday, April 14, 2008 1:50 PM by Leon Zandman

Hi Lars,

I'm trying to get MOSS 2007 to index some Lotus Notes databases. I've read through the blogs you posted how to do this. I also read the relevant chapter on page 227 from the book you and Patrick Tisseghem wrote on SharePoint Search.

However, I cannot get past the stage where you have to run NotesSetup.exe (which is located in the SharePoint install directory). This executable depends on "LCPPN30.DLL", a DLL from IBM that according to documentation I mentioned above should be distributed with IBM's Lotus C++ API download. However, I've downloaded all Lotus C++ API versions from the IBM site (there were three at the time of writing), but they don't contain this DLL. The DLLs I found were "LCPPN30i.DLL", "LCPPN70.DLL" and "LCPPN80.DLL".

Looking at the filenames it looks like those DLLs I downloaded are all newer versions of the DLL I need. The version to which NotesSetup.exe is built doesn't seem to be available anymore. Is there any solution to this? I've already tried renaming the DLLs, but (as expected) this crashed NotesSetup.exe.

# re: Using MOSS 2007 to index and search Lotus Notes databases

Tuesday, April 15, 2008 9:31 AM by lars

Hi Leon

Thanks for buying the book - you must be one of the very first customers for it :-)

I also failed to find the LCPPN30.DLL file on IBM's Website. But you can get past the installation by renaming the LCPPN30i.DLL file to LCPPN30.DLL. But it is unclear to me whether these files are binary compatible, i.e. if the rename also works without problems for the actual crawls.

I would also like to point you to sharepointworks.com who offers a much better solution for crawling Lotus Notes databases including security mappings. They also have connectors for other types of repositories.

/Lars

# re: Using MOSS 2007 to index and search Lotus Notes databases

Wednesday, April 16, 2008 5:45 PM by Leon Zandman

Hi Lars,

I had already tried renaming those DLLs, but NotesSetup.exe crashes when I do that. It doesn't crash on your computer?

# re: Using MOSS 2007 to index and search Lotus Notes databases

Thursday, April 24, 2008 11:47 AM by birixiote

Hi Lars,

You have a great blog going. I find it very helpful. I have question regarding a separate post you have on SP Search SQL Syntax. I am trying to run a query on documents that were modified within last 30 days. You have listed this query:

SELECT WorkId,Path,Title,Write,Author,...

FROM Scope()

WHERE FREETEXT(defaultproperties, 'SharePoint') AND Write<=DATEADD(DAY,30,GETGMTDATE())

ORDER BY Rank Desc

But when i run this query I get an error saying the query is malformed. Is DATEADD a custom .net method that you wrote? Any help will greatly appreciated.

Thanks,

Emon

Leave a Comment

(required) 
(required) 
(optional)
(required)