Versions Compared

Version Old Version 2 New Version Current
Changes made by

Lakshminarayanan1 S CTOO

Ravikumar Babu CTOO (Unlicensed)

Saved on

Key

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

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 relevant Language ID.

Note
title

...

Adding new font alone

If suppose, you need to just add a new font to the existing font family, perform steps 2, 3 and 5 in the following procedure.


To 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  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 table:

    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. 

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


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



    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 for the report 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 Noto Sans Myanmar font is selected as shown in the following sample screen shot: 
    1. Proceed to click Save to save the configured report.

    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 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.


    Image Added 

  8. Download the generated report in Sigma Application.

    Image Added
    The column labels have been listed in the provided Burmese texts, as shown in the following screen shot:

    Image Added