AutoSigns is an application designed to automate the following:
- Downloading the Section Schedule Daily Summary from Destiny and creating a sorted/formatted report.
- Creating the signage for classes running. This includes:
- Classroom signs
- Daily Schedules
- PowerPoint slide deck for TV display
These instructions will help you get started with using the application.
The following must be installed:
- Google Chrome
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Word
- Check the box next to the function(s) you would like to use
- Fill in the require fields.
- Click "Start" when ready. The output files will be saved to your "Save Path" location.
- Click "Exit" to close the application.
Note: Runtime may vary depending on the number of days/classes that need the signs to be created for.
These instructions will get you a copy of the project up and running on your local machine for development.
- Python 3.6 - The scripting language used.
- Pandas - Data structure/anaylsis tool used.
- python-docx - Used to create Microsoft Word documents (Classroom signs)
- Selenium - Web crawling automation framework.
- Chrome Webdriver - Webdriver for Chrome browser. Use to control automation with Selenium.
- xlsxwriter - Used to create Microsoft Excel documents (Daily Schedule)
- python-pptx - Used to create Microsoft PowerPoint documents
- PyQt5 - Framework used to create GUI.
- QtDesigner - GUI builder tool.
- PyInstaller - Used to create executable for release.
Run the following command to installer all the required Python modules:
pip install -r requirements.txt
To run the application:
.\AutoSigns.py
The project files includes a batch file (Windows platform only) with commands to run to compile into an executable.
Other development platforms can run the following command in Terminal:
pyinstaller AutoSigns.spec .\AutoSigns.py
You may need to modify the file paths if not in same current working directory.
- Patrick Yu - Initial work - patrickgod1 - UC Berkeley Extension