QPR ProcessAnalyzer ScriptLauncher

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search

QPR ProcessAnalyzer ScriptLauncher is a tool to run QPR ProcessAnalyzer scripts stored in the QPR ProcessAnalyzer Server, while enabling connections to datasouces from the site where the ScriptLauncher is running, e.g. on-premise.

Installing ScriptLauncher

Follow these instructions to install QPR ProcessAnalyzer ScriptLauncher:

  1. Download QPR ProcessAnalyzer ScriptLauncher from the downloads page, and extract the package into a suitable location.
  2. The ScriptLauncher files are located in the QPR Connector folder which is in the QPR ProcessAnalyzer Excel Client installation folder (e.g. C:\Program Files\QPR ProcessAnalyzer 201X\QPR Connector). If you want to run the ScriptLauncher in a different folder, the QPR Connector folder can be copied into a different location.
  3. If you need to extract data from SAP using the RFC interface, you need to install the SAP Connector.
  4. Configure the ScriptLauncher according to the instructions in the next chapter.
  5. The ScriptLauncher can be run according to the instructions in the chapter below.

Installing SAP Connector for ScriptLauncher

  1. Go to SAP Service Marketplace (SAP Service Marketplace credentials required), and download SAP Connector for Microsoft .NET 3.0.11.0 for Windows 64bit (x64).
  2. SAP connector may require Microsoft Visual C++ Redistributable Package. Check the SAP Connector documentation for more information. For example Microsoft Visual C++ 2010 Redistributable Package is available in https://www.microsoft.com/en-us/download/details.aspx?id=14632. Restart your computer after the Microsoft Visual C++ Redistributable Package installation.
  3. Run the SAP Connector for Microsoft .NET 3.0.11.0 for Windows 64bit (x64) installer.
  4. Copy the sapnco.dll and sapnco_utils.dll files from C:\Program Files (x86)\SAP\SAP_DotNetConnector3_x64 to C:\Program Files\QPR ProcessAnalyzer 201X\QPR Connector (ScriptLauncher installation folder).

Note: If you get error Could not load file or assembly 'sapnco_utils.dll' or one of its dependencies. The specified module could not be found., the reason might be that the MSVCR100.dll file is missing and solution is install Microsoft Visual C++ 2010 Redistributable Package. If the problem still persists, verify that the MSVCR100.dll is included in windows PATH.

Configuring ScriptLauncher

Before you can start running scripts with QPR ProcessAnalyzer ScriptLauncher, you need to configure the connection and other parameters for the tool. Note that you need to have write access to the ScriptLauncher folder, which contains the ScriptLauncher's configuration file Qpr.ProcessAnalyzer.ScriptLauncher.exe.config.

  1. Open the Qpr.ProcessAnalyzer.ScriptLauncher.exe.config file in a text editor.
  2. In the file, go to the section starting with <Qpr.ProcessAnalyzer.ScriptLauncher.Properties.Settings> and configure the values for the following parameters:
    • ConnectionType: Service (if you are connecting to a service) or Database (if you are connecting to a connection string)
    • Username: QPR ProcessAnalyzer username
    • Password: QPR ProcessAnalyzer password
    • ServiceUrl: QPR ProcessAnalyzer url
    • ScriptId: Id of the script you want to run. You can copy the ID from the Manage Scripts dialog in QPR ProcessAnalyzer Excel Client. If ScriptId is 0 (or less than 0), there will be an error written into the log.
    • ProjectId: Project id
    • ModelId: Model id
    • OutputDirectory: folder where to store the created CSV export file. If the folder doesn't exist, it will be created.
    • Parameters: passes defined custom parameters to the script. The script should have corresponding @_Parameter_<ParameterName> variables to use the script. Add the following new setting sections to the configuration file to pass custom parameters (parameter1 and parameter2):
<setting name="Parameters" serializeAs="Xml">
  <value>
    <ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <string>parameter1=value1</string>
      <string>parameter2=value2</string>
    </ArrayOfString>
  </value>
</setting>

It's possible to add more than one string. The type of the parameter value is always NVARCHAR.

In case you want to change location of the log file that will be created, you can do that by changing the value of the parameter LogFilePath in the following section of the configuration file:

<applicationSettings>
  <Qpr.ProcessAnalyzer.Common.Properties.Settings>
    <setting name="LogFilePath" serializeAs="String">
      <value>.\Qpr.ProcessAnalyzer.ScriptLauncher.log</value>
    </setting>
  </Qpr.ProcessAnalyzer.Common.Properties.Settings>
</applicationSettings>

Note that the log folder needs to exist before running QPR ProcessAnalyzer ScriptLauncher and you must have rights to write to that folder. By default, the log file will be stored in the same folder as the configuration file.

Running ScriptLauncher

After ScriptLauncher has been configured, Qpr.ProcessAnalyzer.ScriptLauncher.exe executable file can be run which is located in the ScriptLauncher folder. In addition to the configuration file, all parameters can also be specified in the command line when running the ScriptLauncher. The command line parameters will override the settings in the configuration file. The parameter names are case sensitive. To specify a parameter in the command line, use the following format (note that all custom parameters must start with "Parameter_":

-Parameter_<ParameterName>=<SettingValue>

For example:

Qpr.ProcessAnalyzer.ScriptLauncher.exe -ScriptId=123 -ModelId=12345 -Parameter_MyParameter1=myValue1 -Parameter_MyParameter2="my value 2"

Parameters that contain special characters, such as whitespaces, must be escaped by using double quotes. For example:

-LogFilePath="C:\Temp\Path to My Log Files\ScriptLauncherDir\"

Configuring proxy settings

QPR ProcessAnalyzer ScriptLauncher communicates with QPR ProcessAnalyzer Server using Windows Communication Foundation (WCF). The connection related configurations follow the WCF standard. You can configure proxy settings for QPR ProcessAnalyzer Client by modifying file Qpr.ProcessAnalyzer.ScriptLauncher.dll.config stored into the QPR ProcessAnalyzer ScriptLauncher installation folder. For example, in order to setup a proxy that uses current windows credentials for the proxy connection, you may try to add the following setting inside the <system.net> tags:

<defaultProxy useDefaultCredentials="true" />

Further discussion about proxy setting:

Exporting Script Results to CSV

When a QPR ProcessAnalyzer script contains the GetAnalysis command with the Show=TRUE parameter or the ShowReport command, the analysis is exported into a CSV file. The name of the exported file will be the same as the Excel sheet name when the script is run using ProcessAnalyzer Excel client. If there are multiple Show commands for a same Excel sheet name, the newer will overwrite the older file(s). Only tabular analysis types are supported by the CSV export. When the script has been run, script progress will be written to the specified log file Qpr.ProcessAnalyzer.ScriptLauncher.log.

The exported CSV files have the following formatting:

  • Column separator: semicolon
;
  • Decimal separator in numeric fields: period
.
  • Quotation character for text fields: double quotes (used when the textual value contains semicolon, double quotes, linebreak or tabulator)
"
  • Escape character: Double quotes in textual fields are escaped with two double quotes.
""
  • Date format for date fields: yyyy-MM-dd HH:mm:ss,fff
  • First line: contains column headers