Xml debatching

Viewing 2 reply threads
  • Author
    Posts
    • #18802

      i have a XML message like below

      <PO xmlns=”http://envelopeprocessing“>
       <ord_req_id>5</ord_req_id>
       <cust_id>0005</cust_id>
       <date>2007-11-12</date>
       <exp_ship>2007-11-25</exp_ship>
       <Orders>
        <Order>
         <OrderID>0000050051</OrderID>
         <comment>Hurry, my lawn is going wild!</comment>
         <Items>
          <Item>
           <Part_id>872-AA</Part_id>
           <Desc>Lawnmower</Desc>
           <Qty>1</Qty>
           <Price>148.95</Price>
           <Comments>Confirm this is electric</Comments>
          </Item>
          <Item>
           <Part_id>926-AA</Part_id>
           <Desc>Baby Monitor</Desc>
           <Qty>1</Qty>
           <Price>39.98</Price>
           <Comments>Confirm this is electric</Comments>
          </Item>
         </Items>
        </Order>
        <Order>
         <OrderID>0000050052</OrderID>
         <comment>Hurry, my lawn is going wild!</comment>
         <Items>
          <Item>
           <Part_id>872-AA</Part_id>
           <Desc>Lawnmower</Desc>
           <Qty>1</Qty>
           <Price>148.95</Price>
           <Comments>Confirm this is electric</Comments>
          </Item>
          <Item>
           <Part_id>926-AA</Part_id>
           <Desc>Baby Monitor</Desc>
           <Qty>1</Qty>
           <Price>39.98</Price>
           <Comments>Confirm this is electric</Comments>
          </Item>
         </Items>
        </Order>
       </Orders>
      </PO>

      i want this message debatch so a particular order should be in seprate file and i want that header information should come in every order.I am using envelope schema for doing this ,the problem is that it seprates order but header information is not present in it.

      Please Help!

      Thanks 

       

    • #18806

      Hi

      I have the exact same Problem :-(. So if you find a Solution, please send it to me. My mail is [email protected].

       

      Thanks

    • #18807

      Following sample from BizTalk SDK does the same. 1) Instead of Flat file use out of box XMLRecieve 2) Promote common header properties (cust_id, date…) to Property Schema. Sample promotes them to BTS.bts_system_properties.

       http://msdn2.microsoft.com/en-us/library/aa578216.aspx

      Let me know how it goes. 

      / VReddy

Viewing 2 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.