I will describe the steps taken to migrate Lotus Notes content from a Sandbox database to a SharePoint custom list. I have attempted to record every step and action taken as best as possible.
- Running Kapow Design Studio
- Creating a new project
- Adding a database to the project
- Creating a new type to define the data source and database table
- Creating the extraction robot
- Debugging the extraction robot
- Creating the migration robot
- Debugging the migration robot
The first five parts show the steps taken to read the content and store it to a local database using Kapow Design Studio.
Running Kapow Design Studio
I am running Kapow Studio in a VMWare virtual machine:
- Windows 7 Enterprise 64-bit
- Intel Core Duo CPU 2.8GHz
- 4GB Ram
- Lotus Notes 8.5
- SharePoint Server 2010
- Microsoft Office Professional Plus 2010 32-bit
Open Kapow Design Studio in your Windows
I am running Kapow Design Studio 9.0
Creating a New Project
Start a new project
Enter “Lotus Notes Sandbox Migration” as the project name and click [Finish]
Creating a New Type to Define the Data Source and Database Table
Select the “Lotus Notes Sandbox Migration” project.
Create a new type in the project.
Enter SandBoxDoc.type as the type name. Click [Finish] to continue.
The attributes window opens in the workspace. I added the attributes for this demo.
Click on the [+] to add a new attribute. You will need to add the attributes that you see listed in the previous screen. Enter the name and type for each attribute. The UniqueID is required and part of database key. Click [Ok] to close the “Add Attribute” dialog box for each attribute.
You can double-click on an attribute in the attributes list to edit it again.
I will refer to the SandBoxDoc.type again. Click on the [X] in the tab to close the SandBoxDoc.type window for now.