Information Systems:Gilead Sales Report - Revision history

Jeremym at 20:16, 10 November 2022

2022-11-10T20:16:15Z

Jeremym at 20:15, 10 November 2022

2022-11-10T20:15:20Z

Jeremym at 20:14, 10 November 2022

2022-11-10T20:14:03Z

Jeremym at 19:31, 10 November 2022

2022-11-10T19:31:10Z

Norwinu at 23:17, 28 April 2021

2021-04-28T23:17:46Z

Norwinu at 23:08, 28 April 2021

2021-04-28T23:08:40Z

Norwinu: Created page with "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 writte..."

2021-04-28T23:08:32Z

Created page with "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 writte..."

New page

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 parameters, of which the report date (the date you want to run the report for) is the first one e.g. args[1]. Note that this is not args[0], or the zeroth argument.

[[Category: Reports]]

← Older revision		Revision as of 20:16, 10 November 2022
Line 54:		Line 54:

	[[Category: How-to pages]]		[[Category: How-to pages]]
		+	[[Category: Reporting]]

← Older revision		Revision as of 20:15, 10 November 2022
Line 52:		Line 52:
	Additional instructions can be found here:		Additional instructions can be found here:
	\\Superserver\Tech\Common\Gilead Daily Sales Report\SFTP Profile\Manually Connecting with ValueCentric via SFTP.docx		\\Superserver\Tech\Common\Gilead Daily Sales Report\SFTP Profile\Manually Connecting with ValueCentric via SFTP.docx
		+
		+	[[Category: How-to pages]]

@@ Line 21: / Line 21: @@
  \\Superserver\Tech\Common\Gilead Daily Sales Report\File Specs\VT Standard File Layout - 852 short form 2015.doc
-I use a template created in excel to help fill in the values as it's easier to work with. The template has all the column headers and includes the item numbers in Column A to make it easier to fill in the values.  The template comes prefilled with data but should be replaced with the appropriate data needed to make the file that you're making.  Columns G through Q need to be updated with the new data minus column O, which can stay the same.
+I use a template created in excel to help fill in the values as it's easier to work with. The template has all the column headers and includes the item numbers in Column A to make it easier to fill in the values.  The template comes prefilled with data but should be replaced with the appropriate data needed to make the file that you're making.  Columns G through Q need to be updated with the new data minus column O, which can stay the same.  I use the InfoNet program Item Transaction Tracking found in Inventory under the uniVIEW section.
  \\Superserver\Tech\Common\Gilead Daily Sales Report\Manual File Generation Templates\Gilead Daily Sales File Excel Template.xlsx
 Once the data is accurate the easiest way to create the file is to:
@@ Line 32: / Line 40: @@
 . Select Replace from the Edit menu and put a comma (,) in the Find what box and a pipe (|) in the Replace with box and the select Replace All and then close the Replace dialog box.
 . From the file menu choose Save As and save the file using the same file name but this time as type .txt file.

← Older revision		Revision as of 19:31, 10 November 2022
Line 12:		Line 12:

	<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])		<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])
		+
		+
		+	===How to Manually Run Report and Manually send the file via SFTP===
		+	If there is a problem with the daily Gilead sales report that is sent to ValueCentric you can rerun the Integrator process that generates the file and sends it to ValueCentric as long as it's the same day. The program is preconfigured to only produce a file for the previous day. If you need to generate a file from an earlier day, then the only way to do this is to manually create the file.
		+
		+	To manually create a file, I generally use the previous days file as a guide to help make sure the values make sense. The report needs to be created as per the file specs which can be found here:
		+
		+	\\Superserver\Tech\Common\Gilead Daily Sales Report\File Specs\VT Standard File Layout - 852 short form 2015.doc
		+
		+	I use a template created in excel to help fill in the values as it's easier to work with. The template has all the column headers and includes the item numbers in Column A to make it easier to fill in the values. The template comes prefilled with data but should be replaced with the appropriate data needed to make the file that you're making. Columns G through Q need to be updated with the new data minus column O, which can stay the same.
		+
		+	\\Superserver\Tech\Common\Gilead Daily Sales Report\Manual File Generation Templates\Gilead Daily Sales File Excel Template.xlsx
		+
		+	Once the data is accurate the easiest way to create the file is to:
		+	1. Delete column A as it's not part of the file spec and is just there for reference.
		+	2. Delete row 1 the header row as it's not part of the file spec and is just there for reference.
		+	3. Save as a .csv file and use the following filename convention: man852_uniPHARM_yyyymmdd_VC155 where the date is the date of the report
		+	4. Close the newly created .csv file and open it with notepad.
		+	5. Select Replace from the Edit menu and put a comma (,) in the Find what box and a pipe (\|) in the Replace with box and the select Replace All and then close the Replace dialog box.
		+	6. From the file menu choose Save As and save the file using the same file name but this time as type .txt file.

← Older revision		Revision as of 23:17, 28 April 2021
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 ~~parameters,~~ of ~~which~~ ~~the~~ ~~report~~ ~~date~~ ~~(the~~ ~~date~~ ~~you~~ ~~want~~ to ~~run~~ ~~the~~ report for) is ~~the~~ ~~first~~ ~~one~~ ~~e.g.~~ ~~args[1].~~ ~~Note~~ ~~that~~ ~~this~~ is ~~not~~ ~~args[0],~~ or the ~~zeroth~~ ~~argument~~.	+	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])

← Older revision		Revision as of 23:08, 28 April 2021
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 parameters, of which the report date (the date you want to run the report for) is the first one e.g. args[1]. Note that this is not args[0], or the zeroth argument.	+	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 parameters, of which the report date (the date you want to run the report for) is the first one e.g. args[1]. Note that this is not args[0], or the zeroth argument.
−
−	[[Category: Reports]]