7.1 Adding New Language

This topic provides information on Adding New Language.

To add a new language other than the ones provided, follow these steps:

  1. Determine the locale code: Identify the locale code for the new language you want to add. For example, ‘de’ for German.
  2. Insert a new row into the `DIGX_FW_LOCALE` table: Use the following SQL statement to insert a new row into the `DIGX_FW_LOCALE` table:
    ```sql INSERT INTO DIGX_FW_LOCALE (CODE, DESCRIPTION, IS_ENABLED, VALUE, IS_INSTALLED, IS_DEFAULT) VALUES (‘de’, ‘Deutsch’, ‘N’, ‘de’, ‘N’, ‘N’); ```

    Note:

    Replace ‘de’ with the locale code for the new language and ‘Deutsch’ with the description of the language.

Parent topic: Language Pack

7.1 Column Explanation

  1. CODE: The code for the locale.
  2. DESCRIPTION: The description of the locale.
  3. IS_ENABLED: Flag indicating whether the locale is enabled ('Y' or 'N'). A locale can be enabled only if `IS_INSTALLED` is 'Y'.
  4. VALUE: The value of the locale.
  5. IS_INSTALLED: Flag indicating whether the locale is installed (‘Y’ or ‘N’). This flag is automatically set by the Translation Drop generator job for the locale which are supported by OBDX using translation pack.
  6. IS_DEFAULT: Flag indicating whether the locale is the default (‘Y’ or ‘N’). English is the default language. (Note: This is the default fallback locale system will use in case the locale code from the request is not maintained in the database)

7.1 Rules for Locale Flags (No Manual DB changes is expecting from the user)

The following rules apply to the locale flags:
  1. IS_INSTALLED is automatically set by the Translation Drop generator job. It is not recommended to manually set this flag to 'Y' unless you are certain that the necessary SQL scripts have been executed properly.
  2. To enable a locale, set IS_ENABLED to 'Y', but only if IS_INSTALLED is 'Y'.
  3. If IS_ENABLED is 'Y' without IS_INSTALLED being 'Y', the locale will not be displayed on the screen.
  4. To set a locale as default, both IS_ENABLED and IS_INSTALLED must be 'Y'.
  5. At least one locale should be enabled, and one should be set as default.

7.1 Best Practices for Managing Locales (Always Use Locale Maintenance Screen)

  1. Allow the Translation Drop generator job to automatically manage the IS_INSTALLED flag.
  2. Locales will be available for use only after they have been installed (IS_INSTALLED = 'Y'), and this should be done using the Locale Maintenance Screen.
  3. At least one locale is enabled, and one should be set as default. (System Constraints already enforced on the screen).