I am trying to import addresses for existing organizations using the Data Import Wizard. The import is successful. Why isn't the address data being updated?
The Data Import Wizard is designed to import specific data sets into the knowledge base, not to support full data migrations. There are certain restrictions, particularly with associated tables such as addresses in an organization import. Associated table mapping is applied only in the case of new records. Such mapping is ignored when existing records are updated by the import.
Table mapping is available only for new records for the following associated tables:
- Notes—Maps columns to the notes table for answer, contact, and organization imports. Supported fields include chan_id and text.
- Threads—Maps columns to the threads table for incident imports. Supported fields include chan_id, seq, text, and entry_type.
- Addresses—Maps columns to the addresses table for organization imports. Supported fields include oat_id, city, country_id, postal_code, prov_id, and street.
For additional information, refer to the 'Overview of Data Import' section in the Online Help User Guide documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.