Adding a New Language in Sigma Application

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 Sigma schema for the new language with the relevant Language ID.

To add a new language in Sigma application, perform the following steps:

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

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

   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');

   
   
   

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

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:

   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:

   INSERT INTO `ct_lov_master` 
   			(`APPLICATION_ID`, 
   			 `LOV_CATEGORY`, 
   			 `LOV_KEY`, 
   			 `LOV_VALUE`, 
   			 `LOV_CLASS`,
   			 `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', 
   			  NULL,
   			 'ENABLED', 
   			  NULL, 
   			  NULL, 
   			  NULL, 
   			  4, 
   			  NULL, 
   			 '2021-12-15 15:22:39');

   
   
   
   

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 for the report have been specified in the Burmese texts, as shown in the following sample screen shot:
   
   
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 Noto Sans Myanmar font is selected as shown in the following sample screen shot: 
   
   1. Proceed to click Save to save the configured report.
   
   
6. Access the Sigma Application, select Preferences and choose the Burmese language, as shown in the following screen shot:
   
   

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

   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.

   
    

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