Forum Moderators: DixonJones

Message Too Old, No Replies

Log File Reader and Editor

raw access log file reader

         

antarve

11:41 pm on Aug 16, 2003 (gmt 0)

10+ Year Member



Hi,
I am looking for a relatively simple but highly configurable desktop HD installed software, which allows to read excerpts from available access log files database by desired time or/and visitor.
For time being I am using a regular text editor to abbreviate entry lines, but it is time consuming.
I checked numerous URL's dealing with web analytic software, but none of them mentions such approach.

Does such program exist, or it is just my fantasy?

stevenha

1:16 am on Aug 17, 2003 (gmt 0)

10+ Year Member



Try a program like Windows Grep. It will search for, and show you, all the lines that contain any kind of word or pattern you want. Search for words like "googlebot", or you can turn on the regular expression processing, and search for much more complicated patterns.

Anybody using more sophisticated tools though? Has anyone got a way to parse their logs into a generic, friendly database app?

Sinner_G

5:14 pm on Aug 17, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Has anyone got a way to parse their logs into a generic, friendly database app?

What I do is use Windows Grep to get all the lines of interest, then save the results as txt. That can then be imported into Excel or Access, depending on size.

aspdaddy

7:10 pm on Aug 17, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



M/S Log parser allows you to run SQL type queries on the logs, by date.

stevenha

12:14 am on Aug 18, 2003 (gmt 0)

10+ Year Member



aspdaddy, Can you explain further about how to find M/S Log parser, and how to use it?

aspdaddy

5:16 pm on Aug 18, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



stevenha

Its a free tool that lets you query log files using SQL type queries.

You can run it in a dos shell or create the component in a windows app.

some more info here
http*//www.larkware.com/Articles/LogParser2.0Help.html

and threads on WW
http*//www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=webmasterworld+log+parser