Format Tab

The Format tab indicates the imported data’s format and defines its row structure.

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

Delimited Text

Delimiter Character list

The character that will separate rows in the import data.

Import File Includes Header Row

Indicates whether to include or ignore the first row that represents the heading in the import data file while importing the data.

Data Table Definition

Lists all fields selected on Data tab for inclusion in import data. Left-clicking a column heading allows you to sort the display by that field. Click that heading again to reverse the sort order.

• Field Description: Identifies the database field into which the data will be imported.

• Field Index: The order of that data value in the flat file. A flat file is a source file that you can use for your imports. For example, a text or CSV file.

• Mapping ID: Defines what mapping import, if any, is to be used to translate the imported data.

XML Format

Field Data as XML element or attributes list

• Standard ADO attribute based XML

• Element based XML

XML element name to contain rows

Indicates which XML element will hold the row definitions.

Data Table Definition grid

Lists all fields selected on Data tab for inclusion in import data. Left-clicking a column heading allows you to sort the display by that field. Click that heading again to reverse the sort order.

• Field Description: Identifies the database field into which the data will be imported.

• XML attribute Name: The name used in the XML file that maps to the database field name.

• Mapping ID: Defines what mapping import, if any, is to be used to translate the imported data.

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