Oracle Migration Tool On Demand Guide > Migrating Related Information Layouts > Migrating Related Information Layouts >

Updating or Inserting a Specific Related Information Layout (Upsert)

This topic describes how to update a specific related information layout (if it exists) or to insert the related information layout (if it does not exist) in your Oracle CRM On Demand environment; that is, a customer test environment or production environment.

NOTE:  The Enable Web Services Access and Customize Application privileges are required to run the Upsert operation.

The configuration data is updated when the System Layout Name exists in the target company for the specified object and related object. Table 39 lists the results of an Upsert operation in different situations.

The Upsert operation has the same limitations as the Oracle CRM On Demand user interface (UI), and it fails if the following conditions occur:

• The XML file contains a layout name length longer than what the UI supports.
• The XML contains a description length longer than what the UI supports.
• The XML content references fields that do not exist on the target system.

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to update a specific related information layout (if it exists) or insert the related information layout (if it does not exist):

migrationtool -u UserID -s ServerURL Upsert RelatedInformationLayout MyRelatedInfoLayoutXML

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

  C:\My Files\MyRelatedInfoLayout.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 Related Information Layout

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

migrationtool -u UserID -s ServerURL Upsert RelatedInformationLayout "C:\My Files\MyRelatedInfoLayout.xml"

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