homepage Welcome to WebmasterWorld Guest from 107.21.135.68
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Website Analytics - Tracking and Logging
Forum Library, Charter, Moderators: Receptional & mademetop

Website Analytics - Tracking and Logging Forum

    
Convert Log file to database
nmattheij




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

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?

 

kichus




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

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...]

Iguana




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

I just pull my logs into Microsoft access (using text import with space as the separator).

cgrantski




msg:3177696
 5:14 pm on Dec 4, 2006 (gmt 0)

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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Website Analytics - Tracking and Logging
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved