[Phpmyadmin-devel] about "Invalid parameter for CSV import:

Marc Delisle Marc.Delisle at cegepsherbrooke.qc.ca
Tue Jan 22 22:43:19 CET 2008


Michal Čihař a écrit :
> Hi
> 
> On Mon, 21 Jan 2008 16:34:40 -0500
> Marc Delisle <Marc.Delisle at 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






More information about the Developers mailing list