community-content

Forum Replies Created

Viewing 15 posts - 4,471 through 4,485 (of 9,648 total)
  • Author
    Posts
  • in reply to: Looping problem with mapper #19808

    1. But the tool can do what you want. So why use XSLT instead of the tool?

    2. WIth more experience with the mapper, you get better at recognizing groups of functoids and what they do.

    3. In writing pure XSLT, you have to copy your xpaths from another tool or type them, which is more prone to error.

    4. On complicated schemas like Edifact and X12, you have segments and elements repeatedly reused throughout the document. Without the visual representation from the mapper, it becomes harder to that you have the right node.

    So there are some good reasons to use the mapping tool.

    in reply to: Trackign profile and activityid issue #19807

    Are you sure the messages don’t have anything to uniquely identify themselves?  This doesn’t have to be a single field.  It could be a combination of fields.  If you really need the TPE to assign an arbitrary activity ID that you can accss from an orchestration, then a good way to do it is to have the TPE use the BTS.MessageID or BTS.InterchangeID.  These context properties will be unique, and you can access them from within an orchestration.  Note:  The InterchangeID is only unique for each interchange, so if you are slitting files on the incoming pipeline, you probably want to use something else.

    in reply to: Login to a website to get data #19806

    If you need to navigate through multiple pages in the web site before you download the file, then this gets really tricky.  You could either develop a custom adapter to do it, or you could use a service that sits outside of BizTalk, downloads files from the web site, and then submits the files to BizTalk.  Yikes!  If you have control of the web site, your options are much better.  You could expose  a web service through BizTalk and have the web site call the web service to submit the file.  You could also drop the file to an FTP location and have BizTalk monitor the location. 

     

    – So ur reply seems to be – Application A cannot send messages to Biztalk. It is Biztalk that will pick up the messages from Application A.

    [Mithun]: Correct

    – So the way for it would be – Application A posts the messages (Same code as shown above) to the remote server where Biztalk is running. A public queue on this remote server would be storing these messages sent by Application A. This queue is not a “Biztalk queue” as I said but just a MSMQ queue on the remote server. So Biztalk hasn’t done anything yet … the only thing is that this remote server has Biztalk installed on it.

    [Mithun]: The heart of the Biztalk Server is its SQL Server DB “MessageBox”. It works on the concept of “Publish-Subscription” method, where Receive port picks message from any media (Linke Queue in ur case) using the corresponding adapter and publish it in DB. Similarly Destination application subscribes the DB for those messages and BTS post message to any media using the corresponding adapter. Biztalk has vast list of features, The Solution Architect decides how to use those.

    – So Biztalk does not actually have queues … is that right …. I cannot post to a “biztalk queue” as I initially thought?

    [Mithun] : Yes

    Rest I will reply later.

    Regards,

    in reply to: Constructing File Names at Send Port #19804

     My method is to assign the file name in an orchestration (message assignment shape) using the promoted FILE>ReceivedFileName property of the outgoing message e.g.

    msg(FILE.ReceivedFileName) = “ABC_” + System.DateTime.Today.ToString(“yyyyMMdd”) + “.csv”;

    . You can then use the %SourceFileName% macro in the send port.

    Andy Duke

    [email protected]

    in reply to: Biztalk – Website – Login #19803

    You could try this adapter http://www.codeplex.com/BizTalkScheduledTask

    It has an HttpDownload task that supports Basic authentication

    in reply to: Looping problem with mapper #19801

    Hello

     

    Thanks for the xsl, I got it working now 🙂

    -Woltor

    in reply to: Detecting duplicate nodes in BizTalk #19799

     Depends on what the processing requirements are:

    The simplest approach is to create a validation map based on the Xslt, producing either a Correct_xml_doc or an Incorrect_xml_doc. Put this map into the inbound maps on the receive port from Sharepoint. Have 2 send ports, one subscribing to Correct_xml_doc and sending to correct Sharepoint library and the other subscribing to Incorrect_xml_docs and sending to a different  Sharepoint Library.

    If you require more functionality you can add an one or two orchestrations to process these messages.

    in reply to: DBLookup functiod #19798

     ruselw,

    Thanks for the reply. Help me how can I use SQL adapter in my scenario. I have a sample xml

    <PO>
         <PoNumber>12345</PONumber>
         <Items>
             <Item>It_1</Item>
             <Item>It_2</Item>
             <Item>It_3</Item>
             <Item>It_4</Item>
         <Items>
    <PO>

    from the above xml I have to map to a new schema like below, where Item node repeats for each Item in source xml with Description, OrderDate and Warehousecode need to populated from Database.

    <PO>
        <PONumber>12345</PONumber>
        <Item>
               <Description></Description>
               <ItemNumber></ItemNumber>
              <WareHouseCode></WareHouseCode>
              <OrderDate></OrderDate> 
        </Item>
    </PO>

     Please suggest me how to use sql adapter in this scenario

     

    in reply to: Looping problem with mapper #19797

    Having one tool to do a job is fine, but if that tool can’t do what you want it to do then you need another.

    I find with really complicated maps the Mapper is really hard to comprehend. Given a page of obtuse functoids and lines disappearing off the page, continual scrolling and opening functoids takes forever to untangle a map you have not seen. Some times you just cannot do what you want with the mapper.  

    I use the mapper for simple maps, straight field to field mapping, with a few simple functoids. When a map gets complicated I use Xslt – I find it much faster, more predictable, faster to debug, with more efficient Xslt.

     

     

    in reply to: DBLookup functiod #19796

     You can use the DBLookup functoid or the SQL adapter.  Using the SQL adapter is usally the better approach because you get all the benefits of the adapter framework such as retries, but the DBLookup functoid is good for message enrichment patterns.  For example, if you need to take numerical identifiers in an input file into names in an output file you might want to use the DBLookup functoid.  A drawback to using the functoid is that you need to either hardcode the connection string or write an assembly to dynamically look it up, and then you have to worry about encrypting it, whereas with the adapter approach it would already be encrypted.  You also can’t call stored procedures with the DBLookup functoid, but you can download a free third party functoid package called DBFunktoidz to call stored procedures.

    in reply to: Detecting duplicate nodes in BizTalk #19793

     Greg,

    Thanks for your reply.

    My complete scenario is like this. I receive an xml document from a sharepoint doc. library Recieve_xml_docs. I have to process that in biztalk and a truncated version of it goes to another sharepoint library Correct_xml_docs. While processing it I have to check if there are duplicate items as mentioned above, and if there are any duplicate items, I have to move such xml document to a Incorrect_Xml_docs.

    Can you please tell me what would be the best way to implement this?

     

    in reply to: Looping problem with mapper #19792

    But doesn’t not using a mapping tool defeat the purpose of having a mapping tool?

    Hi Muthun

    Thanks for the reply. However, I am a newbie at Biztalk and so I want to get my ideas really clear here.

    I am not really sure abuot the “purpose” of my requirement. This is because I am entering into a project which is being run by some people and the only thing I know is they plan to use Biztalk to be the middleware platform for message exchange between Application A and Application B … I don’t have more information with me. So I am trying to find out all I can so that when I am actually presented with the problem to be solved, (and I am a programmer, not an administrator who sets up Biztalk) I want to know what path to take purely from a programmer’s point of view. I have been told additionally that the interfaces to Biztalk would be done in Dot Net …. whatever this statement means.

    I am just putting my understanding point by point. Please reply per point … I would really appreciate it.

    – So ur reply seems to be – Application A cannot send messages to Biztalk. It is Biztalk that will pick up the messages from Application A.

    – So the way for it would be – Application A posts the messages (Same code as shown above) to the remote server where Biztalk is running. A public queue on this remote server would be storing these messages sent by Application A. This queue is not a “Biztalk queue” as I said but just a MSMQ queue on the remote server. So Biztalk hasn’t done anything yet … the only thing is that this remote server has Biztalk installed on it.

    – So Biztalk does not actually have queues … is that right …. I cannot post to a “biztalk queue” as I initially thought?

    – Biztalk uses the MSMQ adapter to connect to the queue on the same machine (where my application A has put its message) where Biztalk is installed and pull the message from there. Then it does whatever (I don’t know the details) to change the XML format of the message to what the receiving application wants, and sends it to the receiving application through some mechanism – maybe again the queue mechanism through which the message came in, or something else.

    On the other hand, if Application A (made in C# Dot Net) has to “receive” messages from Biztalk, then this would involve the following –

    – Biztalk Server would receive the message from somewhere (I don’t care where or how) and process it, maybe to change the XML formatting to suit Application A’s requirement. Then it would push the message either into a MSMQ Queue on the local machine (Biztalk Server’s local machine) or into some local folder as a file (XML file maybe). Then it is my application A’s business to either listen to this queue or poll this folder on the Biztalk Server machine and pick up the message.

    – Alternately, to the previous point, Biztalk Server could also send the message to some remote machine’s MSMQ queue (maybe application A’s local machine queue) or save it into some remote machine’s folder (Application A’s local folder) as a XML file. Then it is application A’s business to either listen to this queue or poll this folder on the local machine (Application A’s local machine) and pick up the message.

     Hi Sriram,

    Your post is good enough but I am not very much clear about your purpose. Your first additional question is itself the answer of most of your queries. Since Biztalk works as middleware, therefore it is not in your scope to post ur data in Biztalk. Biztalk itself is responsible to pick the messages from source application and post it at destination location after doing the required transformation of data. In your case, you have posted ur data in local Queue using MSMQ feature of Windows. Now this private queue is configured with the MSMQ of the remote system, where Biztalk has been installed. Simply the public queue of that system pull data from ur system (No role of Biztalk) and ur Biztalk Server has configured with that public queue using MSMQ adapter, which picks data from local queue. Similarly it is configured at destination end with any adapter (depends where Biztalk needs to post the message). It could be SQL Server, SAP, File etc.

    With Regards,

    Mithun

Viewing 15 posts - 4,471 through 4,485 (of 9,648 total)