To map a general table to a file

You map a new general table to export Campaign data for use by other applications.

You can map a new base record table to a file:

When editing a flowchart, through the Admin menu, as described in Working with user tables while editing a flowchart.

Through the Campaign Settings page, as described in Working with user tables from the Campaign Settings page .

Begin from the New Table Definition - Select the table type window.

Select General Table, then click Next.

Select Map to Existing File, then click Next.

To map a base record table to a fixed-width flat file:

Keep the default File Type selection.

Click Browse to select the Source File. Campaign automatically populates the Dictionary File field with the same path and file name, except with the .dct extension. You can override this entry if necessary.

To map a base record table to a delimited file:

Select Delimited File for the File Type.

Check First Row of Data Contains Field Names if this is the case.

Select a Field Delimiter to indicate which character separates each field in a row of data: TAB, COMMA, or SPACE.

Select the Qualifier used to indicate how strings are delimited in the file: None, Single Quote, or Double Quote.

Click Browse to select the Source File, then click Next.

The Specify the New Table's Fields window opens.

Specify the fields to use in the new table. By default, all fields in the file are listed.

Use the Add, Remove, Up 1 and Down 1 buttons to specify the Source Table Fields that are included in the new table and their order.

You can adjust the field type (Numeric or Text) and width, which are automatically detected based on the numRowsReadToParseDelimitedFile configuration setting. For example, if IDs are detected to be 2 characters wide, but you know that IDs can consist of up to 5 characters, increase the value to 5.

If the width value is too small, an error may occur.

When you export data to a fixed-width flat file on disk, you can override the preset field lengths by editing the data dictionary for that file.

When finished, click Next.

The Specify table name and field information window opens.

Accept the defaults, or edit the IBM® Campaign Table Name field to change the name of the table as it will appear in Campaign; and change the IBM® Campaign field names that are mapped to the source field names.

Click Finish.

You have created the general table based on a file.