Oracle Migration Tool On Demand Guide > Migrating Role Associations for Report Folders > Migrating Role Associations for Report Folders >

Updating Role Associations for Report Folders

This topic describes how to update the role associations for report folders on your Oracle CRM On Demand environment (customer test environment or production).

About the Upsert Operation

The Upsert command inserts or updates role associations for report folders based on the following user keys:

• <Path>
• <Path> and <Catalog>

Oracle CRM On Demand attempts to locate the report folder specified in the input file based on the user key. If the <Catalog> element is not specified, and if multiple folders are found that match the value in the <Path> element, then an error is returned. If one existing folder that matches the value in the <Path> element is located, and if role associations already exist for the report folder, then the role associations for the folder are updated. If no role associations exist for the report folder, then the role associations are inserted for the report folder.

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to update the role associations for report folders:

migrationtool -u UserID -s ServerURL Upsert ReportFolder ReportFolderXML

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.
• ReportFolderXML is the fully qualified path name of the role associations for the report folder XML file, for example:

  C:\My Files\Test Folder.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 ReportFolder "C:\My Files\Test Folder.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 the Role Associations for a Report Folder

The following is an example of updating the role associations for a report folder in your Oracle CRM On Demand server:

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

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