XML2Text
The XML2Text component transforms data from XML format to flat file format. This component accepts data in XML format and transforms it into the required Text (delimited, positional or both) format.
The TFL file, used in the configuration of the XML2Text component, which describes the conversion rules, may be created or modified using the Fiorano Studio tool.
Configuration and Testing
Managed Connection Factory
Figure 1: Managed Configuration Properties
Attributes
File 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 the ellipsis button.
Connection Pool Params
Please refer Connection Pool Params section in Common Configurations page.
Interaction Configuration
Prefix namespace for only root element
The schema generated will have element form default as unqualified and the child elements will belong to the namespace of root element, otherwise each element will have its own namespace prefix.
Target Namespace
Refer to the Target Namespace section under the Common Configurations page.
Monitoring Configuration
Please refer to the Monitoring Configuration section in Common Configurations page.
Expert Properties
Enable the Expert Properties view to configure these properties.
Expert properties are meant for advanced users. Use with caution!
Figure 10: XML2Text CPS with the Expert Properties enabled and highlighted
Pre Processing XSL Configuration
Pre Processing XSL configuration can be used to transform request message before processing it. Click the ellipses button against the property to configure the properties.
Refer to the Pre/Post Processing XSL Configuration section under the Common Configurations page for details regarding Pre Processing XSL configuration and Post Processing XSL configuration (below).
Post Processing XSL Configuration
Post Processing XSL configuration can be used to transform the response message before sending it to the output port.
Process Message Based on Property
The property helps components to skip certain messages from processing.
Refer to the Process Message Based On a Property section under the Common Configurations page.
Validate Input
If this property is enabled, it validates the input request with the input port XSD.
Refer to the Validate Input section under the Common Configurations page.
Cleanup resources (excluding connection) after each document
This closes all the resources except for the connection after every request. If the less processing time is more important the less memory usage, then it is recommended to disable this property and vice versa.
For more details, refer to the respective section under in the Common Configurations page.
Elements to Decrypt
Select elements to decrypt in the Input Message.
Refer to the Encrypt Decrypt Configuration section in the Common Configurations page for details.
Scheduler Configurations
Please refer 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 Error Handling section of Common Configurations page for details.
Testing
Schema
Sample CSV file format schema is as below.
Figure 3: Sample CSV Schema Format
The structure of the schema is shown the below figure. Sample schema contains Employee records and each record contains EmployeeName, EmployeeID and EmployeeAge fields. This sample schema has Record Delimiter as CRLF and Filed delimiter as comma(,).
Figure 4: Structure for the Sample CSV Schema Format
Sample Input
The input XML structure is same as that of the sample CSV file format schema which is shown in Figure 4.
Sample input is shown in the below figure. It contains multiple Employee elements under EmployeeSchema element. Each Employee element contains EmployeeName, EmployeeAge and EmployeeID elements.
Figure 5: Sample Input
Sample Output
Sample output contains CSV formated Employee Records, which are separated by new line character (CRLF) and the fields are separated by a comma (,).
Figure 6: Sample Output
Functional Demonstration
Scenario 1
This scenario demonstrates the transformation of XML into comma-separated values (CSV).
Configure the XML2Text component as described in the Testing section and use Feeder and Display components to send sample input and check the response respectively. CSV File Schema is used in this scenario.
Figure 7: Demonstrating Scenario 1 with sample input and output.
Useful Tips
Please refer Flat File Schema Editor section for the documentation related to creating the Text Format Layout (TFL) files.