Updating or Inserting a Homepage Layout (Upsert)
This topic describes how to update a specific homepage layout (if
it exists), or insert that homepage layout (if it does not exist)
on your Oracle CRM On Demand environment (customer test environment or production). For the purposes
of the Oracle Migration Tool On Demand client, this is known as an Upsert operation. It is specified
using the Upsert
command.
About the Upsert Operation
The Upsert
command inserts or updates a homepage layout based on the <LayoutName>
value. If a homepage layout already exists with the same <LayoutName>
value, then the homepage layout is updated, otherwise, a new homepage
layout is created. The matching of the homepage layout names is case
sensitive.
The Enable Web Services Access and Customize Application privileges are required for an Upsert operation on a homepage layout.
Sequence Tags
The <Sequence>
tag in the homepage layout XML must contain all the sequence values
for the layout.
For example, the following are acceptable sequence values for the Upsert operation:
0, 1, 2
0, 1, 3
0, 2, 4
0
1
1, 3
0, 1, 3
The following sequence values are not acceptable for an Upsert operation:
-1 is not acceptable because only positive integers are acceptable
0, 0, 1, 2 is not acceptable because duplicates must not exist
2 is not acceptable because the first left side value (that is, 0) is missing
3 is not acceptable, because the first right side value (that is, 1) is missing
1, 2 is not acceptable because the first left side value (that is, 0) is missing
0, 3 is not acceptable because the first right side value (that is, 1) is missing
0,1,2,5 is not acceptable, because the second right side value (that is, 3) is missing
0, 2, 3 is not acceptable, because the first right side value (that is, 1) is missing
Syntax
The following is the syntax for using the Oracle Migration Tool On Demand client to update a specific homepage layout (if it exists) or insert the homepage layout (if it does not exist):
migrationtool -u UserID -s ServerURL Upsert HomepageLayout HomepageLayoutXML
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.
HomepageLayoutXML is the fully qualified path name of the homepage layout XML file, for example:
C:\My Files\My HomepageLayout.xml
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 Homepage Layout
The following is an example of updating a specific homepage layout (if it exists) or inserting that homepage layout (if it does not exist) in your Oracle CRM On Demand server:
migrationtool -u UserID -s ServerURL Upsert HomepageLayout "C:\My Files\My HomepageLayout.xml"