Forum OpenACS Q&A: Re: Is anyone interested in download reports for file storage?
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!