Versions Compared

Version Old Version 13 New Version 14
Changes made by

Lakshminarayanan1 S CTOO

Lakshminarayanan1 S CTOO

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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:

    Note

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

    Code Block
    languagesql
    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_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.



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





  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.

    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.


     

  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: