PowerExchange for Lotus Notes User Guide for PowerCenter

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5
- 10.4.0

Back Next

Importing a Source Definition from Forms, Views, or Independent Documents

When you import forms, views, or independent documents as source definitions, you can filter the source metadata that displays in the Designer. When you import a Lotus Notes source, you can select the fields that correspond to columns in a source definition. The Designer displays the source definitions in the Import List. The naming convention for the source definition is <DSN name>:<Table name>.

The following table describes the options that you can use when you import a form, view, or independent document as a source definition:

Field	Description
Key Field	Transfers the documents that do not contain null value in the column for which you have enabled this option.
Multi-value Field	Indicates whether a source definition contains multi-value fields. The Designer sets this value to 1 if the source definition has multi-value fields. The Designer sets this value to 0 if the source definition does not have multi-value fields.
Transfer as Text	Transfers a multi-value or Date/Time datatype field as text.
Transfer Text	Transfers a rich text field as text.
Transfer Images	Transfers .BMP and .GIF images in binary format.
Transfer Tables	Transfers text in the tables as a comma-separated list.
Transfer Attachments	Transfers attachments in binary format.

In the Source Analyzer, click Sources > Import from Lotus Notes.

The Import Lotus Notes Source dialog box appears.

Select a DSN from the list.

Enter the password.

Optionally, enter a filter condition.

Click Connect.

The Designer displays a list of forms, views, and independent documents in the Select an Entry to Import area.

Select a Lotus Notes source to import, and click the right arrows (>>) button.

The Select Fields dialog box appears.

Enter the table name.

From the Fields and Columns list, select at least one field, and click the right arrows (>>) button.

The Edit Column Information dialog box appears.

Enter the column information.

Click OK.

The Select Fields dialog box appears.

Select Transfer Attachments to transfer files in a document.

The Attachment and AttachmentName columns are added to the Import List. AttachmentName stores the attachment name along with the extension. An attachment stores the data in binary format.

Click Add Formula Field to add a column based on a Lotus Notes formula.

Click Formula to filter documents.

Click the up and down arrows to change the order of the fields.

Click OK to import the source definition.

Lotus Notes Sources

Adding Formula-Based Columns

Filtering Documents

Download Guide

Watch

Comments

Communities

Knowledge Base