community-content

Forum Replies Created

Viewing 3 posts - 9,646 through 9,648 (of 9,648 total)
  • Author
    Posts
  • in reply to: help with parsing a flatfile #11995

    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.
    mike

    in reply to: help with parsing a flatfile #11993

    Hello.

    I would look at the solution in two parts.
    1. Convert the file into XML
    2. Map the document as you need it

    The 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, Price

    To:
    <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.

    in reply to: Learning Steps to Biz Talk Server #11990

    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

Viewing 3 posts - 9,646 through 9,648 (of 9,648 total)