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.
- Identify and save the report
- Setup the command file
- 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:
..\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
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.
The output file name is supplied with full path (required):
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:
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)