SharePoint University

Hello There,

We have a requirement to check for bad words entered in the reply content on the share point forums.

Following is the requirement & business logic needs to be implemented,

 1. The admin will enter list of bad words (the following is the abitary words used for explanation) i.e "Bad word1", "Bad word2", "Bad word3"...and so on.....

2. On the reply page in the share point forums, if the user reply "Body" or "Subject" contains any of the admin entered bad words, the admin should recieve an email with subject and body of the thread reply content in the email body.

3. The admin will be notified over email and he would visit to the forum for review. T

he forums will be not be premoderated so we would not post the reply for approval instead we would inform the admin over email. The problem we are facing right now is how or where should the bad words saved ( content database or business database). If in either case how can we achieve validating user entered reply content against the badwords. PLEASE HELP! Any approaches or solutions will be highly appreciable.

Cheers.

Probably a number of different approaches you could take on this:

Attempt to parse out the contents of the "reply" editor form (not sure if its possible on the default built-in editor) and generate an email if a specific keyword (bad word list) is found.

Run a custom workflow that looks at the body of the response and if it finds a specific keyword, generates the email (probably a Visual Studio workflow - I dont think this would be possible with the simple workflows available through SP Designer).

Run a custom stored procedure on the SQL server that listens for an Add Record event on the database and runs through the reply data looking for a keyword, and if found, will fire off an email.  In this case you'd store the list of bad words in a separate table that you'd run the comparison against.

Realistically, the third option is what I'd probably look into since I've used other "listeners" on the database in the past and have been successful at it.  Of course you always want to keep in mind the idea that Microsoft does not endorse or support direct manipulation of the database, but in this case you're really just reading it...which in my mind, is ok (my opinion only).

Whatever approach you take, its an interesting endeavor - so good luck with it!

- Dink

Hello Dink,

Thanks for your suggestions. I would look into your suggestions with my developer, from the first expression it looks its not going to be simple & straightforward.

I would appreaciate just incase you come across any article or forum thread describing any solution to our problem would be very helpful.

Thanks,

Amit.