I am involved with Lotus Notes application migrations to SharePoint from time to time. I am looking for a solution that can keep some legacy Lotus Notes applications in place; but provide search capabilities to the legacy data to SharePoint 2013 users. This could be a very practical and cost-effective business solution to customers.
This is a copy of the blog post that I originally posted here:
I want to crawl a Notes database with SharePoint 2013 Search. As part of that effort, I need to install the Lotus Notes client and connector on the SharePoint 2013 Server. But there are a number of steps that I need to execute first. I follow along the steps as detailed here: http://technet.microsoft.com/en-us/library/jj591606.aspx. However, I depart from the steps and do things a bit differently based on where I ran into problems and fixed them. I document everything in detail.
In this first of two blogs, I execute the steps to:
- install and configure the Lotus Notes client software
- grant access privileges to the Notes \ data folder
- install the Notes C++ API
- create the Mappings database
- add a user account mapping to the Mappings database
I am logged onto my SharePoint 2013 Server with the SP_Install user account. The SP_Install user account is a member of the Administrators group on this server.
Installing the Lotus Notes Client Software
I am installing the 32-bit version of Lotus Notes R8.5 on my SharePoint 2013 server. I will only install the client and not the Designer or Administrator software. I would typically recommend against ever installing such software on a server. But I don’t have access to a third party connector (e.g. BA-Insight). I have installed Lotus Notes client software more than a hundred of times already. I will touch on the key points.
I double-click on the installation file.
I click Yes on the User Account Control window.
I change the file path in the InstallShield Wizard and click Next
The files are extracted and the installation process begins. The Install Wizard screen appears. I click Next to continue.
I accept the terms in the License Agreement screen and click Next to continue.
I enter generic text in the Customer Information screen and click Next to continue.
I keep the selections in the Installation Path Selection screen and click Next to continue. I actually tried it with the default file paths first and everything worked until I got to the last step of the Lotus Notes Index Setup Wizard. I could not complete the step. But simplifying the default file paths made it work.
I modify the settings in the Custom Setup screen as seen below. I do not select the Domino Designer or the Sametime Client to be installed since I already have it installed on another virtual machine. I really do not want them installed on a server anyway. I click Next to continue.
I deselect all of the options on the Ready to Install the Program and click Install to continue.
The Install Wizard continues to install until the Install Wizard Completed screen appears. I click Finish.
Grant Permissions on the Data Folder
I open Explorer to the Notes data folder.
Right-click on the data folder and click on Properties.
Click on the Security tab on the Properties window.
Click on the Edit button.
The Permissions for Data screen appears. Click on Add…
The Select Users screen appears. Change the location to the local server and enter WSS_WPG into the object names field and click Check Names.
The group name should resolve correctly. Click OK to accept and continue.
The WSS_WPG group should appear in the security list. Click the Allow checkbox on Full control under permissions. Click OK to accept the changes and continue.
The WSS_WPG group appears in the Security list in the Data Properties screen. Full Control permissions are granted. Click Close to close the screen.
Install Lotus C++ API
I downloaded the Lotus C++ API from here: https://www14.software.ibm.com/webapp/iwm/web/reg/download.do?source=ESD-SUPPORT&S_PKG=CR3DNNA&S_TACT=104CBW71&lang=en_US&cp=UTF-8
I chose the Release 3.0 for Windows file.
I executed the c55svna.exe file on the SharePoint 2013 server where the Lotus Notes client will be installed. I clicked on Run in the Open File – Security Warning screen.
The Lotus C++ API screen appeared. I clicked Finish to continue.
I clicked Yes on the Create directory screen.
I clicked OK on the Extraction completed screen.
Copy the lcppn30.dll file from the C:\notescpp\lib\mswin32 folder to the C:\Program Files\Microsoft Office Servers\15.0\Bin folder.
RHR (2012-05-05): I fixed a typo below. I referenced the wrong Lotus Notes folder to copy to.
Copy the lcppn30.dll file from the C:\notescpp\lib\mswin32 folder to the C:\Lotus\Notes folder.
Update the Path Environmental Variable
I am not convinced that I need to update the Path Environmental Variable; but it has solved problems for me in the past when I use the Lotus C++ API from IBM.
I open Explorer and right-click on Computer. I click on the Properties option on the menu.
The System Properties screen appears. I click on the Advanced tab.
RHR (2012-05-05): The Control Panel \ System and Security \ System screen may appear. If it does, click on Advanced system settings next.
Click on Environment Variables and scroll down in the System Variables and select Path.
Click on Edit and the Edit System Variable screen appears. Append the following text to the end of the Variable value field. Then click OK to accept the change and continue.
Click OK on the Environment Variables screen.
Click OK on the System Properties screen.
Configure the Lotus Notes Client Application
I confirm that my Domino server is running on another virtual machine. The server name is Litwaredemo/litwareinc and the IP address is 192.168.1.88. The Lotus Notes ID that I plan to use is a member of the applicable administrators groups on the Domino server.
I click the Windows Start button on my keyboard and then click on the Lotus Notes 8.5 icon on the workspace.
The Client Configuration screen appears and I click Next to continue.
The Client Configuration screen appears and I enter the details as seen below. I click Next to continue.
The Client Configuration screen opens. Click Next to continue.
The Domino Server Network Information screen appears. I enter the settings as seen below and click Next to continue.
The Notes ID File screen appears. I browse to where my Notes ID is stored and click Next to continue.
I click Yes in the IBM Lotus Notes screen that appears. I do want my Notes ID file copied to the data directory.
I enter the password in the Lotus Notes password screen and click Log In to continue.
Note: Never create this Notes ID without a password! Anyone with access to the SharePoint server could then gain full access to the databases on the Domino server.
The Lotus Notes client successfully connects to the Domino server.
The Client Configuration screen appears. I leave the settings as is and click Next to continue.
Another prompt appears. I check the checkbox in the bottom of the prompt and click No to continue.
The Lotus Notes 8.5 Getting Started workspace appears.
I keep the Lotus Notes client running in preparation for the next steps.
Verify Access to the Lotus Domino Database that You Want to Crawl
I click on File \ Open \ Lotus Notes Application on the menu bar.
The Open Application screen appears. I select my Domino Server (LITWAREDEMO/litwareinc) in the drop down list and click through the folder structure until I see the database that I am looking for. I select it and click Open.
I wait for the Lotus Notes database to open. A Create Cross Certificate prompt appears and I click Yes to accept it.
The About Database document document appears in the workspace. I click the small x on the tab to close it.
The database opens in the workspace. It is opened to the default view named Threaded.
I also see a message in the view. The message indicates that the view is still being updated.
Eventually, the view completes updating and displays data.
I can test access to more Notes databases if I want to. I close the Lotus Notes client software after I completed testing. I click on the X in top right hand corner.
I click Yes to exit from Notes when prompted.
Create the Lotus Notes Mappings Database
I created the Mappings database on another virtual machine where I have the Lotus Notes Designer client installed. I opened the Lotus Notes Designer client and created a Notes database and named it “Mappings”. I then created a new form named “Mapping”. I added two fields and some labels as seen below.
I did change the Window Title of the form to “Mapping”.
I created a view named “Mappings”. The View Selection formula is: SELECT Form="Mapping". I add a column for each field. I sort the first column in ascending order. The view design appears as below:
I removed the default view that came with the design. Only the Mappings view appears in the view design list now.
Add User Accounts to the Mappings Database
I open the Mappings database in the Lotus Notes client and click on Create \ Mapping.
A blank Notes document appears as below:
I enter the names as below to create a new mapping.
|Lotus Notes User ID:||LitwareInc\System Administrator|
The new document appears in the Mappings view.
I close the Notes client on my virtual machine. I copy the Mappings database file from my Notes \ data folder to a shared folder. I then copy the file from the shared folder to the lotus \ Domino \ data folder on the Domino server. Not to the Notes client on the SharePoint server!
Restart the Server
I have the Search components installed on my SharePoint 2013 server. I have to restart the server before proceeding with the next steps.
This concludes part 1 of 2 of my blog entries on installing and configuring the Lotus Notes Connector for SharePoint 2013. I hope that you found it helpful. Part 2 will provide the steps to complete everything to the point where you can get search results from your Notes databases. You can read my other blog entries on how I installed and configured my SharePoint 2013 server environment.