I'm trying to import about 500 contacts from a CSV. About 20% of them only have an email address, some have email and either a first or last name, most have all three. The default import method is rejecting a chunk of the records telling me that they need either a first and last name or an email address. All of my records have an email address.

In terms of the detail, I'm avoiding any deduplication on import and so not selecting any matching rule. To see if this made any difference I did select the default email only matching rule and that made no difference to my results.

I've read other posts here and elsewhere that indicate, as suggested in the error report that my import attempts generate, that either first and last name is required, or an email address, but my experience seems to indicate that in reality all three are required.

Which is of course nonsensical and deeply unhelpful. From what I can see my only option now seems to be to fill in the empty first and last name fields with placeholder text to get past the broken validation check, and then clean it all up post import.

Am I doing something wrong or is the default import broken? This is using Civi 5.37.0 - just about to update before trying again in case it's a known and fixed issue.

Update: now updated Civi to the current version - 5.39 - and it's still broken.

  • 1
    If I remember right this has to do with the settings for the Unsupervised rule, regardless of what you choose for dedupe on the import screen.
    – Demerit
    Jul 22 '21 at 15:03
  • Thanks, I'll take a closer look at that. I'm just working with defaults, which it seems fair to assume would not result in an apparent broken import mechanism.
    – Graham
    Jul 23 '21 at 12:34
  • 1
    I suspect that the error is in your input data, and CiviCRM is misrepresenting the error. Try looking at some of the rows for which civicrm is identifying errors and see if there are in fact, perhaps, errors of a different flavour (e.g. a badly formatted email address). Perhaps CiviCRM is parsing your data in a way different from what you expect, e.g. issues of character sets, quotes, commas, etc.
    – Alan Dixon
    Jul 28 '21 at 15:54
  • Thanks Alan. All my data is clean and good and very throughly checked and formatted into CSV. Based on years of working with CiviCRM imports I know only too well how intolerant it is to minor issues.
    – Graham
    Jul 30 '21 at 11:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.