[Phpmyadmin-devel] about "Invalid parameter for CSV import: Fields enclosed by"
Hi, we got a few requests about this. Probably the most common generator of CSV files is MS Excel, and this fine application, when saving as CSV, generates a semi-colon separated file with no possibility of specifying the enclosing character (at least in the default dialog, I did not dig everywhere). But phpMyAdmin refuses to import it (see subject). I deactivated the message in my copy of PMA then imported some simple sample data Marc;1 Luc;2 (removing the double quotes in the CSV dialog), it went fine so I am tempted to get rid of this validation but would like to hear your comments. Marc
Hi On Mon, 21 Jan 2008 16:34:40 -0500 Marc Delisle <Marc.Delisle@cegepsherbrooke.qc.ca> wrote:
we got a few requests about this. Probably the most common generator of CSV files is MS Excel, and this fine application, when saving as CSV, generates a semi-colon separated file with no possibility of specifying the enclosing character (at least in the default dialog, I did not dig everywhere).
But phpMyAdmin refuses to import it (see subject). I deactivated the message in my copy of PMA then imported some simple sample data
What about leaving enclosed by to quote? It should work.
(removing the double quotes in the CSV dialog), it went fine so I am tempted to get rid of this validation but would like to hear your comments.
I'm not sure what exactly happens in parser when this field is empty. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Michal Čihař a écrit :
Hi
On Mon, 21 Jan 2008 16:34:40 -0500 Marc Delisle <Marc.Delisle@cegepsherbrooke.qc.ca> wrote:
we got a few requests about this. Probably the most common generator of CSV files is MS Excel, and this fine application, when saving as CSV, generates a semi-colon separated file with no possibility of specifying the enclosing character (at least in the default dialog, I did not dig everywhere).
But phpMyAdmin refuses to import it (see subject). I deactivated the message in my copy of PMA then imported some simple sample data
What about leaving enclosed by to quote? It should work.
Yes it works, however users tend to remove it because their file does not have an enclosing character.
(removing the double quotes in the CSV dialog), it went fine so I am tempted to get rid of this validation but would like to hear your comments.
I'm not sure what exactly happens in parser when this field is empty.
I tested with a couple tables and could not produce any error when leaving it empty. I suggest to deactivate the message for 2.11.5. Marc
participants (2)
-
Marc Delisle -
Michal Čihař