| Excerpt |
|---|
Chemistry IT's perspective of issues with the stockroom WebApp system and likely order of addressing them as projects |
...
Table of contents
| Table of Contents |
|---|
...
Service providers and related context
| Provider | Realm of focus | Notes |
|---|---|---|
Brightworks <help@brightworks.com>
| High-level integration and work-flow consulting. Stockroom's Quickbooks configuration, function, and use. Quickbooks and related documentation. Both end-user and technical. Quickbooks reports. Quickbooks 2-way connection to the custom stockroom Web App. Consulting on underlying Windows OS and application, including versions, patching, and upgrades. Consulting on backups and security. | Quickbooks running on Windows Server (2013?). Accessed by Stockroom staff via RDP. |
(Was recently Singlebrook. Before that, GORGES, the app. creator.) Hoping for: CIT Custom Web Development <customdev-req> (Use their ticket numbers) | Stockroom (Kiosk) Web App configuration (PHP code, mostly), function, use, and documentation. Stockroom Web App's and related documentation. Both end-user and technical. Consulting on underlying Windows OS and application, including versions, patching, and upgrades. Consulting on backups and security. | Running on Linux CentOS 6, Apache, coded in PHP. Accessed by Stockroom staff, via Admin web page, for select admin functions. Accessed by end-users as primary POS system. |
| Hoping for: AWS | Server hosting. Server security. Q: OS and select application patching and upgrades (Apache, PHP?). How tested/ done?
| See below for current server hosting situation. |
Chemistry IT <ChemIT> (Use their ticket numbers) | First-responders to problems reported about the system. Project management integrating work from above firms for both break-fix and new functionality. Overall functionality, including effective security. Hosting both Windows and Linux servers. And both production and test systems. Performing OS and application patching and upgrades, including testing and roll-back/ restores. Ensuring backup of infrastructure. Ensure backup of current data (within a day?) | Hope: Migrate servers to AWS, or the like. Currently, all servers running within Windows Servers (2013?), within MS HyperV server VMs. Production running on ~4.5+ old server hardware and Synology box. Test running on old, desktop hardware, with limited RAM for their VMs. |
Chemistry IT projects and associated tickets currently in play
| Date started | REQ and INC numbers, and subject line | Comments |
|---|---|---|
CIT Custom Web Development tickets currently in play
...
| Date started | Ticket# and subject line | Comments |
|---|---|---|
| 12/5/16 | Brightworks: Ticket#92516/Please update Singlebrook's GitHub repository for CU Chemistry Stockroom's Linux system w/ PHP code change | Singlebrook's GitHub repository must be updated, and then Oliver informed that this got done. Also, they should update any running test instances, naturally. Chemistry IT staff fixed. Stockroom system had mostly stopped working. Cornell's Kuali (KFS) upgrade over weekend created problem. See also: |
| 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?? | Ticket#88853/CUChem/Chemistry Stockroom - New reports to support NMR sales | (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#.) |
...