That's a nice implementation because chances are a list item could be viewed tens of thousands of times and you may face scalability issues, so storing it straight in another database is a good idea. It's good that the data can then be accessed in a SharePoint site via a custom list item menu option and other ways in SharePoint sites. I've found I've been approaching some development in a similar way, ie. Don't store the data in SharePoint directly instead store it in another system and you can still surface the data in SharePoint, so it looks like SharePoint, smells like SharePoint but it isn't 100% SharePoint J This depends on whether users want a SharePoint List interface to manage the data though, and whether they need the other good stuff lists provide such as versioning, security, workflow etc.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Crabbe, David Sent: Friday, 8 August 2008 10:19 AM To: [email protected]; Hinson, Brad Subject: RE: [OzMOSS] RE: Hit count for list items... I've seen something similar done with an HTTP Module that records hits on the DispForm.aspx for a particular type of list. The viewing statistics are stored in a database rather than on the list itself and then made available by a feature which adds a new Viewing History option to the context menu for the list item. The viewing statistics are also made available on a dashboard page via Excel Services. Just a thought, David David Crabbe Consultant Web Solutions Team Fujitsu Australia Ltd T: +61 8 9268 1505 E: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Friday, 8 August 2008 6:47 AM To: [email protected]; Hinson, Brad Subject: [OzMOSS] RE: Hit count for list items... Actually, what you could probably do if you wanted to get tricky, would be to edit the javascript (or perhaps change the list template to use a new set of JS), such that it performs a client side script method call to a web service hosted under the same web application, which looks up the current item that you clicked, and performs the same increment on the column as mentioned below - but we're getting very hacky, and maintenance would be a concern. But it's just ASP.NET, so there's always a way around these things. Cheers, Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> Blog: http://cosier.wordpress.com<http://cosier.wordpress.com/> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Friday, 8 August 2008 8:43 AM To: Hinson, Brad; [email protected] Subject: [OzMOSS] RE: Hit count for list items... Hi Brad, You could have achieved this using an eventsink or a workflow attached to the list - however, there isn't a hook for when an item is opened, only when it's edited (correct me if i'm wrong there though). Does that suffice? This means a user would actually have to save the list item back into the list - aka, open a document, change it and save it, for instance. Once you have the entry point, you can write some code against the API which simply grabs the edited list item, takes the current value out of the custom field (column) and increments it, and shoves it back in. Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> Blog: http://cosier.wordpress.com<http://cosier.wordpress.com/> From: Hinson, Brad [mailto:[EMAIL PROTECTED] Sent: Friday, 8 August 2008 3:29 AM To: [EMAIL PROTECTED] Subject: Hit count for list items... Does anyone have a strategy for recording hits for individual items on a list? Ideally, I'd like a custom column that automatically increments (+1) each time someone opens the list item. That's it. Sounds simple, but I can't figure this one out. Any help would be appreciated. </brad> -------------------------------------------------------------------- Brad Hinson Open Learning Coordinator MiraCosta College 760-795-6745 ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you. If you do not wish to receive commercial email messages from Fujitsu Australia Limited, please email [EMAIL PROTECTED] ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
