Send feedback on this topic

Uploading multiple custom object records

You can use Oracle Eloqua's Custom Object Records Upload Wizard to add or update custom object records in a custom object.

Before you begin:

To upload multiple custom object records:

  1. Navigate to Audience An image of the Audience icon, which is represented by a white silhouette of a person., then click Custom Objects.
  2. Open the custom object you want to upload to, or create a new one.
  3. Click the Custom Object menu, then click Upload Custom Object Records.

    An image demonstrating how to navigate to Upload Custom Object Records.

  4. Complete the Upload Details and select the Source of Custom Object Record data, then click Next.

  5. Note: An administrator can create new data sources. For more information, see this Knowledge Base article.

  6. Select the file in Step 2 Upload Data Source.

  7. Map the fields from the source file to fields in Oracle Eloqua in Step 3 Field Mapping, then click Next.

    An image of the field mapping tab.

    • Select the contact field to use to uniquely identify a contact from the Uniquely Match On drop-down list.
    • To have Oracle Eloqua attempt to match source fields to the best possible target fields, click Auto-Map Fields. You can manually fix any mistakes.
    • To change when values are updated (for example, update the value if it is blank or not blank) or to set constant values, click Advanced Options.
  8. Configure how the uploaded fields will be translated into custom object record fields in Step 4 Upload Actions.

    An image of the upload actions step.

    • To validate that the email addresses exist and the format is correct, select the Validate Email Address check box. This option is selected by default.
    • To set the status of uploaded custom object records, select an option from the Status of uploaded data cards drop-down list. The status of a custom object record options are: Registered, In Progress, or On Hold.
    • To update the status of existing custom object records, select the Overwrite status of existing data cards check box.
    • To make the custom object records read-only, select the Data Card ReadOnly check box.
    • To map new custom object records to existing contact records, select the Map data cards check box.
    • To determine the type of entities in the upload and determine what field identifies them, select the options from the Entity Type, Entity Field, and Source Field drop-down lists.
    • To have Oracle Eloqua perform a case sensitive match when comparing to existing contacts, select the Case-sensitive match check box.
    • To send your custom object records to a step in a Program Builder program, click the Program Step field.
  9. Finalize your upload in Step 5 Summary and click Finish.

    • Enter the email address to be notified when the upload completes. If you are using multiple email addresses, separate each with a comma.
    • To use these upload settings in another upload, select Save these settings for re-use. Otherwise, select Run the upload once using these settings.

If custom object records didn't update

You might notice that some of the data from the upload file did not make it to the custom object record. There are a couple reasons why this may happen:

Related

Custom objects

Setting up SSH keys

Data import priority