Customization of the Alphabet Bar for the CRM Grids


 

Starting with the Update Rollup 15 the Alphabet Bar displayed by the standard CRM Application Grid can be customized to better reflect the needs of the CRM users.

The customization is at organization level meaning that all the users accessing this CRM organization will be presented the same changed Alphabet Bar.

The steps needed to implement a modified Application Bar:

1. Extract and configure the Microsoft.Crm.SE.OrgDBOrgSettingsTool.exe as described in the
KB 2479288 - A new tool that retrieves and changes the Organization level settings in Microsoft Dynamics CRM 4.0 configurations is availableKB 2479288 - A new tool that retrieves and changes the Organization level settings in Microsoft Dynamics CRM 4.0 configurations is available

2. The tool allows either retrieving all customizable settings for a certain CRM organization or modifying those settings by supplying the name of the setting that needs to be modified and the new value. The setting controlling the customization of the Alphabet Bar is called "JumpBarAlphabetOverride".

3. To actually run the tool please open a command prompt in the folder where the tool and the asociated files are stored and execute

Microsoft.CRM.SE.OrgDBOrgSettingsTool.exe Update MyOrganization JumpBarAlphabetOverride "NewAlphabetBarDefinition"

4. To reset the Alphabet Bar to the default definition please run the same command but pass an empty string as definition.
Microsoft.CRM.SE.OrgDBOrgSettingsTool.exe Update MyOrganization JumpBarAlphabetOverride ""

The Alphabet Bar definition


The Alphabet Bar definition is a comma separated list of label and the search values to search for when the label is clicked.

The default definition for the US English CRM version (LCID 1033) is 
(#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)

There cannot be any spaces between character sets.

Example 1
To have the label character displayed as "A" return results for multiple versions of "a" you could replace (A:a) in this string with (A:a|ä|á|æ|ã).
Each character after the ':' separated by a '|' will be searched on for the jump condition.

To update the organization settings you would then need to run the tool with these parameters.

Microsoft.CRM.SE.OrgDBOrgSettingsTool.exe Update MyOrganization JumpBarAlphabetOverride "(#:0|1|2|3|4|5|6|7|8|9),(A:a|ä|á|æ|ã),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)"

Example 2
It is also possible to extend the list of labels and values pairs so if there is a need to have multiple jump points for each letter.
So besides the label character displayed as "A" it is possible to have a range of additional label - search value pairs that cover just a subset of the "A" range.

To achieve this you could replace in the Alphabet Bar defintion the
(A:a)
with
(A:a),(Aa-Am:aa|ab|ac|ad|ae|af|ag|ah|ai|aj|al|am),(An-Az:an|ao|ap|aq|ar|as|at|au|av|ax|ay|az).

In this way you can filter to all the items that are corresponding to "A", only the items in the "Aa-Am" range or only the items in the "An-Az" range.

Microsoft.CRM.SE.OrgDBOrgSettingsTool.exe Update MyOrganization JumpBarAlphabetOverride "(#:0|1|2|3|4|5|6|7|8|9),(A:a),(Aa-Am:aa|ab|ac|ad|ae|af|ag|ah|ai|aj|al|am),(An-Az:an|ao|ap|aq|ar|as|at|au|av|ax|ay|az),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)"

Default language bar definitions for further languages

LCID Definition string
1038 (#:0|1|2|3|4|5|6|7|8|9),(A:a|á),(B:b),(C:c|cs),(D:d|dz|dzs),(E:e|é),(F:f),(G:g|gy),(H:h),(I:i|í),(J:j),(K:k),(L:l|ly),(M:m),(N:n|ny),(O:o|o|ó|ö),(P:p),(Q:q),(R:r),(S:s|sz),(T:t|ty),(U:u|ú|ü|u),(V:v),(W:w),(X:x),(Y:y),(Z:z|zs)
1025 (#:0|1|2|3|4|5|6|7|8|9),(A-C:a|b|c),(D-F:d|e|f),(G-I:g|h|i),(J-N:j|k|l|m|n),(O-S:o|p|q|r|s),(T-Z:t|u|v|w|x|y|z),(أ-ت:أ|ب|ت),(ث-ح:ث|ج|ح),(خ-ذ:خ|د|ذ),(ر-س:ر|ز|س),(ش-ض:ش|ص|ض),(ط-ع:ط|ظ|ع),(غ-ق:غ|ف|ق),(ك-م:ك|ل|م),(ن-ى:ن|هـ|و|ى)
1026 (#:0|1|2|3|4|5|6|7|8|9),(А:а),(Б:б),(В:в),(Г:г),(Д:д),(Е:е),(Ж:ж),(З:з),(И:и),(Й:й),(К:к),(Л:л),(М:м),(Н:н),(О:о),(П:п),(Р:р),(С:с),(Т:т),(У:у),(Ф:ф),(Х:х),(Ц:ц),(Ч:ч),(Ш:ш),(Щ:щ),(Ъ:ъ),(Ь,ь),(Ю:ю),(Я:я)
1029 (#:0|1|2|3|4|5|6|7|8|9),(A:a|á),(B:b),(C:c),(Č:č),(D:d|ď),(E:e|é|ě),(F:f),(G:g),(H:h),(Ch:ch),(I:i|í),(J:j),(K:k),(L:l),(M:m),(N:n|ň),(O:o|ó),(P:p),(Q:q),(R:r),(Ř:ř),(S:s),(Š:š),(T:t|ť),(U-W:u|ů|ú|v|w),(X-Ž:x|y|z|ž)
1030 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z),(Æ:æ),(Ø:ø),(Å:å)
1031 (#:0|1|2|3|4|5|6|7|8|9),(A:a|ä),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o|ö),(P:p),(Q:q),(R:r),(S:s|ß),(T:t),(U:u|ü),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1032 (#:0|1|2|3|4|5|6|7|8|9),(α:α),(β:β),(γ:γ),(δ:δ),(ε:ε),(ζ:ζ),(η:η),(θ:θ),(ι:ι),(κ:κ),(λ:λ),(μ:μ),(ν:ν),(ξ:ξ),(ο:ο),(π:π),(ρ:ρ),(σ:σ),(τ:τ),(υ:υ),(φ:φ),(χ:χ),(ψ:ψ),(ω:ω)
1035 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z),(Å:å),(Ä:ä),(Ö:ö)
1036 (#:0|1|2|3|4|5|6|7|8|9),(A:a|à|â|æ),(B:b),(C:c|ç),(D:d),(E:e|é|è|ê|ë),(F:f),(G:g),(H:h),(I:i|î|ï),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o|ô|ö|œ),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u|ù|û|ü),(V:v),(W:w),(X:x),(Y:y|ÿ),(Z:z)
1037 (#:0|1|2|3|4|5|6|7|8|9),(A-F:a|b|c|d|e|f),(G-L:g|h|i|j|k|l),(M-S:m|n|o|p|q|r|s),(T-Z:t|u|v|w|x|y|z),(א:א),(ב:ב),(ג:ג),(ד:ד),(ה:ה),(ו:ו),(ז:ז),(ח:ח),(ט:ט),(י:י),(כ:כ|ך),(ל:ל),(מ:מ|ם),(נ:נ|ן),(ס:ס),(ע:ע),(פ:פ|ף),(צ:צ|ץ),(ק:ק),(ר:ר),(ש:ש),(ת:ת)
1038 (#:0|1|2|3|4|5|6|7|8|9),(A:a|á),(B:b),(C:c|cs),(D:d|dz|dzs),(E:e|é),(F:f),(G:g|gy),(H:h),(I:i|í),(J:j),(K:k),(L:l|ly),(M:m),(N:n|ny),(O:o|o|ó|ö),(P:p),(Q:q),(R:r),(S:s|sz),(T:t|ty),(U:u|ú|ü|u),(V:v),(W:w),(X:x),(Y:y),(Z:z|zs)
1040 (N.:0|1|2|3|4|5|6|7|8|9),(A:a|à),(B:b),(C:c),(D:d),(E:e|é|è),(F:f),(G:g),(H:h),(I:i|ì),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o|ò),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u|ù),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1041 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1043 (#:0|1|2|3|4|5|6|7|8|9),(A:a|à|á|ä|â),(B:b),(C:c),(D:d),(E:e|è|é|ë|ê),(F:f),(G:g),(H:h),(I:i|i|ì|í|ï),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o|ò|ó|ö|ô),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u|ù|ú|ü|û),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1044 (Nr.:0|1|2|3|4|5|6|7|8|9),(A:a|à|á),(B:b),(C:c),(D:d),(E:e|é|è),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o|ò|ô),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z),(Æ:æ),(Ø:ø),(Å:å|aa)
1045 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(Ą:ą),(B:b),(C:c),(Ć:ć),(D:d),(E:e),(Ę:ę),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(Ł:ł),(M:m),(N:n),(Ń:ń),(O:o),(Ó:ó),(P:p),(Q:q),(R:r),(S:s),(Ś:ś),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z),(Ź:ź),(Ż:ż)
1046 (#:0|1|2|3|4|5|6|7|8|9),(A:a|à|á|â|ã),(B:b),(C:c|ç),(D:d),(E:e|é|ê),(F:f),(G:g),(H:h),(I:i|í),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o|ó|ô|õ),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u|ú|ü),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1048 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1049 (№:0|1|2|3|4|5|6|7|8|9),(А:а),(Б:б),(В:в),(Г:г),(Д:д),(Е:е),(Ж:ж),(З:з),(И:и),(К:к),(Л:л),(М:м),(Н:н),(О:о),(П:п),(Р:р),(С:с),(Т:т),(У:у),(Ф:ф),(Х:х),(Ц:ц),(Ч:ч),(Ш:ш),(Щ:щ),(Э:э),(Ю:ю),(Я:я)
1050 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1051 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1053 #:0|1|2|3|4|5|6|7|8|9),(A:a|à|á),(B:b),(C:c),(D:d),(E:e|é|è),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o|ò|ô),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z),(Å:å),(Ä:ä),(Ö:ö)
1054 (#:0|1|2|3|4|5|6|7|8|9),(ก:ก),(ข:ข),(ฃ:ฃ),(ค:ค),(ฅ:ฅ),(ฆ:ฆ),(ง:ง),(จ:จ),(ฉ:ฉ),(ช:ช),(ซ:ซ),(ฌ:ฌ),(ญ:ญ),(ฎ:ฎ),(ฏ:ฏ),(ฐ:ฐ),(ฑ:ฑ),(ฒ:ฒ),(ณ:ณ),(ด:ด),(ต:ต),(ถ:ถ),(ท:ท),(ธ:ธ),(น:น),(บ:บ),(ป:ป),(ผ:ผ),(ฝ:ฝ),(พ:พ),(ฟ:ฟ),(ภ:ภ),(ม:ม),(ย:ย),(ร:ร),(ล:ล),(ว:ว),(ศ:ศ),(ษ:ษ),(ส:ส),(ห:ห),(ฬ:ฬ),(อ:อ),(ฮ:ฮ),(ฤ:ฤ),(ฦ:ฦ)
1055 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(Ç:ç),(D:d),(E:e),(F:f),(G:g),(Ğ:ğ),(H:h),(I:ı|i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(Ö:ö),(P:p),(Q:q),(R:r),(S:s),(Ş:ş),(T:t),(U:u),(Ü:ü),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1058 (#:0|1|2|3|4|5|6|7|8|9),(А:а),(Б:б),(В:в),(Г:г),(Ґ:ґ),(Д:д),(Е:е),(Є:є),(Ж:ж),(З:з),(И:и),(І:і),(Ї:ї),(Й:й),(К:к),(Л:л),(М:м),(Н:н),(О:о),(П:п),(Р:р),(С:с),(Т:т),(У:у),(Ф:ф),(Х:х),(Ц:ц),(Ч:ч),(Ш:ш),(Щ:щ),(Ь:ь),(Ю:ю),(Я:я)
1060 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)
1061 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(Š:š),(Z:z),(Ž:ž),(T:t),(U:u),(V:v),(W:w),(Õ:õ),(Ä:ä),(Ö:ö),(Ü:ü),(X:x),(Y:y)
1062 (Nr.:0|1|2|3|4|5|6|7|8|9),(A:a),(Ā:ā),(B:b),(C:c),(Č:č),(D:d),(E:e),(Ē:ē),(F:f),(G:g),(Ģ:ģ),(H:h),(I:i),(Ī:ī),(J:j),(K:k),(Ķ:ķ),(L:l),(Ļ:ļ),(M:m),(N:n),(Ņ:ņ),(O:o),(P:p),(R:r),(S:s),(Š:š),(T:t),(U:u),(Ū:ū),(V:v),(Z:z),(Ž:ž)
1063 (#:0|1|2|3|4|5|6|7|8|9),(A:a),(Ą:ą),(B:b),(C:c),(Č:č),(D:d),(E:e),(Ę:ę),(Ė:ė),(F:f),(G:g),(H:h),(I:i),(Į:į),(Y:y),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(R:r),(S:s),(Š:š),(T:t),(U:u),(Ų:ų),(Ū:ū),(V:v),(Z:z),(Ž:ž)
1069 (Zk.:0|1|2|3|4|5|6|7|8|9),(A:a),(B:b),(C:c),(D:d),(E:e),(F:f),(G:g),(H:h),(I:i),(J:j),(K:k),(L:l),(M:m),(N:n),(O:o),(P:p),(Q:q),(R:r),(S:s),(T:t),(U:u),(V:v),(W:w),(X:x),(Y:y),(Z:z)

Thanks,

Danny Feiler

Comments (1)
  1. Kostya Afendikov (http://ms-dynamics-crm.com.ua) says:

    Check my solution

    ms-dynamics-crm.com.ua/…/ms-dynamics-crm-alphabets-sort-2

Comments are closed.

Skip to main content