Text translator

The Text Translator converts flat files to and from XML format, enabling flat-file applications to integrate with Sterling™ Order Management System Software.

For detailed information about Text Translator file configuration, see "Time-Triggered Transaction Reference".

Configuration properties

The following are the properties of this node:

Table 1. Text translator configuration properties
Property Description
Input Data Format Select the format in which data is input. Options are:
  • Text - Flat text files
  • XML - Structured text files
Output Data Format Enter the format of the output data, automatically determined by the choices for Input Data Format combined with Input Text Format or Output Text Format.
Input Text Format If you selected Input Data Format to be Text select:
  • Text Positional - For a Flat text file with fields that have a fixed maximum length and records that have a common end-of-record terminator
  • Text Delimited - For a Flat text file that contains one or more records separated by a specified delimiter, or separator
Schema Name Enter the relative path to the schema description file of the translation from XML input to a flat file. The location is relative to the CLASSPATH of the integration adapter.

For example, if the flat file schema XML file is located in <INSTALL_DIR>/bin/test.xml, and <INSTALL_DIR> is in the CLASSPATH, then the value of the attribute is /bin/test.xml.

Connection properties

A Text Translator has to be either preceded by a File or DCS 6.2 Database node or succeeded by a File or DCS 6.2 Database node, using the following conditions:

  • When the File or DCS 6.2 Database node is followed by a Text Translator component:
    • Output format is always XML
    • Input format must be text
  • When the Text Translator component is followed by a File or DCS 6.2 Database node:
    • Output format must be text (either positional or delimited)
    • Input format must be XML

The Text Translator component cannot be directly before or after a pass-through node.

The following are the Text Translator node's connection properties:

Table 2. Text translator connection properties
Connection Node Connection Rules
Can be the first node after the start node Only for services invoked synchronously
Can be placed before
  • Any synchronous transport node
  • Any other component node except for a pass-through node
Can be placed after
  • Start node
  • Any synchronous transport node
  • Any other component node except for a pass-through node
Passes data unchanged Yes