Datafeed to mysql in the form of csv files

Forum Moderators: open

Message Too Old, No Replies

Datafeed to mysql in the form of csv files

Dunno if this is possible

malcolmcroucher

8:17 am on Oct 19, 2008 (gmt 0)

I am downloading a CSV file and then uploading it to mysql .

I am wondering if it is possible to do this in one step to avoid the manual hassle ?

The feed comes in the form :

[website.com...] a bunch of data separated by "+" &f=a bunch of special tags

eg :

[website.com...]

Regards

Malcolm

rocknbil

1:42 pm on Oct 19, 2008 (gmt 0)

Lots of ways, but you may want to write a small program in perl, php, etc. to customize the import so you get some kind of reporting.

Executing SQL Statements from a Text File [dev.mysql.com] - basically put your commands in a file and run the single command line to use the text file for the actions.

Use mysqlimport [dev.mysql.com] is pretty easy to do too.

Both of these would be much easier if you write a little script that executes them for you.

malcolmcroucher

8:19 am on Oct 23, 2008 (gmt 0)

is it possible to do this with ziped files ?

Regards

Malcolm