Text2XML

The Text2XML component transforms data from any flat file format to XML format. This component accepts data in Text (Delimited, Positional or both) format and transforms it into the required XML format.

The component takes TFL file as input in the CPS which describes the conversion rules. TFL files can be created or modified using the Fiorano Studio tool.

Configuration and Testing

Managed Connection Factory

Attributes

Flat Format Schema content

Flat Format Schema Content (TFL file), which describes the conversion rules has to be specified here. The TFL schema file can be provided using 'Flat Format Schema Content editor' which opens up on clicking ellipsis button

Connection Pool Params

Please refer Connection Pool Params section in Common Configurations page.

Interaction Configuration

Attributes

Enable dos2unix conversion?

This property should be used when CRLF (0D0A) should be converted to LF (0A) before processing the input message. New line is treated as CRLF (0D0A) in Windows and LF (0A) in Unix.

If the TFL file contains delimiter as new line character and whether the flat file is generated in Windows or Unix is not known, this property should be set to 'yes'. If this property is set to 'yes', the component converts all CRLF's to LF's in the input flat file and TFL file and then it applies the conversion rules specified in the TFL file.

The transformation may be tested by clicking the Test button in the Interaction Configuration panel. Sample message is generated depending on the Flat Format schema provided in the Managed Connection Factory panel.

First Line as Field Names?

Enable this to consider the first line as the name of fields.

File Encoding

The encoding to be used while reading the file.

• ASCII
  A coding standard used to represent plain text. It is based on English Alphabetical order.

• Cp1252
  This is a character encoding for the Latin alphabet.

• EUC_KR
• EUC_JP
• EUC_CN

• EUC_TW
  EUC_KR, EUC_JP, EUC_CN, EUC_TW are multi-byte character encoding systems used for Korean, Japanese, Simplified Chinese, and Traditional Chinese languages respectively. 

  

  Reading UTF files with a byte order mark (BOM) attached to the beginning of the file may not give the desired result.

• ISO8859_1
  ISO 8859-1, more formally cited as ISO/IEC 8859-1 is part 1 of ISO/IEC 8859, a standard character encoding of the Latin alphabet.

• SJIS
  A character encoding for the Japanese language.
• UTF8
  A variable-length character encoding for Unicode
• UTF-16
  This too is a variable-length character encoding for Unicode. The encoding form maps each character to a sequence of 16-bit words.

Read input from file?

Choose this option to read input from a file instead of the component input port.

Source Directoryname

Directory where the input file is located.

Source Filename

Name of the input file.

Write output to file?

Writes the output XML to the specified file in the target directory.

isFilenameFromHeader

If enabled, the target filename and target directory values will be taken from the header of the input message.

Target Directoryname

Directory where output file needs to be stored.

Target Filename

Name with which the output file needs to be saved.

Action if Same file exists

The action that must be taken if the target directory already has a file with the same name as the file that has to be uploaded. The behavior will be dependent on the selection as shown below:

• OVERWRITE

  The file to be uploaded overwrites the one in the target directory.
  
  

• RENAME
  
  

  

  
  Figure 7: Action if Same file exists property options
  
  
  The name of the file that is being uploaded is changed based on the properties given below:
  
  • Append date-time format postfix: When existing files in the Target directory are not to be overwritten, FTPPut provides the flexibility of uploading the content into a new file whose name is in the format <NameOfExistingFile_CurrentDateTime>. The format in which the date and time are to be appended should be specified as a value for this property.
    Example: If the date-time format is specified as MMddyyyyHHmmssss for the file Sample.txt, the target file created would be Sample_0305200811300013.txt.
  • Append counter: Enabling this property appends a counter along with the Date and Time to target file name when the target file is not to be overwritten.
    Example: A sample file name could be Sample_0305200811300013_0.txt.

Refer to the Common Configurations page for the Monitoring configuration and TargetNamespace descriptions.

Expert Properties

These are the attributes meant for advanced users.

Elements to Encrypt

Select the elements to encrypt in output. Elements in the Input Message will be decrypted and those in Output Message will be encrypted.

For descriptions of Expert properties given below, please refer to the Interaction Configurations section in Common Configurations page:

• Pre Processing XSL Configuration
• Post Processing XSL Configuration
• Process Message Based On a Property
• Validate Input
• Cleanup Resources (excluding connection) after each input document

Scheduler Configurations

Please refer to the respective section in Common Configurations page.

Transport Configurations

Please refer the respective section in Common Configurations page.

Transport Configurations panel will be available only if scheduling is enabled in Scheduler Configurations panel.

Error Handling

Please refer the sections Request Processing Error, Connection Error and Invalid Request Error in the Error Handling section of Common Configurations page for details.

Testing

Schema

Sample CSV File Format Schema is shown in the figure below.

The structure of the schema is shown in the figure below. Sample schema contains Employee records and each record contains EmployeeName, EmployeeID and EmployeeAge fields. This sample schema has Record Delimiter CRLF and Field Delimiter comma (,).

Sample Input

Sample Input contains CSV formatted Employee Records, which are separated by a new line character and the fields are separated by commas. Sample Input is shown in the figure below.

Output

Ouput generated for the sample input is shown in the figure below. The output XML structure is the same as the structure of CSV File Format Schema.

Functional Demonstration

Scenario 1

The scenario demonstrates the transformation of comma-separated values into XML.
Configure the Text2XML component as described in Configuration and Testing section and use Feeder and Display components to send sample input and check response respectively. CSV File Format Schema is used in this scenario.

Use Case Scenario

In Bond Trading sample event process, Text2XML component is used to convert the data from CSV format to XML format.
The event process demonstrating this scenario is bundled with the installer. Documentation of the scenario and instructions to run the flow can be found in the Help tab of the flow in eStudio.

Useful Tips

Please refer Flat File Schema Editor section for the documentation related to creating the Text Format Layout (TFL) files.