To map a general table to a file
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 .
You map a new general table to export Campaign data for use by other applications.
1.
Begin from the New Table Definition - Select the table type window.
2.
Select General Table, then click Next.
3.
Select Map to Existing File, then click Next.
4.
To map a base record table to a fixed-width flat file:
a.
Keep the default File Type selection.
b.
Click Browse to select the Source File. Campaign will automatically populate the Dictionary File field with the same path and file name, except with the .dct extension. You can override this entry if necessary.
5.
To map a base record table to a delimited file:
a.
Select Delimited File for the File Type.
b.
Check First Row of Data Contains Field Names if this is the case.
c.
Select the Field Delimiter used: TAB, COMMA, or SPACE.
d.
Select the Qualifier used to indicate how strings are delimited in the file: None, Single Quote, or Double Quote.
e.
Click Browse to select the Source File, then click Next.
The Specify the New Table’s Fields window opens.
6.
Specify the fields to use in the new table. By default, all fields in the file are listed.
If you are mapping a delimited file, the first 50 lines of the file will be sampled for field type and width. You can override the field type (Numeric or Text) and the width, which are automatically detected. For example, if the IDs in the first 50 lines are detected to be 2 characters wide, but you know that IDs later in the file 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.
You 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.
7.
When finished, click Next.
The Specify table name and field information window opens.
8.
Accept the defaults, or edit the Unica Table Name field to change the name of the table as it will appear in Campaign; and change the Unica field names that are mapped to the source field names.
9.
Click Finish.
You have created the general table based on a file.
Copyright IBM Corporation 2012. All Rights Reserved.