Visa Appointment Booker

Overview

Automated booking system for US visa appointments that monitors availability in real-time and books slots through browser automation. Helps users secure appointment times without manual competition for limited availability.

Objectives

• ▸ Automate US visa appointment booking process
• ▸ Monitor appointment availability in real-time
• ▸ Reduce manual effort for securing desirable time slots
• ▸ Handle multiple visa types and locations
• ▸ Support captcha solving for automated submission

Architecture

Django web application with modular app structure (bookings, users, core). Selenium WebDriver handles browser automation for the visa website. SQLite database stores appointments and user configurations. Django REST Framework provides API capabilities.

Key Features

• ▸ User authentication and profile management
• ▸ Appointment type and location selection
• ▸ Real-time slot monitoring with database tracking
• ▸ Browser automation for form filling and submission
• ▸ Captcha handling (manual screenshots and automated)
• ▸ Status tracking (pending, confirmed, cancelled)
• ▸ Django Admin interface for oversight

Challenges

• ▸ Fragile Selenium automation dependent on website structure
• ▸ Captcha solving requiring human intervention
• ▸ Website changes breaking automation unexpectedly

Outcomes

• ▸ Functional appointment booking automation
• ▸ Real-time monitoring capabilities
• ▸ User management with admin oversight