Information Systems:Gilead Sales Report - Old - Revision history

Norwinu at 18:54, 7 June 2018

2018-06-07T18:54:03Z

2018-06-07T18:49:40Z

2018-06-07T18:47:05Z

2018-06-05T16:56:47Z

2017-05-16T20:44:53Z

sFTP Transmission

2017-05-16T20:42:17Z

To-do

2017-05-16T20:40:23Z

NC_GILREP (RPG)

2017-05-16T20:37:07Z

2017-05-16T20:34:48Z

2017-05-16T20:31:37Z

IFS files and folders

← Older revision		Revision as of 18:54, 7 June 2018
Line 1:		Line 1:
		+	{{quote\|This program has been re-factored in Python, refer here: [[Information Systems:Gilead Sales Report\|Gilead Sales Report]]}}
	=Overview=		=Overview=
	Gilead requires daily sales and inventory reporting from uniPHARM, so a solution needed to be developed to generate and transmit such reports according to their specifications. This endeavor was a greenfield project of sorts, in that it was developed from scratch and comprises new techniques, all of which will be discussed here. This article represents the documentation for this solution.		Gilead requires daily sales and inventory reporting from uniPHARM, so a solution needed to be developed to generate and transmit such reports according to their specifications. This endeavor was a greenfield project of sorts, in that it was developed from scratch and comprises new techniques, all of which will be discussed here. This article represents the documentation for this solution.

← Older revision		Revision as of 18:49, 7 June 2018
Line 55:		Line 55:
	* Create PASE page.		* Create PASE page.

		+	[[Category: Archived Pages]]
−	'''[norwinu@BART /uwdsrc/uwdutils] python3 gilead_852csv.py -h'''
−	usage: gilead_852csv.py [-h] [-f --force] [-d --date DATE]
−	[-s --supplier SUPPLIER]
−
−	Run daily sales report for Gilead.
−
−	optional arguments:
−	-h, --help show this help message and exit
−	-f --force Bypasses one-run-per-day check and forces program to
−	run
−	-d --date DATE Date report will be generated for, in format YYYYMMDD
−	e.g. 20180501
−	-s --supplier SUPPLIER
−	5-digit uniPHARM customer number e.g. 12345
−
−
−	[[Category: Programming/Development]]

@@ Line 54: / Line 54: @@
 * Specify which libraries the source and program objects are in.
 * Create PASE page.
 [[Category: Programming/Development]]

@@ Line 37: / Line 37: @@
 ==sFTP Transmission==
-To date, there already exists several B2B communications on the i, but a) it is all done via FTP and b) it is mostly in a pull configuration (i.e. downloading files). sFTP transmission, as required by ValueCentric, cannot use the built-in FTP client on the i, because it involves a different protocol (SSH) altogether, while the FTP client on the i is for basic FTP transmission. IBM i does have sFTP functionality, but this is offered as a PASE utility ([[Information Systems: PASE on IBM i | read more about PASE here]]).
+To date, there already exists several B2B communications on the i, but a) it is all done via FTP and b) it is mostly in a pull configuration (i.e. downloading files). sFTP transmission, as required by ValueCentric, cannot use the built-in FTP client on the i, because it involves a different protocol (SSH) altogether, while the FTP client on the i is for basic FTP transmission. IBM i does have sFTP functionality, but this is offered as a PASE utility ([[Information Systems: PASE on IBM i |read more about PASE here]]). Running it is thus a different process (it's not directly via command-line, instead must execute in QSH).
 ===Key authentication===
 The sFTP client on the i does not allow for password authentication when run in batch (only interactive), so key-based authentication is being used instead. The following steps were taken to facilitate this:

@@ Line 51: / Line 51: @@
 =To-do=
-* Specify which libraries are involved
+* Specify which libraries the source and program objects are in.
 * Create PASE page.

@@ Line 22: / Line 22: @@
 # Cleans up old reports by moving them to the archive folder.
 # (Disabled) Emails admin upon successful run of program.
 ===File format and layout===

@@ Line 47: / Line 47: @@
 * The Archive folder contains report files for previous dates.
 * The Log folder contains log files for the report run and connectivity.
 [[Category: Programming/Development]]

← Older revision		Revision as of 20:34, 16 May 2017
Line 47:		Line 47:
	* The Archive folder contains report files for previous dates.		* The Archive folder contains report files for previous dates.
	* The Log folder contains log files for the report run and connectivity.		* The Log folder contains log files for the report run and connectivity.
		+
		+	[[Category: Programming/Development]]

← Older revision		Revision as of 20:31, 16 May 2017
Line 44:		Line 44:
	==IFS files and folders==		==IFS files and folders==

−	The files are in '''/UWD Staging/Reports/Gilead/'''	+	* The report files are in '''/UWD Staging/Reports/Gilead/'''. There should be two .txt files (867 & 852) with a datestamp of the current day, but with a filename of the previous day (i.e. report is generated the following day)
		+	* The Archive folder contains report files for previous dates.
		+	* The Log folder contains log files for the report run and connectivity.