Siebel Assignment Manager Administration Guide > Assignment Rule Administration > Exporting and Importing Assignment-Related Data >

Limitations for Importing Assignment-Related Data

This topic is part of Exporting and Importing Assignment-Related Data.

The following limitations apply when you import assignment-related data:

• General limitations. No insert, update, or delete operations can be performed on records for top-level object types: assignment rules or positions.
• Update limitations. The following limitations apply to updates that are performed as part of import operations:
  • User key values cannot be updated as part of an update. For the applicable user keys, see Table 19.
  • As noted in Table 19, skill items and criteria items have no static user key fields. You can update such records in an import operation if you use logically unique fields as user keys. For example:
    • If a skill is Competency, then Competency is a key field in associated skill items, and two other fields (Skill Level High and Skill Level Low) can be updated.
    • If a skill is Language, then Language Code is a key field in associated skill items, and only one field (Expertise) can be updated.
    • If a criterion is Account Bill To City State Country, then Bill to City, Bill to State, and Bill to Country are key fields in associated skill items, and one field (Score) can be updated.

      NOTE:  If you are not sure which fields make up the logical user key for particular skill items or criteria items, you can specify that the import operation perform a delete followed by an insert with updated values.

• Delete limitations. The following limitations apply to deletes that are performed as part of import operations:
  • As noted in Table 19, skill items and criteria items have no static user key fields. You can delete such records in an import operation if you use logically unique fields as user keys. If multiple records match a specified logical user key, only the first matching record is deleted.
  • Records for mid-level object types can be deleted only where all fields of the child object type are empty in the import file. Specifically, this means that criteria records can be deleted only if they have no associated criteria items in the import file, and skill records can be deleted only if they have no associated skill items in the import file.

User Key Fields Relevant to Importing Assignment-Related Data

Table 19 identifies the user key fields that control what happens when you import assignment-related data from a spreadsheet file.