The Import Mapping Translation (“IMT”) is a function that allows for the definition of translated values (“From” and “To”) at a field level when using an Import Mapping Definition (“IMD”). These defined translations are executed in real-time during the import process.
For example, if your client sends you a field for the Name where it’s formatted as "Last Name/First Name”
Where to find the Import Mapping Translation Table and where it is used.
Step 1: Click on to open the Import Mapping Translation Table.
The following screen will open:
Step 2: To add a new translation, click on the button. The following screen will open:
- Code: Enter an alphanumeric code for your IMT
- Description: Enter a description for this IMT
Step 3: Click on the button to add a new rule to this IMT. A row will be enabled, indicated by the yellow highlights, to enter the first translation for this rule. Under the “From” column enter the value that the system will search for in the field where the translation will be assigned. Under the “To” column enter the value that will replace the characters entered under the “From” field. In both cases, the characters need to be enclosed by percentage signs (“%”).
For instance, if the “Name” field in an inbound file was presented in a “LAST NAME / FIRST NAME” format (“slash” separating) and we wished to replace the slash (“/”) with a comma (“,”), then in the “From” column enter “%/%” (percent sign – no spaces – slash – no spaces – percent sign). Under the “To” column enter “%,%” (percent sign – no spaces – comma – no spaces – percent sign)
Make sure you include at the end of your IMT a translation with From “%%” and To “%%”, this is a catch all in cases there are no slashes on the name, such as name of business.
The preceding example would look like this:
Step 7: To save the IMT, click on the button
Step 8: Click Ok to confirm save