Automation Designed As Per Institution's Directions

1- Download class schedule report from EMS

2- Convert it into excel (.xlsx) Format

3- Open the application and load excel file in it

It will remove all the duplications and combine the time slots accordingly

4- Shows the list of rooms and teachers with time. So Start assigning teachers to room until the list of teachers gets empty

5- It will then ask for the day and the session (fall 2022) etc.

6- It will show you button to generate pdf or excel file. Once Clicked both file will get stored on the desktop

Try and close excel file and pdf file before clicking on the button because if any file of same name is opened the software wont work

It is also recommended that set chrome as default PDF Viewer if not then close any opened PDF report first then open another one

In python _with native programming skills

tkinter: For GUI Frontend

FPDF: For PDF Reports

os: For saving files on desktop and launching them

openpyxl: For excel report Reading and Fixing

datetime: To check if given time is already present in previous entries

cryptocode: For license purpose (will expire after certain date mechanics)

etc.

Windows 7 sp1 or above

Required: PDF Reader

Required: Excel File (xlsx) Reader

softwares.rubick.org