Adding Minority Languages by the Multi-language Solution Plugin

Version

Application Scenario

Major Southeast-Asia languages and EU languages have been added in the Multilingual Solution plugin. Currently, a total of 33 languages (including five built-in languages) are supported.

You can customize the needed minority languages through the steps in this document.

Note:

Only a language option entry is added through this function. The content cannot be automatically translated into the corresponding language. You need to manually add/import the translation.

Procedure

1. Back up platform configurations.

2. Connect the FineDB database to retrieve the FINE_CONF_ENTITY table to be modified.

3. Establish a data entry template to modify the table fields of FINE_CONF_ENTITY through data entry.

4. Modify the table fields and submit the modification to FineDB for storage.

5. Restart the project.

You can obtain the plugin at https://community.finereport.com/market/.

For details about how to install plugins in the designer, see Server Plugin Management.

FineDB Backup

Since the minority language adding operation described in this document is involved with FineDB modification, The normal use of the official system may be affected if the operation is incorrect. Therefore, you must back up data before performing the operation.

Choose System Management > Intelligent O&M > Backup & Restoration > Platform Configuration and click Manual Backup, as shown in the following figure.

Table Field Modification in FINE_CONF_ENTITY

Modify the attribute of the field ServerI18NConfig.allLang in FINE_CONF_ENTITY to configure the language options supported on the platform.

1. Dataset Creation

Click Database Query, select Finedb, and enter the SQL statement SELECT * FROM PUBLIC.FINE_CONF_ENTITY WHERE ID = 'ServerI18NConfig.allLang'.

2. Template Design

Drag the field VALUE to cell B2 and configure a text widget for cell B2, as shown in the following figure.

3. Data Entry Attribute Setting

Choose Template > Data Entry Attibute, click the + icon, select Built-in SQL from the drop-down list, set Submission Type Selection to Smart Submission, Database to Finedb, and Table to FINE_ CONF_ENTITY, add fields and cells, select ID (as the main key), and click OK, as shown in the following figure.

4. Data Entry and Submission

4. Data Entry and Submission

Click Data Entry Preview, enter the needed language (value format: ["Language 1","Language 2","Language 3"]), and click Submit, as shown in the following figure.

Note:

The values of the field VALUE must be consistent with the configuration values in section "Notes".

Take French (fr_FR), German (de_DE), and Thai (th_TH) as examples here. Enter ["fr_FR","de_DE","th_TH"] and click Submit.

5. Restart the project.

Effect Display

Platform Effect

Choose System Management > Language Configuration > More Configurations. You can view that French, German, and Thai are added in the drop-down list. Select the needed language.

Designer Effect

After the three added languages are selected on the platform, they are also added in Template Internationalization of the designer.

1. You are advised to select no more than 10 languages, because too many languages may cause poor display and inconvenient use.

2. The translation length should not exceed twice the length of the Chinese translation, otherwise, display problems may be caused. You are advised to simplify the translation accordingly.

If such display problems occur, you can export the multilingual list (as an Excel file) from the platform, locate the specific key in Excel, and modify the corresponding translation on the platform.

3. Only the following 33 languages are supported.

You can download the template Minority Language Adding Example.cpt.