Could the commas at the end of your data lines be causing a problem? (I've never loaded a CSV file.)
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: Jason Pruim [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 09, 2007 10:54 AM > To: Edward Kay > Cc: mysql@lists.mysql.com > Subject: Re: Import file into MySQL Database.. > > > On Aug 9, 2007, at 10:11 AM, Edward Kay wrote: > > > > > > >> -----Original Message----- > >> From: Jason Pruim [mailto:[EMAIL PROTECTED] > >> Sent: 09 August 2007 14:16 > >> To: Gary Josack > >> Cc: mysql@lists.mysql.com > >> Subject: Re: Import file into MySQL Database.. > >> > >> > >> > >> On Aug 8, 2007, at 5:19 PM, Gary Josack wrote: > >> > >>>> > >>> Try: > >>> > >>> |load data local infile '|/volumes/raider/aml.master.8.6.07.|csv' > >>> into table test fields terminated by ',' enclosed by '"' lines > >>> terminated by '\n' |ignore 1 lines > >>> |(First, Last, Add1, Add2, City, State, Zip, XCode, Reason, Date); > >>> > >>> If that doesn't work could you please provide more output from the > >>> csv file in question? > >>> | > >>> > >> > >> The current load file command that I've been trying is: > >> load data local infile "/volumes/raider/aml.master.dos.csv" into > >> table test fields terminated by "," lines terminated by "" (First, > >> Last, Add1, Add2, City, State, Zip, XCode, Reason, Date); > >> > >> > >> I tried adding "\r\n" to the file and it didn't work, here > is some of > >> the lines from my csv file: > >> > >> First,Last,Add2,Add1,City,State,Zip,Date,Xcode,Reason > >> A. DREW,MILES,,1583 Jerome St,Holland,MI,49423-6703,,P, > >> Aaron,Davis,,14796 Creek Edge Dr,Holland,MI,49424,05/17/07,S, > >> Aaron,Kraai,,3710 88th Ave,Zeeland,MI,49464-9716,05/17/04,S, > >> Aaron,Shuck,,288 W 13th St,Holland,MI,49423-3452,04/28/03,, > >> Adam,Hecht,,177 Cambridge Ave,Holland,MI,49423,03/22/05,S, > >> ADE,VLIENSTRA,,304 W 30th St,Holland,MI,49423-6971,,, > >> Adrienne,Smith,,6795 Ransom Rd,Zeeland,MI,49464,03/31/06,A, > >> Anthony,Lewis,,10257 Summerwood Dr,Zeeland,MI,49464,07/30/07,S,Typo > >> AL,HOLTROP,,4850 Dellview Ct,Hudsonville,MI,49426-1664,,, > >> Alan,Russell,,3624 Diamond Dr,Hamilton,MI,49419-9707,,, > >> > >> If anyone wants to see the result that I get goto: > http://raoset.com/ > >> tests/legion/index.php > >> > >> Any help is greatly appreciated! > >> > >> Thanks! > >> > > > > First off, to me it looks like your data is in the format > > > > ... state,zip,date,xcode,reason > > > > but your field list is > > > > ... state,zip,xcode,reason,date > > > > > > I have a cron job that updates one of my tables with a CSV file. > > This uses > > the following command which always works well: > > > > load data infile "table.csv" > > into table table_name > > fields terminated by ',' enclosed by '"' > > lines terminated by '\r\n' starting by '' > > ignore 1 lines; > > > > The CSV file has Windows line endings and is imported by MySql on > > Linux. You > > wouldn't need the enclosed by bit for your data though. > > > > HTH, > > Edward > > I have tried this many different reasons, and all the > possibilities I > can think of... the only thing I can figure is it's something to do > with my actual file... But I have saved it as a tab separated, csv, > both dos and windows line endings... and I just get get it to do it > reliably. It throws the data all over the place. > > I'm about to give up and retype the whole thing... All 900+ records > of it... Just so that it gets done... > > Anyone have any other ideas? > > (Sorry... Just getting frustrated) > > > -- > > Jason Pruim > Raoset Inc. > Technology Manager > MQC Specialist > 3251 132nd ave > Holland, MI, 49424 > www.raoset.com > [EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
