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

Updating or Inserting a Search Layout (Upsert)

This topic describes how to update a search layout (if it exists) or insert a search layout (if it does not exist) on your Oracle CRM On Demand environment (customer test environment or production).

About the Upsert Operation

The Upsert command inserts or updates search layouts based on the following user key:

• <LayoutName> and <ObjectName>

Oracle CRM On Demand attempts to locate the search layout specified in the input file based on the user key. If a match is located, then the search layout is updated. If Oracle CRM On Demand cannot locate a search layout based on the user key, then a new search layout is created for the specified record type.

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to insert or update a search layout for an object:

migrationtool -u UserID -s ServerURL Upsert SearchLayout SearchLayoutXML

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.
• SearchLayoutXML is the fully qualified path name of the search layout XML file, for example:

  C:\My Files\MyAccountSearchLayout.xml

  If the fully qualified path name contains any spaces, then it must be enclosed with quotation marks, for example:

  migrationtool -u UserID -s ServerURL Upsert SearchLayout "C:\My Files\My Account Search Layout.xml"

NOTE:  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 Search Layout

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

migrationtool -u UserID -s ServerURL Upsert SearchLayout "C:\Oracle Migration Tool On Demand\repository\SearchLayout\MyAccountSearchLayout.xml"

NOTE:  Quotation marks are required only if the fully qualified path name contains spaces.