Easy Translator a tool within XRMToolbox

I have written already a post about activating additional translations in Dataverse and usng the OotB Translation functionality, which is not very user friendly at all. A very helpful tool is available - as in many cases - within the XRMToolbox:

1. Decide if you want to load all entities or only the ones from a selected solution. If you select from a solution, you will have to specify the solution in a pop-up window and confirm with OK
2. Next you have to select the tables that you want to include in the export. You can select all tables at once, or have just small exports.
3. Next to the entities options you can define how to handle some additional data e.g.,

• Global choice (Optionset) Labels
• Sitemap custom labels
• Dashboard custom labels
  
  As well as how to handle Entity / Table related translation options:
• Entities
• Attributes
• Picklist Option Labels
• Boolean Option Labels
• Views
• Charts
• Forms
• Form tabs
• Form sections
• Form fields
• Relationships with custom labels
  
  And you can decide if Name and Description of Labels should be exported, only names or only description.

4. And the last option on the right of the screen is to define, if you want to export all languages or only a selected one. I prefer the option to select all.
5. When everything is etup completely, click on Export Translation. Now a dialog pops-up where you have to specify the path and filename to an Excel xlsx file. Once the export is started, a yellow status will show you, which options are getting exported. You can select to open the generated document,once finalized.

Open in Excel

Differently to the OotB translations, the exported Easy Translator file is directly formatted as Excel file. Each option that you have selected is represented as excel tab. Now work in the excel file, but be careful, just to make changes in the columns with the respective language code. Once finished with translations, open Easy translator again.

Import of translations

1. Click on Import translations
2. Specify the path to the translations file
3. Click on Import translations
4. On the right side of the window, the progress is displayed. Be aware, that importing translations can take a lot of time.