Problem with file content conversion in receiver file adapter

[Chandra_Hota]

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

[Former Member]

Hi Chandra Shekar,

The best possible way is to change the receiver file structure rather than manipulating cc for each hierarchy.

Claim record1

<<Work_Order1>>

<<<<Line_Item1>>>>

<<<<Line_Item2>>>>

<<<<Line_Item3>>>>

<<Work_Order2>>

<<<<Line_Item4>>>>

<<<<Line_Item5>>>>

<<<<Line_Item6>>>>

Maintain one node for claim record and one for each work order1 and work order 2

in the fields (for ex: Line_Item1) try mapping this way.

Source <-> remove contexts <-> split by value <-> target

try this,

Regards,

Pavan

[Former Member]

Chandra,

File doesnt support hierarchy, so you should try to create a flat structure for your receiver.

Check out ths following blog : /people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

thanks,

Pooja Pandey

[Former Member]

Hi,

Try adding

endSeparator as '0' for all the claim,work and line items

FieldFixedlengths for all the claim,work and line items

FieldFixedNames for all the claim,work and line items

at the end add

Line_Item.fixedLengthTooShortHandling = Cut

this might solve your problem.