Optional Detail in Biztalk FlatFile

Optional Detail in Biztalk FlatFile

Sample File :

0                 01CBA       CBA CARDHOLDER PAYMENTS   001666AUTO PAY DR 071197                                       

1062-789  1995201 130000064469JOHNS BOOK SHOP                 5353192380300001  062-001 10011111CBA CR CARD PMNT07001666

1062-789  1995101 130000006533JOSEPHS PRINTING                5353192413800001  062-001 10011111CBA CR CARD PMNT07001666

1062-789  1995201 130000063098JOHNS BOOK SHOP                 5353192460900001  062-001 10011111CBA CR CARD PMNT07001666

2062-789  6555102 530000102188PROPERTY SERVICES               PTMAS01           082-0016884-2222STEVE RYAN      06091710

7999-999            000013410000000000000000134100                        000003           

File Structure :

Type0- Header-Occurrence (1)-Length-120

Type1-Details1-Occurrence(0,*) -Length-121

Type2-Details2-Occurrence(0,*) -Length-121

Type7-Trailer- Occurrence (1) -Length-120

Step1:Create Schema using FlatFile Schema Wizard.

1. Specify delimeter {cr}{lf}.
2. Break records based on positions.
3. Specify Tag Identifier for each  records.

Step2: Set Min and Max Occurrence for Detail1 and Detail2 Record

 Step 3 :Set Parser optimization property of schema to Complex .

 

Step 4 : Validate file without record type2.

0                 01CBA       CBA CARDHOLDER PAYMENTS   001666AUTO PAY DR 071197                                       

1062-789  1995201 130000064469JOHNS BOOK SHOP                 5353192380300001  062-001 10011111CBA CR CARD PMNT07001666

1062-789  1995101 130000006533JOSEPHS PRINTING                5353192413800001  062-001 10011111CBA CR CARD PMNT07001666

1062-789  1995201 130000063098JOHNS BOOK SHOP                 5353192460900001  062-001 10011111CBA CR CARD PMNT07001666

7999-999            000013410000000000000000134100                        000003                                       

The sample code is available for download in Code Gallery: