Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Import Assistant > Reviewing Import Results

Reviewing Import Results

You can track the progress of the import by reviewing the queue page in Oracle CRM On Demand. When the import request is completed, you can navigate to the import queue, and drill down on the completed import job. Each import request contains the submitted data file, generated map file, and a log file. This log file provides basic, log file information, including errors, the status of the import, and so on. If an error occurs during the import, it is recommended that you review the log file attached to the import request.

If you enabled email notification during import preparation, then you will receive an email message when your import request is completed. The email message summarizes the import and may have a map file and a log file attached to it. The log file lists the records and fields that were not imported.

You can then correct the data in your CSV file and import the information again. The second time, you should direct the system to overwrite existing records when it encounters duplicate records.

If the size of the log file for an import request is not greater than 2 MB, then Oracle CRM On Demand attaches the file to the email. If the size of the log file is greater than 2 MB, then Oracle CRM On Demand zips the file. If the size of the zipped file is not greater than 2 MB, then the zipped file is attached to the email. Otherwise, the file is not attached to the email.

The map file is attached to the email provided that the combined size of the attachments is not greater than 2 MB. If the combined size of the attachments is greater than 2 MB, then Oracle CRM On Demand zips the map file and attaches it, provided that the combined size of the attachments is not greater than 2 MB. Otherwise, the map file is not attached to the email.

You can access the unzipped attachments, as well as the emails, through your personal email monitor. For information about accessing your personal email monitor, see Accessing Your Pending and Sent Emails. If your user role has the Access Master Audit Trail and Admin Configuration Audit privilege, then you can also access the emails and attachments for all users through the company email monitor. For more information, see Reviewing Your Company's Pending and Sent Emails.

To view your import request queue

1. In the upper right corner of any page, click the Admin global link.
2. In the Import and Export Tools section, click the Import and Export Tools link.
3. In the Import and Export Queues section, click the Import Request Queue link.

   The Import Request Queue page appears, showing the time the import was completed or estimating the completion time.

To review the email message with import results

• Go to your email application and open the email message from Oracle CRM On Demand.

  The message lists any errors that occur on a record-by-record basis along with action you should take, if you want to capture the complete data for that record.

Related Topics

See the following topic for related information:

• Example of Import Results Email and Log File