Configuring the Sequence Property of a List Column to Import Records

To import records, you must make sure you set the Sequence property of the list column so that Siebel CRM imports records in the correct order. For example, assume you must configure Siebel CRM so that the user can import service requests. To do this, the user navigates the Service Requests list, clicks Menu, and then clicks Import. To support this requirement, assume you do the following:

• Configure hierarchical pick lists in the Service Request business component on the following fields:

  • Area. The Area field constrains the Sub-Area field.

  • Sub-Area. The Sub-Area field constrains the SR Type field.

  • SR Type.

• Create a custom import object and a list applet that uses the following configuration:

  • Set Input Format to Comma Separated Text File

  • Set Input Source to Auto Mapping

  • In the applet, you set the Sequence property to the following:

    • 4 for the Sub-Area list column

    • 1 for the SR Type list column

When the user runs this import, it fails and Siebel CRM enters the following errors in the import log file:

Failed to import 'Information' into the field 'SR Type'. 

Failed to import 'Information' into the field 'SR Type'. 

This import fails because the sequence that Siebel CRM uses when it imports these fields is not correct. It attempts to set the SR Type field before it sets the Sub-Area field, but this is not possible because the Sub-Area field constrains the SR Type. Siebel CRM must import the Sub-Area field first, choose a value for it, constrain the SR Type field according to the Sub-Area field, and then import the SR Type field.

To avoid this problem, you must set the Sequence property of the list column in the applet that displays these fields to the following:

• 1 for the Sub-Area list column.

• 4 for the SR Type list column.