English > Support

[FAQ] Can't get CSV import to work

<< < (2/2)

rick.ca:
Sorry, I don't know. I always use the Excel import.

buah:
Instead quotes, I usually use @ or ~, when dealing with CSV export/import.

But I found it more convenient and more reliable to use xls file for such purposes.

nostra:
It seems like the "Ignore header" option is broken and as you have only one line in your file it is treated as header. Just move the data one line below. Note also that you need a delimiter at the end of each value (the last one as well) for the data to be fully imported.

daddydave:

--- Quote from: nostra on August 10, 2010, 06:29:10 pm ---It seems like the "Ignore header" option is broken and as you have only one line in your file it is treated as header. Just move the data one line below. Note also that you need a delimiter at the end of each value (the last one as well) for the data to be fully imported.

--- End quote ---

Thanks, nostra, this did the trick, but first I got a crash and I sent you the bug report. Then I remembered that in the process of trying to get this to work, I had tried saving this to a Unicode file (little endian I think). When I saved it back to ANSI, it imported fine. Thanks to everyone for your persistence!

Navigation

[0] Message Index

[*] Previous page