Forum Replies Created
-
AuthorPosts
-
Hello.
I would use custom XSLT with input parameters of your input message like Name, Project, Day1, Day2, and ext. I think you would have 16 parameters total.
Then, I would use code like this inside a Script Functoid – using XSLT Template:
<xsl:template name=\”yourNameHere\”>
<xsl:param name=\”param1\”/>
<xsl:param name=\”param2\”/>
<xsl:param name=\”param3\”/>
<xsl:param name=\”param4\”/>
<xsl:param name=\”param5\”/>
<xsl:param name=\”param6\”/>
<xsl:element name=\”General\”>
<xsl:element name=\”Name\”><xsl:value-of select=\”$params1\” /></xsl:element>
<xsl:element name=\”Project\”><xsl:value-of select=\”$params2\” /></xsl:element>
<xsl:element name=\”Day\”><xsl:value-of select=\”$params3\” /></xsl:element>
<xsl:element name=\”Time\”><xsl:value-of select=\”$params4\” /></xsl:element>
</xsl:element>
<xsl:element name=\”General\”>
<xsl:element name=\”Name\”><xsl:value-of select=\”$params1\” /></xsl:element>
<xsl:element name=\”Project\”><xsl:value-of select=\”$params2\” /></xsl:element>
<xsl:element name=\”Day\”><xsl:value-of select=\”$params5\” /></xsl:element>
<xsl:element name=\”Time\”><xsl:value-of select=\”$params6\” /></xsl:element>
</xsl:element>
</xsl:template>Note this is not complete.
Hope this helps.
hai friends,
I want to send datas from xml file to sql database with sql adapter and updategrams.
I configured receive port to use file adapter and send port to use sql adapter.
In the receive folder,when I put the file xml ,it vanishes but it does not insert in the sql table.It gives the following error
The adapter failed to transmit message going to send port \”SQL://KAVITHA/bizTest/\”. It will be retransmitted after the retry interval specified for this Send Port. Details:\”HRESULT=\”0x80040e14\” Description=\”Impossible to find stored procedure’s name\”
The adapter \”SQL\” raised an error message. Details \”HRESULT=\”0x80040e14\” Description=\”Impossible to find stored procedure’s name.\”
My question is Does updategrams use stored procedures?
Why it is asking for stored procedures?Can anyone help me?
Thank youOne more thing:
I tested the procedure with SQL Query Analyzer and it worked very well.
Another thing is that I’m working with 2 BizTalk servers. On one server this project works fine, on another it gives me this error.
But I can’t find any differences between the settings of this 2 servers.Hi there,
I am having a problem in mapping in Biztalk using functoidsInput :
<UserInfo>
<Name>Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Mon 3</Day>
<Day>Tue 4</Day>
<Day>Wed 5</Day>
<Day>Thu 6</Day>
<Day>Fri 7</Day>
<Day>Sat 8</Day>
<Day>Sun9</Day>
<Time>8h</Time>
<Time>8h</Time>
<Time>8h</Time>
<Time>8h</Time>
<Time>8h</Time>
<Time>0h</Time>
<Time>0h</Time>
</UserInfo>Output :
<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Mon 3</Day>
<Time>8H</Time></General>
<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Tue 4</Day>
<Time>8H</Time></General>
<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Wed 5</Day>
<Time>8H</Time></General>
<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Thus 6</Day>
<Time>8H</Time></General
<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Fri 7</Day>
<Time>8H</Time></General
<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Sat 8</Day>
<Time>0H</Time></General
<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Sun 9</Day>
<Time>0H</Time></General
Please help me with these and as soon as possible
With Regards,
Vishal DubeAbout the only thing I can think of is to look at the message context properties of your two messages. The one that works and the one that does not work.
You can see these by turning on tracking in HAT on the pipeline.
I’d be looking for something not present or being changes on the Envelope.
Just a thought.
Have to use the .Net classes for the string concatenation.
hai friends,
I want to transfer the datas from Excel to SQL via biztalk server 2004.
can anybody give me a clue to start my project.I defined the xml structure and mapping.
I need the following details
1)How to configure receive and send ports.
2)Which adapters to use
3)Do I need to write any C# codeCan anyone help me?
thanks in advancehai friends,
can anyone suggest me a good book for learning biztalkSorry, I have not been following the full thread
You might have already said this, but how are you initializing the Correlation? On the Send or the Receive? Make sure you are doing so on the Send Shape prior to the Receive.
Also, in the Subscription Viewer was the record you get this data from something link “XLANG\\” or like “Activate”?
October 27, 2005 at 6:21 AM in reply to: using promoted property(Input Schema) in Send Pipeline #12116Hello.
Check out this sample: http://www.biztalkgurus.com/Samples/Property-Promotion-Demotion-Pipeline.html
I think you can promote . demote your value to the File.ReceiveFileName property. Then, use the %SourceFileName% macro.
Don’t know for sure if you can override / set this easily in the Send Pipeline. That might need a custom pipeline component to do that.
Hope this helps.
Hello.
I didn’t have a problem.
Make sure you have the input type set to XML and not the default Generate Instance. Also, you might want to make sure you build the solution first. This was build pre-sp1. I had some problems getting the Test Map option to show up. I have to reopen Visual Studio.
Let me know how this works.
Nishal’s Blog has a great post that walks through a new Biztalk project step by step:
http://biztalkblogs.com/nishil/archive/2005/10/26/57.aspx
It is a great example of a content based routing solution using biztalk.
You can create custom SOAP headers if the header you need is not present. How you do this varies on whether you are using the SOAP adapter, or the WSE adapter. The WSE adapter way is very easy, but tends to cause issues because of namespaces (potentially at least), the SOAP adapter is a little more convoluted, but still relatively easy.
Which adapter are you using?
Working on solution. I don’t fully understand how to read the output from the subscription-viewer, but after posting a message in process1 I found this new row in the subscription-viewer. It seems correct. It show the two properties I have promoted, Name and OrganizationNumber. It also shows the next expected method to be run, namely Update.
[img:37d1706755]http://home.no.net/phpnet/bilder/subscription_viewer.jpg[/img:37d1706755]
I read in this blog (Debugging Routing Failures)
[url]http://blogs.msdn.com/biztalk_core_engine/archive/2004/12/18/325057.aspx[/url]I figure after reading this, that there might be a problem that I actually put the correlation between 1b) and 2a), since 1b) send to a request/response service. What I’m testing now, is to make sure the correlation properties are returned in 1c, thereby changing the correlation to be between 1c) and 2a) instead. I’ll post my results…
Any other Ideas on how to debug this problem ?
Hmm, I’d start by using the subscription viewer (prior to submitting your second request) to see what the state of your subscriptions are.
-
AuthorPosts