Creating a Migration Robot in Kapow Design Studio–Part 1 of 5

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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s