Oracle Migration Tool On Demand Guide > Migrating Sales Categories > Migrating Sales Categories >

Updating or Inserting Sales Categories (Upsert)

This topic describes how to update a sales category (if it exists) or insert a sales category (if it 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 sales category (if it exists) or insert a sales category (if it does not exist):

migrationtool -u UserID -s ServerURL Upsert SalesCategory SalesCategoryXML

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.
• SalesCategoryXML is the fully qualified path name of the sales categories XML file, for example:

  C:\MyFiles\1.xml

  If the fully qualified path name contains any spaces, then it must be enclosed with quotation marks, for example:

  migrationtool -u UserID -s ServerURL Upsert SalesCategory "C:\My Files\1.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.