Product: ImportOmatic
Description: This solution discusses how to use virtual fields

Environment: All

Version: 2.0.0.12 and higher

Answer:

Virtual columns allow you to import additional data without manipulating the data file. 

To add a virtual column, go to Virtual Fields and in the field mapping area of the screen, right click and select Insert Virtual Field. Edit the field name and map the record type, value type, and relationship group number (if applicable) fields.

In the Function column, select the appropriate function. IOM provides five standard functions:

Copy Field – This copies a value from the import file and uses it as is. Choose the field from the data file you would like to copy in the Seed column.

Uppercase – This uppercases all letters in the field. Choose the field from the data file you would like to copy and uppercase in the Seed column (optional).

Lowercase - This lowercases all letters in the field. Choose the field from the data file you would like to copy and lowercase in the Seed column (optional).

Static Field (field name) – This uses the value assigned in the Field Name column as the value for the field. No seed is needed for this function.

Current Date– This uses the current date for date fields. No seed is needed for this function.

Please note that a function must be selected. The virtual field will not work if a function is not applied.

Refer to the ImportOmatic User Guide for additional information.