Format Tab

The Format tab defines the destination file’s structure.

The Data Format list includes the list of format types of the destination file, as described below. Other fields will appear, as needed, for each entry in this list.

XML Format

XML Type

• Standard ADO attribute based XML

• Element based XML

Delimited Text

Delimiter Character

The character that will separate fields in the destination file.

Include Header Row

Indicates whether to ignore the first row in the import data file while importing the data.

Text Template

Allows you to define the format of the text file.

Define Template Format

This field allows free form entry for the file structure (commonly used when third party systems have a predefined file format). Any portion of the string beginning with %%, ending with %%, and enclosing a valid column name, is translated as a bookmark. For each record in the output, the actual value of the bookmarked column will be substituted for the %%Column_Name%% string.

To modify the format definition, select the desired field and change its value. Click Save to keep your changes or Cancel to discard them.