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

clip_image001

I am running Kapow Design Studio 9.0

clip_image002

Creating a New Project

Start a new project

clip_image003

Enter “Lotus Notes Sandbox Migration” as the project name and click [Finish]

clip_image004

Creating a New Type to Define the Data Source and Database Table

Select the “Lotus Notes Sandbox Migration” project.

clip_image005

Create a new type in the project.

clip_image006

Enter SandBoxDoc.type as the type name. Click [Finish] to continue.

clip_image007

The attributes window opens in the workspace. I added the attributes for this demo.

clip_image009

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.

clip_image010

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.

clip_image011

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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