Reply To: CVS import – missing data

11/20/2014 at 9:03 am #310446
Steven Zahm
Keymaster

@ Betty

Could you give more details on what you mean by missing data?

I did take a look at the CSV file…

I noticed line 51 is pretty much blank; you should remove that.

Also, I see that a fancy single quote is being used instead of an apostrophe in several rows. Since the cells are not quoted, that could be causing import issues.

I’ve attached your CSV file UTF8 w/o BOM encoded to better deal with those fancy quotes. I used Notepad++ to do the conversion.

What is your source document, Excel? If it is, I suggest using LibreOffice. Excel can make a mess of CSV files.

Hope that helps, let me know!

Attachments:
You must be logged in to view attached files.