public-clubsy

Players Placeholder Import via Template (CSV)

This import creates pre-registered invitations (pre_registered = true) in the invitations table. It does not insert directly into team_members.

Goal

Enable bulk load of players or staff not yet registered in the app, using the same manual placeholder approach.

CSV Template

Use as base:

• players_placeholder_import_template_en.csv

Columns:

• full_name (required)
• email (required if phone is not present)
• phone (required if email is not present)
• role (optional, default player)
• notes (optional)
• jersey_number (optional)
• position (optional)
• dominance (optional)
• jersey_name (optional)
• medical_info (optional)
• federation_license (optional)

App Flow

1. Go to team management (Manage Team).
2. Click Import players.
3. Select CSV file.
4. Confirm import.
5. Review summary (inserted, skipped, error).

Dedupe and Validations

The RPC applies row-level validations:

• full_name is required.
• email or phone must exist.
• role must exist in the roles table (otherwise row error).
• If a pending placeholder already exists for the same team and contact (email or phone), the row is marked as skipped.

Result

A row-by-row list is returned with:

• row_no
• status (inserted, skipped, error)
• message
• invitation_id (if applicable)

Notes

• Final link to a registered user happens in the normal invitations/claim flow.
• This import is compatible with the existing pre-registration approach.