Multiple Section Flatfile

Multiple Section Flatfile

I have a flatfile tha looks like this:

HDR.S44444.E00.CFFFF.S000003032006J3/3/2006 7:18:05 PM
C504648LNA4597200511230448510001                             
C52041804187922700000000120000000000LNAINA                                   
            C53010045970053270020000005                    TA        
C5302004597005327002000000532148143334
C504648LNA4597200511230448510001                             
C52041804187922700000000120000000000LNAINA                                   
            C53010045970053270020000005       
END.S44444.E00.CFFFF.S00000000449

I need to parse all like records in order.  For example:
<Root>
    <HDR>
            <C50>
                  <C52>
                       <C53>
                       <C53>
                       <C53>
            <C50>
                  <C52>
                       <C53>
     <END>

The records can be defined by there TAG (50, 52, 53, HDR, and END) using the 
offset.  I can parse a document that has one C50 and C52 record but not 
multiple ones.

Any help will be greatly appreciated.


-- 
Michael Krok
President
Mallard Solutions LLC
Microsoft Certified Partner

date: Mon, 27 Mar 2006 10:26:01 -0800 author: Michael Krok am

Re: Multiple Section Flatfile

Try making a node above it, a parent to hold the repeating C52 elements, 
then create records under that, by creating a <C50> repeating record it 
should work,

brian


"Michael Krok" <TheDuck@newsgroup.nospam> wrote in message 
news:52002FB4-3239-490D-8DC0-18565AB3F24F@microsoft.com...
>I have a flatfile tha looks like this:
>
> HDR.S44444.E00.CFFFF.S000003032006J3/3/2006 7:18:05 PM
> C504648LNA4597200511230448510001
> C52041804187922700000000120000000000LNAINA
>            C53010045970053270020000005                    TA
> C5302004597005327002000000532148143334
> C504648LNA4597200511230448510001
> C52041804187922700000000120000000000LNAINA
>            C53010045970053270020000005
> END.S44444.E00.CFFFF.S00000000449
>
> I need to parse all like records in order.  For example:
> <Root>
>    <HDR>
>            <C50>
>                  <C52>
>                       <C53>
>                       <C53>
>                       <C53>
>            <C50>
>                  <C52>
>                       <C53>
>     <END>
>
> The records can be defined by there TAG (50, 52, 53, HDR, and END) using 
> the
> offset.  I can parse a document that has one C50 and C52 record but not
> multiple ones.
>
> Any help will be greatly appreciated.
>
>
> -- 
> Michael Krok
> President
> Mallard Solutions LLC
> Microsoft Certified Partner

date: Mon, 27 Mar 2006 14:40:11 -0500 author: Brian Kinser

Re: Multiple Section Flatfile

Thanks Brian - doesn't seem to work though.  I can parse a docujment that has 
one instance of C50 with one C52 and multiple C53s.  The problem comes in 
when I get to the second C50.  I get an error that the parse found data while 
looking for END.S which is the tag identifier for the trailer record.  I do 
have the C53, C52, and C50 rfecords as repeating.
I'm stuck
-- 
Michael Krok
President
Mallard Solutions LLC
Microsoft Certified Partner


"Brian Kinser" wrote:

> Try making a node above it, a parent to hold the repeating C52 elements, 
> then create records under that, by creating a <C50> repeating record it 
> should work,
> 
> brian
> 
> 
> "Michael Krok" <TheDuck@newsgroup.nospam> wrote in message 
> news:52002FB4-3239-490D-8DC0-18565AB3F24F@microsoft.com...
> >I have a flatfile tha looks like this:
> >
> > HDR.S44444.E00.CFFFF.S000003032006J3/3/2006 7:18:05 PM
> > C504648LNA4597200511230448510001
> > C52041804187922700000000120000000000LNAINA
> > C53010045970053270020000005                    TA
> > C5302004597005327002000000532148143334
> > C504648LNA4597200511230448510001
> > C52041804187922700000000120000000000LNAINA
> >            C53010045970053270020000005
> > END.S44444.E00.CFFFF.S00000000449
> >
> > I need to parse all like records in order.  For example:
> > <Root>
> >    <HDR>
> >            <C50>
> >                  <C52>
> >                       <C53>
> >                       <C53>
> >                       <C53>
> >            <C50>
> >                  <C52>
> >                       <C53>
> >     <END>
> >
> > The records can be defined by there TAG (50, 52, 53, HDR, and END) using 
> > the
> > offset.  I can parse a document that has one C50 and C52 record but not
> > multiple ones.
> >
> > Any help will be greatly appreciated.
> >
> >
> > -- 
> > Michael Krok
> > President
> > Mallard Solutions LLC
> > Microsoft Certified Partner 
> 
> 
>

date: Mon, 27 Mar 2006 12:23:02 -0800 author: Michael Krok am

Re: Multiple Section Flatfile

{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hi Michael,
\par 
\par This should be able to work if you properly specify C50, C52 and C53 as tag Identifier. You may post the problematic schema file here for us to take a look.
\par 
\par For your reference:
\par 
\par Managing Flat Files in BizTalk 2004 
\par http://geekswithblogs.net/synboogaloo/archive/2005/04/22/37294.aspx
\par 
\par Best regards,
\par 
\par WenJun Zhang
\par Microsoft Online Partner Support
\par 
\par This posting is provided "AS IS" with no warranties, and confers no rights. 
\par 
\par 
\par 
\par }

date: Tue, 28 Mar 2006 10:28:36 GMT author: (WenJun Zhang[msft])

Re: Multiple Section Flatfile

Thanks - I'm going to work on this some more before I post the schema and 
instance file.  Do your suggestions mean to add additional record nodes for 
C52, C53, and C50 specifying TAG Identifier, then repeating records under 
them to hold the field elements?

Thanks for your help
-- 
Michael Krok
President
Mallard Solutions LLC
Microsoft Certified Partner

""WenJun Zhang[msft]"" wrote:

> Hi Michael,
> 
> This should be able to work if you properly specify C50, C52 and C53 as tag 
> Identifier. You may post the problematic schema file here for us to take a 
> look.
> 
> For your reference:
> 
> Managing Flat Files in BizTalk 2004 
> http://geekswithblogs.net/synboogaloo/archive/2005/04/22/37294.aspx
> 
> Best regards,
> 
> WenJun Zhang
> Microsoft Online Partner Support
> 
> This posting is provided "AS IS" with no warranties, and confers no rights

date: Tue, 28 Mar 2006 19:21:02 -0800 author: Michael Krok am

Re: Multiple Section Flatfile

{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hi Michael,
\par 
\par Since the C50, C52, C53 are all known records in the XML, you should be able to use them as Tag Identifiers to allow flat parse identify these fields and retrieve the data.
\par 
\par Thanks.
\par 
\par Best regards,
\par 
\par WenJun Zhang
\par Microsoft Online Partner Support
\par 
\par This posting is provided "AS IS" with no warranties, and confers no rights. 
\par 
\par 
\par 
\par }

date: Thu, 30 Mar 2006 10:15:19 GMT author: (WenJun Zhang[msft])