KB485395: MicroStrategy objects translation via Repository Translation Wizard

Action

1. Add preferred MS Access database to a new DSN or configure currently existing one (if applicable)  

Note: A new DSN can be also created at the next stage (see point 7 below)

1. Open Repository Translation Wizard and click Next. (in case you have xml file prepared, you can use it to initialize the wizard) 
2. Select project source and enter credentials.
3. To add or modify a given object translation, currently existing translation needs to be exported first. Select Export Translations as a translation action and click Next.
4. In the next window choose a project in which the MSTR object is located and as a next step select a reference language and languages to be exported. (languages for which translation content is supposed to be modified)

1. After clicking Next, select a target(s) of the translation process. Once done, click Next.
2. Choose preferred Microsoft Access DSN and enter credentials (if applicable). Check connection by using Connect button. In this step you can also create a new DSN. 
3. Before moving to next window, specify a name of a table to which the translation strings are to be exported (name should start from ‘RST’)

1. Click Next and specify the level of logging desired, name and location for the log file, plus the name and location of XML file.
2. Click Next, check details and when you are ready click Finish. If additional window pops up, select Yes to create a new table in MS Access. 
3. Go to MS Access, open a database that the table was exported to and double click the table.
4. In the Retranslation column you can find the object’s components names in a reference language selected in point 5. Corresponding names in the language(s) for which translation is to be modified or uploaded can be found in Translation column.

1. Modify the content of Translation column in line with requirements. It can be done directly in the exported table or other way, i.e. by exporting table to Microsoft Excel, applying changes and uploading modified data back to the MS Access table. Once done, go back to Repository Translation Wizard.
2. Click Next, specify a project source and enter credentials. This time choose Import Translations as a translation action.
3. In the next window select the same Data Source Name as before (point 7), click Connect (enter credentials, if applicable) and specify a table from which translation strings will be imported.

1. Click Next, select perform import and provide validation check as feedback.
2. Go to the next window where you need to define level of logging, log and XML files names and paths.
3. Click Next and Finish.
4. You should get a message that translation process has been successful. (If not, check logs to identify the issue)