As part of spring cleaning I deleted my old log files and then one of my professors thought that some of the data should be analyzed and perhaps published! Aaah!
Turns out I still have the data in awstats but trying to cut-and-paste it into an openoffice spreadsheet breaks the spreadsheet every time. Any way I can extract the data directly from awstats?
Okay, here's a partial answer to my own question. Awstats produces its reports by extracting your domain's stats (including parked and add-on domains) from the server's logs. It does not use your logs. It does not use the .txt files in /tmp/awstats. It extracts your data from the server's log files. So if foo.com and bar.com are on box12.nohost.com, then if it's July 23rd when the owner of foo.com opens awstats, awstats extracts, live, all of July's foo.com entries from the log files of box12.bluehost.com, ignoring the bar.com entries. Needless to say, nohost.com isn't going to share their complete log files.
If somebody knows how to get awstats to print a custom log extract directly to a csv file instead of an html page, I would greatly appreciate your assistance.
In the mean time, I found, of all things, I could run queries in the usual awstats gui and then cut and paste the tables out of IE and into Excel. I could not cut them out of IE, Mozilla, or Firefox and into Excel, OpenOffice, or NeoOffice. The only combination that worked was IE to Excel. Go figure.
