Exporting report results using the export client

For saved user-defined reports, you can use the export client command line tool to run reports and export the report results for further external processing.

Before you begin

This option is only available for saved user-defined report definitions that do not contain parameters.

The export client tool wps_install_root/ProcessChoreographer/util/bpcobserverexporter.jar has to be installed on your local workstation.

Procedure

To run a report and export the report result, use the command line to start the export client.

Enter the following command: java -jar bpcobserverexporter.jar options

You can specify options directly on the command line in the format -option value -option value ..., or specify the name of a properties file. In the properties file the options have the format option=value. Options that are specified on the command line take precedence over those that are specified in a properties file.

Following options are valid:
Table 1. Valid options for the export client
Option Description
help Shows usage information.
verbose Shows additional information when the result is exported that you can use for debugging.
unicode Exports the result in UTF-8 encoding. The default is the local operating system encoding.
o Overwrites any existing file. The default is an error if the file already exists.
properties This defines a fully qualified file name that contains additional options.
url Complete URL where the Business Process Choreographer Explorer is running. The default is http://localhost:9080
out This defines a fully qualified filename to store the export result. The default is report name.csv.
userid When security is enabled, a valid user ID is required.
password When security is enabled, a valid password is required.
reportname The name of a saved report definition is required. Export with the export client only works for saved user-defined report definitions that do not contain parameters.