Forum Replies Created
-
AuthorPosts
-
Thanks Stephen
Hello.
Biztalk 2006 has support for email via a POP3 adapter. In the mean time, BizTalk Bill has a POP3 adapter available now. You can get it here: http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=471392e5-d5c4-4158-a118-8af639a6e16a
I think his adapter has “better” support for attachments. I heard him talking about it today
Some other vendors might have a supported version of an adapter as well.
Hello.
I do not have a lot of experience with EDI.
But, maybe you could do your mapping inside an Orchestration and use a 2nd message on the input of the map with the partner id?
Don’t know if that help you out.
Sorry about the link. It has an “.” at the end. Just remove that and the page opens. Try this one: http://codebetter.com/blogs/jeff.lynch/articles/category/1169.aspx
Close, #2 would be done inside a map on the Receive Port.
XSLT is straight forward but not very user friendly. I like w3schools.com. They cover XSLT well. I think what I was talking about can be done. I’d try to use a xslt:foreach with conditional logic to only create a new node if the invoice number was difference. Might need nested foreach, but don’t remember if that’s allowed.
Take a look at some of my maps samples on the site. I think I have some that us custom XSLT.
Might be some “easier” ways to do it without custom XSLT. Could probably use multiple maps inside an Orchestation. I’d just try to break it down into smaller parts like:
Step 1: Get flat file into xml
Step 2: Get Xml into a nodes based on Invoice Number.
Step 3: Get Xml sorted as needed
Step 4: Remove extra Headers
Step 5 so on.Hope this helps.
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