Whenever I have worked on similar projects in ended up being the customer's idea of what a "close approximation" was that made a possible duplicate. It was usually something like: same birth date same last name same city (optional) same state (optional)
Since there is not such a thing as a tried and true method for what a duplicate record is I believe you'll just need to do some manual work. My advise would be to ask your customer/boss for what the rules are. On Jul 11, 4:29 pm, Justin Stanczak <rizen...@gmail.com> wrote: > Yes, this is all very true. I was thinking if a comparison was done on > multiple attributes that would help with just one name being wrong. I'm not > looking for magic, just wondering how others find duplicated records. I > could see this being used to detect data that links or is similar in nature. > > Found this as > well.http://en.wikipedia.org/wiki/User:Ipeirotis/Duplicate_Record_Detection > > > > > > > > On Mon, Jul 11, 2011 at 4:17 PM, pepe <p...@betterrpg.com> wrote: > > I don't believe you're going to find a magic formula for what you're > > suggesting. The same thing could be said about last or first names as > > you are suggesting could happen with SSNs. What if somebody misspells > > Smith for Smit, for example? But worse yet, what if it is not a > > misspelling situation and the Smit is actually Smit? The same is true > > for SSNs, switching the last 2 digits does not mean it was a > > "misspell", it could just be that 2 different people have the same > > name and very similar SSNs. You have to draw a line somewhere, I > > think. > > > You could use auto-complete fields and then provide options based on > > records found using the 'LIKE' option in the where clause using the > > information currently being entered. That might help but I think > > you'll find it's not worth the effort. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.