If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Using Restrict function in multiple languages
I have an Outlook addin. In one of the methods, I am using the Restrict
method to restrict the appointment items I am getting from a folder based on the Category name. So the restrict condition goes like this "[Categories] = 'xxxxxx'". It works just fine. But the issue comes when this addin works in a different language OS environment, for example, Korean. Apparently, the property names are translated according to the language of the OS and hence [Categories] may be something else in Korean. Is there a way to solve this issue? How can I code a restrict condition that will work in multiple languages? Is there a way to retrieve the property name and then use it to build the condition? I am giving [Categories] as an example, but I am also using different properties in the condition. Any help would be greatly appreciated. Thanks in advance. (I already posted this in the Office Developer-Addin forum. No one has responded yet. My programming language is C++, but I don't think it matters for this issue) |
Ads |
#2
|
|||
|
|||
Using Restrict function in multiple languages
You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ramesh" wrote in message ... I have an Outlook addin. In one of the methods, I am using the Restrict method to restrict the appointment items I am getting from a folder based on the Category name. So the restrict condition goes like this "[Categories] = 'xxxxxx'". It works just fine. But the issue comes when this addin works in a different language OS environment, for example, Korean. Apparently, the property names are translated according to the language of the OS and hence [Categories] may be something else in Korean. Is there a way to solve this issue? How can I code a restrict condition that will work in multiple languages? Is there a way to retrieve the property name and then use it to build the condition? I am giving [Categories] as an example, but I am also using different properties in the condition. Any help would be greatly appreciated. Thanks in advance. (I already posted this in the Office Developer-Addin forum. No one has responded yet. My programming language is C++, but I don't think it matters for this issue) |
#3
|
|||
|
|||
Using Restrict function in multiple languages
Hi Sue,
Thanks for the reply. I will look into it. But if I remember correctly, AdvancedSearch is available only in certain versions of Outlook (2003 I believe). I want a solution that would work for Outlook 2000 also. Thanks "Sue Mosher [MVP-Outlook]" wrote: You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ramesh" wrote in message ... I have an Outlook addin. In one of the methods, I am using the Restrict method to restrict the appointment items I am getting from a folder based on the Category name. So the restrict condition goes like this "[Categories] = 'xxxxxx'". It works just fine. But the issue comes when this addin works in a different language OS environment, for example, Korean. Apparently, the property names are translated according to the language of the OS and hence [Categories] may be something else in Korean. Is there a way to solve this issue? How can I code a restrict condition that will work in multiple languages? Is there a way to retrieve the property name and then use it to build the condition? I am giving [Categories] as an example, but I am also using different properties in the condition. Any help would be greatly appreciated. Thanks in advance. (I already posted this in the Office Developer-Addin forum. No one has responded yet. My programming language is C++, but I don't think it matters for this issue) |
#4
|
|||
|
|||
Using Restrict function in multiple languages
Am Tue, 28 Feb 2006 08:15:56 -0500 schrieb Sue Mosher [MVP-Outlook]:
I wonder why there´s a problem. For me, on a German system, they work both the English and the German names. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names. |
#5
|
|||
|
|||
Using Restrict function in multiple languages
That's why we always suggest that people include their Outlook version(s) in their initial post.
You have no choice then but to research the localized field names. There's no central source of documentation for that. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ramesh" wrote in message ... Hi Sue, Thanks for the reply. I will look into it. But if I remember correctly, AdvancedSearch is available only in certain versions of Outlook (2003 I believe). I want a solution that would work for Outlook 2000 also. Thanks "Sue Mosher [MVP-Outlook]" wrote: You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ramesh" wrote in message ... I have an Outlook addin. In one of the methods, I am using the Restrict method to restrict the appointment items I am getting from a folder based on the Category name. So the restrict condition goes like this "[Categories] = 'xxxxxx'". It works just fine. But the issue comes when this addin works in a different language OS environment, for example, Korean. Apparently, the property names are translated according to the language of the OS and hence [Categories] may be something else in Korean. Is there a way to solve this issue? How can I code a restrict condition that will work in multiple languages? Is there a way to retrieve the property name and then use it to build the condition? I am giving [Categories] as an example, but I am also using different properties in the condition. Any help would be greatly appreciated. Thanks in advance. (I already posted this in the Office Developer-Addin forum. No one has responded yet. My programming language is C++, but I don't think it matters for this issue) |
#6
|
|||
|
|||
Using Restrict function in multiple languages
Michael,
Would you mind posting the code snippet that you use to do the Restrict, specifically restricting on Categories field? Thanks for your help K. Ramesh "Michael Bauer" wrote: Am Tue, 28 Feb 2006 08:15:56 -0500 schrieb Sue Mosher [MVP-Outlook]: I wonder why there´s a problem. For me, on a German system, they work both the English and the German names. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names. |
#7
|
|||
|
|||
Using Restrict function in multiple languages
Hi Sue,
Thanks again for your reply and sorry for not including the version number in my initial post. I can probably get the localized field names by translating the field names, but there is no guarantee that it will match the field names used by the Outlook API. The only way, that I know off, would be to get the translated strings for the field names (as they are used in the Outlook API) from Microsoft. But I am pretty sure someone must have faced this problem already and must have found a solution. If you know of a way or a workaround, please let me know. Thanks K. Ramesh "Sue Mosher [MVP-Outlook]" wrote: That's why we always suggest that people include their Outlook version(s) in their initial post. You have no choice then but to research the localized field names. There's no central source of documentation for that. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ramesh" wrote in message ... Hi Sue, Thanks for the reply. I will look into it. But if I remember correctly, AdvancedSearch is available only in certain versions of Outlook (2003 I believe). I want a solution that would work for Outlook 2000 also. Thanks "Sue Mosher [MVP-Outlook]" wrote: You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ramesh" wrote in message ... I have an Outlook addin. In one of the methods, I am using the Restrict method to restrict the appointment items I am getting from a folder based on the Category name. So the restrict condition goes like this "[Categories] = 'xxxxxx'". It works just fine. But the issue comes when this addin works in a different language OS environment, for example, Korean. Apparently, the property names are translated according to the language of the OS and hence [Categories] may be something else in Korean. Is there a way to solve this issue? How can I code a restrict condition that will work in multiple languages? Is there a way to retrieve the property name and then use it to build the condition? I am giving [Categories] as an example, but I am also using different properties in the condition. Any help would be greatly appreciated. Thanks in advance. (I already posted this in the Office Developer-Addin forum. No one has responded yet. My programming language is C++, but I don't think it matters for this issue) |
#8
|
|||
|
|||
Using Restrict function in multiple languages
Am Wed, 1 Mar 2006 19:43:26 -0800 schrieb Ramesh:
Interesting, first I wanted to anwser you this: For fields, like Categories, it doesn´t work at all - neither in the localized version nor in English. That is what you can read in the VBA help. Then I tested and in fact: Restrict works on Categories if you use the localized version. But it works only if you do know the exact string, there´s no LIKE operator supported. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- Michael, Would you mind posting the code snippet that you use to do the Restrict, specifically restricting on Categories field? Thanks for your help K. Ramesh "Michael Bauer" wrote: Am Tue, 28 Feb 2006 08:15:56 -0500 schrieb Sue Mosher [MVP-Outlook]: I wonder why there´s a problem. For me, on a German system, they work both the English and the German names. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names. |
#9
|
|||
|
|||
Using Restrict function in multiple languages
Hi Michael,
Thanks for your reply. But I beg to differ on your statement that "it doesn't work at all". Restriction on Categories does work but there are limitations. For my purpose it works well except for this localization issue I am facing. You state that "Restrict works on Categories if you use the localized version". What do you mean? Did you have to use the translated string for "Categories" in your Restrict condition? And if you did, and if it worked for you, how did you find out about the exact translated string as required by the Outlook API? Any help you provide would be of great help. Thanks again for your help K. Ramesh "Michael Bauer" wrote: Am Wed, 1 Mar 2006 19:43:26 -0800 schrieb Ramesh: Interesting, first I wanted to anwser you this: For fields, like Categories, it doesn´t work at all - neither in the localized version nor in English. That is what you can read in the VBA help. Then I tested and in fact: Restrict works on Categories if you use the localized version. But it works only if you do know the exact string, there´s no LIKE operator supported. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- Michael, Would you mind posting the code snippet that you use to do the Restrict, specifically restricting on Categories field? Thanks for your help K. Ramesh "Michael Bauer" wrote: Am Tue, 28 Feb 2006 08:15:56 -0500 schrieb Sue Mosher [MVP-Outlook]: I wonder why there´s a problem. For me, on a German system, they work both the English and the German names. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names. |
#10
|
|||
|
|||
Using Restrict function in multiple languages
Am Thu, 2 Mar 2006 00:07:26 -0800 schrieb Ramesh:
... Restriction on Categories does work but there are limitations. For my purpose it works well except for this localization issue I am facing. Hm, I intended to tell the same, didn´t I? I´m a German, so translating "Categories" into my native language and using that localized name in the Restrict condition isn´t very hard for me :-) As Sue told already, there´s no MS site translating any words for you. If you need the Korean translation only then you could try it with babelfish (http://babelfish.altavista.com/), any other dictionary or just ask friendly a customer. If you don´t know your customers respectively their languages then I wouldn´t use the Restrict function, but search in a loop through the items. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- Hi Michael, Thanks for your reply. But I beg to differ on your statement that "it doesn't work at all". Restriction on Categories does work but there are limitations. For my purpose it works well except for this localization issue I am facing. You state that "Restrict works on Categories if you use the localized version". What do you mean? Did you have to use the translated string for "Categories" in your Restrict condition? And if you did, and if it worked for you, how did you find out about the exact translated string as required by the Outlook API? Any help you provide would be of great help. Thanks again for your help |
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to restrict number of newsgroup headers downloaded | Adrian | Outlook Express | 14 | March 4th 06 07:44 AM |
Using Restrict in Multiple languages | Ramesh | Add-ins for Outlook | 0 | February 28th 06 06:41 AM |
filtering specific languages | seagull | Outlook Express | 1 | February 21st 06 10:38 AM |
How do I restrict access to Outlook in limited account using XP Pro? | Joe K | Outlook - General Queries | 1 | February 8th 06 03:25 AM |
Restrict | jim | Add-ins for Outlook | 2 | January 13th 06 08:14 PM |