CSV import problems Version 4.2.2 (422001)

starksm64

I have a very simple test.csv file with two lines that cannot be imported. I have even gone to the trouble of using dos line terminators and still cannot get the file imported. The file type and contents are:

scotts-imac:standalone starksm$ file /tmp/test.csv 
/tmp/test.csv: ASCII text, with CRLF line terminators
scotts-imac:standalone starksm$ cat /tmp/test.csv 
"Alaska Air","http://www.alaskaair.com","x1234567","y1234567","12345678"
"Bank of America","https://www.bankofamerica.com/","x12345678","y123456789"

I have also attached the file as well. It would be good if the log that is shown was providing at least some hint as to what is going on as this file cannot be that difficult to parse.

Jasper

Hi @starksm64,

You're missing the fifth piece of data (notes field) on the second line. Try:

"Alaska Air","http://www.alaskaair.com","x1234567","y1234567","12345678" "Bank of America","https://www.bankofamerica.com/","x12345678","y123456789","12345678"

You might also find our importing guide helpful:

How can I import data from another application? [CSV]

Please let me know if you have any other questions! :)