By M. Crane (Craniac) on Tuesday, April 19, 2005 - 05:04 pm:

Anyone want to walk me through using "mysqlimport" to do the above? Where's our crazy swedish mysql expert????

I tried using LOAD INFILE but got strange errors.

By John Massaglia (Mrklaw) on Thursday, April 21, 2005 - 12:28 pm:

ick, I would export the excel spreadsheet into a tab or comma-delimited file. Once you have a delimited text file, I'm sure that it's much easier to import into mysql.

By John Massaglia (Mrklaw) on Thursday, April 21, 2005 - 12:30 pm:

you've probably searched, but here is a tutorial on how to import excel into mysql

How to import Excel Access or XML data into MySQL database by using a MySQL Client Tool – Navicat?

By M. Crane (Craniac) on Saturday, April 23, 2005 - 12:15 am:

I used the following mysql command from the prompt. I had forgotten to convert the file to unix line endings, which through me off, but it's something like:

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/LOAD_DATA.html

basically, the LOAD INFILE LOCAL DATA imports it correctly. With phpmyadmin running to mod the table, the searches you can do are awesome!

By M. Crane (Craniac) on Saturday, April 23, 2005 - 08:25 pm:

Here's the actual line, which I'll put here for future reference some day:

LOAD DATA LOCAL INFILE "f2.txt" INTO TABLE f2005 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';

I totally want to be a database/php geek now.

By Tim Tate (Tatertot) on Monday, April 25, 2005 - 11:09 am:

them's good referencin' thangs.

By M. Crane (Craniac) on Monday, April 25, 2005 - 01:26 pm:

Hey Tim, I'll be in Portland in early May. I've never posted the last two ST projects that I took pictures of in Portland, I just realized. Hopefully Wacky Willy's is still around. I'll keep an eye out for you and try to give any scooter riders a wide berth.

By Tim Tate (Tatertot) on Monday, April 25, 2005 - 05:23 pm:

that reminds me:
http://www.portlandmercury.com/2005-04-07/ex.html

By M. Crane (Craniac) on Tuesday, April 26, 2005 - 05:53 pm:

You are a rock star!

200cc seems like a lot of engine for a scooter.

By John Massaglia (Mrklaw) on Tuesday, April 26, 2005 - 11:59 pm:

sweet pics. I wish I could blow it up more. I like the rack on the back of your Lambretta and that fenderlight is hot!

By Larry Smilg (Larrys) on Friday, April 29, 2005 - 12:23 am:

Tim, we are very different places - That's my house on the left in the picture.

http://www.indystar.com/apps/pbcs.dll/article?AID=/20050422/ZONES0106/504220317&SearchID=7320651191304

Me, not so much a rock star.

By Tim Tate (Tatertot) on Friday, April 29, 2005 - 11:18 am:

But your house is!

Yes, 200cc is a large scooter engine, but I need it to haul my fat ass around. I'm hoping one day to add a 235cc kit and performance pipe to it.

By Jay Townsend (Artdog) on Friday, April 29, 2005 - 01:21 pm:

Good lord man, in the Washington DC area that house would sell for $1M...