Harmobot Calendar Integration

Status: Beta - Local Development Version

Automated system for syncing student council work schedules from Excel files to Google Calendar events.

Overview

This tool parses Harmobot harmonogram (Excel schedule files) and creates Google Calendar events for each person's assigned time slots. It's designed to integrate with existing student council infrastructure.

Migration Plan: This project will be migrated to the open-source Salata-WRSS-WIET (schej-it/timefullap) platform built in GoLang.

Features

• 📊 Parses Excel schedule files with automatic slot merging
• 🔄 Converts person aliases to email addresses (with SQLite caching)
• 📅 Generates Google Calendar events with reminders
• ✉️ Sends calendar invites to assigned people

Quick Start

Prerequisites

pip install pandas openpyxl google-auth-oauthlib google-api-python-client

Setup

1. Google Calendar API credentials:

   • Create a project in Google Cloud Console
   • Enable Google Calendar API
   • Download credentials.json → place in token/ folder

2. Prepare your schedule:

   • Excel file with structure: Godzina column + date columns + person names in cells

3. Run:

   python main.py

Project Structure

├── data/
│   ├── plan.xlsx              # Input schedule file
│   └── xlsx_scrapper.py       # Excel parser
├── name_to_email/
│   ├── email_resolver.py      # Alias → email resolver
│   └── users.db              # SQLite cache (auto-created)
├── token/
│   ├── credentials.json       # Google API credentials (not in repo)
│   └── token.pkl             # OAuth token (auto-generated)
├── convert_slots_to_events.py # Slot → Calendar event converter
├── event_sender.py            # Google Calendar API client
└── main.py                    # Main pipeline

How It Works

1. Parse Excel → Extract person names and time slots per date
2. Merge Slots → Combine consecutive time blocks
3. Resolve Emails → Convert aliases to email addresses (prompts if unknown)
4. Generate Events → Create Google Calendar event objects
5. Send → Batch insert to Google Calendar with email invites

Configuration

Edit convert_slots_to_events.py to customize event details:

• Summary/title
• Description
• Location
• Reminder settings (default: 60min email, 10min popup)

Notes

• First run requires Google OAuth authorization (browser popup)
• Unknown aliases trigger interactive email input (cached for future use)
• Events are sent to primary calendar with sendUpdates='all'
• Beta version - local development only

Future

This codebase is a proof-of-concept. Production deployment will migrate to the GoLang-based Salata platform for better performance and maintainability within the student council ecosystem.

---

Contributing: Issues and PRs welcome for the beta version. For production features, see the Salata repo.