Import DNT Terms with the New Smartling Glossary
While migrating over to the New Smartling Glossary, you may be using this as the perfect time to perform a Glossary "health-check". Putting some attention on what terms should be flagged as DNT should be part of this project.
Do Not Translate, or (DNT) allows you to flag a term for a brand or specific use case that you want to consistently use as seen in the Glossary, and therefore should not be translated.
One of the important changes of the New Smartling Glossary is the update to how the DNT (Do Not Translate) flag works. Instead of the DNT flag being applied to all languages in the Glossary, you can now specify which terms in exactly what languages should not be translated.
The New Smartling Glossary facilitates this action in bulk, in just four easy steps.
STEP ONE: Export the Glossary
If you have been following steps to preparing for the migration to the New Glossary, there is a high chance you already have a recent export of your Glossary locally.
If not, follow steps to exporting an existing Glossary here.
- Excel or CSV is recommended.
- Choose only the languages that have terms that you intend on applying the DNT flag to.
- Next we're going to do some light formatting.
STEP TWO: Format for the Eye
This step isn't essential to the task, but it makes it a lot easier!
- Open your sheet.
- Expand the columns to make it easier to read.
The important columns are:
- D: Do Not Translate Term
- G: Do not Translate Locales
Let's highlight those columns in a color of your preference. Additionally, you could hide columns E and F for now.
Step Three: List the terms and apply the languages
In column D, insert, paste, or type the terms that you do not want translated differently in your content.
In column G, insert, paste, or type the locale ID's of the languages this flag should apply to. If you want to apply the flag to the term across multiple languages, simply separate them with a comma. The aligned term column D will be applied to the languages in the Glossary and flagged with DNT.
When you're finished listing terms in column D, and applicable languages in column G, save the file.
Need help? Here is an example of an exported Glossary in Excel. The terms "pencil" and "Lose it" were updates made to "pen" and "Move it"; both of which are still found in my Glossary under English. The term "cups" is a new addition to the Glossary, hence no additional metadata, which is irrelevant for this exercise.
Step four: Import!
Finally, follow steps to importing an update to an existing Glossary.
- DNT overrides translation. This means that if you happen to update any terms already listed in column D, they will be updated in the languages specified in column G.
- You can add any term to column D, even if it was not already included in your Glossary.
- Do not reorder the columns. It is vital that the Glossary template heading remain the same as they were when they were exported.