Skip Navigation
Expand
What is the Data Import feature?
Answer ID 4191   |   Last Review Date 11/14/2018

What is the Data Import feature?

Environment:

Data Import Wizard, Templates and Reporting
Oracle B2C Service

Resolution:

Using the Data Import Wizard, you can add new contacts, answers, assets, incidents, organizations, and custom objects to your Oracle B2C Service database from a data file.  Note: It is not possible to import file attachments or to import SLAs to an organization record using the Data Import Wizard.

Oracle B2C Service provides the following import features.

Data Record Types: Answer, Asset, Config Base Entry, Config Base Value, Contact, Incident, Message Base Entry, Message Base Text, Organization


Data Import Wizard - Use the wizard to map the data file to columns in the Oracle RightNow database and prescan the file for problems, such as duplicate records or invalid email addresses.

  1. Click the Configuration button on the navigation pane.
  2. Double-click Data Import Wizard under Database.
  3. The content pane displays the Data Import Wizard.


Data import templates - For imports that you want to perform more than once, you can create column mapping templates that can be selected when importing data with the wizard. You can customize a data import template via the template designer.

  1. Click the Configuration button on the navigation pane.
  2. Double-click Data Import Template under Database.
  3. The content pane displays the Data Import Template designer.
                                                                              Configuration > Database > Data Import Template > designer opens   


Data imports reporting - View the Data Imports report to track information about past imports. Imports are tracked in the Data Imports report, located in Reports Explorer > Public reports > Common > Site Administration. The Data Imports report contains information such as the type of records imported, process start and completion times, the import file name, and information about file locations and column mapping. The statistics used for this report are stored in the data_imports table and can also be accessed by creating a custom report. For a description of the information logged in the data_imports table, refer to the Data Dictionary.

Note: In order to access the Data Import Wizard and template editor, staff members must have the Data Import permission in their profile. A staff member with this profile permission can import any of the supported record types, even if the staff member's only responsibility is to import contact data for marketing purposes.

For additional information, refer to the 'Overview of Data Import' section in online 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.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.