Configuring FTP Adapter Format Definition Properties

Enter the FTP Adapter format definition parameters.

Topics

What You Can Do from the FTP Adapter Format Definition Page

You can configure the following parameters on the FTP Adapter Format Definition page.

  • Create a new schema file from a comma-separated value (CSV) file.
  • Use an existing schema file.

What You See on the FTP Adapter Format Definition Page

The following tables describe the key information on the FTP Adapter Format Definition page.

The fields that display on the Format Definition page are determined by your selection on the Basic Info page:

  • Selected to create a new schema file

  • Selected to use an existing schema file

Note:

If configuring the FTP Adapter in the trigger (inbound) direction, schema selection is not supported. If you select Yes to define a schema for the endpoint on the Basic Info page, nothing prevents you from uploading a schema on the Format Definition page. However, this schema is not used. You must select No on the Basic Info page to transfer files as an attachment.

Creating a New Schema File

Element Description

Select a New Delimited Data File

Selects the delimited comma-separated value (CSV) file from which to create the schema file. This field appears if you selected to create a new schema on the Basic Info page of the wizard.

  • Enter the Record Name

Enter the record name. This becomes the parent element in the created schema file for the record names selected as column headers from the CSV file.

  • Enter the Recordset Name

Enter the recordset name. This becomes the root element of the created schema file.

  • Select the Field Delimiter

Select one of the following supported file delimiter options:

  • Single space

  • Comma

  • Semicolon

  • Tab

  • Use the First Row of the File as the Column Headers

Displays by default the first row of the selected CSV file as the column headers.

  • Detach

Select to edit the CSV file in a separate window.

Editable Column Headers

Edit the column headers of the table, as needed.

Data Types

Select the data type (for example, string, byte, integer, and so on) to use for each column in the table.

Using an Existing Schema File

Element Description

Select a New File

Select the existing schema file to use. This field appears if you selected an existing schema from the file system on the Basic Info page of this wizard.

  • Selected File Name

Displays the selected schema file name.

  • Select the Schema Element

Select the schema element. This field is displayed after the schema file is selected. The element name is treated as the root element in the uploaded schema file.