The Field Translation tab allows you to identify specific values in the source data that can be translated/converted to the value you specify in the Destination Value field. When the data is imported, the identified source values will be converted to the destination values. The destination value will display in the output data.
The Field Translation tab is available when you click the Source Fields tab on the Import Definition form.
See Also:
Field Translation Field Descriptions
Source Value
Identifies the value in the source data that will be translated into the destination value in the output data by the Import Files Service.
Destination Value
Identifies the value that will be reflected in the output data.
Update Date, Updated By
These fields display when the record was created or updated, and the person who created or updated the record.
Click Main Menu > Configuration > Interfaces > Import Definition.
Select an Import Name from the Import Name drop-down menu.
Click the Source Fields tab.
Select the Source Fields record that contains the details you want to view.
Click the Field Translation tab to view the configured values.
Click Main Menu > Configuration > Interfaces > Import Definition.
Select an Import Name from the Import Name drop-down menu.
Click the Source Fields tab.
Select the Source Fields record you want to add a translation record to.
Click the Field Translation tab.
Click Add.
Enter the Source Value you want to translate.
Enter the Destination Value.
Click Save.
Click Main Menu > Configuration > Interfaces > Import Definition.
Select an Import Name from the Import Name drop-down menu.
Click the Source Fields tab.
Select the Source Fields record that contains the translation record you want to modify.
Click the Field Translation tab.
Select the record you want to modify and click Modify.
Modify the record.
Click Save.
Click Main Menu > Configuration > Interfaces > Import Definition.
Select an Import Name from the Import Name drop-down menu.
Click the Source Fields tab.
Select the Source Fields record that contains the translation record you want to delete.
Click the Field Translation tab.
Select the record you want to delete and click Delete.
Click OK to confirm the action.