Knowledge Base
Using a Translation
Browse Common Categories
- Using a Restriction
- Adding a Run Map Task
- Adding an Email Task
- Defining Remaining Options
- Using a Custom Rolling Column
- Using a Translation
- Using a Date Calculation
- Using a Calculation
- Performing the Field Mapping
- Determining Source Grouping
- Defining an Integration Target
- Defining an Integration Source
- Populating the Integration Details
- Using a MultiList Option Lookup
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Lookup
- Using an Activity Party
- Using an Entity Lookup
- Setting up an Integration to Dynamics CRM
- Setting up a Dynamics CRM Connection
- Creating a Dynamics CRM Real-Time Data Source
- Creating a Dynamics CRM Change Data Source
- Using a Relationship
- Creating a Dynamics CRM Bulk Data Source
- Setting up a Dynamics CRM Connection
- Using an Odata Field Lookup
- Creating a Dynamics 365 Business Central Change Data Source
- Creating a Dynamics 365 Business Central Real-time Data Source
- Setting up a Dynamics 365 Business Central Connection
- Connecting to Dynamics 365 Business Central using an OAuth Token
- Using a Page Field Lookup
- Using a Page Key Field Lookup
- Setting up an Integration to Dynamics 365 Business Central
- Creating a Dynamics 365 Business Central Bulk Data Source
- Using an Activity Party
- Using an Entity Lookup
- Connecting to Dynamics 365 Customer Engagement using an OAuth Token
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Setting up an Integration to Dynamics 365 Sales
- Creating a Dynamics 365 Sales Real-Time Data Source
- Creating a Dynamics 365 Sales Change Data Source
- Creating a Dynamics 365 Sales Bulk Data Source
- Setting up a Dynamics 365 Sales Connection
- Using an Entity Reference
- Using a MultiList Option Lookup
- Using an Activity Party
- Using an Entity Lookup
- Setting up an Integration to Dynamics CRM
- Creating a Dynamics CRM Real-Time Data Source
- Creating a Dynamics CRM Change Data Source
- Creating a Dynamics CRM Bulk Data Source
- Setting up a Dynamics CRM Connection
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Reference
Using a Translation
- Under the Integration tab click on the Additional Columns tab.
- Click on the Add Additional Column button.
- The Additional Column window opens.
- Name – enter a name for the column.
- Type – select Translation to display the fields to create a translation.
- 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.
- If a Translation Table needs to be created click on the Manage Translation Tables tab.
- On the New Tab:
- Key – Enter the Key field information
- Description – Enter a description for the table
- Click the 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.
- Translation Tables tab
- Shows a list of Translation Tables that have been created.
- The tables can be deleted by clicking on the Delete icon.
- After the Translation Table is created, the user will need to add the table to the Integration Process by following Step 6 above.
Support