Common Import Errors
In this Article:
This guide covers common errors you may encounter during the import process and how to fix them quickly.
General Tips:
- Use the Back button (lower left) to return to previous steps and make corrections.
- If needed, select Cancel to start over.
- After import, you may need to make some manual adjustments, like marking phone numbers private or adding missing details.
Upload Your CSV File Errors
Error: Import Canceled.
Problem: The uploaded file is not a CSV file.
Fix:
- Open your spreadsheet (Excel, Google Sheets, etc.).
- Save it as a CSV (comma-separated values) file.
- Re-upload the updated file.
Error: Unexpected Error (ColumnCount: 0, CurrentIndex: 14, HeaderRecord)
Problem: There are duplicate column names.
Fix:
- Check the header row (column names) for duplicates.
- Ensure each column has a unique name.
- Save the updated CSV and re-upload.
Photo Upload Errors
Error: No uploaded photo matching [Photo filename]
Problem: The CSV references a photo filename that wasn’t uploaded.
Fix:
- If you have the photo:
- Ensure the filename in the CSV matches the actual photo’s filename exactly.
- Use the Back button to upload the missing photo.
- Continue the import process.
- If you don’t have the photo:
- Open your CSV and remove the missing photo’s filename.
- Hit Back to return to the Upload CSV File step.
- Upload the updated CSV and continue.
Quick Fix: You can also select "Ignore Column" during mapping to skip missing photos.
Data Import Errors
Error: Parsing Issues (Invalid Data in Fields)
Problem: Some fields contain incorrect data, such as:
- Extra numbers in birthdates (e.g., 10/22/20224)
- Email addresses missing "@" (e.g., meganemail.com)
- Spaces inside email fields or any other column, especially leading spaces
Fix:
- Check the listed family’s row for errors.
- Ensure all fields are formatted correctly, removing any leading or trailing spaces.
- Save your CSV, use the Back button to return to Upload CSV File, and re-upload.
Note: If a birth year is missing, we automatically set it to the current year (hidden from public view).
Error: Family Last Name is Required
Problem: A row is missing a Family Last Name, or there are extra blank rows.
Fix:
- Ensure every row has a Family Last Name.
- Remove any blank rows between families.
- Check for rogue characters (open in Notepad to find unexpected commas or characters at the bottom).
- Save your CSV and re-upload.
Need More Help? If you're still having trouble, reach out to our support team for assistance.