[COLOR=#009900]++Batch Header-1 +++Detail Record [0] ++++AddRecord -1 +++Detail Record [1] ++++AddRecord -1 ++++AddRecord -3
[/COLOR] ++Batch Trailer
+File Trailer
::>The AddRecord record starts with ‘8’ followed by ‘01’,‘02’,‘03’ indicating the versions , ie records starts with 801 / 802 /803.
::> I have cretaed the FF Dict and schema having record identifier as 801,802,803 and these records are unordered. So what is haapenning is everytime 801/802/803 is occuring it is creating a new list ex -
+++Detail Record [0] ++++AddRecord 3 [0] ++++AddRecord 2 [0] ++++AddRecord 3 [0] X
i think it would be really helpful to give u solution if u can attach a example flatfile which u got …becouse idk if anyone understood the heirarchy u explined in the post,i did not ! ,so can u attach your example flatfile …
Sri
+Header [Occurrence Single, Record Identifier ‘00’ ]
++Batch Header [Occurrence multiple, Record Identifier ‘1’ ]
+++Detail Record [Occurrence multiple, Record Identifier ‘7’ ]
++++ADD RECORD -1 [Occurrence multiple, Record Identifier ‘801’ ]
++++ADD RECORD -2 [Occurrence multiple, Record Identifier ‘813’ ]
++++ADD RECORD -3 [Occurrence multiple, Record Identifier ‘815’ ]
+++Batch Trailer [Occurrence single, Record Identifier ‘90’ ]
+File Trailer [Occurrence single, Record Identifier ‘9’ ]
ADD RECORD -1 /2/3 are unordered and can occur multiple times
If all are ordered then parsing is fine. As it is unordered the list items is getting created multiple times. Attached is the FF please someone look into this .
can u just clarify one thing …does the records(1,7,2) alwyas be in this order …i mean when we just consider these three records …(not 815,801 and 813) …
what i see in ur sample file is
1
7
2
7
2
is this consistent for all batch records …and in between first 7 and first 2 u can have any occurance of 815 ,801 and 813 in any order …
is this right …
sri
male the 8,2,9 unlimited unchecking the mandatory for those records. Also 7 should be mandatory and unlimited.Even 1 is mandatory and unlimited. try this and let us know
The records 7/2 is already unlimited. I donot have record type as ‘8’ , what I have is ‘801’ ‘813’ and ‘815’. You will see in the screenshot that even that under the header record multiple list of 7 and 2 are occuring in an indefinite way (Both are unlimited and unordered under the batch header.)
When few record of 7 are coming they are grouped together and when 2 records are coming in data they are grouped together. Now if 7 record sets are coming again then another list is getting created of 7 and so on…
I was keenly waitng for u to reply. Yeah the structure used by me is as follows , slight change in what is mentioned by you : -
+1(maxRepeat=unlimited) Batch Header
++7(unlimited) Detail Record
+++801(unlimited) [ Different Fields ,01 version , Record identf ‘801’]
+++813(unlimited) [ Different Fields, 13 version , Record identf ‘813’ ]
+++815(unlimited) [ Different Fields , 15 version, , Record identf ‘815’ ]
+++2(unlimited)
+++9(Single)–Trailer for each Batch record
After parsing I am getting : -
+1([0]) Header
++7(List - Say 4 items)
+++2(List - Say 3 items)
++7(List)
+++2(List)
++7(List)
+++2(List)
Under a Batch record 1 → multiple lists of detail record 7 and 2 are coming as the data in the flat file is unordered. Please suggest something
hi , this is what i think the structure should be …
header ( single)
—Batch Header( multiple)
-----Detail record 7(multiple times)
--------801(multi)
--------803(multi)
--------815(multi)
--------detail record 2 (single)
--------Batch Trailor (single)
trailor(single)
the only thing concerns me is the combinations of 801 ,803 and 815 which can occur in detail record …so maybe u have to check different combinations and place them accordingly… make all the 801,803 ,815 and batch trailor records not required
HTH
sri
Comments above suggested by Srikanth if you have setup your FFSchema that way it should parse successfully.Can you check regarding 800 loops thing as said.Please try and let us know.
