Find duplicate or very similar entries

[smehrens]

Summary

Pleace provide a "find duplicates" to show all entries with same (username and password) or (website and username) and
a) delete duplicate entries
b) mark one entry as "main" and set references to password (and maybe username) in all "minor" entries.

Examples

Multiple entries for user "amueller for" websites:
account.foobar.com
cloud.foobar.com
groupware.foobar.com
external-tools.barfoor.com

click on "find duplicate":

• entries with same passwords are shown in a list.

select main account:

• one entry (eg. account.foobar.com) is tagged as (foobar.com - main account).
  select moinor accounts:
  in cloud.foobar.com username and password is replaced by a reference to account.foobar.com and a tag (minor of account.foobar.com)

Context

To found duplicates and delete or link(references) them

[smehrens]

okay sorry... a just found a way for a)
by filtering the list and by showing the passwords.

but there ist no easy way to reference to entries.

[droidmonkey]

Reference syntax: https://keepassxc.org/docs/KeePassXC_UserGuide#_entry_cross_reference

We have had requests for 'duplicate detection' before. I cannot find an open issue so I'll keep this one open.

[brianjmurrell]

We have had requests for 'duplicate detection' before. I cannot find an open issue so I'll keep this one open.

#2202 perhaps? Although that one is for a manual de-duplication, I suggested that automatic duplication detection would be more ideal.

[Viper780]

Reference syntax: https://keepassxc.org/docs/KeePassXC_UserGuide#_entry_cross_reference

We have had requests for 'duplicate detection' before. I cannot find an open issue so I'll keep this one open.

should be #750 or #2369

because of merging some databases I have many duplicates but with small differences (other Favicon, different subdomain, different comment,...)

[nerdoc]

I think this iss not the same as #551. A Health check tool can make use of duplicate detection. But if you merge another db into yours, typically a diverged copy of your passwords db, 99,9% are duplicates, you want to just "add" the 3 passwords you saved accidentally in your other copy.
So the health check does not apply, as the db is already "health checked", and let's say all passwords are super-secure and unique. Except the 99,9% of the just merged.

And this must be done at the merging procedure. So when some passwords are matching 100%, just don't include them.

[droidmonkey]

This would never be implemented to exclude valid merge entries. That would be completely improper. This is most useful as a report (allongside the other database reports) that allows you to make a decision on the various entries.

PS- if you know which 3 entries need to be moved over just open both databases and drag/drop the 3

[nerdoc]

But what is the valid use case of having an exact copy of an already existing entry? I just can't think about one. If I have a double entry, I delete one, as it leads to problems when you change one of the two and have diverged entries.

[Viper780]

Exactly there is no point to have double entrys. But when importing some hundred entrys and have of them are duplicates (maybe with a different comment, another favicon or in a different group) finding and deleting them by hand is half a days work.

Keepass has a duplicate check which is very helpful and it would solve such problems in seconds

[droidmonkey]

The only time you have a true duplicate in the keepass world is when two entries have the same uuid.