MicroStrategy ONE

Adding a New Language

This scenario deals with adding a new language so it can be supported by MicroStrategy Web products. This is particularly useful when you wish to deploy the application to users whose language is different from the ones supported by default in MicroStrategy Web products. This customization can be accomplished in the following steps:

  1. Generating and adding the MessagesBundles file to MicroStrategy Web products 

  2. Deploying the plug-in provided with MicroStrategy SDK  OR Using the Web Customization Editor to create a plug-in

The MessagesBundles file is used for storing the text strings for MicroStrategy Web products. Each language has its own MessagesBundles file identified by a unique suffix.

The following is an illustrative example for adding the Modern Greek language in MicroStrategy Web products. The assumptions made for this example are:

  1. You are using a Microsoft® Access Database for storing all the translations of the MicroStrategy Web products' interface. The translations for the Modern Greek language reside in a table called WebGreek with the following columns: ID, String_English, String_GreekModern.::

    Using a database for storing all the translations strings is a convenient way for generating the MessagesBundles file. However, you can use your own method to generate the MessagesBundles files as long as the strings follow the syntax: <UniqueID>=Text, where <UniqueID> must be a unique identifier. The default format for MicroStrategy-provided values is mstrWeb.<n> , where <n> is a unique sequential number. To maintain consistency between the uniqueID used in other MessagesBundles files and their corresponding strings, it is recommended that you use a similar format.

  2. The MicroStrategy Web product is deployed on the Windows operating system.

1. Generating and adding the MessagesBundles file to MicroStrategy Web products

This procedure assumes that all the translations of the MicroStrategy Web products' interface reside in a Microsoft Access database table called WebGreek with the following columns: ID, String_English, String_GreekModern.

  1. Create the following columns in the WebGreek table:
    MstrWeb -> Text(50), Equals -> Text(50), Concatenate -> Memo     

  2. Run the following SQL statements:
    UPDATE WebGreek SET WebGreek.MstrWeb = ‘mstrWeb.’;
    UPDATE WebGreek SET WebGreek.Equals = ‘=’;
    UPDATE WebGreek SET Concatenate = MstrWeb & ID & Equals & String_GreekModern;     

  3. Select the column Concatenate in the table and copy it. Paste the results in a file called MessageBundle_el.properties. The file must be saved as UTF-8.:

    Make sure you delete any heading in the text file. Your first string must look like the following: MstrWeb.0=Translated String.
    For other languages, find the two letter language identifier from the Microsoft Developer Network (MSDN) at http://msdn.microsoft.com, and use it to replace ch in the name of the properties file above. 

  1. Create a resources subfolder inside your customization plug-in folder (example: plugins/pluginName/WEB-INF/classes/resources) and add MessagesBundle_el.properties inside this resources subfolder.

2. Deploying the plug-in provided with MicroStrategy SDK

MicroStrategy SDK provides a plug-in (ZIP file) that can simply be extracted to the plugins folder to view the customization in MicroStrategy Web. The following steps guide you in locating the plug-in and deploying it.

  1. Access the plug-in: JSP version or ASP .NET version. 

  2. Extract the plug-in to the plugins subfolder inside the MicroStrategy Web installation folder.   

  3. Launch MicroStrategy Web to view the customization.

2. Using the Web Customization Editor to create a plug-in

MicroStrategy SDK provides a Web Customization Editor that can be used to create a customization plug-in. The following steps guide you in creating the plug-in and deploying it. 

  1. Launch the Web Customization Editor. 

  2. Create a new plug-in and give it a meaningful name. For example: AddingModernGreekLocale. 

  3. Exit the Web Customization Editor. 

  4. Navigate to the WEB-INF/xml folder inside your MicroStrategy Web installation. 

  5. Make a copy of locales.xml and save it in your new customization plug-in folder (plugins/AddingModernGreekLocale/WEB-INF/xml) inside the plugins folder of the MicroStrategy Web installation. Get the locale information for the language you wish to add from the Microsoft Developer Network (MSDN) at http://msdn.microsoft.com.:

    For Modern Greek, the locale id is 1032 and the language identifier is el. 

  6. Add the following line to the copy of locales.xml:
    <locale locale-id="1032" language="el" country="GR" desc="Modern Greek" desc-id="" char-set="UTF-8" char-set-excel="UnicodeLittle"/>     

  7. Save your changes. 

  8. If the Web Customization Editor is closed, launch it again and access your plug-in. 

  9. Click on MicroStrategy Web Configuration inside the Application Settings view to expand the hierarchical tree. The expanded list comprises the different settings that can be modified to perform customizations. 

  10. Click Web Configuration Settings. 

  11. Double-click MicroStrategy Configuration Settings to launch the Global Settings editor. 

  12. Click ... for Locales to point to the edited locales.xml in plugins/AddingModernGreekLocale/WEB-INF/xml inside your MicroStrategy Web installation. 

  13. Save your changes. 

  14. Launch MicroStrategy Web to view the customization. 

See Also