Problem building message body based on the numbers of Vendors

Home Page Forums BizTalk 2004 – BizTalk 2010 Problem building message body based on the numbers of Vendors

Viewing 0 reply threads
  • Author
    Posts
    • #23401

      Problem building message body based on the numbers of Vendors

      Hi all,

                (Sorry to repeat this but marked my last post as answered) I have a message which contains a header body & trailer, based on the amount of vendors in my <Body> I would like to split the message into 20 lines per message.

      Ie.

      <Header>

      Line1

      Line 20

      <Trailer>

      I have an expression doing a xpath count of the number of lines in the body and then I go into a loop and count them all. From here I have a decide shape that filters them off based on the amount of vendors if (nLoopCount <= 30)

      Then I build the message in an expression shape as below

      MyVar = MyVar + “<BACSBody>”+sbRemitMsg.ToString()+”</BACSBody>”;

      RemitXmlDoc.LoadXml(strHeaderRemitMsg + MyVar + strTrailerRemitMsg);

      This does some of what I need but if I have 30 vendors return it repeats the below 30 times one after another.

      Do I have to build say the first 30 into an xml document and do the same for the rest of them?

      <Header>

      Line1

      Line 20

      <Trailer>

      <Header>

      Line1

      Line 20

      <Trailer>

      Can anyone tell me where I am going wrong please

      Kind Regards

      Grant

       

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