Text translator delimited sender XSD file

The Text Translator delimited Sender XSD file defines how to transform XML data to delimited files. The following table lists the essential elements and attributes.

The Root, FileHeader and FileTrailer element definitions remain the same as explained in Text translator positional receiver XSD file.

Table 1. Elements in the delimited flat file sender XSD file
Property Description
ParserDefaults Element
RecordIdStartPosition Required. Integer. Indicates the start position of a record.
DefaultRecordDelimiter Required. RecordDelimiterType. The default delimiter between records is Newline.
DefaultFieldDelimiter Optional. CharacterType. The default field delimiter between the fields is comma [,].
DefaultEscapeCharacter Optional. CharacterType. The default escape character is \.
DefaultPadCharacter Required. String. Minimum length=1. Maximum length=1. Fills the non-data portion of a field with any single character. Valid values include a space or zero as well as any other character. The default value is #.

For example if you specify trailing ###'s in a field, they are ignored.

This character is used for visual convenience when you want to space out the fields correctly and do not want to rely on the blank space.

SkipCarriageReturn Optional. Boolean. Defaults to true.
SuppressEORFieldDelimiter Optional. Boolean. Defaults to False. This attribute when passed as True does not print the delimiter at the end of the record.
ElementMapList Element

This element maps the elements in the XML to the records in the flat file.

ElementMap Element
ElementName Required. NMTOKEN. The name of the element in the XML file.
RecordId Required. NMTOKEN. The record identifier to write.
AttributeMap Element
AttributeName Required. NMTOKEN. The name of the attribute.
FieldName Required. NMTOKEN. The field corresponding to the attribute. This field corresponds to the Name attribute of the Field element.
TruncateData Optional. Boolean. Defaults to true.
RecordDefinitions\Record Element

A record describes a line in the flat file. This record definition is translated into an XML element.

RecordId Required. NMTOKEN. This is the RecordId in the source XML file.
Name The name of the record. This is used to associate with a Header, Terminal, Sequence or Choice Name attribute.
Description String. The description of the name. This is not used while processing the file.
XMLName Required. NMTOKEN. The tag name of the output element.
WriteRecordId The default value is Y. If set to N, no record ID is written to the output file.
Field Element

Each record consists of fields, which are translated into attributes or child elements depending on the ContainmentType.

Name Required. NMTOKEN. The name of the field which is used as a reference in the AttributeMap. This name must be unique within a record.
XMLName Required. NMTOKEN. The output attribute or element name of the XML.
FieldPosition Required. Integer The position of this field within the record. If the RecordId is at position 1, then the numbering of fields should begin at position 2.