Wiki

Case Status
Log In

Wiki

 
How to Automatically Run Store…
  • RSS Feed

Last modified on 7/20/2017 1:58 PM by User.

How to Automatically Run Stored OASIS Reports (Windows users)

Overview

At times it is important in a corporate environment to run the same report regularly. Possibly a weekly orders report, or a monthly activity report of some kind. This may be done by first saving the report and giving it a unique name. Then the commands in this article show how the report may be run without the OASIS user interface, allowing the running of the report to be done in a batch environment.

CAUTION: EXPERTS ONLY!  Recommend IT Personnel do this.

Note:  The batch command file being referred to is one that stores commands in a plain text file (see https://en.wikipedia.org/wiki/Batch_file).  This allows you to run a report from outside OASIS and even use Operating System features that will run this batch file on a schedule.  It is not to be confused with the Batch Job functions in OASIS. 

Steps

  1. Identify and save the report
  2. Setup the command file
  3. Run when needed

Identify and save the report

Any report that may be saved in the reports application in OASIS may be run. It is best to use relative dates like "this week" or "Last Month" as the report will run without any user input.

Setup a batch command file

The command file may contain any commands before or after the following:

Oasis Batch Report Example:

cd OASIS_INSTALL_DIR\OASIS
..\jre\bin\java -Xmx1G -jar OASIS.jar CLI=REPORTS ARGS DBKind=Sybase DBServer=10.255.10.110 DBPort=5002 DBUser=oasis DBPassword=oasis AUTOLOGIN=demo/ Report=Weekly_Report File=test.pdf

There are only 2 lines - the second line wraps in most browsers. The first command changes the working directory to the OASIS installation directory and is required.  The line that starts with "..\jre\bin\java" cannot be split up with a return(enter for a new line), it will break the command and treat it as a new argument.

Here are some details on the actual command:

This part is required - only the memory size may be altered (512M =  -Xmx512M)

..\jre\bin\java -Xmx1G -jar OASIS.jar CLI=REPORTS ARGS

The database connection parameters must be changed to match how the GUI connects to the database

DBKind=Sybase DBServer=10.255.10.110 DBPort=5002 DBUser=oasis DBPassword=oasis

The user login information is required. This user identification must be defined in the users application in OASIS. The format is userid/password

AUTOLOGIN=demo/

The report name is next. If the name of the report has spaces, replace the spaces with the under bar (_) character. Quotes normally will not work. This is the name of the report as it was saved in the reports application.

Report=Weekly_Report

The output file name is supplied with full path (required):

File=test.pdf

Note: This feature supports output to PDF and .xls format for individual reports, when saving to a file directory. If calling a batch email report it will only support PDF format(each report will be a separate attachment on the email).

 

How to Generate Multiple Oasis Batch Reports Simultaneously

After creating Oasis Batch Report batch command files via the steps above, you can generate multiple Oasis Batch Reports simultaneously.

This can be done by calling your already created batch command files from another batch command file.

Here's an example of a batch command file that calls batch command files previously created:

cd "C:\Users\BatchFileLocation"
call BatchFileNameJaneDoe.cmd
cd "C:\Users\BatchFileLocation"
call JohnnyTapia_BatchFileName.cmd
cd "C:\Users\BatchFileLocation"
call BadBoys2_BatchFileName.cmd

Software Updates

This feature will only run on release W542C1 and later. The machine running the command file must have the current updates. This is done by logging into the GUI normally on the machine and as the (windows/unix) user that will run the batch file.

 

For Mac OSX users, please see these steps steps: click here How to automatically run stored OASIS reports (macOS)