ImporterValueMapping Table

The ImporterValueMapping table stores mapping pairs for use by importer tasks. It serves as a basic lookup translation table that is not connection-specific.

Table 1. Database columns for ImporterValueMapping table

Database Column

Details

ImporterValueMappingID

Type: integer. Key. Generated ID

Unique auto-incrementing identifier.

Category

Type: text (max 100 characters). Key

The importer section applicable for this key, uses dotted notation: e.g. “MobileDevice.Apple.Model”.

FromValue

Type: text (max 256 characters). Key

The value to translate.

ToValue

Type: text (max 256 characters). Nullable

The required destination value for the Category/FromValue pair.