csv import format problems

[raylutz]

I can't seem to get the CSV import to work, and your documentation is very limited in that regard!

I have created a text file that has this contents:

NAME,EMAIL
T & Cricket,cabbt@cox.net
Jane Cruz,janeano@cox.net
Cynthia & Jeanette,cbvanz@msn.com
Susan & Nick,sdhc@cox.net

But it will not import. What is wrong?

[admin]

[raylutz]

I did an export and I notice now that you have an extra comma at the end of every line

STATUS,EMAIL,EMAIL2,NAME,PREFIX,COMPANY,TITLE,ADDRESS,ADDRESS2,CITY,STATE,ZIP,COUNTRY,FAX,ADD_INFO1,ADD_INFO2,CREATED,

That's really not standard CSV format, which does not require the extra comma at the end.

I was able to get my short CSV file to work as long as I put the extra comma at the end.

In reviewing your code, I believe you need the comma because you do not remove the line termination characters, and then the field has those line termination characters during further processing, comparison, etc. You should probably check on that. Don't sell yourself short. The code is designed to allow the fields in any order and does NOT require that you have all the fields.

Thanks!