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.

Currently no one. 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.

Server hosting.

Server security.

Q: OS and select application patching and upgrades (Apache, PHP?). How tested/ done?

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.

8/23/17: Putting this on pause; can re-open via email with both our ticket numbers. Paused while Lulu works the integration issues (v1.0=>1.5=2.0), following the 7.5 hours work Brightworks has done. (I pre-authorized Brightworks another 5 hours, if this gets spooled up again.) See our costs page, too.

Current "1.0" production system, and new "2.0" development system, are both in Amazon Web Services (AWS). See:

• Stockroom 2.0 upgrades - Summer 2017

INC000001836298: Stockroom - Ticket#88853/CUChem/Chemistry Stockroom - New reports to support NMR sales

In play: Secure support for Web App and related PHP coding support. Current effort:

CIT's Custom Web Development (see below)

Then: Get Web App's git repository hosted.

Then: Integrate various changes Lulu made to production (PHP). Fix to (external!) KFS migration problem; bug fix related to QB-to-Web App's MySQL data, enhancement related to QB-to-Web App's MySQL data.

Was: Brightworks: Ticket#92516/Please update Singlebrook's GitHub repository for CU Chemistry Stockroom's Linux system w/ PHP code change

AND

Brightworks: Ticket#89702/CUChem/Software Troubleshooting - Kiosk display issues

AND

Ticket#72537/CUChem/Discovery with Singlebrook: Obtain final snapshot of code improvement suggestions

Michael asks 2017-02-10:

• Why is Flash Active X plugin installed? It appears to be an ancient version. Can it be removed?
• Why is Microsoft Silverlight plugin installed? Can it be removed?
• Currently the server has Office 2013 on it? Would problems be created by moving to Office 2016?

12/12/16

Ticket#88853/CUChem/Chemistry Stockroom - New reports to support NMR sales

Issue: Need to create a report for the Stockroom purchases AND one for NMR purchases.

A consequence of NMR's purchases being added to the system somewhat willy-nilly, I suppose.

Dave started this request with Brightworks around August 2016. No movement made with Brightworks so handed issue to Oliver in December 2016. (Dave presumably has actual date started and original ticket#, if different.) This ticket had been Dave's "Priority 2" (of 2) during those months. This "Reporting enhancement" took a back-seat to Brightworks working on his "Priority 1" for months. (A problem Lulu fixed in hours/ days, with assistance from Oliver.)

Stopgap measure taken:

1/19/17: John sent latest version of Singlebrook's git repository to Oliver. Need to get that hosted, then update it with Lulu's changes.

FULL STOP: Singlebrook no longer available to help! WAS: Singlebrook's GitHub repository must be updated, and then Oliver informed that this got done. Also, they should update any running test instances, naturally.

Code to update: Lulu, Chemistry IT, fixed show-stopping issue due to KFS change, and debugged "WebConnector" issue (which wasn't that!), And added enhancement to Web App. Stockroom system had mostly stopped working. Cornell's Kuali (KFS) upgrade over weekend created problem. See also:

• Known issues and related workflows or work-arounds

(Dave's Priority 1, of 2) Fix bug in WebConnector (Intuit).

Brightworks misdiagnosed issue. Chemistry IT's Lulu found problem within Web App's PHP and fixed the bug.

Issue: Quantity type data not changing in kiosk view when changed in Quickbooks; Example: gallons => liters (Dave presumably has actual date started (~summer 2016.)