Bulk Import Boxers

This guide explains how to import multiple boxers at once using an Excel or CSV file.

Prerequisites

• You must have admin or licensing permissions for your club
• Prepare your boxer data in the correct format (see below)

Step-by-Step Guide

Step 1: Access the Bulk Import Feature

1. Navigate to your club’s Boxers page
2. Look for the three-dot menu icon (⋮) in the top-right corner
3. Click on Bulk add from the dropdown menu

Step 2: Prepare Your Data

Create an Excel (.xlsx, .xls) or CSV file with the following columns in this exact order:

Important notes:

• The first row should contain column headers
• All fields are required
• Date must be in YYYY-MM-DD format
• Weight will be automatically rounded to the nearest whole number
• Gender must be exactly “male” or “female” (lowercase)

Step 3: Import Your File

1. In the bulk import dialog, click Choose File
2. Select your prepared Excel or CSV file
3. Wait for the file to be processed

The system will automatically:

• Parse your file
• Display all boxers in an editable table
• Highlight any invalid entries in red
• Show duplicate warnings in yellow

Step 4: Review and Edit

After importing, you can:

• Review all entries in the table
• Edit any field by clicking on it
• Add more rows manually using the ”+ Add” button
• Delete rows using the trash icon on each row
• See validation errors - invalid rows are highlighted in red
• See duplicate warnings - possible duplicates are highlighted in yellow with a warning icon

Step 5: Handle Duplicates

The system automatically detects potential duplicates based on:

• First name
• Last name
• Gender
• Date of birth

If duplicates are detected:

• You’ll see a warning count at the top: “Warning: X duplicates”
• Duplicate rows are highlighted in yellow
• Hover over the warning icon (△) to see details
• You can choose to proceed anyway or remove the duplicates

Step 6: Submit

1. Review the counter showing valid entries: “Add X/Y boxers”
   • X = number of valid entries
   • Y = total number of rows
2. Click the Add X/Y boxers button
3. If duplicates exist, you’ll see a confirmation dialog
4. Confirm to proceed or cancel to review

Step 7: Completion

• Valid boxers will be created
• You’ll see a success message
• The dialog will close
• The boxer list will refresh with the new entries

Troubleshooting

Invalid entries not being accepted

Problem: Some rows are highlighted in red and won’t be submitted.

Solution: Check that all required fields are filled:

• First and last name must not be empty
• Date of birth must be valid (YYYY-MM-DD format)
• Gender must be “male” or “female”
• Weight must be a valid number
• Number of matches must be a valid number

Weight values not exact

Problem: Weight values are different from what I entered.

Solution: This is normal. The system automatically rounds weights to the nearest whole number (e.g., 75.5 becomes 76).

Duplicate warnings

Problem: I’m seeing duplicate warnings but these are different boxers.

Solution: The system detects duplicates based on name, gender, and date of birth. If two boxers have identical information in these fields, they’ll be flagged as potential duplicates. You can still proceed with the import - you’ll just need to confirm that you want to create the duplicates.

File not uploading

Problem: Nothing happens when I select a file.

Solution:

• Ensure your file is in .xlsx, .xls, or .csv format
• Check that your file has the correct column structure
• Try with a smaller file first to test
• Check your browser console for errors

Tips

• Start with a small test file (5-10 boxers) to ensure your format is correct
• Keep a backup of your import file in case you need to make corrections
• Use the ”+ Add” button to manually add a few boxers first to see the expected format
• Export existing boxers first to see the correct format, then use that as a template
• Weight values with decimals will be rounded (e.g., 75.8 → 76)
• Empty rows in your spreadsheet will be automatically skipped

Example Template

Here’s a sample CSV template:

First name,Last name,Date of birth,Gender,Weight,Number of matches
John,Smith,1995-03-15,male,75,12
Jane,Doe,1998-07-22,female,60,8
Mike,Johnson,2000-11-05,male,82,15

Save this as a CSV file or copy it into Excel and use it as a starting point for your imports.