PSIcapture Administrator Guide: Migration

 Audience

This article is meant for PSIcapture Administrators.

Overview

The migration module provides options for moving document images and metadata to file folder formats, database formats, and content management systems. There are two types of migration formats that PSIcapture handles as outlined below.

• Direct Write - This type of migration can move images, metadata, and OCR text directly into the target content management system or database. The metadata and OCR text function as index values for image retrieval and Document Management systems. Database migrations create a standard MS SQL Server 2005 database or Access 2003 database where each index field name is a column, the index values are rows in the table, and the final column of the database table is the path to the drive/directory of the image file associated with each row of index values.
• Flat File - This type of migration includes text and XML formats. The user can then take the output files and import them in the ECM of their choice.

Introduction

The Migration module is the data and image exporting stage of processing a PSIcapture batch. The product currently migrates data in over 60 different formats with many configurable options for each. All levels of index data, scanned images, and OCR output can be sent to a target location in a local or remote document management system, database, or folder, all depending on which migration method is being applied.

Migration to multiple formats or products is supported; when more than one migration target is selected and added to the workflow (see "Migration Settings" below), each migration will be executed sequentially from the top of the list to the bottom. Furthermore, multiple migration stages can be added to the workflow if data needs to be partially migrated, edited or checked, and then completely migrated.

For links to specific details on configuring migrations PSIcapture can process, see the "Available Migration Configurations" list below.

Adding a Migration Workflow Step

The Migration workflow step can be added in the Workflow section of Capture Profile Configuration.

As mentioned above, more than one Migration step can be added, each with its own set of migrations to process with different rules; usually, one Migration step is sufficient for most scenarios.

Fig. 1: Capture Profile Configuration, Workflow section.

In this example, the "Migration" step is selected from Available Workflow Modules.
Clicking the Add button will place "Migration" below "Quality Assurance" in the Workflow list to the right.

Migration Settings Window

The Migration Settings configuration window can be reached by adding it from the "Available Workflow Modules" list in the Workflow section while configuring a Capture Profile. Double-clicking "Migration", or selecting it and choosing "Add" will open and focus the window.

General Section

The Migration Settings window (see below) opens immediately after the Migration workflow step is added while configuring a profile (see Fig. 1 above). The General section is always the first to appear, and it lists migrations available to be added alongside currently configured migrations.

Available Migrations

This list features all the migrations which can currently be used in the product.

Some migrations have Direct support, and are named as such: this indicates that the PSIcapture product will directly connect to the target system and upload the batch data in that system's native format.

Other migrations have Flat support, and are named as such or simply have a lack of "Direct" in the name: this indicates that the PSIcapture product will migrate a file/folder format that is expected by the target product without establishing a direct connection to that product. That exported data can then be imported by the target product.

Migration Workflow

This list features all the migrations that have been added to the current Migration step. Some notes on the behavior of this list:

• Migrations to a single product or generic format can be configured multiple times (e.g. you may have two separate FTP migrations in the workflow)
• Migrations can be duplicated with identical settings
• During batch processing, the migrations process in sequence from top to bottom
• Exception Processing alters the way the list behaves when a migration fails