Lars Fastrup on SharePoint Search - All Comments

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

birixiote — Thu, 24 Apr 2008 15:47:26 GMT

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

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

Leon Zandman — Wed, 16 Apr 2008 21:45:39 GMT

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

lars — Tue, 15 Apr 2008 13:31:29 GMT

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

Leon Zandman — Mon, 14 Apr 2008 17:50:21 GMT

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

whatiwantmost — Wed, 09 Apr 2008 05:55:56 GMT

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: New book on SharePoint search

Morten Haahr — Tue, 25 Mar 2008 19:20:54 GMT

I've been looking forward to this title from you and patrick, whom I've enjoyed his courses on search from u2u. However when will it be released?

On the ms site it says its possible to order it from 2th of April www.microsoft.com/.../12195.aspx

Amazon.co.uk have it from 9th of April please tell me the truth :D

re: New book on SharePoint search

ilphkfqzzkq — Sun, 09 Dec 2007 03:15:17 GMT

byxqQm <a href="vervvoyhidci.com/.../a>, [url=http://bvsucspbdgde.com/]bvsucspbdgde[/url], [link=http://cjjtznjduoou.com/]cjjtznjduoou[/link], http://ysglkqyjgsin.com/