Product: ImportOmatic

Description: This solution describes how to create a dictionary to translate an incoming value into a blank value

Environment: All

Versions: All


Go to RE > Plugins > ImportOmatic > Configuration > Dictionaries. Select to "Add".

A. Select the "No" button

B. The next window to appear will be the Dictionary itself. All fields will be blank and need values appointed. The blank fields are as follows, Title, Description, Replacement Values and Values to Match On

C. Create a Title

D. Create a Description (optional)

E. In the Replacement Value pane, place your mouse in the smaller field and hit the enter key on your keyboard. This will create a value appearing as --Blank--.

F. Highlight the added Replacement Value (--Blank--), then enter a Value to Match On in the smaller field on the right that needs to be translated from the data file. Select the plus sign or hit enter on the keyboard to add the value to the dictionary after you type it in the field.


Replacement Value (Desired RE Value): --Blank--

Value To Match On (Value From Data File): Welcome Letter

This association will allow the value of "Welcome Letter" from the data file to be translated to a value of blank within RE.

Place the newly created dictionary on the appropriate column within the IOM profile to apply it for use on the selected field.