Kirix Strata Extensions

Apache Log Import

ScreenshotInstall Now

by Aaron Williams |

This extension enables you to quickly import your Apache web logs into Strata. This tool imports and appends multiple, raw Apache web logs into a single table and parses the data into the appropriate columns. It works with both the Apache common and combined log formats.

Overview

Web logs contain all kinds of interesting data. There are many types of web log analytics tools out there, such as Google Analytics and AWstats; this extension helps to supplement them. For instance, sometimes it is really useful to get your hands on the raw web log data in order to pick out individual trends, identify website errors, track robots or do other ad hoc analysis that standard web log tools may not perform out-of-the-box.

The problem with web logs is that it takes a bit of work to convert the raw tab delimited logs into a nice, usable format. This extension does the appending, parsing, importing and data transformation in one go.

Instructions

  1. After installing the extension, select “Import Apache Logs” from the Tools menu and an import dialog will appear.
  2. Click the Add button to browse your system for the web logs you wish to import. If you select the wrong file, select the file and click the Remove button.
  3. Select a name for the output table; you may select a folder in your project by clicking the Browse button.
  4. Click the Run button to being the import. You can see the progress of the import by viewing the status bar on the bottom right of Strata. Or, you can select Jobs from the Tools menu.
  5. Once the import is completed, the table will appear. Click the “X” on the top right of the Apache Log Import extension to close it and begin working with your log files.

Video

Click on the video screencast below to see this extension in action:

Play Video

(And here’s an embeddable YouTube version…)

Further details about this video can be found at this Strata Blog post.

Version 1.0.1; Nov 04, 2008

2 Responses to “Apache Log Import”

  1. Researching Problems in your Apache Web Log Activity | Strata Blog says:

    […] handle the data size, but the format is enough to give any software fits.  So, we wrote a quick Apache log parser extension that makes it really simple to just point the software to your Apache log and import it.  The […]

  2. Embedded phpBB Search Terms within Apache Web Logs | Data and the Web says:

    […] import as space delimited with quotation marks as the text qualifier.  Update:  You can now use a handy little log parsing extension to pull in your web log files without having to mess around with a straight text […]

About Strata Extensions

Kirix Strata enables you to create plug-ins that extend the functionality of the software. This section is dedicated to showing off the extensions people have created. Feel free to download any of them and try them out. If you have one you'd like to list, please let us know.

Get the Latest and Greatest

We'll be continuously adding extensions to this list -- both our own creations as well as those submitted by the community. You can stay up-to-date with the latest by subscribing to the extension blog feed:

Get the Extension RSS Feed here.