Import UI translations from Excel

Level: beginner

You can use Excel import to quickly export and import translations. To do this:

1. Open the Translation section and select the needed strings. Learn more about searching for translation strings: Search translation strings using filters. To export only the strings that need translation, set up a filter first: Filter the strings to export.

2. Obtain a template for the import table. To do this, use the "Export list to file" action in the Translation section. Creatio downloads an .xlsx file with the currently displayed records and columns.

   note

   Columns required for translation are the Key column, as well as source and target language columns.

3. Open the System Designer and click the Data import link. Drag the .xlsx file with translations and click Other. Select the "Translation" object (Fig. 1).

   Fig. 1 Importing the translation file

   

4. Set up duplicate check by the Key column and click Start data import.

5. After importing, click Apply translations in the Translation section.

Filter the strings to export

To export only the strings that need translation and exclude system and technical strings that you do not need to transfer to another environment, set up an advanced filter before the export. Learn more about advanced filters: Filters.

1. Switch to the advanced filter mode. To do this, click Filters/folders → Switch to advanced mode.

2. Add a condition by the target language column. For example, if you export Spanish translations, add a condition that the Spanish (Spain) column is filled in. As a result, the list does not display strings that have no value in this language.

3. Add conditions that exclude technical strings. For each of the following values, add a condition that the Key column does not contain the value. Make sure the conditions are combined with "AND" so that Creatio excludes strings whose key contains any of the values.

   • BaseElement
   • Parameters
   • SysCspDirectiveName
   • SysPackage
   • SsoSettings
   • %process%lane%caption%
   • externalaccess
   • SysSettings
   • Lookup.Name
   • Data:Feature
   • SysAdminOperation
   • Lane1
   • SysPluginPackage
   • SysProcessDisabled

4. Exclude strings with a process name placeholder. Add a condition that the English (United States) column does not contain "[#Process name#]".

5. Apply the filter. To do this, click Apply.

6. Save the filter (optional). Click Save to reuse the filter later.

As a result, the list displays only the strings to export. Export and import them as described above, starting from step 2.

---

See also

Determine translation string context by the "Key" column