Knowledge Base

Using a Translation

How can we help?

Browse Common Categories

Getting Started with

Using a Translation

  1. Under the Integration tab click on the Additional Columns tab.
  2. Click on the Add Additional Column button.
Add Additional Column Button
  1. The Additional Column window opens.
Additional Column Window
  1. Name – enter a name for the column.
  2. Type – select Translation to display the fields to create a translation.
Additional Column Translation
  1. If a Translation Table already exists enter data in the following fields:
  • Source Column – Select the data source column that contains the data to look up in the translation.
  • Translation Table – Select the Translation Table to be used.
  • If No Data – Select the required action if field data is not contained within the translation table. The options are:
    • Return error if no match – Will stop processing on the document if there is no match in the translation table.
    • Return source data if no match –Will return the source field data if there is no match in the translation table.
    • Return blank if no match – Will return blank if there is no match in the translation table.
    • Return default if no match – Will return a pre-defined default value if there is no match in the translation table.
  • Default Value – If required, enter a default value to be returned by the translation column.
  1. If a Translation Table needs to be created click on the Manage Translation Tables tab.
Manage Translation Tables tab
  1. On the New Tab:
  • Key – Enter the Key field information
  • Description – Enter a description for the table
  • Click the Add Translation button
Add Translation Button
    • From – the source value to be translated.
    • To – the value to be returned and inserted into the destination.
    • Mark the Select checkbox to activate the translation when the Integration Process runs.
  • Click Update to save the translation.
    • After the translation is saved, Edit and Delete icons become active.
  • Delete Translations – click this button to remove selected translation(s).
  • Save Translation Table – click to save the table.
  1. Translation Tables tab
Translation Tables Tab
  • Shows a list of Translation Tables that have been created.
  • The tables can be deleted by clicking on the Delete icon.
  1. After the Translation Table is created, the user will need to add the table to the Integration Process by following Step 6 above.

Email an Expert

Start a Ticket

Chat with Us


Submit a Ticket


Call Us

  • Microsoft Dynamics 365
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2023 SmartConnect|eOneSolutions
Cloud Terms of ServicePrivacy PolicyTerms of ServiceEULA

How can we help?