Dealing with SharePoint Spam Comments
Joel Oleson has published an article on dealing with SharePoint spam comments. If you have a public facing site with a SharePoint blog receiving comments, this is a must read. The last time I checked, my comment spam blocker on this site caught over 40,000 pieces of junk.
Here are a couple of tips I found useful. You can read the entire article on his site, SharePoint Joel.
“I learned that all other views, other than dataview are a pain to delete items, and even editing large quantities of items going from page to page in all other views, was simply not worth my time.”
“I was editing a list with more than 10,000 items and the best way to manage it was to 1) Use the datagrid view 2) Limit the items to groups of a few hundred. A thousand was doable, but more than that I felt like I was waiting. 3) Limiting the columns to those that I needed to see also helped improve the query response time”
“When using dataview be sure to note the little progress bar in the bottom right hand corner. If you ever delete like 700 rows at once it can take a while. It will let you continue doing other operations, but if you refresh it will warn you… if you ignore the warning you will find out later it wasn’t done. Bad news. Pay attention to ‘Pending Changes’”.
Full article: Working with HUGE lists – My Real World Experience Dealing with My Blog Spam Comments List
This is a great tip, I know the Enhanced Blog Edition from CKS has the CAPTCHA feature to help block spam, so that’s a great option.
On my blog, which isn’t using the EBE release yet… I built a custom workflow to delete spam. Michael Gannotti has a great post on creating a required column and using approval. I took his method and extended it w/o approval to a workflow that would check this column’s entry and make sure it had the right characters or else it would be deleted. This has worked pretty well so far, it’s like a homemade CAPTCHA that never changes :P