<a class="reference external image-reference" href="http://www.gnu.org/licenses/agpl-3.0-standalone.html"><img alt="License: AGPL-3" src="https://img.shields.io/badge/licence-AGPL--3-blue.svg"> </a> <a name="deduplicate-contacts-by-similar-name"></a> <h2>Deduplicate Contacts by similar name</h2> <p>This module extends the criteria to match duplicated contacts looking for similar names according a maximum of different characters.</p> <a name="installation"></a> <h3>Installation</h3> <p>You need to have the <em>fuzzystrmatch</em> Postgres extension installed. You can add it from a psql command line typing:</p> <pre> <code lang="psql">CREATE EXTENSION fuzzystrmatch;</code> </pre> <a name="usage"></a> <h3>Usage</h3> <p>To use this module, you need to:</p> <ol class="arabic simple"> <li>Go to <em>Sales &gt; Tools &gt; Deduplicate Contacts</em>.</li> <li>Mark &quot;Similar name&quot; in the section &quot;Search duplicates based on duplicated data in&quot;, and select the maximum number of different characters that you are going to allow.</li> <li>This criteria will be used for deduplicating.</li> </ol> <a class="reference external image-reference" href="https://runbot.odoo-community.org/runbot/111/8.0"><img alt="Try me on Runbot" src="https://odoo-community.org/website/image/ir.attachment/5784_f2813bd/datas" /></a> <a name="known-issues-roadmap"></a> <h3>Known issues / Roadmap</h3> <ul class="simple"> <li>The similarity is not a transitive operation (it's only symetric and reflexive), which means that we cannot set an equivalence relation. This makes that the search is perform through a pivot partner, and looking for similar names to it, but no subsequent searches are performed for finding similar names to the results, or you will probably match everything. Imagine you have &quot;Maco&quot;, &quot;Mala&quot; and &quot;Rala&quot;, and you put a difference of 2 characters, &quot;Maco&quot; will match with &quot;Mala&quot;, and &quot;Mala&quot; will match with &quot;Rala&quot;, but &quot;Maco&quot; won't match with &quot;Rala&quot;. The current algorithm will match only the first two, losing the second similarity.</li> </ul> <a name="bug-tracker"></a> <h3>Bug Tracker</h3> <p>Bugs are tracked on <a class="reference external" href="https://github.com/OCA/crm/issues">GitHub Issues</a>. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.</p> <a name="credits"></a> <h3>Credits</h3> <a name="images"></a> <h4>Images</h4> <ul class="simple"> <li>Odoo Community Association: <a class="reference external" href="https://github.com/OCA/maintainer-tools/blob/master/template/module/static/description/icon.svg">Icon</a>.</li> </ul> <a name="contributors"></a> <h4>Contributors</h4> <ul class="simple"> <li>Pedro M. Baeza &lt;<a class="reference external" href="mailto:pedro.baeza&#64;tecnativa.com">pedro.baeza&#64;tecnativa.com</a>&gt;</li> </ul> <a name="maintainer"></a> <h4>Maintainer</h4> <a class="reference external image-reference" href="https://odoo-community.org"><img alt="Odoo Community Association" src="https://odoo-community.org/logo.png" /></a> <p>This module is maintained by the OCA.</p> <p>OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.</p> <p>To contribute to this module, please visit <a class="reference external" href="https://odoo-community.org">https://odoo-community.org</a>.</p>