While designing your project, you not only need to consider your analysis and deliverable requirements, 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 giving users the ability 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 firstname.lastname@example.org for more information. Are used to enable this feature.
In this article
- Language sheet
- Upload language sheet
- Selecting display language
- Display language on analysis
- Display language on 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 need to be displayed in other languages.
You can create the language sheet using 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 consist of all items from the project tree or a specific selection.
You can use the subsequent columns to enter the corresponding label translations.
As a start 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 My Projects area through the browse menu. From here, click on the globe in the project tile, choose the upload option and then and browse to the location of your language sheet file.
After the file uploads, the globe icon turns orange and the options to download or remove the language sheet become available too.
After loading your project, you will notice in the top right-hand corner the language dropdown.
3. Selecting the display language
After loading the project, the project tree-labels display in the default language. The default language can be set using personalization keys. Contact email@example.com for more information.
To change the display language, select the appropriate option on the language dropdown. The labels translate on the fly using the information from the language sheet.
The language selection is sticky throughout your session.
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 on 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 on 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
Project item labels for analysis, stories, and dashboards export to PPT or Excel using the language selected in the language dropdown.