Civi CRM

>Connection Interrupted<

I got this importing as few as a couple thousand rows on a shared host. This created duplicates the next time I tried to import the file. Then I try and find duplicates, but it won't find any. Turns out it was looking for equal email addresses to match duplicates, and rows without email addresses (all of them), but matching "First Name" and "Last Name" did not match each other. NULL != NULL was the problem.

Once that became clear, finding all of the duplicates didn't help much as there was a list of however many thousands of duplicates, and each had a button next to it, "merge." It would have taken me hours to click through them all, merge-> are you sure->successfully merged, three clicks to delete one row. And no apparent way to combine them.

So, we delete everything and reimport.

Cut the 16k file from down to 3333 rows max per import and take it gently.