Oracle Migration Tool On Demand Guide > Migrating Workflow Rules and Action Sets > Migrating Workflow Rules >

Updating or Inserting Workflow Rules (Upsert)

This topic describes how to use the Upsert command to update workflow rules (if they exist) or insert workflow rules (if they do not exist) in your Oracle CRM On Demand environment; that is, a customer test environment or production environment. For the purposes of the Oracle Migration Tool On Demand client, this is known as an Upsert operation.

About the Upsert Operation

When you run the Upsert command, the existing workflow rules are updated, new workflow rules are inserted, and rules that are not in the request are deleted. The order of the rules in the workflow request must match the order of the rules for the workflow result in the Oracle CRM On Demand application. The changes following the Upsert operation are applied completely or not at all.

For more information about the considerations that apply to Upsert operations, see Considerations That Apply to Upsert Operations.

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to update workflow rules (if they exist) or to insert new workflow rules (if they do not exist):

migrationtool -u UserID -s ServerURL Upsert WorkflowRuleSet WorkflowRulesXML

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.
• WorkfowRulesXML is the fully qualified path name of the workflow rules XML file, for example:

  C:\My Files\My WorkflowRules.xml

NOTE:  The Oracle Migration Tool On Demand client requests your Oracle CRM On Demand password, which can be redirected (by 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 Workflow Rules

The following is an example of updating workflow rules (if they exist) or inserting workflow rules (if they do not exist) in your Oracle CRM On Demand server:

migrationtool -u UserID -s ServerURL Upsert WorkflowRuleSet "C:\My Files\My WorkflowRules.xml"

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