community-content

Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 9,648 total)
  • Author
    Posts
  • Hi,

    I’ve done it with “Direct Binding” using “Routing between ports via filters on MessageBox”. It works well.

    As an additional benefit, I can easily reconfigure SAP Port in Admin Console depending on environment I want to use.

    in reply to: Loop, Atomic Transaction #22152

    You shouid consider using the xpath function, along with the position() xpath function.

    Initialize a variable to contain the number of items:

    nbItems = System.Convert.ToInt32(orderMsg, “count(//*[local-name()=’item’ and namespace-uri()=’ns’)”);

    Then, initialize a counter:

    itemcounter = 1;

    In a loop, while itemcounter <= nbItems

    Use another xpath expression to extract the item information. For instance, suppose your item has only one information, the item description:

    itemDesc = xpath(orderMsg, “//*[local-name()=’item’ and namespace-uri()=’ns’ and position() ='” +itemcounter + “‘]”);

    Increment itemcounter before the next loop.

    That way, you won’t have to use an atomic scope.

    Another way would be to treat your order as an envelope and each item as a separate document, disassemble it in a pipeline and process it in a sequential convoy.

    in reply to: Use table looping functoids in chain #22147

    Hi,

    Thank you Amol. I need further clarrification on this.

    My Input file is like below.

    1,2,3,4,5,f,g,h,i,j

    a,b,c,d,e,6,7,8,9,10

    But my output should be like this. (My first record should be split into two. And again those child records to be split into different child records.

    1*2

    3

    4

    5

    f*g

    h

    i

    j

    a*b

    c

    d

    e

    6*7

    8

    9

    10

    So I added a Table looping functoid to spilt the records as

    1,2,3,4,5

    f,g,h,i,j

    And then I sent these record elements to a child table looping functoid to split them. But the child Table looping functoid is giving me the output as

    1*2

    3

    4

    5

    But I am unable to get the second record details.

    Please provide me the suggestion where to add the table value functoid (Beleve it is “Value Mapping functoid”)

    Thank you,

    R.Subha

     

    in reply to: is FTPS Adapter supported? #22145

    You can accomplish this with out creating a extra  shema and also not setting the Root Reference. 

    Please read  the blog about this :

    http://kiranasokan.wordpress.com/2009/04/15/de-batching-polling-records-wcf-oracle-lob-adpter-in-biztalk/

     

     

     

     

    in reply to: Use table looping functoids in chain #22143

    Use table value functiods.

     

    — Amol Pande

    in reply to: Transport Security – NetTcp binding, Authorization help #22142
    in reply to: Inline #22141

    Oh, Tank u man alot.. it works 🙂

    I went for the first option you mentioned since i simplified my example here. This was a part of my map. I use other functoids in the map and this was the last thing to deal with.

    again, Many thanks. i was sitting with this for 3 days now!

    in reply to: Inline #22140

    Oh, Tank u man alot.. it works 🙂

    again, Many thanks. i was sitting with this for 3 days now!

    in reply to: how to split file name #22139

    Hi Nick Thanks for teh reply, how will the C# code look like do you have any code examples for the split function like how to write the code to split.

    Thanks

    in reply to: how to split file name #22137

    Hi Thanks for your reply’s I have a question Cant I do like this

    FileName = “robert_telecom_wired_02102009”;

    FileExtract = FileName.Substring(8,14);

    wont I get “telecom” from the file name. I havent test this procedure I am just asking you does it work.

     

    Thanks

    in reply to: Inline #22136

    I believe that the problem you are having has to do with the context within the “test” expression at the line:

                       <xsl:if test=”//EDE1D01R/EDONR = current()/EDORN”>

    The “current” node in the test expression is not the EDE1D01R node.  You can address this simply by using a variable.  This should work:

           <xsl:for-each select=“//EDE1D01R”>
                    <ED01>
                        <xsl:variable name=“D01Value” select=“ED0NR”/>
                        <ED0NR>
                            <xsl:value-of select=“$D01Value”/>
                        </ED0NR>
                        <xsl:for-each select=“//EDE1D02R[ED0RN = ED0NR]”>
                            <ED02>
                                <Message>
                                    <xsl:value-of select=“current()/EDT60”/>
                                </Message>
                            </ED02>
                        </xsl:for-each>
                    </ED01>
                </xsl:for-each>

    Since it seems that your map is just XSLT you may want to have your map just use an XSLT file rather than hide the XSLT in a functoid.  Then you can use templates which are cleaner and faster.  Here is an example that should work:

    <xsl:stylesheet version=“1.0” xmlns:xsl=“http://www.w3.org/1999/XSL/Transform&#8221;>

        <xsl:template match=“/”>
            <xsl:element name=“root”>
                <xsl:apply-templates select=“//EDE1D01R”/>
            </xsl:element>
        </xsl:template>

        <xsl:template match=“EDE1D01R”>
            <xsl:variable name=“D01Value” select=“ED0NR”/>
            <xsl:element name=“ED01”>
                <xsl:element name=“ED0NR”>
                    <xsl:value-of select=“$D01Value”/>
                </xsl:element>
                <xsl:apply-templates select=“//EDE1D02R[ED0RN = $D01Value]”/>
            </xsl:element>
        </xsl:template>

        <xsl:template match=“EDE1D02R”>
            <xsl:element name=“ED02”>
                <xsl:element name=“Message”>
                    <xsl:value-of select=“EDT60”/>
                </xsl:element>
            </xsl:element>
        </xsl:template>
    </xsl:stylesheet>  


     


    in reply to: Fetch lookup Data from MS CRM 4.0 #22134

    I have jsut finished working out an issue with the Responce.xsd.
    I needed the response GUID ID after creating an Activity. I created a Helper class to parse the string XML into XML. I then
    used the Email_CreateResponce Schema to format to a message.
    I modified the code to fit what i needed. by doing this wi can do Seardches and Fetch using the adapter.
    Thanks to Chris Romp for is project I was able to do the following.

    In Expresion message construct

    Create a verable string in the Orch and fill it.

    strResponseXML = xpath(crmActivityResponce, “string(/*[local-name()=’Response’ and namespace-uri()=’http://schemas.microsoft.com/crm/BizTalkAdapter/Response’%5D/*%5Blocal-name()=’Body&#8217; and namespace-uri()=”]/*[local-name()=’Message’and namespace-uri()=”]/text())”);

    crmActivityEmailCreateResponce = CBN.BizTalk.HelperClasses.XMLString.GetMessageFromXmlString(strResponseXML);

    Created a Class with the following.

    public class XMLString
    {
    public static XmlDocument GetMessageFromXmlString(string XmlString)
    {
    XmlDocument doc = new XmlDocument();
    XmlString = DecodeXmlString(XmlString);
    //XmlString = InsertNamespaceString(XmlString, Namespace);
    doc.LoadXml(XmlString);
    return doc;
    }

    private static string DecodeXmlString(string XmlString)
    {
    XmlString = XmlString.Replace(“<“, “”);
    XmlString = XmlString.Replace(“"”, “\””);
    XmlString = XmlString.Replace(“'”, “\'”);
    XmlString = XmlString.Replace(“&”, “&”);

    return XmlString;
    }

    private static string InsertNamespaceString(string XmlString, string Namespace)
    {
    return InsertNamespaceString(XmlString, Namespace, String.Empty);
    }
    }

    in reply to: Slowly installing VStudio 2008 on Windows Server 2008 #22133

    This was my second attempt at installing VS2008.  Both times I used a clean WinSrv2008 O/S but had the same result.  VS2008 hangs (did so overnight – 16 hours worth).

    The application event log has several errors, like:

         Application Error w/ Event ID: 1000; Keyword: 0x80000000000000

        Faulting application msiexec.exe, version 4.5.6002.16670, time stamp 0x4983d418, faulting module ntdll.dll, version 6.0.6002.16670, time stamp

        0x4983e781, exception code 0x80000003, fault offset 0x000348d8, process id 0xf5c, application start time 0x01c9bc8c731d0340.

    I’m not sure what the problem is, but am leaning towards this being a problem with my WinSrv2008 install.

     

    in reply to: how to split file name #22131

    Hi Thanks for your reply’s I have a question Cant I do like this

    FileName = “robert_telecom_wired_02102009”;

    FileExtract = FileName.Substring(8,14);

    wont I get “telecom” from the file name. I havent test this procedure I am just asking you does it work.

     

    Thanks

Viewing 15 posts - 2,941 through 2,955 (of 9,648 total)