Integrating Integrators – BizTalk, Windows Azure, Windows Workflow, and Beyond

how to have different serial numbers in one section

BizTalk 2006

This group is for all content related to BizTalk Server 2006. This includes a forum, samples, videos, labs, and tools. Most of the content here also applies to other versions of BizTalk beyond 2006.

how to have different serial numbers in one section

Not Answered This question is not answered

Hi,

I'm new for Biztalk 2006, and have the issue needs to fix.

I received an order and the order detail has same information such as line number, part number. However it has different serial number.  How I can put the serail number in one section?

For instance:

  • <OrderDetail>
  •   <OrderNumber>123</OrderNumber>
  •   <ShipDate>2011-08-09</ShipDate>
  •   <LineNumber>1</LineNumber>
  •   <PartNumber>abc</PartNumber>
  •   <Description>PINK</Description>
  •   <Quantity>2</Quantity>
  •   <SerialNumber>159</SerialNumber>
  •   </OrderDetail>
  • - <OrderDetail>
  •   <OrderNumber>123</OrderNumber>
  •   <ShipDate>2011-08-09</ShipDate>
  •   <LineNumber>1</LineNumber>
  •   <PartNumber>abc</PartNumber>
  •   <Description>PINK</Description>
  •   <Quantity>2</Quantity>
  •   <SerialNumber>252</SerialNumber>
  • </OrderDetail>

Instead,  it should be like:

  • <OrderDetail>
  •   <OrderNumber>123</OrderNumber>
  •   <ShipDate>2011-08-09</ShipDate>
  •   <LineNumber>1</LineNumber>
  •   <PartNumber>abc</PartNumber>
  •   <Description>PINK</Description>
  •   <Quantity>2</Quantity>
  •   <SerialNumber>159</SerialNumber>
  •  <SerialNumber>252</SerialNumber>
  •  </OrderDetail>

However, the quantity might change to 3 or 4 with 3 or 4 serial numbers.  Thanks for the help.

 

 

All Replies
  • Hi,

    You have 2 possibilities:

    1. Create a custom receive pipeline where you recreate the new message in code

    2. Map the incoming message to schema A. Create a schema B that covers you solution file. Create a map where you use custom xslt to map the data from your incoming schema A to your schema B.

    Regards

    ps If you want some sample code, just give me a sign

    • Top 75 Contributor
Page 1 of 1 (2 items)