This example convert 2 different recordsets inside single file to xml. First recordset is “SINGER”, second recordset is “SONG”. First column is 1 character length. It is a key column to identify different recordset. “A” from first half mean SINGER,
File Adapter – Sender – Convert Single Fixed Length Structure to XML
Previous example tested the CSV file with delimiter, now look at fixed-length file. The objective is to convert fixed-length file to xml representation. ABB, FULLNAME, GENDER and COUNTRY, each is with length 5,20,7,10 respectively. Example: The target message type
File Adapter – Sender – Content Conversion to Convert CSV file to XML
The objective is to convert csv file to xml representation. Example: The target message type is 2 columns that repeatable at node row. Document Name is the target message type. Document Namespace should be the namespace of the message type.