Update Custom Object Data

This example shows how to update custom object data in Sales and Fusion Service.

Update Only Parent Records

To create the parent and child custom objects, review the topic Import Custom Object Data referenced in the Related Topics section. Perform the following steps to update only the parent records:

1. Create the CSV file based on the following table:

   ID	RecordName	OrderName	OrderCount
   300100035820958	CustomOrder1	01-A1-inventory	90000
   300100035820960	CustomOrder2	01-A1-inventory	70000

2. Click Tools > Import Management.

3. On the Manage Imports page, click the Create Import Activity button to create an import activity UpdateCustomObject. For more information about creating an import, see the topic Import Data mentioned in the Related Topics section.

4. On the Create Import Activity page, provide the file name UpdateCustomObject and select the custom object CustomOrder from the Object drop-down list. Browse the CSV file that you created in step 1. Click Next.

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

   Column Header	Example Value	Attribute Display Name
   ID	300100035820958	Record ID
   RecordName	CustomOrder1	CustomOrder Name
   OrderName	01-A1-inventory	OrderName
   OrderCount	90000	OrderCount

6. Review and activate the import activity.

   Note:

   The Parent Record Object Key should be taken from the log file generated by the parent insert import job.

Update Only Child Records

To create the parent and child custom objects, review the topic Import Custom Object Data referenced in the Related Topics section. Perform the following steps to update only the child records.

1. Create the CSV file using the following table.

   ID	RecordName	ItemName	ItemCount
   300100035821118	CustomOrder1_Item1	Switches	2500
   300100035821120	CustomOrder1_Item2	Sockets	1000

2. Click Tools > Import Management.

3. On the Manage Imports page, click the Create Import Activity button to create an import activity UpdateCustomObject.

4. On the Create Import Activity page, provide the file name UpdateCustomObject and select the custom object CustomOrderItem from the Object drop-down list. Browse the CSV file that you created in step 1. Click Next.

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

   Column Header	Example Value	Attribute Display Name
   ID	300100035821118	Record ID
   RecordName	CustomOrder1_Item1	CustomOrder Name
   ItemName	Switches	ItemName
   ItemCount	2500	ItemCount

6. Review and activate the import activity.