ChatBot Admin

Dashboard, exports, backup/restore, and CSV upload for RegattaNetworkData.

Health & connectivity

Test database and OpenAI before using the dashboard or Chatbot.

Debug

Table and row count. Check the browser console (F12 → Console) for full response and any errors.

—

Table

—

Record count

—

Unique sailors

—

Unique regattas

—

Unique clubs

—

Date range

—

Download distinct lists

CSV files of all unique values. Use to check for duplicates or bad data (e.g. spacing, typos).

All sailor names All club names All regattas

Cleanup invalid data

Set yacht_club to "Unknown" where it doesn't start with a letter (e.g. race results in wrong column).

Export filtered data

Apply filters and download CSV for validation.

Skipper

Boat name

Yacht club

Regatta

Year

Backup & restore

Backup: download full table as CSV. Restore: upload CSV to replace or append.

Replace existing data (truncate before restore)

Upload CSV (new results)

Upload a CSV of regatta results. Columns: regatta_name, regatta_date, category, position, sail_number, boat_name, skipper, yacht_club, results, total_points. Missing yacht_club → "Unknown".

Chatbot ChatBot (Legacy) Find Regatta Home