Our mothers taught us to wait our turn. We learned that lesson, but it's much easier said than done. When we do things like import records into CRM On Demand, we expect immediate results. Usually, our imports are processed in 4 minutes or less and we move along happily, but every once in a while there appears to be a delay. That can be frustrating, I know, but just as Mom said, "We must wait our turn."
The first place to check when you don't see your imported records is the Import Queue. To get there:
1. Click the Admin link.
2. In the Data Management Tools section, click the Import and Export Tools link.
3. In the Import and Export Queues section, click the Import Request Queue link.
If the status of your import is Queued, you're waiting in line. While waiting for your import, you may be cursing your computer or CRM On Demand...but it's not their fault. There may be a few factors contributing to your wait time:
Rush hour - Yes, you even experience traffic in cyberspace. Most CRM On Demand customers share a multi-tenant pod (a CRM On Demand instance or environment) with other companies. During certain times of day and certain days of the month, there may be more import activity and slower queues. Doing imports during off hours, like non-working times will keep you out of most traffic jams. If you're not sure of the best time for your import, do a test run.Data Loads - Larger imports take more time. If another person on your pod is trying to import a lot of data, you'll have to wait longer. To maintain your own sanity and the sanity of those behind you in line, make sure you understand the business need behind your import and only import the records you MUST HAVE to meet your business needs.
Work in Progress - Before you get in the import queue, check to be sure that your import won't coincide with planned maintenance or downtime for your pod. To view your maintenance schedule, click the Service Information link at the bottom of any Oracle CRM On Demand page.
If the status of your import is In Progress, you're waiting on your own import. To make sure your import processes as quickly as possible, it's best to prepare in advance. Data preparation and planning are VERY important steps to ensuring a smooth import. We have a few resources to help you:
Free Webinars:
Importing Your Data - Part 1
Importing Your Data - Part 2
Consulting Best Practices for Data Import
Instructor-Led Course:
Data Import Workshop
Solutions and Tools:
Before You Import Data
Data Preparation and Cleanup Guide
Address Mapping Template and Phone Mapping Guide
Help Topics:
Click the Help link on any page in the CRM On Demand application and find the Import and Export Tools topic on the Contents tab under Administering Oracle CRM On Demand > Data Management Tools.
