This program will update the quantity in master inventory with the quantity found in supply inventory based for each part in master inventory
-
The default filenames that program accepts are:
- "SupplyInventory.csv" for the supply list
- "MasterInventory.csv" for the master list
-
You can set your own filenames but you must specify their name and location in command line arguments
- See how to use command line arguments below
-
Both csv files must include the following columns:
VenCode PartNumber TotalQty
There is currently no error handling.
Play nice.
Use proper csv files with proper columns.
To run this program in command line...
First, make sure you download and install python if you haven't already.
-
with the default filenames
Place your csv files into the same directory as query.py
and rename them "SupplyInventory.csv" and "MasterInventory.csv"python3 query.py
-
with custom filenames or paths using command line arguments
python3 query.py supply-list-name.csv master-list-name.csv