superset localisation

[Nivraj]

superset localisation how to support different languages and where to configure in helm chart

[dosubot[bot]]

To support different languages in Superset, you can follow these steps:

1. Backend Configuration:

   • Modify superset/config.py to include Babel configuration with BABEL_DEFAULT_LOCALE, BABEL_DEFAULT_FOLDER, and LANGUAGES settings.
   • Add the LANGUAGES variable to your superset_config.py to enable language selection in the UI. For example:

     LANGUAGES = {
         'en': {'flag': 'us', 'name': 'English'},
         'fr': {'flag': 'fr', 'name': 'French'},
         'zh': {'flag': 'cn', 'name': 'Chinese'},
         'LANGUAGE_CODE': {'flag': 'flag_code', 'name': 'Language Name'},
     }

   • Use the following commands to initialize and update translation files:

     pybabel init -i superset/translations/messages.pot -d superset/translations -l LANGUAGE_CODE
     ./scripts/translations/babel_update.sh
     pybabel update -i superset/translations/messages.pot -d superset/translations --ignore-obsolete

   • Replace LANGUAGE_CODE with the code of the language you want to add ^[1][2].

2. Frontend Configuration:

   • Install dependencies and build translations:

     cd superset-frontend/ && npm ci
     npm run build-translation

   • The language picker functionality is available through the UI via superset-frontend/src/features/home/LanguagePicker.tsx ^[1].

For configuring Helm charts to set environment variables for language selection, you can use the extraEnv or extraSecretEnv configuration options. For example:

extraEnv:
  LANG: "en_US.UTF-8"

If the environment variable is sensitive, use extraSecretEnv:

extraSecretEnv:
  LANG: "en_US.UTF-8"

These configurations will ensure that the specified environment variable is available in the Superset pods. You can reference these environment variables from superset_config.py using os.environ.get("VAR") ^[3][4].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[Nivraj]

how to add language localisation to chart and response

[dosubot[bot]]

To add language localization to a chart and its response in Superset, you can use the i18n.ts file to define translations for different languages. Here's an example of how you can add translations for English, French, and Chinese:

import { Locale } from '@superset-ui/core';

const en = {
  'Query Mode': [''],
  Aggregate: [''],
  'Raw Records': [''],
  'Emit Filter Events': [''],
  'Show Cell Bars': [''],
  'page_size.show': ['Show'],
  'page_size.all': ['All'],
  'page_size.entries': ['entries'],
  'table.previous_page': ['Previous'],
  'table.next_page': ['Next'],
  'search.num_records': ['%s record', '%s records...'],
};

const translations: Partial<Record<Locale, typeof en>> = {
  en,
  fr: {
    'Query Mode': [''],
    Aggregate: [''],
    'Raw Records': [''],
    'Emit Filter Events': [''],
    'Show Cell Bars': [''],
    'page_size.show': ['Afficher'],
    'page_size.all': ['tous'],
    'page_size.entries': ['entrées'],
    'table.previous_page': ['Précédent'],
    'table.next_page': ['Suivante'],
    'search.num_records': ['%s enregistrement', '%s enregistrements...'],
  },
  zh: {
    'Query Mode': ['查询模式'],
    Aggregate: ['分组聚合'],
    'Raw Records': ['原始数据'],
    'Emit Filter Events': ['关联看板过滤器'],
    'Show Cell Bars': ['为指标添加条状图背景'],
    'page_size.show': ['每页显示'],
    'page_size.all': ['全部'],
    'page_size.entries': ['条'],
    'table.previous_page': ['上一页'],
    'table.next_page': ['下一页'],
    'search.num_records': ['%s条记录...'],
    'second': ['秒'],
    'Copy of %s': ['%s 的副本'],
  },
  ja: {
    'Check out this chart: ': ['このチャートをチェックしてください:'],
    'Check out this dashboard: ': ['このダッシュボードを確認してください: '],
    'Check to force date partitions to have the same height': ['日付パーティションを強制的に同じ高さにする場合にオンにします。'],
    'Child label position': ['子ラベルの位置'],
    'Choice of [Label] must be present in [Group By]': ['[グループ化]に[ラベル]の選択肢が存在する必要があります。'],
    'Choice of [Point Radius] must be present in [Group By]': ['[グループ化]に[点半径]の選択肢が存在する必要があります。'],
    'Choose File': ['ファイルを選択'],
    'Choose a chart or dashboard not both': ['両方ではなくチャートまたはダッシュボードを選択してください。'],
    'Choose a database...': ['データベースを選択してください...'],
    'Choose a dataset': ['データセットを選択'],
    'Choose a metric for right axis': ['右軸の指標を選択'],
    'Choose a number format': ['数値形式を選択してください'],
    'Choose a source': ['ソースを選択してください'],
    'Choose a source and a target': ['ソースとターゲットを選択してください'],
    'Choose a target': ['ターゲットを選択してください'],
    'Choose chart type': ['グラフの種類を選択してください'],
    'Choose the annotation layer type': ['注釈レイヤーのタイプを選んでください'],
    'Choose the format for legend values': ['凡例値の形式を選択します'],
    'Choose the position of the legend': ['凡例の位置を選択してください'],
    'Choose the source of your annotations': ['注釈のソースを選択する'],
  },
};

export default translations;

This code snippet shows how to define translations for different UI elements and messages in multiple languages. You can extend this by adding more languages or additional translation keys as needed ^[1].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[Nivraj]

how to perform on dashboard and save different language chart name and also sql responses in different language

[dosubot[bot]]

To save and display dashboard elements, including chart names and SQL responses, in different languages in Superset, follow these steps:

1. Enable Multi-Language Support:

   • Modify superset/config.py to include Babel configuration with BABEL_DEFAULT_LOCALE, BABEL_DEFAULT_FOLDER, and LANGUAGES settings. Populate the LANGUAGES dictionary with the desired languages and their respective flags and names ^[1].

2. Translation Files:

   • Use pybabel commands to initialize and update translation files:

     pybabel init -i superset/translations/messages.pot -d superset/translations -l LANGUAGE_CODE
     ./scripts/translations/babel_update.sh
     pybabel update -i superset/translations/messages.pot -d superset/translations --ignore-obsolete

   • Replace LANGUAGE_CODE with the code of the language you want to add ^[1].

3. Frontend Configuration:

   • Install dependencies and build translations:

     cd superset-frontend/ && npm ci
     npm run build-translation

   • Use the i18n.ts file to define translations for different languages. You can add translations for chart names and SQL responses in this file ^[2].

4. Language Picker:

   • Ensure the LANGUAGES dictionary in superset/config.py is not empty and includes the languages you want to support. The language picker functionality is available through the UI via superset-frontend/src/features/home/LanguagePicker.tsx ^[1].

By following these steps, you can configure Superset to save and display dashboard elements, including chart names and SQL responses, in multiple languages.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[Nivraj]

still its unclear, my sql output and widgets are need to be translated in localisation language is it possible ?

[dosubot[bot]]

Yes, it is possible to translate SQL output and widgets into a localized language in Superset. Superset supports localization through a translation system that includes translations for various languages such as French, Chinese, German, Spanish, Italian, Japanese, Korean, Portuguese, Brazilian Portuguese, and Russian. This system allows for the translation of UI elements like "Query Mode", "Aggregate", "Raw Records", and pagination controls, enabling Superset to display these elements in different languages based on the locale settings ^[1][2][3].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}