Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2010-10-27 13:03:25
- pmjewett
- Member
- Registered: 2008-06-12
- Posts: 15
Exporting Visitor Log Info? Plugins that expand the visitor logs?
Hi All,
We use TP to run our corporate intranet and recently our HR dept wanted to know how many hits their page is getting. It appears that the log only goes back 2 weeks? Can that be adjusted? Most importantly is their a way (plugin, etc) to export the results or some kind of counter that will indicate how many times xxx page was accessed in the past xxx weeks/months?
I’ve seen plenty of stuff for this with WordPress…anything out there for TP?
Thanks so much.
Offline
Re: Exporting Visitor Log Info? Plugins that expand the visitor logs?
Admin->Preferences->Advanced holds a setting called Logs expire after how many days which you can freely edit. However, the textpattern logs aren’t really designed for the sort of tracking you are looking at. While you can filter a bit directly in the Admin interface or download the whole table as a CSV file from phpMyAdmin and do some rudimentary Excel-style filtering/sorting, I suspect you’ll come up short.
I don’t know of any plugins at the moment that enhance the logging capabilities although I suppose one could be written (actually, I know someone who started one to interface with one of my plugins but I don’t think it was ever finished).
Alternatively — although it won’t help you this time — you can employ Google Analytics like many (imo, mad!) people do. If you prefer not to rely on some third party site being available and the network delays it adds to your page load times or prefer to keep your logging in-house (useful on an intranet) I’ve had good results from Piwik. I’ve had it installed for a while now on my server and the depth of reporting is pretty decent. It does allow you to export stuff in CSV or some other fancy-pants formats but I haven’t really delved into it at that level yet.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
#3 2010-10-27 13:54:18
- pmjewett
- Member
- Registered: 2008-06-12
- Posts: 15
Re: Exporting Visitor Log Info? Plugins that expand the visitor logs?
Thanks very much for the reply. I’ve adjusted the log expiration setting but could you provide some direction to phpmyadmin so I can export that table? I’m a whiz with Excel but have very little experience with TP.
Thanks!
Offline
Re: Exporting Visitor Log Info? Plugins that expand the visitor logs?
phpMyAdmin is a 3rd party bit of kit that is normally installed on your hosting environment side by side with MySQL. You’ll need access to the server where your TXP installation is running from, or at the very least a login. Perhaps as it’s an intranet your company might not have a standard ‘control panel’ setup like a hosting company, so it might be more difficult. Or they might use proprietary software.
If you’re lucky and they use phpMyAdmin, once you have a login it’s fairly easy to browse the database from the interface and export the contents of the txp_log table as CSV (or whatever).
Last edited by Bloke (2010-10-27 14:04:44)
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: Exporting Visitor Log Info? Plugins that expand the visitor logs?
If you should decide to look further at Piwik, there’s also a Txp plugin: cbs_piwik
Offline