Browser Compare Reports

Application designer provides the option to generate browser compare reports in addition to standard compare reports.

I find that browser compare reports are a lot easier to use than standard compare reports as they provide a nice dash-board style interface that lets you drill down from a high level summary of differences to the individual differences in definitions. They also provide a nifty search option.

Generating Browser Compare Reports

To generate a browser compare report:

  1. Perform a compare and report as usual: Tools > Compare and Report
  2. When the compare screen appears, click on the Options button
  3. Navigate to the Report Options tab.
  4. Check the Generate Browser Reports check box.

Here's a screenshot of the screen:

compare-report-options-browser-reports.png

Note the report output directory (C:\Oracle\PeopleSoft\reports in the example). This is where the browser reports will be generated. You can also change the font size and settings.

Note if you want to change the output location of the browser reports, you can set it in the Tools > Options > General (tab).

Viewing Browser Compare Reports

Once the report has been generated, you can open it by double clicking on the Browser Report Created message that appears in the application designer output window:

open-browser-compare-report.png

Alternatively, you can navigate directly to the report output directory and open the file CompareViewer.html.

If you can't open the file CompareViewer.html make sure that you have the setup folder in your PS_HOME directory, particularly if you have installed PeopleTools locally.

Generating Browser Compare Reports from the Command Line

You can also generate browser compare reports by running application designer through the command line. To do so:

  • Pass the report directory flag e.g. -ROD C:\Temp
  • Pass the generate browser (XML) report flag e.g. -CMXML 1

Note that migrate project generates browser compare reports for you with the compare option.

Here's an example of the syntax you would use to generate a browser report by calling pside.exe (application designer) from the command line:

pside.exe -HIDE -PJM %project% -CT %dbtype% -CO %user% -CP %pwd% -CD %srcdb% 
-TD %tgtdb% -TO %user% -TP %pwd% -QUIET -AF 0 -DDL 1 -PPL 0 -CFD 0 -CFF 0 -CMT 1 -TGT 1 
-ROD %browser_report_dir% -CMXML 1

Run this from the directory where pside.exe is located OR add this directory to your system path. Replace the following parameters accordingly:

  • %project% = Name of the Application Designer Project
  • %dbtype% = Database type (e.g. ORACLE, MICROSFT)
  • %user% = PeopleSoft user in source environment
  • %pwd% = Password for PeopleSoft user in source environment
  • %srcdb% = Source environment
  • %tgtdb% = Target environment
  • %user% = PeopleSoft user in target environment
  • %pwd% = Password for PeopleSoft user in target environment
  • %browser_report_dir% = directory where the browser reports will be created (e.g. C:\Temp)

Useful Resources

  • The PeopleSoft and SQR blog has a good article about streamlining compare reports by removing target statuses other than 4 (custom changed) and 5 (custom unchanged).
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License