Hi All
I have a problem with file content conversion in receiver file adapter.
I get data from proxy in 3 levels. I have claim records and each claim record have multiple work order records. Each work order record has multiple line item records.
Claim record1
<<Work_Order1>>
<<<<Line_Item1>>>>
<<<<Line_Item2>>>>
<<<<Line_Item3>>>>
<<Work_Order2>>
<<<<Line_Item4>>>>
<<<<Line_Item5>>>>
<<<<Line_Item6>>>>
I have the following file content conversion:
Recordset Structure: Claim_Record,Work_Order,Line_Item
Content conversion parameters are:
Claim_Record.fieldSeparator = ,
Claim_Record.endSeparator = 'nl'
Work_Order.fieldSeparator = ,
Work_Order.endSeparator = 'nl'
Line_Item.fieldSeparator = ,
Line_Item.endSeparator = 'nl'
My problem is, data is written into the file without this hierarchy.
All claim records are written in sequence followed by all work order records, followed by all line item records.
Can file adapter's file content conversion handle 3 levels of data? If not, what is the solution for this scenario?
Please help!
Chandra