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/1/16 | Ticket#92412/Non-authorized Quickbooks server remote connection to production system | Oliver initiated |
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.