Manage organization translation files

Creating organization translation files allow you to serve the Sigma users in your organization and consumers of embedded analytics with custom workbook text in their preferred language. Custom workbook text includes any customizable workbook element titles and user-defined strings, including column names from source data.

Admins can manage organization translations by going to Administration > Account > General Settings > Locale or by using the API.

Organization translations are centrally managed translation files that translate commonly-used terms across all workbooks. As a result, workbook owners do not need to translate those common terms in each individual workbook.

Workbook owners can also manage translations for their workbooks on a per-workbook basis. A translated string in a workbook-level translation file takes precedence over a translation of the same string in an organization-level translation file.

For example, if you have hundreds of workbooks in your organization that use the term "Quantity" in data column names, you can upload a translation file for Spanish to specify that "Quantity" should appear as "Cantidad" for any users with their locale set to Spanish. If the owner of an individual workbook does not specify a translation for "Quantity" in their workbook-level translation file, Sigma applies the translation from the organization-level translation file and "Cantidad" will appear. If that workbook owner uploads a different translation for the term, Sigma uses the translation from the workbook-level translation file.

See Manage workbook localization for details on how workbook-level and organization-level translation files interact.

📘

Organization translations affect version-tagged workbooks.

If an organization translation exists for a language, any version-tagged workbooks viewed in that language use the translations. If you want to control how a translation appears in a version-tagged workbook, apply a workbook-level translation file to that workbook.

Supported languages

Sigma supports the following languages and locales:

Requirements

• You must be assigned the Admin account type.

Add a translation file

1. Go to the Administration > Account > General Settings tab.

2. In the Locale section, click Add next to Organization translations.

3. Choose the language for which you would like to create an organization-wide translation file.

📘

To maintain multiple unique translation files for the same language, choose Add custom translations. Adding a custom translation for a language allows you to translate common strings differently for different consumers of embedded dashboards, for example.

4. Click the download icon in the Actions column to download the json file.

5. Open the file with a text editor. The default file contains an example to demonstrate the required syntax.

   JSON

   {
     "This is an example": "This is an example",
     "This is a second example": "This is a second example"
   }
   

6. Replace the example key-value pairs with valid json that represents the common phrases used in workbooks across your organization, and their translated values. For example:

   JSON

   {
      "Date": "Fecha",
      "Quantity": "Cantidad",
      "Cost": "Costs",
      "Price": "Precio",
      "Product Type": "Tipo de Producto"
   }
   

7. Save the json file. Do not change the file name.

8. In the Actions column, click the upload icon to upload the file you just edited.

The translations you provided in the file apply immediately to the corresponding locale version of any workbook in the organization that uses those phrases, provided the workbook does not already provide a translation file that contains different translations for those phrases.

Preview organization translations in a workbook

To preview the results of translations, go to a workbook that uses the phrases you translated.

1. Click Edit.

2. Click the Manage settings icon (), located in the workbook’s left sidebar, to open your workbook’s settings panel.

3. Click Manage locales.

4. Preview the translation:

   1. If a workbook-level translation for the language already exists, click the More icon (), then click Preview to open the workbook with that locale applied.
   2. If no translation exists at the workbook level, click the plus icon (+) next to Available locales to add a new locale, and select the language. Then, click the More icon (), then click Preview to open the workbook with that locale applied.

Update an organization translation file

To update an organization translation file:

1. Go to the Administration > Account > General Settings tab.

2. Click the download icon () in the Actions column to download the json file.

3. Open the file with a text editor.

4. Update the json file to edit existing key-value pairs or add new ones.

5. Save the file. Do not change the file name.

6. In the Actions column, click the upload icon () to upload the file you just edited.

The translations you provided in the file apply immediately to the corresponding locale version of any workbook in the organization that uses those phrases, provided the workbook does not already provide a translation file that contains different translations for those phrases.