Troubleshooting CSV Import Errors

This guide helps you fix common errors when importing parent and family data into Enrollio using CSV files. Each error code includes the reason it occurred and exactly how to resolve it.

What is Bulk Importing?

Bulk importing lets you upload large volumes of family data quickly using CSV files. It's essential when moving from another system, adding waitlist families, or syncing parent lists. However, formatting mistakes can stop your import cold. This guide will help you fix them fast.

Watch this quick overview of how to find and resolve import errors:

[SCREENSHOT: Contact import bulk action screen showing error log link and error resolution workflow]

Why Clean CSV Imports Matter

Mastering CSV troubleshooting saves you hours of frustration. Here's what you gain:

• Save time — no more starting over from scratch
• Avoid duplicates — prevent the same family appearing multiple times
• Keep data clean — maintain accurate parent contact information
• Enable automations — properly formatted data triggers your enrollment workflows
• Assign correctly — ensure families are assigned to the right staff member
• Preserve personalization — keep tags and campaign data intact

Pre-Import Checklist

Use this checklist before every import to prevent common errors:

• ✓ Only one sheet in your Excel/CSV file
• ✓ All required fields are filled out correctly
• ✓ Email addresses formatted properly (name@domain.com)
• ✓ Phone numbers in correct format
• ✓ Dates formatted consistently
• ✓ Each row has a unique identifier (like email or contact ID)
• ✓ Dropdown values match exactly what's in Enrollio
• ✓ Owner column uses valid staff email addresses
• ✓ You've selected a reliable primary column (Email recommended)

Complete Error Code Reference

Here's every error you might encounter, what it means, and how to fix it:

General Processing Errors

Error 1001: Unknown Error

What it means: Enrollio couldn't process your file due to an unexpected issue. Your data was not imported.

How to fix it:

1. Confirm your file meets all formatting requirements
2. Clear your browser cache or try a different browser
3. Re-upload and try again

Error 1003: Invalid Sheet Count

What it means: Your file contains more than one sheet. Enrollio only processes single-sheet files.

How to fix it:

1. Open your file in Excel or Google Sheets
2. Delete any extra sheets (look at the tabs at the bottom)
3. Keep only the sheet with your parent data
4. Save and re-import

[SCREENSHOT: Excel file showing multiple sheet tabs with arrows pointing to sheets that should be deleted]

Owner and User Assignment Errors

Error 1002: Multiple Owners Found

What it means: The Owner column in your file matches more than one staff member in your account (for example, you have two staff members named "Sarah Johnson"). The families were imported, but no owner was assigned.

How to fix it:

1. Replace all owner names with staff email addresses in your CSV
2. Re-import the file, OR
3. Manually assign the owner to each affected family record

Error 1015: Could Not Find the Owner

What it means: The owner listed in your file doesn't match any staff member in Enrollio. The families were imported, but no owner was assigned.

How to fix it:

1. Check that all staff members are added to Enrollio first
2. Use staff email addresses instead of names in your Owner column
3. Re-import or manually assign owners

Formatting and Data Type Errors

Error 1004: Invalid Required Property

What it means: A required field contains a value in the wrong format. That row was not imported.

How to fix it:

1. Check the format requirements for the field showing the error
2. Update your file to match the correct format
3. Re-import the file

Error 1005: Invalid Enumeration Option

What it means: A dropdown, checkbox, or radio button field in your file doesn't match the options in Enrollio. The families were imported, but that field is blank.

How to fix it:

1. Compare your file values to the dropdown options in Enrollio
2. Either update your file to match existing options, OR
3. Add new custom options to your Enrollio field settings
4. Re-import or manually update the affected records

[SCREENSHOT: Side-by-side comparison of CSV dropdown values vs Enrollio field settings showing exact match requirement]

Error 1008: Failed Validation of Email

What it means: An email address in your file isn't formatted correctly (missing @, no .com, etc.). Those records were not imported.

How to fix it:

1. Find the invalid email addresses in your file
2. Correct them to proper format: name@domain.com
3. Re-import the file

Error 1013: Could Not Parse the Phone Number

What it means: A phone number contains non-numeric characters or isn't in the correct format. The families were imported, but the phone number field is empty.

How to fix it:

1. Format phone numbers as: +1234567890 (country code + number, no spaces or dashes)
2. Remove any letters or special characters
3. Re-import or manually add the phone numbers

Error 1014: Could Not Parse the Date

What it means: A date value doesn't match the format you selected during import. The families were imported, but the date field is empty.

How to fix it:

1. Check what date format you selected during import (MM/DD/YYYY, etc.)
2. Update all dates in your file to match that format exactly
3. Re-import or manually add the dates

Duplicate and ID Errors

Error 1006: Invalid Contact ID

What it means: You selected "update existing records using Contact IDs" but the IDs in your file don't match any families in Enrollio. The records were not imported.

How to fix it:

1. Export your existing families to get the correct contact IDs
2. Update your import file with the correct IDs
3. If you're adding new families (not updating), don't select the "update existing" checkbox
4. Re-import

Error 1009: Empty Unique Property Value

What it means: Your primary column (the unique identifier you selected) is blank for some rows. Those records weren't processed.

How to fix it:

1. Fill in the missing values in your primary column
2. If using email as primary, make sure every row has an email address
3. Re-import the file

Error 1010: Duplicate Unique Property Value in Enrollio

What it means: The value you're using as your primary column (like email) already exists multiple times in Enrollio. Your data was imported but may have created duplicates.

How to fix it:

1. Choose a different primary column that's more unique
2. Clean up any duplicate family records in Enrollio
3. Re-import with the correct settings

Error 1011: Duplicate Unique Property Value in the File

What it means: The same email (or other unique value) appears multiple times in your import file. Data was imported but you may have duplicate family records.

How to fix it:

1. Search your file for duplicate emails or IDs
2. Keep only one row per family (the most recent/complete data)
3. Delete duplicate rows
4. Re-import the cleaned file

Error 1012: Duplicate Contact ID in the File

What it means: The same Contact ID appears multiple times in your file. Those records were not updated or imported.

How to fix it:

1. Find all rows with duplicate Contact IDs
2. Keep only one row per family (with the most up-to-date information)
3. Delete the duplicate rows
4. Re-import

File Not Found Error

Error 1007: File Not Found

What it means: Enrollio couldn't locate the file you selected. Nothing was imported.

How to fix it:

1. Verify the file is saved to your computer
2. Make sure it's a .csv or .xlsx file
3. Re-upload the file

Frequently Asked Questions

What file format should I use for imports?

CSV (.csv) files work best. You can also use Excel (.xlsx) files, but make sure they contain only one sheet.

Which column should I use as the primary column?

Email is your best choice because it's unique and unlikely to change. Avoid using names, which can duplicate easily.

How do I avoid creating duplicate family records?

Before importing, check if the families already exist in Enrollio. If updating existing families, use their Contact IDs. If adding new families, make sure your primary column (email) doesn't match existing records.

Can I import without an email address?

You can import using phone number or Contact ID as your primary column instead. However, email is recommended for best results and to enable automated email communications.

What happens to data in fields that have errors?

It depends on the error. Most of the time, the family record is still created but the problematic field is left blank. You can manually fill it in later or fix your file and re-import.

Where can I find the error log after an import?

Go to Settings → Bulk Actions, find your import, and click on it. You'll see a detailed error log showing which rows had issues and what went wrong.

[SCREENSHOT: Settings > Bulk Actions screen showing completed import with clickable error log]

Should I delete failed imports before trying again?

It depends. If only a few rows had errors and the rest imported successfully, just fix those rows and import them separately. If the entire import failed, you can re-import the whole file after fixing the issues.