List:General Discussion« Previous MessageNext Message »
From:John Date:September 26 2009 5:35pm
Subject:RE: Newbie question: importing cvs settings
View as plain text  
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 john@stripped

-----Original Message-----
From: Patrice Olivier-Wilson [mailto:biz@stripped] 
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=1

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.409 / Virus Database: 270.13.113/2396 - Release Date: 09/26/09
05:51:00

Thread
Newbie question: importing cvs settingsPatrice Olivier-Wilson26 Sep
  • RE: Newbie question: importing cvs settingsJohn26 Sep
    • Re: Newbie question: importing cvs settingsPatrice Olivier-Wilson26 Sep
      • Re: Newbie question: importing cvs settingsPatrice Olivier-Wilson27 Sep
        • RE: Newbie question: importing cvs settingsJohn27 Sep
        • RE: Newbie question: importing cvs settingsJerry Schwartz29 Sep
          • Re: Newbie question: importing cvs settingsPatrice Olivier-Wilson29 Sep
            • Re: Newbie question: importing cvs settings - followupPatrice Olivier-Wilson30 Sep
      • RE: Newbie question: importing cvs settingsGavin Towey28 Sep