Format Definition Page

Enter the FTP Adapter format definition parameters.

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.

  • The FTP Adapter can only be configured as an invoke connection in an orchestrated integration.

Creating a New Schema File

Element Description

Select a New Delimited Data File

Select the delimited comma-separated value (CSV) file from which to create the schema file. The content of the file is then displayed at the bottom of the page. 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

  • Pipe (for example, Name|City|Country)

  • Character Set

Select a character set. The selected value will be used as the encoding format while reading the sample data file.

This field is used for character encoding during file transfer. If data sent to the FTP Adapter is in a specific encoding format, then select that same encoding format in the FTP Adapter. Otherwise, there may be some character loss in the final written file. This also corrupts the file. For example, if a REST Adapter is using UTF-8 encoding and the FTP Adapter is configured with the ASCII character set, this may corrupt the file. If you select the same UTF-8 encoding in the FTP Adapter, the problem is resolved.

  • Optionally Enclosed By

This value causes occurrences of the selected delimiter to be ignored during processing. For example, when processing the following record:

Fred,"2 Old Street, Old Town,Manchester",20-08-1954,0161-499-1718

If the selected Field Delimiter is “,” and the Optionally Enclosed By value is quot; (), then the value 2 Old Street, Old Town,Manchester is treated as a single record column.

If Optionally Enclosed By is used, the character must not be part of any field. Therefore, the following is invalid:
  • a,b",c (In this scenario, " is part of the second field)
  • a,"b,c",d (In this scenario, the second field is created using Optionally Enclosed By ('"'). However, it has ',' as content for the second field value.)
  • 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.

  • Mark All As Optional

Select to mark elements as optional in the schema file. By default, all elements are mandatory. You can also select the data type (for example, string, byte, integer, and so on) to use for each column in the table and mark specific elements as optional. While this option enables you to select all elements as optional, you must have at least one mandatory element to validate this page. This checkbox provides a convenient method to select the majority of elements as optional.

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.