By default, DotNetNuke contains only a list of US States and Canadian provinces. As a special Service, we provide a SQL script to include German, Austrian and Swiss States in the dropdownl ists in user profile and modules.
Which changes are applied by the script?
- there are 3 general new lists created: German federal states, Austrian federal states and swiss Cantons
- "Germany" is replaced by "Deutschland", "Austria" by "Österreich" and "Switzerland" by "Schweiz"
- * Those 3 countries are moved to the top of the contry list.
- * Existing entries will be adjusted accordingly (as good as possible)
There are two versions of the script, a German one and an international one. Items above marked with * are contained in German version only, which also provides German spelled names for all swiss Kantons, while the international version contains the most commonly name used in that region (either German, French or Italian).
What does users get?
As soon as the usere selects one of the Countries in his profile, the appropriate list of states is automatically loaded into dropdown list.
How to install?
extract the contained file, load and and execute it from Host > SQL menu. Now try it in your own user profile ;)
Download