Forum OpenACS Q&A: Is anyone interested in download reports for file storage?
I thought that this would be of general interest but Don is a bit dubious and suggested that I post the idea for public comment. My proposed changes consist of adding a table to file storage, writing a row to it each time someone downloads a file, and adding a link for admins to access a simple report. This is actually a dotLRN install, so I would provide the link at the group, community and site-wide levels. It can be turned off by a package parameter.
Comments? Is this something that should be added to the toolkit?
I implemented this about 1.5 years ago on an OACS3.2.5 site for a corporate client. So this is at least the second time its been requested.
I implemented it with user_content_map by adding the file storage pages to the static content pages. I don't know if this approach would be applicable in 4x.
I think you shoudl consider the suggestions in this thread:
It would be good to try to find a more general solution then adding a table to File Storage. For instance what if next semseter dotLRN has expanded and your client puts class content into ETP, Photo Album, FAQ etc. then wants to know if the students have viewed this content?
Then you could maybe enable a service contract with file storage that add's an entry (or increases it) for that particular object.
In the long run you would not only have the valuable information, which user has viewed what document, but also what documents are the most popular. This would be a valuable addition to an universal grading system in that sense, that you could see, what object has been viewed by which user, but not yet rated by him. It would be especially interesting to get his/her rating/comments, if the file was downloaded a couple of times. But I'm sure I'm way out of scope here :).
So, my request / suggestion would be to keep the table as general as possible and use a counter with this table. If you can go one step further, make a seperate service package out of it. And make sure you can turn this off site wide and on a per user basis (if your client is keen on getting this data, but not all his users agree to it, and have the legal right to decline the collection of this data).
Last but not least, thanks for letting us know and getting the discussion out in the open!
For our purposes, a very basic solution would be sufficient i.e. just see the number of downloads for a particular file. To see who's downloaded the file would also be nice.
Do you have any concrete timeline for this to happen?
We do require both page based and a user based views. Our requirements are to track probably 2 dozen or so different pages, we do not require a solution that tracks every click.
We've been looking at the idea's Don and others have proposed for analyizing logs possibly using an open source log analyzer tool such as anlalog or webalize. aD used to have an old package for 3x called Reportee that was a wrapper for analog, which might be worth looking at as a starting point.
Does anyone else have similar requirements and an interest in this kind of approach?