AccStats
1.0
AXS
logfile utility
AccStats
is a small free Microsoft Access database program for people that
use the Fluid Dynamics
free AXS perl script for tracking website traffic and hits.
AccStats
can be used to query, convert, import, export and keep a master
database of all hits in the AXS log.txt file.
You
can also use this utility to create nicely formatted, printable
reports through the standard Microsoft Access report module.
Requirements:
Microsoft
Access 97 or 2000.
If
you are using Access 2000... you must
add a reference to the DAO 3.5 object library by simply clicking
on one checkbox within Access, see the Microsoft
Knowledge Base article Q202192 for instructions.
Failing
to do this will result in errors like: "Compile
error: Can't
find project or library" or
"User defined type not recognized" etc.
Tested
with AXS Script Set Versions:
2.3.0.0010
to 2.3.0.0016.
Features:
Import
Import
Axs log.txt file. AccStats ensures not duplicate hits can be
imported so it's safe to import any log at any time.
Export
Export
to comma separated text, html or back to Axs format for the entire
database or select a specific date range.
Enter
and keep track of spiders
AccStats
comes with a list of 327 known spiders, you can easily add to or
edit this list. This list is used in queries to show things
like most recent visit by each unique spider etc.
Queries
There
are many queries that come with AccStats and you can easily add
your own. There are 17 different queries that come with this
release.
Support:
We
do not provide any support for this utility, however we would like
to hear about any bugs you encounter.
Bug
reports or suggestions
Acknowledgments
Thank
you to Zoltan for permission to publish this utility and for help
with the AX-Stats logfile format.
Release
history:
v1.0
- initial release
