Column Translations

This topic is related to the following sections:

About Column Translations

Descriptions for the target system fields captured on reports are maintained within this page. It provides a translation of the target system field names to the corresponding text by Language Code. This offers an opportunity for the client to implement their own translations for target system defined fields as well as allowing for naming of fields for specific reports using global translations.

You can manage translations in two ways: add translations individually through the user interface, or use the bulk import feature to efficiently manage multiple translations at scale. The bulk import capability is particularly useful for large-scale translation updates across multiple languages and reports, allowing you to upload hundreds of records at once with built-in validation and error handling.

The rows of phrases are built from the tables used in mappings and reporting. An asterisk (*) in the Report Name indicates that the column translations apply to all documents on-line or exported that contain the field.

View the following page by navigating to Migrate > Column Translations from the Syniti Migrate Homepage.

The Search icon on the top right allows for a search for a translation.

Add a User Defined Translation

Click the Add icon to create a new translation. Field definitions for adding a Column Translation are listed below:

Field	Definition
Object Type*	Select the type of object for this translation. (Required)
Object Name*	The name of the Report or Enrich table that use this translation. (Required) Note An asterisk (*) applies to every object.
Phrase In*	Existing field name. (Required)
Language*	Language that this column name applies. (values are defined in Administer > Advanced > List Boxes for LANGUAGE CODES) (Required)
Phrase Out	Translated field name. Note If this field is left blank, the system ignores this record; however, it is recommended to enter the translated field name.
Active	Toggle for status of the Translation. Note Defaults as Active.

When finished with edits, click the Save icon to complete.

Importing Translations in Bulk

Download the Template: Access Migrate > Column Translations from the Syniti Migrate Homepage and click the Download Template button. An Excel file will download that shows you the exact format and structure expected.
Prepare Your Data: Open the downloaded template and add new translation records following the template structure. Ensure all required fields are completed and save the file.
Note
Do not alter the column headers or structure of the template.
Upload the File: Return to the Column Translations page and click Import Translations. Upload the prepared Excel file.
Review the Import Summary: After uploading, the Import Translations dialog box displays the Import Summary showing new records, existing records to be skipped, and invalid records with error details.
You can click Download Error Report to view the invalid records and error details, which can be re-imported later.
Click Confirm Import to import successful translation records.

Re-import Fixed Records

Open the downloaded error report.
Fix each error based on the error details provided.
Save the corrected file.
Return to Column Translations and click Import Translations to re-upload.

Edit a Translation

Any Column Translation may be edited as shown by the active Edit icons. The edit process allows for changing fields Phrase Out or Active as the remaining fields are part of the unique key for the translation. Within the Translations page, click the Edit icon on a selected translation record to edit the translation.

The following fields may be altered in translation:

Field	Definition
Phrase Out	Translated field name. Note If this field is left blank, the system ignores this record; however, it is recommended to enter the translated field name.
Active	Toggle to mark the record as Active/Inactive. Note Defaults as Active.

Field

Definition

Phrase Out

Translated field name.

Note
If this field is left blank, the system ignores this record; however, it is recommended to enter the translated field name.

Active

Toggle to mark the record as Active/Inactive.

Note
Defaults as Active.

When finished with edits, click the Save icon to complete.

Delete a User Defined Translation

Should an error occur in a user defined Column Translation, it may be deleted. Most of the fields of the translation make up the key, and therefore cannot be edited once the column translation is saved.

A user defined column translation displays with an active Delete icon. Click on the Delete icon for the translation click Ok to confirm the action.

Use the Delete Unused button in the upper-right corner of the page to delete PAGE object type translations with empty PhraseOut values. This button is useful to clean up placeholder records that have no translated values.

Internationalization Translations

Syniti Migrate allows for use of multiple languages that can be assigned to a user with a default language key. Refer to section Migration User Interface > My Profile for details of setting the user default language key.

Within Column Translations, the international language translations are stored at the Page Object Type level. Several languages are included within the system including English, Spanish, Chinese, French, German, Japanese, Portuguese and Russian. International translations continue to expand in languages for use.

Column Translations: Page level: International Translations

Within User Profile > My Profile section of the system, should the user select a language default other than en-English, the pages translate to the selected language key as shown in the image below once the change is saved and the page is refreshed.

The columns for all grids and lists that have active column translations display the translated values. None of the actual data - fields, tables, or configured values will translate.

Documentation Index