Oracle Migration Tool On Demand Guide > Migrating Picklist Values > Migrating Picklist Values >

Updating or Inserting a Set of Picklist Values for a Single Object (Upsert)

This topic describes how to update a set of picklist values (if the set exists) or insert a set of picklist values (if the set does not exist) in your Oracle CRM On Demand environment (customer test environment or production).

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to update a set of picklist values (if the set exists) or insert a set of picklist values (if the set does not exist):

migrationtool -u UserID -s ServerURL Upsert Picklist PicklistXML

where:

• UserID is the user sign-in ID that has the appropriate privileges to run the Oracle Migration Tool On Demand client commands.
• ServerURL is the URL for the Oracle CRM On Demand server where your company resides.
• PicklistXML is the fully qualified path name of the picklist XML file, for example:

  C:\My Files\MyAccountPicklist.xml

NOTE:  The Oracle Migration Tool On Demand client requests your Oracle CRM On Demand password, which can be redirected (using the pipe command) to the client program from standard input; that is, from a file, from the command line, or from another program.

Example of Updating or Inserting a Set of Picklist Values for a Single Object

The following is an example of updating a set of custom picklist values for the Account object (if the set exists) or inserting a set of custom picklist values (if the set does not exist) in your Oracle CRM On Demand server:

migrationtool -u UserID -s ServerURL Upsert Picklist "C:\My Files\MyAccountPicklist.xml"

NOTE:  Quotation marks are required only if the path or file name contains spaces.