Klemen's Blog

kl82slo.github.io

MicroStrategy Translation - PDF Export

08 May 2021

Dificulty ★★★★☆

Microstrategy transactions are separated in multiple categories

INTRO

If you use added transactions you may come across an error where transactions on PDF export are not working correctly. Here is a quide what to do in this situation.

ERROR

  1. Set new language in WEB

  2. Set the ‘Number and Date Format’ to ‘Germany’

  3. Create dossier and use automatic lines like ‘Average’ or ‘Max’.

  4. Export to PDF

  5. PDF will export Average as ‘Durchschnitt’

SOLUTION

  1. Stop PDF Exporter in MicroStrategy Service Manager.

  2. Open location “C:\Program Files (x86)\MicroStrategy\Export”

  3. Copy PDFExporterService.jar file to another location (e.g. folder Document in demo) so that it can be open directly.

  4. Create backup to another location.

  5. Open previusly created copy of PDFExporterService.jar with 7-Zip(right click -> 7-Zip -> Open archive)

  6. Navigate to target folder in 7-Zip: \PDFExporterService.jar\BOOT-INF\classes\descriptors\

  7. Add customer’s MessageBundle file (in this case MessagesBundle_sl)

  8. Add line to locales.xml

    Change the values as peer your locale settings.

     <locale 
             locale-id="1060"
             language="sl"
             country="SL"
             desc="Slovenscina"
             desc-id=""
             char-set="UTF-8"
             char-set-excel="UnicodeLittle"/>
    
  9. Replace the PDFExporterService.jar file in installation folder by the updated one.

  10. Start PDF Exporter in MicroStrategy Service Manager.

SOLUTION 2021.12 UPDATE

Files were moved locales.xml is now in \PDFExporterService.jar\BOOT-INF\classes