Chemistry IT's perspective of issues with the stockroom WebApp system and likely order of addressing them as projects
Brightworks tickets currently in play
| Date started | Ticket# and subject line | Comments |
|---|---|---|
| 12/5/16 | Stockroom system not working. Kuali upgrade over weekend might be contributing factor. | |
| Summer 2016 | Ticket#89702/CUChem/Software Troubleshooting - Kiosk display issues | (Priority 1, of 2) Fix bug in WebConnector (Intuit). Quantity type data not changing in kiosk view when changed in Quickbooks; Example: gallons => liters((Dave presumably has actual date started.) |
| Summer 2016 | ?? | (Priority 2, of 2) Reporting enhancement. Need to create a report for the Stockroom purchases AND one for NMR purchases (Dave presumably has actual date started and ticket#.) |
Usually info regarding completed work gets moved to the following page, under section, "Past issues dealt with, through Brightworks":
And our known issues are parked:
Status, as of November 2016
4 "big" to-do's (projects), listed in the order they are expected to be addressed:
1. Fix bug in WebConnector (Intuit)
Prevents an item's "unit" from being changed in WebApp (Linux), from Intuit Quickbooks (Windows). Customers therefore don't see any units changed within Quickbooks.
- Example: Change from using gallon units to using liter units, for a liquid item.
2.Reporting enhancement.
Stockroom WebApp now accepts NMR charges.
- New reports must be created, or current ones modified, to distinguish Stockroom charges from NMR charges.
3. Update CUWebAuth (Cornell)
Chemistry IT staff expect to update Linux system to the current version of CUWebAuth, once bug and enhancements above are solved.
4. Migrate both Stockroom WebApp system's servers off Chemistry IT server infrastructure.
A hopeful candidate is Amazon Web Services (AWS). A very good opportunity to upgrade both servers' OSes.
- One server is Windows (running Quickbooks), and the other is Linux (running Apache web server, a MySQL DB, and the custom web application code (PHP), and both are connected via Intuit's WebConnector tool.
- Must decide if doing one at a time, or both servers at once.