Welcome to WebmasterWorld Guest from 54.205.75.60

Forum Moderators: DixonJones & mademetop

Message Too Old, No Replies

Convert Log file to database

   
11:21 am on Dec 4, 2006 (gmt 0)

10+ Year Member



I mainly use Webtrends for analysis, but I'm looking for a little program that will import my log files into a database table, so I can perform SQL searches on it.

Looking into raw logfiles doesn't get me very far most of the time, being able to run queries on it with sql could really help me figure out a lot of stuff without having to create and run complex Webtrends reports.

So basically all I need is a tool that will create a table/database with the log fields as columns and put the log data in it.

Preferably with me being able to filter on extensions and/or ips, and imports of multiple logfiles.

Any ideas?

12:15 pm on Dec 4, 2006 (gmt 0)

5+ Year Member



This is a link from Microsoft site, So I think it's okay ti mention here...

"How To Use SQL Server to Analyze Web Logs"
[support.microsoft.com...]

12:33 pm on Dec 4, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I just pull my logs into Microsoft access (using text import with space as the separator).
5:14 pm on Dec 4, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Also look at LogParser (on the Microsoft site). It was designed with logs (in general) in mind, and so might be even more appropriate than Access.