CSV Import Log

zachzach

I am importing a large CSV of users and receiving an error that the Name and Email fields are required. When i copy out a smaller subset of this CSV, the import runs successfully, so the formatting should be correct. I have checked that there are no empty values for either Name or Email in the sheet, and made sure that all email values include an @ and . in them.

I assume there must be some other invalid data / illegal character in one of the fields somewhere, but I haven't been able to find it. Is there a log somewhere that may tell me what line the CSV import fails on? Any other obvious characters I should look for?

Thanks!

KevinTheJedi

zachzach

No logs for such things, no; simply the error. You likely have a row that's malformed, missing a comma, has an extra comma, etc. There are plenty of CSV validators online that you can test your CSV file with.

Cheers.

zachzach

Ah alright. Figured it was worth asking.
The CSV itself seems to be valid, I've run it through a few different apps now. Are there any characters that would cause either field to fail?

KevinTheJedi

zachzach

Not really, except for an un-escaped comma (as commas are the delimeters). As I mentioned above you could also be missing a comma, have an extra comma, etc.

I would suggest breaking the CSV into chunks and seeing which chunk has an error then keep narrowing down until you find the culprit.

Cheers.