Page Comparison

From Sigma 19.1 onwards, you You can manage resource bundles for any language in Sigma Studio itself instead of maintaining separate resource bundle property files. However, you need to make an entry in a table in the Canvas Sigma schema for the new language with the correct language ID.

To support add a new language in your application from Sigma 19.1 onwardsSigma application , perform the following steps:

1. Add an entry for the new language in the LANGUAGEMASTER table languagemaster table (in the Canvas Sigma model schema) with the correct relevant Language ID (from LOCALE_KEY_VALUE table). Additionally, specify the text direction as either left-to-right (LTR) or right-to-left (RTL) accordingly. A sample entry for Arabic the Burmese language is shown in the following screen shot:

   Note
   The sample queries for adding the Burmese language in the languagemaster table on the Sigma schema is provided as follows:

   Note
   Implementation developers are not expected to change the flow or the framework components used during rendering of workspaces.

   Image Removed
   Manage the language-specific display names using the Add Labels feature in Sigma Studio. 

   Code Block language sql INSERT INTO `languagemaster` (`APPLICATION_ID`, `LANG_ID`, `LANGUAGE`, `CREATED_DATE`, `CREATED_BY`, `UPDATE_DATE`, `UPDATE_BY`, `DIRECTION`) VALUES ('SIGMA', 'my', 'Burmese', '2013-07-29', 'MAKER', NULL, NULL, 'LTR');

   Image Added
   
   
   

2. In the Sigma Application WAR folder (e.g. D:\Canvas_19\Sigma\forReports\TempXML\fonts), add the appropriate font family file to the fonts folder placed within the Sigma Application WAR folder. In the provided sample, the NotoSans Myanmar-Regular.ttf file is added to the fonts folder placed within the Sigma Application WAR folder.
   
   Image Added
   
   

3. Add an entry for the font family in the ct_lov_master table on the Studio schema. A sample entry for the NotoSans Myanmar-Regular.ttf font family is shown in the following screen shot:

   Note

   The sample queries for adding the NotoSans Myanmanr-Regular font family in the ct_lov_master table on the Studio schema is provided as follows: Code Block INSERT INTO `ct_lov_master` (`APPLICATION_ID`, `LOV_CATEGORY`, `LOV_KEY`, `LOV_VALUE`, `STATUS`, `LOV_PARENT_KEY`, `BUNDLE`, `LOCALE_KEY`, `DEFAULT_VALUE_PRIORITY`, `LOV_CONFIG`, `LST_UPD_DT`) VALUES ('CTSTUDIO', 'FONT_FAMILY', 'Noto Sans Myanmar', 'Noto Sans Myanmar', 'ENABLED', NULL, NULL, NULL, 4, NULL, '2021-12-15 15:22:39');

   
   Image Added
   
   

4. In Sigma Studio, make use of the Add Labels option on the Information Report screen to provide the display names in the added language. In this example, the Burmese language has been selected in the Add Labels (Resource Bundle Entries) screen and the column labels have been specified in the Burmese texts, as shown in the following sample screen shot:
   
   Image Added
   
   
5. In the Report Parameters tab, click the Font Family drop-down list and select the newly added font family. In the provided example, Noto Sans Myanmar is the newly added font family and the mentioned font family is selected as shown in the following sample screen shot: 
   
   Image Added
   
   
6. Access the Sigma Application, select Preferences and choose the Burmese language, as shown in the following screen shot:
   
   Image Added
   
   

7. Access the relevant report (CARD SUMMARY) in the Sigma Application and click Run to generate the report.

   Note
   Since resource bundles are not applied for the entire Sigma Application in the Burmese language, there might be some texts like the display names of columns, which could be missing in the Sigma screen. As the resource bundles for the Burmese language have not applied for the entire Sigma Application, the texts could be missing for some options in the Sigma screen.

   
   Image Added 
   
   

8. Download the generated report in the Sigma Application.
   
   Image Added
   
    The column labels have been listed in the provided Burmese texts, as shown in the following screen shot:
   
   Image Added