Value Mapping

Information about value mapping.

Value mapping helps you to complete imports successfully by mapping custom, user-defined terms in mapped fields of an import file to valid Touchstone values. For example, you can tell AIR ImportExpress to convert user-defined peril codes, such as "Hurr" (hurricane) and "Terr" (terrorism) to AIR-recognized peril codes, "TC" (tropical cyclone) and "TR" (terrorism) during the import process.

Note:

You must configure the field mappings before you configure the value mappings.

Procedure

To create or edit value mappings:

  1. In the Mapping Set and File Selection area on the Import & Mapping Data tab of AIR ImportExpress, click Scan Mappings.

    The Value Mapping window opens. It contains a tab for each of the types of data that you selected. Each tab displays information about unrecognized values, if any, in the import files.

  2. Click the Contracts tab that corresponds to the import file for which you want to edit or create value mappings.
  3. To map an unrecognized value to a valid Touchstone entry, select the source value that you want to map and then select the Touchstone value in the Mapping list.

    For example, the list includes a mapped Perils field with an unrecognized source value, Hurr. In the Mapping list, select Wind under Tropical Cyclone. Click Apply to map the unrecognized source value to a Touchstone value. The <n> Unrecognized values prompt remains; it reminds you that the source CSV file contains unrecognized values. You may choose to modify the unrecognized values in the source CSV file.

  4. To add your own mappings:

    For detailed information about the fields that are available for value mapping, refer to "Fields that Support Value Mapping for Import."

    1. Click in the green row with the this icon

      (Add).
    2. Select an available field.
    3. Enter a value.
    4. Select the appropriate mapping value.
  5. As you edit the settings on each tab, click Apply to save the mappings you created or edited.
  6. When you finish setting value mappings, click OK.

Next Steps

After configuring the value mappings, you can specify the destination data source.