autoBooker

TimeEdit autoBooker script

Installation

Make sure that the pip path is the same as python install path.
https://nomodulenamed.com/a/I-have-installed-the-package-using-pip

python3 -m pip install pyautogui
python3 -m pip install pynput
python3 -m pip install gspread

Usage

Put preferred rooms in preferredRooms.csv, one room per line.

A2 071
C3 090
C3 091
C3 092
A2 043
D3 060
D3 061

File structure/hierarchy

1. autoBooker.py - Main

• selectDay.py - Try next room in preferredRooms.csv list if the top preferred room is already booked.
• scan.py - Function to completely scan the day block to be booked in TimeEdit.
  • RGBchecker.py - Check if room is already booked. Used by scan.py
• sheets.py - Google Sheets integration → interts booking data to spreadsheet.
• dualUserBooking.py - Second user booking function

Backlog

• Initial concept!
• Avoid already booked rooms detection
• If room is already booked: choose new room from a list of preferred rooms
• Dual user booking
• Automatic Google Sheets integration (Sheets API)
• Automatic Google Calendar integration (Calendar API)

Check number of code lines

cd /home/pi/autoBooker/
git ls-files | xargs wc -l

Checkpoints:

1. 15.02.2021 → 471 lines of code
2. 05.03.2021 → 635 lines of code
3. 22.03.2021 → 937 lines of code