🛠ī¸ System Control Dashboard

Environment: Cloud-Connected
🛡ī¸
Safe & Protected Environment None of these administrative actions can harm the application. All real data maintenance is securely performed directly within Google Sheets, which are fully protected by built-in sharing permissions.
🌐 Google Drive Synchronization Tracker Active Link
💃 Dances Catalog Sheet (Instructions) ↗ī¸ Jun 2, 2026, 1:24 PM EDT
📝 Calling Log Sheet (TuesdayEnglish_Master) ↗ī¸ Jun 14, 2026, 11:49 PM EDT
📂 SQLite Database Status Last Rebuild: Jun 15, 2026, 7:24 AM EDT
⏱ī¸ Auto-Sync Check Interval Last Verified: Jun 16, 2026, 11:22 AM EDT
ℹī¸ The home page automatically checks Google Drive modifications every 3 hours and updates in less than 2 seconds if updates are found.
📖 Administrator Maintenance & Spreadsheets Guide

Access a friendly, step-by-step catalog guide detailing Google Sheets setups, caller mapping directories, and tips for inserting weekly logs at the top of the spreadsheet to avoid scrolling.

Open Guide
🔄 Update: Reload the Database

Completely drops and repopulates all tables from scratch (Callers, Dances, Series, and Calling Logs). Use this when any changes are made to the Google spreadsheets that contain all the data: adding new caller logs, new callers, series codes, or importing new dances to your Dances Catalog Sheet (Instructions).

Run Update
⚠ī¸ View Sync Errors Table

Inspect the errors logs to identify any misspelled dance names or unregistered callers inputted into the spreadsheets during recent updates.

Show Errors
🗄ī¸ Recreate Tables Schema

Drops and recreates the SQLite database structures completely from scratch, then automatically reloads all data from the Google Sheets. This fully refreshes the schema and spreadsheets in under 2 seconds. You should hardly ever need to run this.

Recreate DB