Siebel Enterprise Integration Manager Administration Guide > Importing Data > Special Considerations for Imports >

Importing LOV and MLOV Data

When importing List of Values (LOV) data, whether into an LOV column or a multilingual LOV (MLOV) column, you must populate the EIM table column with the display value of a specific language. The difference between the two cases is the following:

• When importing into an LOV column, the EIM engine puts the display value directly into the column.
• When importing into an MLOV column, EIM translates MLOV values during the import process. The EIM engine looks up the Language Independent Code (LIC) of the display value in the EIM table column and populates the LIC into the MLOV column.

EIM runs in the same language as that of the Siebel Server installation. For example, if the Siebel Server installation is in German, the LANGUAGE parameter setting defaults to German. In this example, the following takes place:

• To import into an MLOV column, you enter a German display value in the EIM table column. You can enter "Aktiv" to indicate an account status that is active. The EIM engine puts the corresponding LIC, "Active," into the MLOV column.
• To import into an LOV column, the EIM engine puts "Activ" into the LOV column.

NOTE:  You must always populate EIM table columns that are mapped to LOV bounded base table columns with values that correspond to S_LST_OF_VAL.VAL, even when MLOV are used.

To find the specific steps for importing LOV data, see the example in To import data into an LOV table.

LOV Validation

When importing data from EIM tables, you may encounter the following error message in your trace file:

[ERR00] Interface table:
[ERR00] S_XXXX_XMIF (Interface for XXXX Built-In M:1 Extension Table)
[ERR00] --------------
[ERR00]
[ERR00] Base table:
[ERR00] S_XXXX_XM (Account M:1 Extension)
[ERR00] ------------
[ERR00] TYPE (Type)
[ERR00] This column contains a bounded picklist value and the value given does not
[ERR00] correspond to a value in the list-of-values table for the given picklist type.

This error message indicates that either a picklist has not been created for this column (TYPE) or the value in your EIM table for this column (TYPE) does not correspond to one of the values in the picklist for this column. To resolve this issue, you need to make sure that:

• A picklist already exists for this column.
• The value you are importing for this column corresponds to one of the values in the picklist.

The following procedure explains how to import data into an LOV table, using the S_ORG_EXT_XM table as an example.

To import data into an LOV table

1. To find the LOV type for a column in the S_ORG_EXT_XM TABLE, perform the following actions:
   1. In Siebel Tools, select Types.
   2. Click Table.
   3. Select S_ORG_EXT_XM.
   4. With the S_ORG_EXT_XM table highlighted, expand Column tree control, and find the Type column.
   5. With the Type column highlighted, find the following two attributes in the Properties window:
      • Lov Bounded: TRUE
      • Lov Type: ORG_EXT_XM_TYPE

        The TYPE column should contain the value as the VAL column in the S_LST_OF_VAL table.

2. Using the Siebel client, find S_ORG_EXT_XM_TYPE.
   1. Navigate to the List of Values screen.
   2. Query the Display Value column for ORG_EXT_XM_TYPE to make sure that the picklist already exists.
3. Using the Siebel client or EIM, add values for this bounded picklist.

   If you are using the Siebel client:

   1. In the List of Values view, create a new record.
   2. In the Type column, type ORG_EXT_XM_TYPE.
   3. In the Display value column, insert any value you want to use for this type.
   4. Repeat Step c until you have created records for all values you want to have in this picklist.

      If you are using EIM:

   5. Populate the EIM_LST_OF_VAL table, set the TYPE column to ORG_EXT_XM_TYPE, and set the VAL column to any value you want to use for this type. Make sure to populate all the required fields in the EIM_LST_OF_VAL table.
   6. Repeat Step e until you have inserted all records into the table for all values you want to have in this picklist.
   7. Import data from EIM_LST_OF_VAL to S_LST_OF_VAL using EIM.

      The VAL column in the S_LST_OF_VAL table should contain the same value as the TYPE column in the S_ORG_EXT_XM table.