Forum Replies Created
-
AuthorPosts
-
Hi,
From my knowledge, BizTalk 2000 is NOT supported in Windows 2008. If you are upgrading your server OS to Windows 2008, I would strongly recommend upgrading your BizTalk software to version 2009.
July 15, 2010 at 11:42 AM in reply to: Importing msi without bindings – deletes password in send port #25253I realize this is quite a bit later, but I have come across this issue quite a few times and just wrote an article on it>
If you ever get this again, I hope this helps.
July 15, 2010 at 9:40 AM in reply to: How to send and recieve file/data from the one location to another using http adapter #25251Hi.
A little bit more information would be great.
So it looks like a normal copy job for me.
But you can handle it with BTS. You just have to build a receive port and a receive location. In the receive location you told BTS on what kind of file it should work. Than build a receive pipeline for a flat file disassembler and just an send port to transfer the file to another location. If you will have a data mapping between the received and send data, you have to build a map and put this map into the send port.
I hope this helps so far.
best regards
Wolfgang
Hi Sean,
Are you doing any exception handling in your orchestration when sending a request and receiving a response from the SOAP web service? I have a similar BizTalk project in production, that has a Scope shape (with properties Synchronized set to “False” and Transaction Type set to “None”) encapsulating the Logical Send and Receive shapes, and multiple Catch Exception shapes to handle four different Exception Object Types (Time Out, Soap, XLangs, System). To create a Catch Exception shape, highlight the Scope shape, right-click and choose the first option (New Exception Handler). I then use MS Enterprise Library Logging Application to output any errors to a log file, but you could do something different, like sending an email notification…
If you haven’t done so already, you should look into implementing exception handling in your orchestration to trap any errors returned from calling the web service.
Cheers,
Daniel.
Hi,
To accomplish what you want, you should promote the field in your Canonical schema if you know which field will receive a value that will allow you to route the message based on the promoted property, just make sure that the field is unique and not reoccurring; then execute the map in your Receive Port. Please see the following blog for more information (in particular the third post):
http://blog.eliasen.dk/default,month,2007-09.aspx
Daniel.
Hi Daniel.
Thanks again. I checked it aus, but it didn’t worked for me.
So I found another way to do this. I did it with the 3 functoids as well. But I used the “String Right” functoid in this case and it worked very well.
At the end it looks like this in one row: <source field> – – – “String Find” – – – “Substraction” – – – “String Right” – – – <destination field>
Now I get the number or the text I want.
The parameters I used are:
String Find: 1. “Source Field” 2. “-“
Substraction: 1. “Output String Find” 2. “1”
String Right: 1. “Source Field” 2. “Output Substraction”
Thanks again for your help and for the tip how to use the String functoids.
Wolfgang
Hi Abhishek,
Regarding processing PDF files through BizTalk, see my post in the following BizTalkGurus forum thread:
http://www.biztalkgurus.com/forums/p/5012/9439.aspx
To update data in a SQL table, I would suggest using WCF SQL Adapter to accomplish that.
Daniel.
Hi Daniel.
Thanks a lot for your great help!
I will check this out and let you know.
One more question regarding the combination of the functoids. When the source field will be empty (it comes out of a database and shouldn’t be empty but I don’t know, because this field coud be managed manually) will this be a problem for that combination or will the destination field be filled blank?
Thanks again for your help.
best regards
Wolfgang
Finally have done it.
I had to modify quite a few schemas to make it work. And now the Invoice.xml instance document is validated against the StandardBusinessDocumentHeader.xsd schema.
What a pain! The GS1 people weren’t helpful either. What’s the point to produce the standard that is so hard to implement and so much stuff needs to be modified.
I had this same problem. I changes the “persistent connection” property to FALSE and it all worked fine. The problem is that the vendor is not closing the connection after sending the message.
Thanks,
Shaik Dawood
Hi Wolfgang,
To answer your first question, put the value zero (0) in the Min Occurs property of your field in the destination schema, to avoid the warnings.
As of your second question, use a combination of String Find, Size and String Extract functoids to achieve what you want, something like the following diagram:
(String Find) >>>>>>>> |
^ |
^ |
^ |
(Source field) >>>>>>>>> (String Extract) >>>>>>>>> (Destination field)
V |
V |
V |
(Size) >>>>>>>>>>>> |
In the String Find functoid, specify the first parameter as the link from your Source field, and the second parameter as the string that you do the search on (which is the dash character).
In the String Extract functoid, specify the first parameter as the link from your Source field, the second parameter as the link from the String Find functoid, and the third parameter as the link from the Size functoid.
Hope this helps,
Daniel.
July 14, 2010 at 9:38 AM in reply to: Mapping – Delimited Flat file to XML – Group wise Looping – Hierarchial #25237OK. Thanks for the help. Appreciate it.
July 14, 2010 at 8:11 AM in reply to: How to use the SQL receive adpater to fetch the data from the database #25236Hi,
Since you are using BizTalk 2009, is there any reason why you don’t want to use WCF SQL adapter to fetch data from a database? Some other alternatives would be:
1. Wrap your database call in a .NET assembly and call that assembly from a BizTalk orchestration.
2. Wrap your database call in a Web Service (SOAP or WCF) and call that service from a BizTalk orchestration.
July 14, 2010 at 7:59 AM in reply to: How to transform a flat SQL result set into a nested xml structure in BizTalk #25235Thank you guys
I went with the for xml query option and it seems working fine.
Thanks,
Yusuf.
July 13, 2010 at 11:49 PM in reply to: How to use the SQL receive adpater to fetch the data from the database #25231Thanks
I don’t want to use WCF SQL adapter.
Please tell me other solution.
-
AuthorPosts