community-content

Forum Replies Created

Viewing 15 posts - 8,686 through 8,700 (of 9,648 total)
  • Author
    Posts
  • in reply to: Sort of XML file to read #14423

    The easiest way to do this is to use a map with a Logical Equals and Value Mapping Flattening functoid.

    For every column in the output schema you will need a Logical Equals (LE) functoid and a Value Mapping (VM) functoid

    Connect the column name attribute to each LE functoid then add a constant Input parameter to this functoid set the value to the column name.
    Connect this LE functoid output to the VM functoid input.
    Connect the Column element to the VM functoid
    Connect the output of the VM functoid to the appropriate element on the output schema.
    Repeat this process for each column on the output schema.

    The order of input parameters on the Value Mapping functoids is important.

    The end effect is
    If column/@name = \”COLUMN1\” then put column/text() in <column1>

    in reply to: Sort of XML file to read #14420

    Hi Greg

    Idea is to receive that XML file as described. When building schema for this xml only attribute for data is \”column name\” which is not usable. After column name comes data which I want to save to SQL server DB

    example :
    <column name=\”ACCESSORY\”>BR6</column>

    I am able to extract ACCESSORY but i am not able to extract the value of that column BR6

    I have idea to use normal updategram with this file to save it into db. I think I have a mapping problem how to map ACCESSORY column’s data BR6 to certain column in update schema.

    Does this help a bit?

    \\R

    Try thes sites
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdk/htm/ebiz_prog_email_ijqb.asp[/url]

    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdk/htm/ebiz_sdk_samples_kcnd.asp[/url]

    Thanks greg.forsythe. I will try to do what you have suggested. I hope it works.

    In case if it didn’t, can you provide with websites that explain such things using diagrams because it is always easier this way.

    Many Thanks

    in reply to: Sort of XML file to read #14422

    I am bit confused about what you are trying to do.

    Are you receiving a flat file, xml file.
    What type of database are you trying to add the data to – SQL, Oracle?

    How are you adding the data – updategram, stored procedure?

    Can you provide more information about the end to end process.

    in reply to: What is an [Biztalk] Accelerator? #13214

    What is an [Biztalk] Accelerator? I have failed to find the definition anywhere. When initiators (like Microsoft) attach special meaning to a term, they don’t even bother to define it and start using it…soon the \”in the know\” crowd spread the buzzword…and the cycles continues….

    The easiest way is to make the CustomerEmail a distinguished field in the schema.
    Then in the expression shape you can access this data like this:
    strVar = message.CustomerEmail;

    Otherwise you can use the xpath function:
    strVar = xpath(message, \”xpath string\”);

    To specify a destination email address on a dynamic port you set the port address Url:
    portname(Microsoft.XLANGs.BaseTypes.Address) = \”mailto:\” + strVar

    in reply to: Error Connecting two orchestrations- Can anyone help #13185

    Make sure you have Biztalk 2004 Sp1 installed.
    The work around for this is dont use a scope shape, or atleast dont initialize any message in the scope shape.

    Also check if your direct binding is working prior to everything else.

    in reply to: Publishing ackowledgeable message #13138

    Well, it really depends on what type of system you are integrating with and what options you have.

    BizTalk offers many different ways to accomplish reliable messaging either through SOAP or Queue adapters or through a correlation response from a vendor.

    In vendor solutions I have done in the past, the vendor sent a response message back for every message we sent them. We used an Orchestration with correlation to track the response messages.

    Hope this helps.

    in reply to: Publishing ackowledgeable message #13136

    Does any one have an answer for this

    in reply to: Biztalk Server 2004 Configuration #13182

    Nope, BizTalk 2004 will not work with SQL 2005 or Visual Studios 2005.

    in reply to: Encrypting userid and password #13177

    Thanx Greg,

    But can you explain this a bit more?

    in reply to: Biztalk Server 2004 Configuration #13180

    Is Biztalk 2004 supported in SQL server 2005? That may be one of reason for the error you are facing

    in reply to: xPath error #13203

    Also the context-position is 1- based
    So you should have something like this:

    [code:1:51ddb39d9a]/*[local-name()=’Sample’ and namespace-uri()=’http://BizTalkOrch.InPutSchema’]/*[local-name()=’Body’ and position()=1 and namespace-uri()=”][/code:1:51ddb39d9a]

    in reply to: BizTalk evaluation #13190

    Microsoft is about the only place I have seen they type of information. Check out the main BizTalk site at http://www.microsoft.com/biztalk/ Although, I have never found there info to be very helpful.

    I know HP has a performance white paper.

Viewing 15 posts - 8,686 through 8,700 (of 9,648 total)