How To Import Leads With Multiple Child Objects Records Using MULTI-CSV Method (Doc ID 2231031.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Fusion Marketing Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal


Multi-CSV method is a clean and better way of import using a zip file that contains a csv file for every object you want to perform the import. In our case: Lead, Lead_Product, Lead_Contact and Lead_Resource (Lead object and its child objects).
The only condition you need to fulfil to perform this kind of import is to use the right csv file name (like in the ImportLeadWithChildObjects.zip attached to this certification) and the exact column names used in the application (API names).
This import method offers a lot of advantages: the mapping is done automatically by the application (having the same column names like API names) so you will spare the time for creating the mapping, you can include custom fields in your import files and the error log files are created separately per every object. The error zip file includes error log files per each import csv file you used.


The purpose of this import is to create lead with multiple products, multiple resources added to the Sales Team and with multiple existing contacts.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms