Importing contacts or accounts

Using the data import tool, you can make the following types of updates to your database:

  • Add contacts or accounts
  • Update email addresses
  • Identify contacts with hard bouncebacks
  • Unsubscribe contacts
  • Delete contacts or accounts
  • SMS Opt In/Out

    Important: This feature is only available if your organization has purchased SMS services. Please contact your account manager for additional information and pricing.

Note: To use the import tool you must place your import file on an SSH File Transfer Protocol (SFTP) server. You can set up SSH keys to authenticate to the SFTP server. Learn more about contact data Oracle Eloqua retains and restores when you delete contacts.

Before you begin:

  • Port 22 must be used for SFTP transfers to and transfers from Eloqua.
  • Date values can not include milliseconds. If milliseconds are included in the date value, that date value is ignored and not imported. For example, "2020-08-03 18:01:00.437000000" would be ignored and not imported, whereas "2020-08-03 18:01:00" would be successfully imported.
  • Oracle Eloqua uses Rebex SFTP for connecting to SFTP server. Please refer to the following Rebex documentation for a list of supported security algorithms.
  • Create your upload file (.txt, .csv, .xls, .xlsx) and place it on your SFTP server. The upload file should only contain the contacts or accounts that you want to update or delete.

    Note: Uploads to Oracle Eloqua from an SFTP server cannot exceed 5 GB.

  • Separate fields in a .csv or .txt file using a comma (,), pipe (|), or semi-colon (;).
  • The first row of the file must be column headings. Oracle Eloqua will attempt to map the headings to existing contact or account fields.
  • If you are adding or updating contacts or accounts, make sure that you can map the data in your import file to contact fields in Oracle Eloqua. Use similar naming conventions in your import file to make this mapping easier.
  • Make sure that contacts in your import file have a unique identifier (such as an email address).

To import contacts or accounts:

  1. Navigate to Audience An image of the Audience icon. > Tools, then click Data Export and Import.
  2. On the Data Import tab, click Add An image of the Add button., then click New Contact Import or New Account Import.

    An image of the Data Export and Import Setup window with the Import Settings tab selected.

  3. On the Import Settings tab, configure the settings.
  4. Click the Field Mapping tab to map the columns in the import file to contact or account fields. If you need to update a mapping, double-click the row.
    • Make sure you map all the data in your upload file to the applicable contact or account field.
    • Also, make sure that you select when you want the fields to update using the All Fields Update Type drop-down list. For example, update the field if it is blank or not blank. Using Set to default will use the default configuration for each field. If a specific field should be updated differently than the rest, you can double-click the field and configure the update type for that specific field.
  5. Click Save.

After you finish: To import now, click the Overview tab and click Run now. Otherwise, the import will run according to the schedule you specified on the Import Settings tab. If you have unexpected results after an import (for example, fields not updating as expected), see this troubleshooting information for more help.

Important: Data imports via SFTP or manual upload are subject to a 30-minute timeout.

Learn more

Exporting contacts or accounts

SFTP troubleshooting

Viewing the results of data imports or exports

Setting up SSH keys

Knowledge Base: SFTP Import Error - "Your Username or Password Is Invalid for the Hostname Provided"