Mapping a general table to a file

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

Procedure

  1. Use one of the following methods to open the New table definition - Select the table type dialog:
    • If you are editing a flowchart, open the Admin menu and select Tables, or
    • Select Settings > Campaign settings, then click Manage table mappings.
  2. Select General table, then click Next.
  3. Select Map to existing file, then click Next.
  4. To map the table to a fixed-width flat file:
    1. Keep the default File type selection.
    2. Click Browse to select the Source file. Unica 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.
  5. To map the table to a delimited file:
    1. Select Delimited file for the File type.
    2. Check First row of data contains field names if this is the case.
    3. Select a Field delimiter to indicate which character separates each field in a row of data: TAB, COMMA, or SPACE.
    4. Select the Qualifier used to indicate how strings are delimited in the file: None, Single quote, or Double quote.
    5. Click Browse to select the Source file, then click Next.
      The Specify the new table fields window opens.
  6. 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.
    Important: If the width value is too small, an error may occur.
    Note: 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.
  7. Click Next.

    The Specify table name and field information window opens.

  8. Accept the defaults, or edit the Unica Campaign table name field to change the name of the table as it will appear in Unica Campaign; and change the Unica Campaign field names that are mapped to the source field names.
  9. Click Finish.

Results

You have created a general table based on a file.