Just Another Relatively Very Intelligent Business Automation Server


Project Summary
ust 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

Jim Foust

Leave a Reply