Difference between revisions of "Information Systems:Gilead Sales Report"
m |
m |
||
| Line 7: | Line 7: | ||
===Manually running the report=== |
===Manually running the report=== |
||
| − | A workflow for this that can be executed by a non-developer is still being worked on. This is because the Class Runner feature in Integrator, which is how you would normally run a one-off job, doesn't accept |
+ | A workflow for this that can be executed by a non-developer is still being worked on. This is because the Class Runner feature in Integrator, which is how you would normally run a one-off job, doesn't accept command line arguments (runtime args), which is needed to instruct the program to generate a report for a specific date. If no argument is supplied, the program generates a report for the previous day, which is of limited use. |
| + | |||
| + | An ideal solution will likely involve running the Java program from the command line on the Integrator server, but with the class path pre-set to look in the lib folder. Otherwise, the program's dependencies will not be included. The command will look something like: |
||
| + | |||
| + | <code>C:\Program Files\Java\jdk1.8.0_251\bin\java.exe com.unipharm.integrations.bizreports.GileadDailyActivityReport " " "20210422"</code> Note the format of the date and the fact that it is the second command line argument (args[1]) |
||
Revision as of 16:17, 28 April 2021
The Gilead Sales Report is a daily CSV (actually pipe-delimited) report that is generated every morning and transmitted to ValueCentric (data provider). This program is written in Java and run as an Integrator timer job.
sFTP
ValueCentric only accepts connections from whitelisted IPs. I believe our Telus WAN subnet has been whitelisted, or at the very least, both the WAN IPs of bart and superman, so the regular programs can run (it used to run on Bart). This is just something to keep in mind in case you try to either upload the file manually from home (won't work even through VPN) or run the program.
The sFTP connection also requires public key authentication (no password authentication). This private-public key pair was generated by us and the public key was provided to ValueCentric. The name of the key is isvcacct.key, found in the SSH keys folder in superserver\tech\common
Manually running the report
A workflow for this that can be executed by a non-developer is still being worked on. This is because the Class Runner feature in Integrator, which is how you would normally run a one-off job, doesn't accept command line arguments (runtime args), which is needed to instruct the program to generate a report for a specific date. If no argument is supplied, the program generates a report for the previous day, which is of limited use.
An ideal solution will likely involve running the Java program from the command line on the Integrator server, but with the class path pre-set to look in the lib folder. Otherwise, the program's dependencies will not be included. The command will look something like:
C:\Program Files\Java\jdk1.8.0_251\bin\java.exe com.unipharm.integrations.bizreports.GileadDailyActivityReport " " "20210422" Note the format of the date and the fact that it is the second command line argument (args[1])