Project Summary
Just Another Relatively Very Intelligent System, for Bailey’s Wagon LLC
Wonkish Geek Leet Speak Warning…
A few people have asked for some details of my latest project:
To help avoid the problem of customer “purchases” of out-of-stock items, this business needed to develop a low cost automated stock checking system. BW unhappily experienced this problem on two occasions, and it was very uncomfortable both times… So, in short, the project is a bespoke (custom developed) small business automation server. Gave it the not so original name JARVIS
(Newegg.com is the primary source for the required hardware.)
(All operating & development software is Open Source acquired directly from managed standard Open Source projects on the internet.)
The hardware consists of low-cost:
- White DIYPC J180-W ATX Mid Tower Case.
- ASRock H97 Pro4 Motherboard.
- Intel Haswell Core i5-4690S Quad-Core 3.2 GHz CPU with integrated Intel HD Graphics GPU.
- Mushkin ECO2 (economy) 16GB (2 x 8GB) DDR3L 1600MHz Memory.
- 500GB SAMSUNG 850 EVO 2.5″ SSD
- CRYORIG M9i CPU Cooler
- RAIDMAX RX-535AP-S 80-PLUS-BRONZE Modular Power Supply (ready for future expansion)
- Using previously purchased monitor mouse and keyboard.
- A UPS box (battery backup power) will be added soon.
The Open Source Software:
- Operating System: Linux Mint 18. Might switch over to CentOS 7 (community version of Red Hat Enterprise Linux)
- Development Platform:
- Primary Programming Language: Python 3.5 (Anaconda 4.2 distro.)
- Integrated Development Environment: Spyder 3.0 .
- Version Control System: Git 2.7.4 .
- Source Code Cloud Repository: BitBucket.com is used for the secure remote Git repository.
- Web and DataBaseServer Development Stack: XAMMP .
Initial Implemented programmed business automation:
- Written in Python, “Stockchecker” runs on a predefined schedule. It automatically browses and navigates warehouse vendor’s website to retrieve current product stock status ques, then compares the warehouse stock status against retail listed status for products from a local MySQL database, then sends email and SMS alerts for any important changes in actual stock status.
- Linux Cron is used to schedule daily “Job” runs