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.
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 |
|
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. |