Login  Register

Re: Object De-Duplication

Posted by David E Jones-2 on Sep 14, 2006; 8:03am
URL: http://ofbiz.116.s1.nabble.com/Small-bug-in-Entity-Engine-tp141811p141817.html


There is some similar stuff in the catalog manager for creating a  
product in a category (if I remember right) that searches for  
existing products based on certain information. There isn't anything  
special about this type of functionality so I don't think you'll find  
any secrets or re-usable code there... this sort of thing is just a  
couple of screens for user interaction and some queries to aid in  
that interaction...

-David


On Sep 14, 2006, at 12:27 AM, Amit Shinde wrote:

> Hello,
> We need to create parties and on the creation process we need to  
> first take
> certain fields, and search the database to make sure the contact or  
> company
> doesn't already exist. The user should be presented with the list of
> potential matches, which can then be selected or the user can  
> continue with
> new input.
>
> This automated search capability will be integrated into the creation
> process of various objects to avoid data duplication.
>
> For "Person" we need to check:
> SOUNDEX(First Name), SOUNDEX(Last Name), EXACT(Telecom Number),
> EXACT(Email)
>
> For "Company" we need to check:
> SOUNDEX(Company Name), EXACT(ZIP), EXACT(PHONE)
>
> Has anyone worked on anything similar to this? Any directions  
> would be
> appreciated.
>
> Thanks in advance.
>
>
> Amit Shinde
>