Index Database

Index your USCF or customized databases in dBase format to enable player searches. Non-dBase databases do not require indexing.

Why Indexing Matters

SwissSys cannot search for players in a dBase database without access to its index files. While you can manually create index files using database creation software, SwissSys provides a built-in indexing command that handles this automatically.

Index files act as a lookup table, allowing SwissSys to quickly find players by name. Without proper indexing, player searches will fail even if the player is in the database.

How Indexing Works

When you run the Index Database command:

SwissSys scans your dBase database file (.dbf format)
Creates index files using the names configured in Database setup
Stores the index files in the same folder as the database
Enables fast player lookups during registration

The index files created depend on your configuration in the Database setup dialog.

Requirements

Database format: Must be dBase (.dbf) format
File location: Index files must be stored in the same folder as the database file
Configuration: Index file names must be properly configured in Database setup (Database → Database setup)

When to Reindex Your Database

Rebuild your database indexes in these situations:

After downloading a new USCF rating database
When setting up a custom dBase database for the first time
When index files become corrupted or missing
After moving database files to a new folder location
When player searches start returning “No match found” errors

Troubleshooting “No Match Found” Errors

If you receive a “No match found” error during player registration but know the player exists:

Step 1: Check Spelling

Verify you’ve entered the player’s name correctly. Try searching with just the last name or a partial match.

Step 2: Reindex the Database

Run the Index Database command to rebuild the search indexes. This resolves most “No match found” errors caused by corrupted or missing index files.

Step 3: Verify Database Configuration

Check that your Database setup configuration points to the correct database file and index names.

Step 4: Contact Support

If indexing doesn’t resolve the issue, the database file itself may be corrupted. Contact support for additional troubleshooting.

Database setup – Configure database paths and index file names
Database troubleshooting – Additional remedies for database issues