1. Try opening up the csv file in a text editor, viewing it in a spreadsheet looks like it's hiding some extra formatting or lines that may be causing problems.
2. Try importing through the mysql CLI. From the screenshot you posted, it looks like PMA is parsing the file and creating an insert statement for each line. It may be incorrectly handling some of that data. Using the CLI you'll get better feedback about what, if any, the error is. Regards, Gavin Towey -----Original Message----- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Saturday, September 26, 2009 11:02 AM To: 'mysql' Subject: Re: Newbie question: importing cvs settings Yep, typo ...:-( I did some screen shots of 2 tests. A workaround solution is to make a final entry in the csv file that I don't really need. Then everything up to that point gets imported ok using CSV method. The LOAD DATA method did not enter anything. My earlier assumption about line 17 was false. It was dependent on how many rows, and I had been using tests with same amount of data. As I said, very beginner level, so thanks for the patience. screenshots at http://biz-comm.com/mysqlprojects/ thank you.... John wrote: > I assume you mean csv not cvs! > > What is the error you get when the import fails? What version of MySQL are > you using? Can you post the output of SHOW CREATE TABLE for the table you > are trying to load the file in to and a sample of the csv which is failing > to load? > > Do you get the same error if you try and load the files using MySQL client > and the LOAD DATA INFILE command? (See this link for details on how to use > LOAD DATA INFILE http://dev.mysql.com/doc/refman/5.1/en/load-data.html) > > Regards > > John Daisley > MySQL & Cognos Contractor > > Certified MySQL 5 Database Administrator (CMDBA) > Certified MySQL 5 Developer (CMDEV) > IBM Cognos BI Developer > > Telephone +44 (0)7812 451238 > Email j...@butterflysystems.co.uk > > -----Original Message----- > From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] > Sent: 26 September 2009 17:08 > To: mysql > Subject: Newbie question: importing cvs settings > > Greetings: > > I have a project for which need to import cvs files into db. > > I can do so up to a point. The import will only do 16 lines, > consistently. Error is failing at line 17. > > Steps: > > create table fields in Excel document, where they all match database fields > enter information in several of the columns, but not all as client will > be filling it in online (leaving ID blank) > save excel to .cvs > log into phpMyAdmin > import cvs > > > I've experimented with several settings in the import, but consistently, > it fails at line 17, even with different .cvs files. > > > Any guidance, most appreciated. > > -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
