Case Status
Log In


How to Automatically Run Store…»How to Automatically Run Store…
  • RSS Feed

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

How to Automatically Run Stored OASIS Reports (macOS)


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 shell script.

CAUTION: Recommend IT Personnel do this.


  1. Identify and save the report
  2. Create file and give executable permissions to the 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.

Create a Shell Script and Give Executable Permission to the File

Caution: In whatever text editor you use to create, make sure the 'Line Endings' are set to Unix line endings because Windows line endings won't work in an Unix Shell.

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

Oasis Batch Report Example:

cd /

cd /Applications/

java -Xmx1G -jar OASIS.jar CLI=REPORTS ARGS DBKind=Sybase DBServer= 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 "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.

Give the file executable permissions:

Running the command in your shell or terminal will give all users permissions to read, write, and execute your shell script:

         chmod 777 filelocation/filename

You can learn more about the 'chmod' command by enter this command:

         man chmod

Here are some details on the actual command:

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


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

DBKind=Sybase DBServer= 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 .xls and .pdf 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 shell scripts via the steps above, you can generate multiple Oasis Batch Reports simultaneously.

This can be done by calling your already created shell scripts from another shell script.

Here's an example of a shell script that calls shell scripts previously created:

cd ShellScriptLocation
cd ShellScriptLocation
cd  ShellScriptLocation

Note: Make sure to make the this shell script executable too. Like you did with before with the 'chmod' command above.

Software Updates

This feature will only run on release W542C1 and later. The machine running the shell script must have the current updates. This is done by logging into the GUI normally on the machine and as the unix user that will run the shell script.