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

[Michal Čihař]

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.

> (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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20080122/b0c48c00/attachment.sig>