Skip to Content
SwissSys UsageUser GuideRegistrationDatabase Menu

Database Menu

The Database menu controls all aspects of using player databases with SwissSys, from initial setup to ongoing maintenance.

Database Benefits

Setting up a database provides significant benefits:

  • Save Time: Look up player IDs, ratings, and membership status instantly
  • Reduce Errors: Eliminate manual data entry mistakes
  • Verify Membership: Check expiration dates automatically
  • Multiple Federations: Support USCF, CFC, and FIDE databases
  • Flexible Formats: Work with modern binary or legacy formats

Quick Start

For most users, the best starting point is:

Database Wizard - Quick automatic setup for USCF, CFC, or FIDE databases

See Database Overview for a complete introduction to databases in SwissSys.

Database Menu Options

Setup and Configuration

Access: Database > Database wizard…

Quick setup for official federation databases with automatic configuration.

Best for:

  • First-time database setup
  • Downloading latest USCF, CFC, or FIDE databases
  • Quick configuration with sensible defaults

See Database Wizard for step-by-step instructions.

Database Setup (Advanced)

Access: Database > Database setup…

Advanced configuration for custom databases and special requirements.

Best for:

  • Custom database formats
  • Manual field mapping
  • Working with legacy files
  • Primary and secondary database configuration

See Database Setup for detailed configuration options.

Download Federation Databases

Download and configure US Chess Federation database with ~450,000 players.

🇺🇸USCF Database

Download and configure Chess Federation of Canada database.

🇨🇦CFC Database

Download and configure international FIDE database.

🌍FIDE Database

Work with older dBase, Access, Excel, and CSV databases.

📁Legacy Formats

Database Creation and Updates

Create Index

Access: Database > Create index…

Create search indexes for dBase (.dbf) databases to enable fast player lookups.

See Index Database for instructions.

Binary format databases (.rbin.gz) do not require index files. This option is only needed for legacy dBase formats.

Make Joint USCF Database

Access: Database > Make joint USCF database…

Combine multiple USCF database files into a single joint list.

See Make Joint USCF Database for details.

Create/Update Database

Access: Database > Create or update database…

Create a custom database or update an existing one with player data from your tournaments.

See Create/Update Custom Database for instructions.

Update Club from Database

Access: Database > Update club from USCF database…

Refresh club information for players using data from the USCF database.

See Update Club from Database for details.

Player Management

Load Players from Database

Access: Database > Load section from database…

Import an entire section of players from your database into the current tournament.

See Load Section from Database for instructions.

Confirm Ratings from Database

Access: Database > Confirm ratings from database…

Verify and update player ratings and membership information from your configured database.

See Confirm Ratings from Database for details.

Database Maintenance

Swap Primary and Secondary Databases

Access: Database > Swap primary and secondary databases

Exchange your primary and secondary databases instantly.

See Swap Primary and Secondary Databases or Secondary Database Use for details.

Database Cleanup

Access: Database > Database cleanup…

Remove unwanted or duplicate records from your custom database.

See Database Cleanup for instructions.

Supported Database Formats

SwissSys supports multiple database formats for flexibility:

FormatExtensionUse Case
Binary.rbin.gzModern USCF/CFC databases (recommended)
Text.txtFIDE databases
dBase.dbfLegacy USCF databases
Access.mdb, .mdeLegacy CFC databases, custom databases
Excel.xls, .xlsxCustom player lists
CSV.csvLegacy CFC databases, custom exports

See Legacy Database Formats for details on older formats.

Common Database Workflows

First-Time Setup

Choose Database Type

Decide which federation database you need (USCF, CFC, or FIDE).

Run Database Wizard

Go to Database > Database wizard…

Select and Download

Choose your database type and download the latest version.

Test Configuration

Register a player and test the database search function.

See Database Wizard for detailed walkthrough.

Using Two Databases

Set Up Primary

Configure your primary database using the Database Wizard.

Set Up Secondary

Run the wizard again with “Apply this to the secondary database” checked.

Switch Between Them

During registration, search primary first, then switch to secondary if needed.

See Secondary Database Use and Examples for common configurations.

Updating Your Database

Run Database Wizard

Go to Database > Database wizard…

Select Same Type

Choose the same database type you currently use.

Download Latest

Select “Yes” to download and choose your install location.

Overwrite Existing

The wizard will update your database file with the latest data.

Update Frequency: USCF updates monthly, FIDE updates monthly, CFC updates periodically. Download fresh databases before major tournaments.

Troubleshooting

For database-related problems, see:

See Also

Last updated on
Database Cleanup - Database MenuDatabase Overview
See something that needs updating? .