Forum Replies Created
-
AuthorPosts
-
Steven, thanks for taking the time to respond. I have a few follow up Qs to your response. First of all, the link does not work for me, so I have not had a chance to look at the code examples.
Secondly, I am a little unclear as to where you are pointing me. Let me see if I can put your words into my words and to see if I have it correct.
1. convert each line into XML using the disassembler.
2. use custom XSLT within an orchestration to find like header records and group the lines together under the single header record within that single node as you have shown in the \”To:\” output.
3. debatch within the orch using whatever criteria I decide now that I have the doc in a hierarchical format.
4. map to customer specific format using maps in the ports.I think I have a good idea how to do 1, 3, and 4, and hopefully after looking the examples I can figure out the custom XSLT. If not I will ask around here.
Again, Thanks for the assistance.
mikeHello.
I would look at the solution in two parts.
1. Convert the file into XML
2. Map the document as you need itThe first part will be taken care of for you by the flat file disassemble.
The second part can be done in a map on the Receive Port. I think you could use custom XSLT to basically batch your message together inside a new node that you can then debatch in the Orchestration.It would look like this:
CustA, Invoice1, InvoiceDate, Line#1, Part, Qty, Price
CustA, Invoice1, InvoiceDate, Line#2, Part, Qty, Price
CustA, Invoice2, InvoiceDate, Line#1, Part, Qty, Price
CustB, Invoice3, InvoiceDate, Line#1, Part, Qty, PriceTo:
<node>
CustA, Invoice1, InvoiceDate,
Line#1, Part, Qty, Price
Line#2, Part, Qty, Price
</node>
<node>
CustA, Invoice2, InvoiceDate,
Line#1, Part, Qty, Price
Line#2, Part, Qty, Price
</node>All the fields would be in XML of course. This article talks about it a little: http://codebetter.com/blogs/jeff.lynch/articles/category/1169.aspx. I don’t think the XSLT would be very hard. I have some samples of mapping on this site that might help as well.
Best of luck.
Hello.
The best place to set started is on Luke’s blog. He has a quick start guide. It talked you through a 5 day what to do when. It is located here: http://blogs.msdn.com/luke/articles/category/7732.aspx
The best part is the MSDN Demo labs. You do not have to have Biztalk installed at all to run the labs since you user a virtual pc through the web.
Best of luck.
Stephen W. Thomas
-
AuthorPosts