While designing your project, you not only need to consider your analysis and deliverable requirements, but it is also critical to consider who your audience is.
The multi-language functionality in Harmoni allows you to speak to and engage with a global audience by allowing users to display project items in different languages during their session.
Personalization keys Keys that can be applied at the user, site (all users), or company (all users) level. Contact email@example.com for more information. are used to enable this feature.
In this article
- Language sheet
- Upload language sheet
- Selecting display language
- Display language - Analysis
- Display language - Stories and Dashboards
- Display language on export to PPT or Excel
1. Language sheet
The language sheet identifies the items from the project tree that must be displayed in other languages.
You can create the language sheet in Excel using the following structure:
The first row of the spreadsheet lists the different language options. These options become the selectors on the language dropdown.
The first column of the file should mirror your project tree and contain the list of item labels that need to be translated.
These items can include Axes, Elements, Headers, etc., and must be identical to Harmoni items without any heading/trailing spaces in the cell.
This list can include all items from the project tree or a specific selection.
You can use the subsequent columns to enter the corresponding label translations.
As a starting point for your language sheet, you can export all the labels in your project tree using export label structure.
2. Upload language sheet
The project owner can upload, download, or remove the language sheet.
Translation only applies to the project item labels included in the language sheet.
To upload, you first need to navigate to the PROJECTS area. Click on the 3-dot menu and choose the option to upload the language sheet. Browse to the location of your language sheet file.
After the file uploads, the project tile will display a globe. This icon represents a Multilingual project. The 3-dot menu will now allow downloading and removing the language sheet.
3. Selecting the display language
After loading the project, the project tree displays in the default language. The default language can be set using personalization keys. Contact firstname.lastname@example.org for more information.
Select the appropriate option on the language dropdown to change the display language. The labels translate on the fly using the information from the language sheet.
The language selection is sticky throughout your session.
Data design options are only available when the project tree is displayed in the original language used to create the project.
Data design options (i.e., design menu options) are only available when the project tree is displayed in the original language used to create the project.
Search functionality is available across all languages.
4. Display language - Analysis
When you create an analysis, the labels of the items defined on the language sheet display according to your selection. You can change the language on the fly using the language dropdown.
System variables do not translate as you change languages.
5. Display language - Stories and Dashboards
Stories and dashboards inherit the selected language. The project labels are displayed as per their definition in the language sheet. You can change the language using the language dropdown.
6. Display language on export to PPT and Excel
When exporting to PowerPoint or Excel, project item labels export using the selected language in the language dropdown.