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:
3
-
4Hi 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, 2018 at 22:26
-
1Also, the Birth Dates look incorrect - just a number and not formatted– Andy ClarkNov 9, 2018 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 MortadaNov 9, 2018 at 16:46
Add a comment
|
1 Answer
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.