Data Import

Upload CSV files to bulk import your data

Import Complete Roster

Upload a single CSV containing all clubs, providers, and attendees. The system will automatically create or update all records and link them correctly.

⚠️ Important: Fields with commas MUST be wrapped in quotes

Example: If a provider name is "ABC, Inc." it should be quoted in your CSV. Most spreadsheet software does this automatically when exporting to CSV.

Required columns: club_name, provider_name, first_name, last_name

Weekly Delta Import

Smart Dedup

Upload the weekly CSV from your Dev. Same format as the roster — the system will skip anyone already in the database (matched by email) and only add new attendees.

  • Builds an in-memory email index from all existing attendees first
  • Skips duplicates instantly — no slow per-row queries
  • Only inserts truly new attendees (~50–100 per week)
  • Also creates any new clubs/providers found in the file

Normalize Email Addresses

Converts all stored attendee emails to lowercase so searches work regardless of how users type their email (e.g. Timothy.Onstad@clubassist.com → timothy.onstad@clubassist.com). Run this once after your initial import.

Clear Data (Use if re-importing)

If you need to re-import data, clear Providers and Attendees first (keep Clubs). This removes any incorrectly linked data.

How It Works

  • Upload one CSV with all your data
  • Clubs and Providers are automatically created or updated
  • Attendees are linked to their correct Club and Provider
  • Safe to re-run - existing records are updated, not duplicated