Forum Replies Created
-
AuthorPosts
-
There is no standard functoid for this.
You can write a custom functoid, or use the scripting functoid.
Biztalk does not try to convert the single byte character to its UTF-8 equivalent. It simply reads the characters as they exist. The British pound sign ASCII character is invalid according to the UTF-8 spec.
The code page setting in the FF schema should match the actual encoding of the incoming document.
Hello Greg,
just to understand this a bit more clearly.The source document is in ASCII and has the pound sign in it.
This character does not fall in the standard 127 character ASCII range.
The FF schema is set to UTF 8 in the schema properties.
So when the Biztalk processes, it tries to convert the single byte character into the equivalent
UTF-8(multibyte) which turns out to be an invalid string character?
kindly assist.
Regards,There are a number of ways to do this:
1. use xpath function: xpath(DBMessage, “xpath to appropriatenode”) = InputMessage(FILE.ReceivedFileName);
2. Make the node in the DB message a distinguished field DBMessage.InputFileName = InputMessage(FILE.ReceivedFileName);
3. Create you own property schema, add a property called InputFileName, promote the appropriate node in the DBMessage to this property: DBMessage(Custom.InputFileName) = InputMessage(FILE.ReceivedFileName);
4. Promote the appropriate node in the DBMessage to the FILE.ReceivedFileName property: DBMessage(FILE.ReceiveFileName) = InputMessage(FILE.ReceivedFileName);
All of these mechanisms require you to create the node in the DBMessage instance.
The last option is probably the best approach, all the work can be done in the pipeline and you do not need an orchestration.
If you put your map in the pipeline (this is the last thing performed before the message is published to the messagebox db) the mapped DBMessage instance will assume all the properties of the input message and the XML Assembler will demote the FILE.ReceivedFileName into the message.
Is this all on one server or multiple servers? What version of SQL Server are you running? What parts of SQL Server were previously installed?
As for SharePoint, seems like a clear message that WSS or MOSS has not been installed on the web server where you are trying to install the adapter …
The processing instruction at the top of the schema file defines the encoding of the schema file itself. It has no effect of any instance document.
These are the rules the FF Disassembler uses to set the encoding on documents:
When disassembling a flat file instance message, the following algorithm is used to determine and preserve encoding information:
- If the “Charset” in the body part is set, use it.
- Otherwise, if the envelope (or document) schema specifies a code page, use it.
- Otherwise, if a byte order mark is present, use it
- Otherwise, assume UTF-8.
I assume the British pound sign is a single byte character in the file and not the multi-byte character required by UTF-8
UTF-8 matches ASCII for the first 127 characters, then uses some escaping characters to specify other characters.I would suggest using the Western-European (1252) code page to maintain the British pound sign.
June 2, 2008 at 11:13 PM in reply to: Using External Assembly for Database Lookups instead BZ DBLookUp functoid #19836Thanks Greg,
sounds exactly what I need to be doing. I have a DTS package that updates the Lookup tables each night. There are minimul changes and reason for having the LookUps was to have no user interaction for any updates. By having a nightly process that updates the cache would be efficiant.
Thanks again.
Rob
I have following scenario,
I want to extract the attachments
from mail, I want to count the number of attachments and their type, for me type
should be .pdf.If number of attachments is greater
than 1 or less than one I have to send an email notification for that I have a
.net component. And if number of attachment equal to 1 then I have to extract
the same and put it to some location and at the same time create one xml file
which contains mail information.amit
June 2, 2008 at 10:26 PM in reply to: Using External Assembly for Database Lookups instead BZ DBLookUp functoid #19834How many codes do you have and how often do they change?
One possibility is to provide a custom data mapper assembly, which extracts the codes from the database and caches them in memory.The codes will always be available in cache, no more expensive database lookups. You can have a cache load/refresh mechanism that would retry if the database is unavaliable. The cache refresh mechanism may just be restarting the Biztalk host, if the rate of change of the codes is very low. Check out the Enterprise Library CacheManager http://msdn.microsoft.com/en-us/library/ms978498.aspx
The assembly would have a static function:
public static string GetERPCode(string tenderCode)This can be referenced inside the map using the scripting functoid/External Assembly.
This would improve performance and remove the occasional database connectivity issue.June 2, 2008 at 9:33 PM in reply to: Using External Assembly for Database Lookups instead BZ DBLookUp functoid #19833Hi Greg,
the files I’m processing can have up to 15,000 rows. We can have up to 1000 Sales transactions in one file. These Transactions can come in many forms and the rows come in different combinations. Depending on the sequence of the rows and their tags. I map the file accordingly. Each transactions can have multiple tenders(Which I do a lookup against them and get the right codes for our ERP system). We have over 150 stores hence 150 files being processed simultaneously.
I can’t see how I could manage that via a SQL adapter. I was thinking more along the lines of having a scripting Functoid call to a External Assembly that does the Database Lookup. that way I could have a few retries in the code. At the end of the day. It would be preferred by the business that I have one corrupt transaction then a whole file not being processed. If there is a way where I do one LookUp at the beginning of my processing and then I’m able to keep it memory for my tender Look Up it might be a solution, but i could not afford to have the whole file fail due to that Look Up failing.
Currenlty the problem occurs probably less than .01% of the times, but enough for finance to log it as a problem. the entire process is very quick and accurate. Apart form the .01%.
If you still believe the SQL adapter approach is best. Could you please give me a little more detail as to how I would do it.
Thanks
Rob
June 2, 2008 at 8:47 PM in reply to: Using External Assembly for Database Lookups instead BZ DBLookUp functoid #19832Have you considered using the SQL Adapter to perform the query and aggregating the results with with original message in a map.
You will get the in-built retry capability of a send port and no external class library to build and deploy.
June 2, 2008 at 11:02 AM in reply to: Biztalk group configuration with sql 2005 on diferent server #19830Ha Neal, thanks, your answer helped me a lot, I tried to test DTC, and figured out that the error was because the DNS, the IP of the biztalk computer was wrong, I changed the IP in the DNS and the group was configured normaly.
Thanks a lot!!!!!
Thiago Di Giorgio
Ruselw,
Thanks for your response. I have tried using DB Lookup with some modifications to the database. I am planning to change that to use SQL adapter.
Meanwhile, can you please tell me how to configure connection information in DB Lookup functoid once it deployed to production?
Thank you
My thought was to install the WSE2 tools, publish orch as WSE2, build a C# to call it. Then republish orch as WCF, then see if C# can still call it.
Even though the WSE2 seemed to install, I still don’t get the (WSE…) promoted properties, nor the “Tools/Publish WSE” option.
Neal
Here’s what I’m installing. I’m afraid I’ll need it for backward compatibility to the other vendor.
Does anybody know if WCF is plug compatible with someone that is calling a WSE2 .asmx service?1) WSE2 (Web Service Enhancement 2) for .NET (a prereq for the next install)
2) The two downloads on this page;
http://www.microsoft.com/biztalk/evaluation/adapter/adapters/wse/default.mspx
Neal
-
AuthorPosts