on 03-04-2009 7:16 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.