Fix CSV import errors
Resolve common issues when importing gymnasts from CSV.
Prerequisites: You're on Step 2 of CSV import.
Finding Errors
On the import table (Step 2), rows with errors are highlighted. Use the filter chips at the top to show only rows with a specific error type.
Common Errors and Fixes
Wrong Date Format
Symptom: Date of birth shows as invalid.
Fix: Go back to Step 1 and change the Date Format setting to match your data. For example, if your dates look like "15/01/2012", set the format to dd/MM/yyyy.
Missing Required Fields
Symptom: Row is highlighted with a "missing field" error.
Fix: Click the row to open the Edit Drawer. Fill in the missing field (first name, last name, discipline, or DOB).
Invalid Discipline
Symptom: Discipline column shows an error.
Fix: Click the row and select a valid discipline from the dropdown. Valid values depend on the context (e.g., WAG, MAG).
Invalid Level Name
Symptom: Level doesn't match any available level (meet import only).
Fix: Click the row and select a valid level from the dropdown. The dropdown shows all levels configured for the meet.
Future Date of Birth
Symptom: DOB validation error.
Fix: Click the row and correct the date. Dates in the future are not allowed.
Encoding Issues (Special Characters)
Symptom: Names show garbled characters (e.g., José instead of José).
Fix: Go back to Step 1 and change the Encoding setting. Try UTF-8 first, then ISO-8859-1 or Windows-1252.
Wrong Delimiter
Symptom: All data appears in one column, or columns are misaligned.
Fix: Go back to Step 1 and change the Delimiter setting. If your file uses tabs (from Excel), select Tab. If from a European locale, try Semicolon.
Tips
You can fix errors one row at a time using the Edit Drawer, or go back to Step 1 and re-import with corrected settings.
After fixing errors, the stats bar updates automatically to show remaining errors.
You must resolve all errors before you can proceed to Step 3 (import).
Related
Last updated