My new router has a traffic meter on it. Unfortunatly it is only accessible from a web page with lots of JavaScript/Java in it. If anyone is employed here by netgear, Allow the user to either e-mail or ftp the data to themselves. You have an ftp server built right into the router. I managed to put a script together using firefox and iMacros. Then I format the output as a groups of MySQL insert statements which is then sent off via the script to the MySQL server. Ok, I got it working even though I had to do some things which aren't the best.

I couldn't format the insert statements with single quotes around the data items. I could get them formated with double quotes. I tried to use sed to change all of the double quotes to single quotes, but I couldn't get it to work. I ended up writing a tiny little Free Pascal program to do it.

The sed I tried was something like this:

sed s/'"'/'\''/ Traffic.dat

It would change some, but not all of them.

I think you're just missing a 'g' on the end, to replace ALL occurrences in every line.

Hope this helps,

Yes that worked, thanks.

If you don't have any other (related!) questions, then could you mark the thread as 'SOLVED', please? There should be a link to do it at the top of the page...

Thanks