PZS_Manager_V126

I have not updated the source code as it has to be redacted for sensitive information before release, but the .exe contained herein is updated for several aspects. First, we upgraded to the MS SQL server 2017. This required new drivers for querying the database, which had to be coded into python, as well as some changes to the login information, and the IP address of the serves had to be updated as well. This coincided with several other changes that I made. First, I changed the automatic email trigger to trigger in UTC time because the station computers are on MST, and do not observe DST. This causes problems when DST hits. In, UTC there is no such problem, and the emails will go out at 5:30AM MST and 6:30AM DST. I also added a second automatic email to come out 2 hours later because some of the PZSs are not finished running until 5:10AM. This means they miss the 5AM server upload, and won't be available to be queried until sometime around 6:00-6:30 AM (MST). Also, any internet connectivity issues can cause the PZSs to miss the bus to the MS SQL Server at MASOB. The later email that will go out at 7:30MST/8:30DST should catch most of these. Price and Erda sometime have longer lasting issues, but that can't really be controlled for.

Operator Friendly Formatting

This release contains various bug fixes, but was primarily produced to create an email output that is easier for the operators to leave. This contains the old source code. Waiting to redact aspects of it to release the correct source code.

PZS_Manager_v1.0.0

First working version of the app. Successfully queries utah deq air vision database and send email to appropriate people with a report of analysis findings. Some information is redacted in the source code.