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:-
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
-
Click
. -
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.
-
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.
-
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
-
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.-
Create the CSV file using the following table.
ID
RecordName
ItemName
ItemCount
300100035821118
CustomOrder1_Item1
Switches
2500
300100035821120
CustomOrder1_Item2
Sockets
1000
-
Click
. -
On the Manage Imports page, click the Create Import Activity button to create an import activity UpdateCustomObject.
-
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.
-
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
-
Review and activate the import activity.