Language Translation

[ThanveerMangani]

Hello Community,

I am currently working on a translation/localization requirement in our development instance. Specifically, I need to translate a large number of variables for a Record Producer into a target language.

Since I have a very large volume of translation data already compiled in an Excel sheet, doing this manually row-by-row via the UI or sys_translated_text isn't feasible.

I want to know the absolute best practice for importing this bulk data.

Any guidance, step-by-step articles, or transform map configurations you can share would be greatly appreciated!

Thank you in advance!

[Ankur Bawiskar]

@ThanveerMangani 

use transform map, data source and load the data in the target table

this will help to do in bulk

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Hi @ThanveerMangani 

My suggestion would be to first identify which catalog components use which translation tables.

Please go through the details of the five translation tables and refer to this article for additional context:

Refer: Everything you ever wanted to know about the 5 translation tables

https://www.servicenow.com/community/developer-forum/translation-of-table-label-where-is-it-done/m-p...

Based on that, prepare the translated data target-table-wise.

Then, create the Data Source → Transform Map, ensuring that the Coalesce is configured correctly, including the appropriate Choice Action settings.

Most importantly, please ensure that the changes do not impact or overwrite any of the existing translations.