Import Leads Using the Import Macro

Here's how to enter your lead data into the macro and import. You can use the macro only to import net new leads. You can't use it to import leads for existing customers or prospects.

You can import up to 5,000 lead records at a time. If you import multiple batches, you must ensure that each import completes before you start another.

Note: You can add import additional attributes by appending columns to the import macro file, but you can't make any other changes. You can't edit the Visual Basic for Applications (VBA) code or other functions.

Here's how to download the files you need:

1. Sign in to My Oracle Support.
2. Search for the document, Oracle Sales: Download the Import Files (KB171529).
3. Download the OracleSalesImportFiles.zip and extract it to a location on your computer.
   Note: You can create different folders for the different macro files, as long as each folder includes the .jar file.

1. Open the Lead Import Macro file.
2. If you receive a security warning that macros have been disabled, you must enable macros.
3. If you're importing additional fields, including custom fields, then:
   1. Click the Attributes Mapping worksheet.
   2. Click Fetch Attributes from Server.
   3. In an empty row in the worksheet, select the attribute from the Attribute Name column.
   4. Enter the name you want displayed as the column heading in the Lead worksheet. This name displays only in the macro.
   5. Click Update Headers to add the column to the Lead worksheet.
4. If you changed the lead rank or the lead channel lookup types, then enter the new values in the Lead Rank and the Lead Channel worksheets.
5. In the Template worksheet, enter your lead data. The import requires you to enter three pieces of information for each lead:
   • Lead name
   • Account name
   • Contact full name

   The macro generates the required lead number after you click Create Import Activity.

   You must also include contact information for your inside salespeople to be able to qualify the lead. If you're assigning qualified leads using the state where the business is located, you must include the state in your import or have the inside salespeople enter it as they qualify the lead.

   This table describes the available columns:

   Column	What to Enter
   Lead Number	Leave this required column blank. The macro generates the lead number automatically using the date and time. The application uses the lead number to identify the lead record for updates.
   Lead Name	The lead name identifies the lead in the lists that salespeople see in the Leads work area. In the UI, the application automatically enters a lead name as a combination of the contact name and the date and time. You might want to follow the same practice in your import. Entry in this field is required.
   Account Name	Organization name. Entry is required.
   Contact Full Name	You must enter the contact's first and last names separated by a space.
   Job Title	Contact job title.
   E-mail	Contact email address.
   Phone Country Code	Contact phone country code.
   Phone Area Code	Contact phone area code.
   Phone Number	Contact phone number with no spaces or delimiters.
   Address 1	Contact address line 1. If you convert the lead to an opportunity, then the application uses the address entered in the contact address fields both as the contact address and the account address.
   Address 2	Contact address line 2.
   City	Contact address city.
   State	For US states, enter the two-letter state code.
   Province	This column (O) is hidden in the macro file.
   ZIP Code	Postal code.
   Country	The ISO two-letter code for the country.
   Product Group	Enter the Product Group Reference Number. You can copy this number from the macro file that you used to import product groups.
   Product	Product name you imported earlier using the product import macro file. If you're importing a product interest for a lead, you can't import a product group at the same time.
   Lead Rank	You must use one of the standard values provided by Oracle in the macro file, unless you changed them. The standard values are: COOL HOT WARM
   Lead Channel	You must use one of the standard values provided by Oracle in the macro, unless you changed them. The standard values are: DIRECT_MAIL EMAIL FAX PHONE SALES_VISIT WEB WIRELESS_MESSAGE ZSP_MODEL_PREDICTION ZSP_RULES_PREDICTION

6. In the lead import macro file, click Create Import Activity.
7. If you're prompted to correct errors in your entries, do this:
   1. Click OK.
   2. Click each error link in column D and make the correction on the Template worksheet.
      Note: After you correct an error, you must click outside the field for the correction to be recognized.
   3. Click Create Import Activity again.
8. On the Login page, enter:
   • Host information for your environment.

     The host name is the portion of the URL between the https:// and /sales. You must be signed in and navigate to one of the sales work areas to ensure that the host name is correct. The name on the sign-in page and on setup pages is different.

   • Your user name
   • Your password
9. Click Submit.
10. If the macro data is validated without errors, then the macro displays one of the following messages:

    Message	Meaning
    The file import activity was submitted successfully.	Your import has started. If the file import activity is submitted successfully, then the confirmation message displays the job ID.
    Unable to connect to the server at this time.	You might have entered an incorrect host.
    Unable to submit the file import activity. Check log for details.	Open the Errors work sheet to view the error details.

11. If your import activity was submitted successfully, then click Activity Details.

    The Activity Details window appears, listing the import activity name, its ID, and its status.

    • If the import activity is still in progress, you can refresh the status periodically by clicking Refresh.
    • If your import completed successfully, then the status listed is Completed.
12. Optionally, click Generate Log to save a file listing the leads that were imported.