2

I am attempting to import a csv file that is both regular comma delimited and I have also tried one saved as CSV UTF-8 (Comma delimited). Each time I go through the steps, I get through the match fields correctly. When I get to Step 3 Preview, I am told that my total number rows have errors and won't be imported:

  • 4
    Hi James - it would be v helpful if you downloaded your errors and then pasted an example of the problem that will be reported in the csv – petednz - fuzion Nov 8 '18 at 22:26
  • 1
    Also, the Birth Dates look incorrect - just a number and not formatted – Andy Clark Nov 9 '18 at 12:57
  • I hope that the screenshot isn't real data about individuals. If it is I would recommend that you delete this screenshot and make sure that you obscure any personal data from future screenshots. – William Mortada Nov 9 '18 at 16:46
2

Without seeing some of the actual file that is being imported, it is hard to say for sure. But my guess is that birth date field is an actual date field? And if so, it needs to be formatted as a date and on the first import screen you have to tell Civi how it is imported.

The error file that you can click and download will give you more information, as it will tell you what field(s) are the problem.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.