Parsing a delimited flat file with multiple record types

Parsing a delimited flat file with multiple record types

Post by Deepak » Thu, 14 Aug 2003 21:00:36


can Biztalk handle a flat file with layout as follows

----------------------BEGIN--------------------------------------
ENV|CO-FROM|CO-TO|EDI|ORDERS|20030718|2035
HDR|050131371 |01
ADR|DEL|ABRACADABRA INTERNATIONAL
HTX|
HTX|SPECIAL SHIPPING INVOICE ONLY
HTX|TERMS: ABC
HTX|SHIP VIA: FEDEX
HTX|
LIN|001|4562-8421.000
LIN|002|4534-0047.005
LIN|007|4513-0028.001
HDR|072877321 |01
ADR|DEL|FABRIKAM GMBH
HTX|******************************
HTX|PRIORITY CODE: 2 (CRITICAL)
HTX|******************************
HTX|NO PARTIAL SHIPMENTS !!!!!!!!
HTX|COUNTRY OF ORIGIN: CHINA
HTX|******************************
LIN|006|4534-0067.001
LIN|007|4534-0065.003
EOF
----------------------END----------------------------------------

I'm told this is a variation on the EDIFACT standard, the hierarchical representation of the data above is as follows -

# elements Structure type
1 Envelope (element - ENV)
1..* Order (HDR)
1 Address (ADR)
1..* Comments (HTX)
1..* Order Items (LIN)


Is is possible to design a biztalk schema to process this file ?
one problem i've encountered so far is that the record delimiter for all the records and record types is <CR> - whereas the delimited flat file sample in the SDK uses different delimiters !!!

Any help/pointers is appreciated !!




Sent via http://www.yqcomputer.com/
everything about BizTalk Server
 
 
 

Parsing a delimited flat file with multiple record types

Post by R.Balaj » Fri, 15 Aug 2003 23:01:56

Hi,
I haven't worked on EDIFACT.
But it is possible to develope a custom flat file schema to parse this file.
Take <CR> as record delilmiter and '|' as field delimiter.
As each record has a different source tag identifier, its quiet easy.

Regards,
R.Balaji



representation of the data above is as follows -
the records and record types is <CR> - whereas the delimited flat file
sample in the SDK uses different delimiters !!!

 
 
 

Parsing a delimited flat file with multiple record types

Post by Steve Drak » Sun, 17 Aug 2003 04:49:55

I have done flatfile schemas for files more complex, this file looks ok.



Cheers

Steve


representation of the data above is as follows -
the records and record types is <CR> - whereas the delimited flat file
sample in the SDK uses different delimiters !!!