RE: SOT: Garbage Data Detection/Prevention

[Gavin Brook]

Yeah, I agree. I only really want to find out who's doing it so they can be
better trained.

The spelling check is a good idea. It will at least cut the list down.

At the minute I've basically got the system to checking user data on the fly
to check for duplicates, required fields and validation of phone numbers,
etc.

-Original Message-
From: Ryan Emerle [mailto:[EMAIL PROTECTED] 
Sent: 01 December 2004 14:17
To: CF-Talk
Subject: Re: SOT: Garbage Data Detection/Prevention


The only thing i would suggest is that you don't alienate your users by
implmenting some flawed garbage detection scheme.  There will be some users
whose name really is "Sadf Dsij" (even if it's not an international site).

If you do anything, i would run your algorithm in the background and simply
flag the accounts for human review if they seem off.  One method would be to
run a spelling-type check and based on the number of possible errors, you
can flag the entry.

The last thing you want to do is piss of your users so that you have less
work to do :)

-R


~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185792
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SOT: Garbage Data Detection/Prevention

[Ryan Emerle]

The only thing i would suggest is that you don't alienate your users
by implmenting some flawed garbage detection scheme.  There will be
some users whose name really is "Sadf Dsij" (even if it's not an
international site).

If you do anything, i would run your algorithm in the background and
simply flag the accounts for human review if they seem off.  One
method would be to run a spelling-type check and based on the number
of possible errors, you can flag the entry.

The last thing you want to do is piss of your users so that you have
less work to do :)

-R


On Wed, 1 Dec 2004 13:39:24 -, Gavin Brook <[EMAIL PROTECTED]> wrote:
> Hi All,
> 
>   I've got a CF/SQL Server 2k application that serves several hundred users
> and is designed to store large amounts of data. I have built in many checks
> and restrictions into the application to prevent incorrect data being
> inserted. But there is a proportion of users who are circumventing these
> restrictions by entering garbage data. For instance, where a name is
> required, they would enter "jdsl".
> 
>   There is only so far I can go to do checks as data is input, so I need to
> concentrate on user education by finding the culprits. There is full
> auditing of the data and to this end, I was wondering if anyone had any
> thoughts on ways to find garbage data, or other steps I could take to
> prevent it. Most of the data in the system is fine, so I was thinking maybe
> somehow comparing data with other examples of correct info to root out the
> garbage. I'm just not sure how!
> 
>   Any thoughts or suggestions would be greatly appreciated.
> 
> Thanks,
> 
> Gavin
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185790
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54