Managing translations in Framework Manager can be a bit of a hustle. This post describes a handy way of keeping track of your translations and avoiding frustrating rework.
The solution is based on a simple Excel file that uses a master translation list that is applied on whatever part of the Framework Models that has to be translated using VLOOKUP.
Using translations in Framework Manager has a couple of challenges attached to it:
- How to stay consistent in the model?
- How to make sure that duplicate items are translated in the same way throughout the model?
- How to avoid rework?
- How to avoid manually typing all the translation in Framework Manager?
- How to keep track of what translations are used for what items?
The solution is to use an Excel file to keep track of all this and manage an item master translation list that is applied to any part of the model.
Step 1: Translation File Setup
The first step is to create an item master translation list containing all the items of the model with their associated translation.
- Export all technical items from the Framework Manager project to a language file.
- Download the Framework Manager Translation File (FrameworkManagerTranslationFile.xlsx).
- Paste the technical items from the export language file in column A in sheet “Lookup Sheet”.
- Fill column B in the sheet “Lookup Sheet” with the business names for each technical name.
Step 2: Using the Translation File for a Business Language
The next step is to take a part of the Framework Model that has to be translated. This process can be repeated several times for different parts of the model or even for different models. Just make sure that a single language is used and kept with all the technical item names. As such it is always possible to revert or update parts of the model when changes are introduced.
- Create a business language in your Framework Manager project.
- Export the items from a certain part of the Framework Manager model with only the language that holds the technical item names.
- Paste the technical item names in column A of the sheet “Import I”, including the language header (e.g. “en”) .
- Extend the VLOOKUP formula in column B in sheet “Import I” to cover all the items in column A.
- Rename column B in sheet “Import I” to the language name of the Business language.
- Save the sheet “Import I” as a *.txt file (make sure it is as unicode.txt).
- Import the sheet in the Framework Manager project and perform the correct mapping.