Information Systems:Gilead Sales Report (Python)

For the old page, click here:Gilead Sales Report - Old

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.

Important notes:

Gilead uses ValueCentric as their data/analytics provider, so reports are sent to their servers. There is no communication with Gilead servers in this process.

(uwdutils) 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. 1234