Created in Python3 by Drew Cannedy, (dxc142830@utdallas.edu)
- Open Windows Explorer and place the 'Journals' folder directly in "Local Drive (C:)"
- Place the NanoWeb_Journal_Helper folder anywhere you like. (I keep mine on my Desktop)
- Open the emails.txt file in the 'Journals' folder.
- Replace the first line with your first and last name
- Go to the 'NanoWeb_Journal_Helper' folder
- Open the 'Dist' folder and doubleclick on the NanoWeb_Journal_Helper.exe
- Enter the folder name of the Journal month you would like to use, such as 2018-01 etc
- Click the button for whatever action you want to take
This will remove all excel sheets with a total of $0 and delete excel files without any sheets
This will email every professor who has an attachment in the folder entered. The emails.txt file contains emails for professors who I have sent an email to before. You may need to add a new professor someday. To do so, start a new line.
The format for the line is Firstname Lastname, email, ccemail(if any)
Make sure the first name and last name are as they appear in the excel files for all emails, leave off the 'utdallas.edu' part. You can include any ammount of CC emails, just make sure to seperate them with ','
This will create the report to send to OPM, and a template for how you will fill out the JRNL1 It creates an excel file named 'copy' in the JRNL1 folder. After, copy this file and rename it to 'NanoWeb_Month_Year' and put it in the journals folder NEVER DELETE OR REMOVE the copy file or it will not create the monthly report