Jump to content
Sign in to follow this  
uemtux

Importing Apache Logs

Recommended Posts

Hello Everyone,

I'm trying to write a database to run reports on apache logs. Does anyone have a tried, tested, and true way of splitting an apache log line into its constituent parts? I've found a few Perl regexes that do the job, so I can always use Applescript to do shell script and write a little perl program that splits all the 'fields' of the log onto separate lines for interpretation by FileMaker, but if anyone knows of a FileMaker native implementation of apache log parsing I'd love to know!

Here is a sample apache log line if anyone needs (IPs Xed out):

XXX.XXX.XXX.XXX - - [05/Aug/2012:23:57:39 -0400] "GET /SpryAssets/SpryMenuBarVertical.css HTTP/1.1" 304 - "-" "Mozilla/4.0 (compatible;)" XXX.XXX.XXX.XXX XXX.XXX.XXX.XXX

Thanks!

Share this post


Link to post
Share on other sites

What do you want to see as the result?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.