Import Custom Object Data

You can import custom object data into Sales and Fusion Service. Before importing custom data, create the parent and child custom objects for the data you want to import.

In this example, we will create a parent object (CustomOrder) and a child object (CustomOrderItem) with the required fields and then import data for these objects.

Create the Parent and Child Objects

To create parent and child custom objects:

Navigate to Application Composer.
Click the Custom Objects icon on the Overview screen.
Click the Create New Object icon to bring up the Create Custom Object window. Note that your environment must be in an active sandbox to perform this action.
Enter the value CustomOrder for Display Label. The other fields are automatically filled, which creates the parent custom object CustomOrder.
Create the custom fields by clicking the Fields option under the CustomOrder object. Enter the display names OrderName and OrderCount for the fields.
Click the CustomOrder icon on the side pane. On the Overview page, click the Create Child Object button to create the child object CustomOrderItem.
Create the custom fields ItemName and ItemCount.
After creating the custom objects, publish and sign out from the sandbox.

Import Data for Parent Custom Object

To import data for parent custom objects only, follow these steps:

Create the CSV file using the following table:

RecordName	OrderName	OrderCount
`CustomOrder1`	01-A1-inventory	2000
`CustomOrder2`	02-B3-inventory	3000

Click Tools > Import Management.
On the Manage Imports page, click the Create Import Activity button to create an import activity InsertCustomObject. For more information about creating an import, see the topic Import Data mentioned in Related Topics section.
On the Create Import Activity page, provide the file name InsertCustomObject and select the custom object CustomOrder from the Object drop-down list. Browse the CSV file that you created in step 1. Click Next.

On the mapping page, map the attributes as shown in the following table:

Column Header	Example Value	Attribute Display Name
RecordName	`CustomOrder1`	CustomOrder Name
OrderName	01-A1-inventory	OrderName
OrderCount	2000	OrderCount

Review and activate the import activity.

Note: If there are any mandatory fields in the custom object, then they must be included in the CSV file and a value must be provided for all records when performing an import. The required values must be mapped on the mapping page. In this example, OrderName is a mandatory attribute.

Import Multiple Child Records for an Existing Parent Record

After importing the parent record you can import data for child records associated with the parent record. To import data for multiple child records for an existing parent custom object, follow these steps:

Create the CSV file using the following table.

RecordName	CustomOrder_Id_c	ItemName	ItemCount
CustomOrder1_Item1	300100035820958	Electronics	150
CustomOrder1_Item2	300100035820958	Stationery	200
CustomOrder1_Item3	300100035820958	Computer Accessories	500

Note: You can import the custom child of an object using the ParentRecordName attribute also.

Click Tools > Import Management.
On the Manage Imports page, click the Create Import Activity button to create an import activity InsertCustomObject. For more information about creating an import, see the topic Import Data mentioned in Related Topics section.
On the Create Import Activity page, provide the file name InsertCustomObject and select the custom object CustomOrderItem from the Object drop-down list. Browse the CSV file that you created in step 1. Click Next.

On the mapping page, map the attributes as shown in the following table.

Column Header	Example Value	Attribute Display Name
RecordName	CustomOrder1_Item1	CustomOrderItem Name
CustomOrder_Id_c	300100035820958	CustomOrder_Id_c
ItemName	Electronics	ItemName
ItemCount	150	ItemCount

Review and activate the import activity.

Import Multiple Child Records with Different Parent Records

After importing the parent record you can import data for child records of the parent record. The Parent Record Object Key values will be different depending on which parent record the child records are being imported for. To import data for multiple child records with different parent object records, follow these steps:

Create the CSV file using the following table.

RecordName	CustomOrder_Id_c	ItemName	ItemCount
CustomOrder1_Item1	300100035820958	Switches	50
CustomOrder1_Item2	300100035820958	Sockets	100
CustomOrder1_Item3	300100035820958	Regulators	50
CustomOrder2_Item1	300100035820960	Pencils	50
CustomOrder2_Item2	300100035820960	Sharpener	100
CustomOrder2_Item3	300100035820960	Eraser	50

Note: You can import the custom child of an object using the ParentRecordName attribute also.

Click Tools > Import Management.
On the Manage Imports page, click the Create Import Activity button to create an import activity InsertCustomObject. For more information about creating an import, see the topic Import Data mentioned in the Related Topics section.
On the Create Import Activity page, provide the file name InsertCustomObject and select the custom object CustomOrderItem from the Object drop-down list. Browse the CSV file that you created in step 1. Click Next.

On the mapping page, map the attributes as shown in the following table.

Column Header	Example Value	Attribute Display Name
RecordName	CustomOrder1_Item1	CustomOrderItem Name
CustomOrder_Id_c	300100035820958	CustomOrder_Id_c
ItemName	Electronics	ItemName
ItemCount	150	ItemCount

Review and activate the import activity.

High Volume Import of Custom Objects

You can now use auditing functionality while performing high-volume import of custom objects. You can control base table auditing by setting the profile option ORA_ZCA_IMPORT_ENABLE_AUDIT_HIGHVOLUME to Yes. The default value is No.

To enable base table auditing, go to Setup and Maintenance.
Search for Manage Administrator Profile Values Profile Option code: ORA_ZCA_IMPORT_ENABLE_AUDIT_HIGHVOLUME.
Set it to Yes, then Save.