DOUBT REGARDING GENERATING EDI FILES

Question

Hi.I have a doubt.My edi team gave me some sample files to compare with the EDI files which i am generating.

The thing is the sample files which i got have one sequence for the segements and the file which i am generating after batching is having another sequence of the records.Though its not an issue but its getting tough to compare.

original sample file:

ST~820~348090001
BPR~D~50424.8~C~FWT~~01~021000021~~9102475200~~~01~121000248~~~20111201
TRN~1~0000509945
N1~PR~U.S.  Exploration and Production
N1~RB~WELLS FARGO BANK
N2~*~NATIONAL OILWELL VARCO-DHT
N3~SAN FRANCISCO, CA
N1~C1~NATIONAL OILWELL VARCO~ZZ~4127271500
N2~*~9700 WEST GULF BANK
N3~HOUSTON, TX
REF~ZZ~LTR
SE~12~348090001
ST~820~348090002
BPR~D~110143.74~C~FWT~~01~021000021~~9102475200~~~01~043000096~~~20111201
TRN~1~0000509937
N1~PR~U.S.  Exploration and Production
N1~RB~PNC BANK PNCCUS33
N2~*~MCJUNKIN RED MAN CORPORATION
N3~PITTSBURGH  15265, PA
N1~C1~MCJUNKIN RED MAN CORPORATION~ZZ~1160241
N3~TULSA, OK
REF~ZZ~LTR
SE~11~348090002
ST~820~348090003
BPR~D~36504.25~C~FWT~~01~021000021~~9102475200~~~01~113000609~~~20111201
TRN~1~0000509944
N1~PR~U.S.  Exploration and Production
N1~RB~J P MORGAN CHASE BANK NY-J P MORGAN
N2~*~WEATHERFORD LABORATORIES INC
N3~HOUSTON, TX
N1~C1~WEATHERFORD LABORATORIES INC~ZZ~00103188448
N2~*~P.O. BOX 203696
N3~HOUSTON, TX
REF~ZZ~LTR
SE~12~348090003

file which i am generating

ST~820~348090002
BPR~D~110143.74~C~FWT~~01~021000021~~9102475200~~~01~043000096~~~20111201
TRN~1~0000509937
N1~PR~U.S.  Exploration and Production
N1~RB~PNC BANK PNCCUS33
N2~*~MCJUNKIN RED MAN CORPORATION
N3~PITTSBURGH  15265, PA
N1~C1~MCJUNKIN RED MAN CORPORATION~ZZ~1160241
N3~TULSA, OK
REF~ZZ~LTR
SE~11~348090002

ST~820~348090003
BPR~D~36504.25~C~FWT~~01~021000021~~9102475200~~~01~113000609~~~20111201
TRN~1~0000509944
N1~PR~U.S.  Exploration and Production
N1~RB~J P MORGAN CHASE BANK NY-J P MORGAN
N2~*~WEATHERFORD LABORATORIES INC
N3~HOUSTON, TX
N1~C1~WEATHERFORD LABORATORIES INC~ZZ~00103188448
N2~*~P.O. BOX 203696
N3~HOUSTON, TX
REF~ZZ~LTR
SE~12~348090003

ST~820~348090001
BPR~D~50424.8~C~FWT~~01~021000021~~9102475200~~~01~121000248~~~20111201
TRN~1~0000509945
N1~PR~U.S.  Exploration and Production
N1~RB~WELLS FARGO BANK
N2~*~NATIONAL OILWELL VARCO-DHT
N3~SAN FRANCISCO, CA
N1~C1~NATIONAL OILWELL VARCO~ZZ~4127271500
N2~*~9700 WEST GULF BANK
N3~HOUSTON, TX
REF~ZZ~LTR
SE~12~348090001

The thing is is there any chance that i can generate the files in a sequence as the incoming file.

Thanks

---

sri

Answer 1

The file will be processed in the order it received. Can you tell how do you receive the input message?

As a file and you create the EDI file by aggregating the inputs? If so, you should have custom logic to arrange the order based on the unique id. I see in XSL you have the option to sort the records based on any unique field.

Thanks

---

SKGuru

Answer 2

Hi.I am dropping the flat file in a receive location which has a custom pipeline with flatfile disassembler then i am implemeting amap in the send port and dropping the output to a file location then i am picking the map output from that folder withanother receive location with a custom pipeline with batch marker component and xml dissassembler for batching and thensetting the filter conditions on another send port to drop the batched edi file.Everything is working fine but the thing is i amlosing the order as its specified in the incoming flat file.As its not a big issue since the generated EDI file is correct but i want torectify the issue so that it will be easy for me to compare the generated EDI files with sample EDI files given to me.

Thanks

Answer 3

Hello Sree77,

Hope you resolve your issue, if not give us a chance we will provide solution for your issue.

You can catch me at 248-233-1805