Updating or Inserting Workflow User Sets (InsertOrUpdate)

This topic describes how to use the InsertOrUpdate command to update a workflow user set (if it exists) and insert a workflow user set (if it does not exist) on 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

To insert users you specify the workflow name with unique values for the <UserID> or <UserLoginName> child elements of <WorkflowUser>. If some of the specified user data results in an error, for example, if a value for a user is not unique, the whole request is rolled back.

When you run the InsertOrUpdate command, the following happens:

If Oracle CRM On Demand locates a matching workflow user based on the user keys, then the workflow user is updated.
Existing workflow users that are not included in the XML request are not affected. The InsertOrUpdate operation does not delete any existing workflow users that are not included 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 users (if they exist) and to insert workflow users (if they do not exist):

migrationtool -u UserID -s ServerURL InsertOrUpdate WorkflowUserSet WorkflowUsersXML

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.
WorkflowUsersXML is the fully qualified path name of the workflow user set XML file, for example:
```
C:\My Files\My WorkflowUserSet1.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 a Workflow User Set

The following is an example of updating a workflow user set (if it exists) or inserting a workflow user set (if it does not exist) in your Oracle CRM On Demand server:

migrationtool -u UserID -s ServerURL InsertOrUpdate WorkflowUserSet "C:\My Files\My WorkflowUserSet.xml"

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