How yatish-balu/roll_call works
RollCall AI turns attendance spreadsheets and sheet photos into validated, four-state attendance records, summaries, and downloadable reports; it also supports safe database queries. The main user path runs through the dashboard and agent, which coordinates extraction, validation, confidence checks, summarization, and optional export. SQLite persists institutional and attendance data. The README documents these stages and capabilities; sampled source confirms several calls and storage behaviors, while some unsampled implementation links are omitted.
Main entry points: agent.py Attendance agent · ui.py Streamlit dashboard · read_photo_tool.py Photo extraction · summary_tool.py Attendance summaries
Components 18
User interaction
- Streamlit dashboard
app/ui.py - FastAPI entrypoint
app/main.py
Agent orchestration
- Attendance agent
app/agent.py - Agent demo
demo_agent.py
Attendance processing
- CSV ingestion
tools/read_csv_tool.py - Photo extraction
tools/read_photo_tool.py - Record validation
tools/validate_tool.py - Attendance summaries
tools/summary_tool.py
Persistence and queries
- Safe query tools
tools/query_tool.py - Database utility
tools/database.py - Attendance CRUD
app/db/crud.py - SQLite connections
app/db/connection.py - Database schema
app/db/schema.py - Attendance database
Reporting
- Excel and PDF export
tools/export_tool.py
Other components
- Institutional user
- Gemini vision
- EasyOCR fallback
Connections 22
- Institutional user → Streamlit dashboard: uploads and queries
README.md - Institutional user → FastAPI entrypoint: uses REST API
README.md - Streamlit dashboard → Attendance agent: submits requests
app/ui.py - Streamlit dashboard → Attendance CRUD: loads sessions
app/ui.py - Attendance agent → CSV ingestion: dispatches reads
app/agent.py - Attendance agent → Photo extraction: dispatches extraction
app/agent.py - Attendance agent → Record validation: validates records
app/agent.py - Attendance agent → Attendance summaries: computes summaries
app/agent.py - Attendance agent → Safe query tools: dispatches queries
app/agent.py - Attendance agent → Excel and PDF export: requests exports
app/agent.py - Photo extraction → Gemini vision: tries vision backend
tools/read_photo_tool.py - Photo extraction → EasyOCR fallback: falls back to OCR
tools/read_photo_tool.py - Record validation → Attendance summaries: gates summarization
README.md - Attendance summaries → Excel and PDF export: provides summary data
tools/export_tool.py - Safe query tools → Attendance database: reads records
tools/query_tool.py - Attendance CRUD → SQLite connections: opens connections
app/db/crud.py - SQLite connections → Attendance database: connects to
app/db/connection.py - Database schema → SQLite connections: initializes through
app/db/schema.py - Database schema → Attendance database: defines tables
app/db/schema.py - Database utility → Attendance database: manages database
- Agent demo → Attendance agent: demonstrates usage
demo_agent.py - Agent demo → Attendance CRUD: uses database helpers
demo_agent.py