Creating Flat File Schemas

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Creating Flat File Schemas

Viewing 1 reply thread
  • Author
    Posts
    • October 1, 2009 at 4:26 AM #23362
      community-content 
        Hi Everyone,

I'm stuck in creating a Flat File Schema for the following structure

Header
DataLine1
DataLine2
DataLine1
DataLine2
Trailer

I would like to have a XML equivalent like 

<Message>
      <Header />
      <Data>
          <DataLine1 />
          <DataLine2 />
      </Data>
      <Data>
          <DataLine1 />
          <DataLine2 />
      </Data>
    <Trailer />
</Message>

I dont to do Debatching, i need the whole message.
        Based on my finding, i see there is a way of doing this with Choice/Sequence group. I've already created a schema but its not accpeting mutlple DataLine records.

Please Advice. 

Thanks in advance,
Karthick G.
      • October 1, 2009 at 9:24 AM #23366
        community-content

          Hi Karthick,

           

            In your schema, did you make sure that your Record node Data has its Max Occurs property value set to “unbounded” or “*”, and that your underlying element field DataLine also has its Max Occurs property value set to “unbounded” or “*”?

           

             Daniel.

           

          • October 4, 2009 at 8:58 PM #23380
            community-content

              Hi Daniel,

              I’ve tried that and no luck. Currently y schema is like this

              Schema
                   Root — Postfix 0x0d 0x0a
                      HeaderLine – Positional (maxoccurs – 1)
                      DataLines – Infix 0x0d 0x0a (maxoccurs – unbounded)
                          <Sequence Group> (maxoccurs – unbounded)
                                  Line1 (maxoccurs – unbounded)
                                  Line2 (maxoccurs – unbounded)
                      TrailerLine – Positional (maxoccurs – 1)

              If i have only 1 set of data DataLines, its getting validated successfully. But it fails for 2 set of the same. Let me know if you have any suggestions.

              Cheers,
              Karthick G.

        • Author
          Posts
        Viewing 1 reply thread
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.