Fix CSV import errors
You uploaded your CSV and some rows have errors. That's normal, especially the first time. Most issues are quick to fix.
Prerequisites
You're on Step 2 of the CSV import, looking at the validation table.
Finding the problems
On the import table, rows with errors are highlighted. Use the filter chips at the top to narrow down to a specific error type so you're not scrolling through hundreds of rows.
Common errors and how to fix them
Wrong date format
What you see: Date of birth shows as invalid.
What happened: Your file uses one date format (like day/month/year) but the importer is expecting another (like month/day/year).
Fix: Go back to Step 1, click Settings, and change the Date Format to match your data. If your dates look like "25/01/2012", set the format to dd/MM/yyyy.
Missing required fields
What you see: A row is highlighted with a "missing field" error.
What happened: First name, last name, discipline, or date of birth is blank for that row.
Fix: Click the row to open the Edit Drawer. Fill in the missing value.
Invalid discipline
What you see: The discipline column shows an error.
What happened: The discipline value in your file doesn't match one Gym Art Meets recognizes.
Fix: Click the row and pick a valid discipline from the dropdown (WAG, MAG, etc.).
Invalid level name
What you see: The level doesn't match any available option. This only happens during meet registration imports.
What happened: The level name in your file is spelled differently from how the meet organizer set it up.
Fix: Click the row and select the correct level from the dropdown. It shows all levels configured for that meet.
Future date of birth
What you see: A date validation error on a row.
What happened: The date is in the future. Usually a typo, like "2025" instead of "2015".
Fix: Click the row and correct the year.
Garbled characters in names
What you see: Names look wrong, like "JosA(c)" instead of "Jose" or "MA 1/4ller" instead of "Muller".
What happened: The file encoding doesn't match what the importer is expecting.
Fix: Go back to Step 1, click Settings, and change the Encoding. Try UTF-8 first. If that doesn't work, try ISO-8859-1 or Windows-1252.
All data in one column
What you see: Every field for a gymnast is crammed into the first column.
What happened: The delimiter setting is wrong. Your file uses tabs or semicolons to separate columns, but the importer is looking for commas.
Fix: Go back to Step 1, click Settings, and change the Delimiter. If your file came from Excel, try Tab. If from a European locale, try Semicolon.
Two ways to fix things
You can fix errors one at a time using the Edit Drawer on Step 2. Or, if lots of rows have the same problem (like a wrong date format), go back to Step 1 and re-import with corrected settings. That's usually faster.
The stats bar updates automatically as you fix things, so you can always see how many errors remain.
You need zero errors before you can move on to Step 3 and actually import.
What's next
CSV template and format - Double-check your column setup
Advanced import settings - All the settings in detail
Related
Last updated