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, “B” from second half mean SONG.
file_adapter_multiple_fixed_length_before_after

This is the target Message Type:
file_adapter_multiple_fixed_length_MT

Below are the configuration that make this happen:

ignoreRecordsetName true
SINGER.fieldFixedLengths 1,5,20
SINGER.fieldNames KEY,SINGERID,FULLNAME
SINGER.keyFieldValue A
SINGER.keyFieldInStructure ignore
SONG.fieldFixedLengths 1,5,35
SONG.fieldNames KEY,SINGERID,SONGNAME
SONG.keyFieldValue B
SONG.keyFieldInStructure ignore

file_adapter_multiple_fixed_length_CC

Keep on posting!

File Adapter – Sender – Convert Multiple Fixed Length Structure to XML Using Key Field Name
Tagged on:             

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.