Check daily PZS for failures, create email report. Can check past PZS as well. When the admin mode is activated this program will execute and analysis of the last two weeks (and month) of PZSs. It generates an email that contains a list of warnings and failures for the last two weeks PZSs. It will highlight the ones that were run that day. The most important part of the email is where it shows month based PZS gaps, and any gaps in the last two weeks or seven days.
Just download the latest version here. The source coed will be included, but a stand alone binary file will also be provided which will not require the user to have python or a python IDE installed.
-need the right driver for you MS SQL Server. I am using 'ODBC Driver 17 for SQL Server' https://www.microsoft.com/en-us/download/details.aspx?id=56567
No installation needed. Just download the .exe and run it.
You can test the application by clicking run with the "Send Email" checkbox checked. This will send an email to me at bcubrich@utah.gov by default, so to perform the test you will want to change the "Preview Email:" entry field to your own email.
This will test the server connection, email connection, and the integrity of the download of the script.
Python - Entire Scirpt
Pandas
MIMEtext
tkinter
numpy
pyodbc
datetime
BeautifulSoup
Versioning method undetermined at this time. Update soon. Currently just releasinf the first stable version as V1.
- Bart Cubrich - Initial work
*Phil Harrison
- Krisy Weber