13 September 2016

Unicode Field Caption on Pages/Reports MS Dynamics NAV

Hi All, 

Microsoft Dynamics supports Unicode data from NAV 2013 on wards. so we can store Unicode data in database. So obviously we can print the same in reports.

But what about Unicode Field Caption on Pages, Reports, etc.

One of the option is by export and import of objects from object designer 

1) Export the object to text file from Object Designer--> Tools--> Translate--> Export

For ex : Below are the few rows of exported  payment terms table.
T3-P2818-L30:Payment Terms
T3-P8629-A1033-L999:Payment Terms
T3-P4960-V1000-P2818-L128:PaymentTermsTranslation
T3-F1-P2818-L128:Code
T3-F1-P8629-A1033-L999:Code
T3-F2-P2818-L128:Due Date Calculation


2) Then open the exported text file and add a new row for the field you want to translate to the needed language.

For ex : To translate Code field caption of Payment Terms Table to Khmer (Cambodian Language) we need to add below row

T3-F1-P8629-A1107-L999:លេខកូដ

Where Language Code : A1107 (Khmer)
Translated String :លេខកូដ

T3-P2818-L30:Payment Terms
T3-P8629-A1033-L999:Payment Terms
T3-P4960-V1000-P2818-L128:PaymentTermsTranslation
T3-F1-P2818-L128:Code
T3-F1-P8629-A1033-L999:Code
T3-F1-P8629-A1107-L999:លេខកូដ
T3-F2-P2818-L128:Due Date Calculation


3) Save the Text file in UTF-8 Format. You cannot import directly this file as it is in UTF-8 format.If the file doesn't contain any unicode data then we could have imported it directly from Object Designer--> Tools--> Translate--> Import.


4) Instead we add these file in Translations folder under NAV Service Folder Directory. If there are multiple instances then under the respective instance folder you add these translations.


5) Restart the service and open NAV client to see the changes.


Other option can be to store the translated caption strings in database itself in some tables. And then add the fields which stores translated string to reports directly.


Thanks & Regards, 
Nandesh Gowda

No comments:

Post a Comment