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


Four more steps to add!

clip_image001

The hyperlink needs to be clicked to get to the “Download Agreement” web page. You may need to right-click it then click on the [Click] option. This creates a step that you can later delete.

clip_image002

You should see the “Download Agreement” web page.

clip_image004

Scroll down the web page until you see the “I have read and accept the terms and conditions” hyperlink.

clip_image005

Right-click on the hyperlink and select the [Extract \ Extract URL \ Post.URL] option.

clip_image007

A new step is created and it should appear like below.

Step

Tag Finders

Action

Extract File URL

clip_image009

clip_image011

Right-click on the “Extract File URL” step and select [Insert Step After].

clip_image012

A new step is created. Change the name of the step on the Basic tab to “Assign Variable” and it should appear like below.

Step

Tag Finders

Action

Extract File URL

clip_image014

clip_image016

The text in the Value text field appears as follows:

substring(Post.URLFileAttachment, indexOf(Post.URLFileAttachment, "$FILE/")+6, length(Post.URLFileAttachment)-12)

Right-click on the “Assign Variable” step and select [Insert Step After].

clip_image012[1]

A new step is created. Change the name of the step on the Basic tab to “Extract File Attachment” and it should appear like below.

Step

Tag Finders

Action

Extract File URL

clip_image018

clip_image020

This step is extracting the file attachment and saving it with the same filename to the C:\Temp directory.

Right-click on the “Extract File Attachment” step and select [Insert Step After].

clip_image012[2]

A new step is created. It should appear like below.

Step

Tag Finders

Action

Extract File URL

clip_image014[1]

clip_image022

The “Store in Database” step saves the record to the database for future use.

Grouping Steps

I grouped the steps by first selecting them with the mouse in the robot editor view.

clip_image024

Then click the [Group] button in the action bar. Enter a name for the group (e.g. Extract File Attachment) and hit [Enter] on your keyboard.

clip_image025

You can now collapse and expand the group in the robot editor view by clicking on the [-+] button in the group.

clip_image026

Save the Robot

Save the robot by clicking on File \ Save in the menu.

clip_image027

Next: I have to document and publish the steps to migrate the content that I just extracted to a SharePoint 2010 server. I have done the migration already; but I need to record it here.

Many thanks to the Kapow support team for helping me through this process. I’m sure that they know better ways for some of the steps. I did learn a lot using this hand-on approach.

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