I have a need to keep track of who opened a document in the website. For example, I have built a module (called Projects) in which a 'project' can be associated with a document (document is a custom field of type 'Media').
I've looked at this posting http://www.sitefinity.com/developer-network/forums/developing-with-sitefinity-/how-do-i-track-who-is-accessing-documents and see how I can get the user information for who's accessing the files...My question is what would be the best approach to take in order to store this information so that it can be viewed/accessed later on (in a report). I'm not interested in storing this information in a log file as that's not an appropriate place to store this type of information. This information needs to be retained indefinetly.
What are my options? Create a custom table in the sitefinity database? Create a custom database to store this? Create some other type of module to associate this with?
I'd appreciate any input you might have.
I guess depends on your requirements :)
1) Like it might be neat to create a longtext field on the document itself, and everytime the event fires append the username to that longtext...
2) Or create a new table and map it in using OpenAccess, then just update that
3) Create a new Module builder type to store the data, on download run some code to add a new entry. Downside here is the download "log" is separate from the document in the UI.
So option 1&2 mean you don't have to create a UI to show the data...
I would defiantly not create a new DB though...just no need.