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.
- Identify and save the report
- Create file and give executable permissions to the 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.
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:
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 "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:
Here are some details on the actual command:
This part is required - only the memory size may be altered (512M = -Xmx512M)
-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 .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:
Note: Make sure to make the this shell script executable too. Like you did with before with the 'chmod' command above.
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.