Problem with Flat File schema

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Problem with Flat File schema

Viewing 1 reply thread
  • Author
    Posts
    • July 12, 2010 at 9:21 AM #25205
      community-content

        Hi,

        I have the following INVOICE flat file Where H is Invoice Header, I is Item and P is posting. 1 Invoice is 1 Header Line and several Item and posting lines. When I create a schema in Flat File Wizard the schema only create an XML instance for the first 4 lines in the file.

        H;00001;811349372;SUPPLIER1
        I;811349372;1232-1;1;1;600.00;
        P;000001;1;811349372;SUPPLIER1
        P;000001;2;811349372;SUPPLIER1
        I;811349372;1232-1;10;4;639.44
        P;000001;3;811349372;SUPPLIER1
        H;000002;811349372;SUPPLIER2
        I;811349372;1232-1;1;1;600.00;
        P;000001;1;811349372;SUPPLIER2
        I;811349372;1232-1;10;4;639.44
        P;000001;3;811349372;SUPPLIER2
        H;000003;811349372;SUPPLIER3
        I;811349372;1232-1;1;1;600.00;
        P;000001;2;811349372;SUPPLIER3
        I;811349372;1232-1;10;4;639.44

        Someone have some tips for me to get further on this problem?

         

        Thanks Dag

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

      • July 12, 2010 at 9:32 AM #25206
        community-content

          Hi Dag:

           

             Modify your flat file schema to do the following:

          1) In the nodes for Header Line and Item, set the Max Occurs property to unbounded and keep the Min Occurs property blank

          2) In the node for Posting, set the the Max Occurs property to unbounded and the Min Occurs property to zero (0).

          3) Add a sequence group node to your schema, under the Root node, set its Max Occurs property to unbounded, and place all the Header, Item and Positing nodes (mentioned above) underneath this sequence group node in this order: Header, Item, Posting.

           

             Hope this works,

           

             Daniel.

           

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