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

Updating or Inserting Workflow Rules (InsertOrUpdate)

This topic describes how to use the InsertOrUpdate 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 InsertOrUpdate operation.

About the InsertOrUpdate Operation

The InsertOrUpdate command updates workflow rules based on the following user keys:

1. <RecordType> and <TriggerEvent> and <Order>
2. <WorkflowName>

If Oracle CRM On Demand locates a workflow rule based on the user keys, then the workflow rule is updated.

If Oracle CRM On Demand cannot locate any workflow rule based on the user keys, then a new workflow rule is created.

Unlike the Upsert operation, the InsertOrUpdate operation does not delete any existing workflow rules that are not identified in the input XML file.

The changes following the InsertOrUpdate operation are applied completely or not at all.

Syntax

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

migrationtool -u UserID -s ServerURL InsertOrUpdate 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.