- This topic has 2 replies, 1 voice, and was last updated 9 years, 6 months ago by
.
-
Posts
-
-
I have looked thru all the posts and samples with debatching and all are a little of what I need and I cant seem to get it all to work together, we have these files that we call repeaters where in the whole line repeats and alot of the data is the same, so for instance and I will chop this down as much as possible.
<Order>
<Line><ordernumber><orderDate><sender><recpient><linenumber>><buyerpart><vendorpart><qtyordered><price><Line/>
<Line><1><2006-11-06><us><you><1><buyerpart><vendorpart><qtyordered><price><Line/>
<Line><1><2006-11-06><us><you><2><buyerpart><vendorpart><qtyordered><price><Line/>
<Line><2><2006-11-06><us><you><1><buyerpart><vendorpart><qtyordered><price><Line/>
<Line><2><2006-11-06><us><you><2><buyerpart><vendorpart><qtyordered><price><Line/>
<Order/>
Basiclly I need to group all order numbers that are the same to one file, if I can break it up, then I can map it in this structure but if all the orders are together then I can't. I have seen alot of debatching and sorting but its either part of the file or all of it. I have seen where I can suppress nodes and pull only by 1 order number but I cant get the item details to follow. Has anyone had experiance doing this type of debatching? Any pointers would be greatly appreaciated.
Mike
-
I’ve never done exactly what you are asking. I think it could be done using custom XSLT.
If you are not an expert XSLT coder (not many of them), you could always pass the message into a .net component inside an Orchestration. Then, you could use any type of logic you wanted to sort the message and break it up. It wouldn’t perform well though and if the message got to big it would “Out of memory” on you.
-
To debatch this will require a 2 stage process. The first requires grouping the orders and the second will debtach them.
To group Xml records using some arbitary content, requires a custom Xslt. The best technique is Muenchian grouping (google Biztalk and Muenchian for examples).
You can then pass this thru another pipeline to debatch (the output of the first map should be a envelope/document schema) or debatch using a loop inside an orchestration.
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.