Forum Moderators: phranque

Message Too Old, No Replies

I need a program

         

grandpa

11:18 pm on Dec 2, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



My web host maintains a continous log file. This is a new host - the previous host broke those logs into daily files.
So I download this 15MB file and guess what, it won't load into Excel, or more specifically only the first 65K lines or so will load. After that, obviously, nada.

I can load this file into Wordpad, but it takes 20 minutes to scroll 1/3 way thru the file just to save a portion off and rebuild everything later.

Does anyone know a better way? I don't want to lose my hosting company statistics, they are pretty good. But if they change my logging to give me managable chunks of data, I will lose those statistics.

All I want is the ability to track the occasional event on my web site, preferrably with the Office products that I have available - Excel, Access.

ncw164x

11:29 pm on Dec 2, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



textpad is good for large files

it's free to evaluate (full working copy) but if you carry on using it a pop up box appears every now and then asking for payment.

grandpa

2:44 am on Dec 3, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Thanks,

I grab a copy a give it a try.

plumsauce

8:36 am on Dec 3, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member




look for:

LOG FILE PARSER

from Microsoft as a free download

understands most log file formats
as input, can do sql queries against
the log file and output in various formats
including stuffing it into a sql server.