Oracle Migration Tool On Demand Guide > Migrating Homepage Layouts > Migrating Homepage Layouts >

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.

An update to a homepage layout is derived from the homepage layout system name. That is, if you run an Upsert operation on a homepage layout where the homepage layout system name in the XML file is My Homepage, and a homepage layout of the same name exists in the target company, then the target homepage layout is updated. If the homepage layout does not exist on the target company, then the homepage layout is inserted on the target. The matching of the homepage layout name is also case sensitive. For example, if the homepage layout system name in the XML file is MY Homepage and the target access profile is My Homepage (no uppercase Y), then the MY Homepage homepage layout is inserted in the target.

The Enable Web Services Access and Customize Application privileges are required for an Upsert operation on a homepage layout.

NOTE:  Users cannot reference record names or section names that are not set up on the target system in an Upsert operation.

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"

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