Skip to main content
November 27, 2021
Question

Tool for detecting and removing duplicates? [Available in 8.10.18]

  • November 27, 2021
  • 179 replies
  • 15906 views

https://1password.community/discussion/comment/697252/#Comment_697252

I have several logins that somehow have been duplicated in 1Password 8. This may have happened in different times when I've attempted to migrate my 1Password 7 data to my 1Password.com account.

In any case, I have a load of duplicates in 1Password 8 and it would be very helpful if there were an efficient tool or feature to help me merge/dedupe these entries (and ideally test them to make sure that I'm preserving the correct credentials).

Any thoughts/ideas for how to handle this situation?


1Password Version: 1Password for Mac 8.5.0 80500017, on BETA channel
Extension Version: 2.1.4
OS Version: macOS 12.0.1 (21A559)

https://1password.community/discussion/comment/662923/#Comment_662923

179 replies

1P_Dave
1Password Employee
January 11, 2023

@kjdiehl

Please don't post the same comment in multiple threads. I've replied to you here: https://1password.community/discussion/comment/670977/#Comment_670977

Let's continue the discussion in the other thread. 🙂

-Dave

January 16, 2023

Consider this yet another vote for deduping. My duplicates are somehow the result of switching from a local vault to an online account so I really feel the onus is on Agilebits to fix this.

January 17, 2023

In an ideal world, nobody will duplicate data at import time, but actually it will happen. I will not discuss how it can happen or can be avoided, only that it will happen - proof is this thread and others. Duplicate items are not always user error. Switching to a decent password manager often means merging from multiple sources, then consolidating: import from previous password manager plus Chrome's plus Firefox's plus Safari's internal password managers.

One does import once directly after account creation, then never again. You at Agilebits do it never again, so you don't see really any need for postprocessing aid. However, for a new user it's crucial, it's a barrier.

With duplicate items I mean login items that contain the same userid+password combination.

What I propose you can do about this:
- give an overview how many items match above description, in a similar way Watchtower does this. Also create filters, so the user can see a list of only matching entries.
- also give an overview how many items match with url+userid, but different password. These might represent current and obsolete entries of the same login. The category could be something like "unable to merge", "merge conflict" or "password mismatch". Also make a filter for these.
- explain if duplicates are distributed over multiple vaults. If 2 vaults contain the same, because the user imported the same 2 times, the user should see this and the easy fix for the user is to just delete one of these vaults
- make it clear over how many different vaults how many duplicated entries are distributed
- add the opportunity to "merge" duplicate entries in one vault, in spirit similar to functions to merge different address entries in address books in other apps. Merge only items within the same vault.
- this merging would be available from the context menu you get if you select multiple entries. Merging candidates are only taken from the entries the user selected.
- This merging functionality could find login entries with same userid+password combination, then choose the oldest entry as "merged" entry. Then merge all URLs from the other entries to this entry, the same with any custom fields and sections with different values (don't add custom fields with same title+value multiple times). And merge the password history of course. Also skip merging for history entries with identical password+timestamp combinations. After merging, add the tag "merged " to the merged entry (so the user can find all processed entries and can check if all is ok). Then delete the items their content was merged into the merged item.

It's an investment in getting new users. I bet the turnover rate from ex-Lastpass users would be higher if you had such a functionality.
When I was new, I merged entries from Password Safe and Chrome. I almost gave up, because it was so tedious - after all, Chrome autofill wasn't that bad, and Password Safe for just a local vault also wasn't that bad for all non-browser login items. A month after the trial expired I gave it a second shot and decided to do the tedious work.

1P_PeterG
Community Manager
January 18, 2023

Hi @peregrine, sorry that this happened in the switch. I have added a vote for the feature on your behalf. Thanks for letting us know why this matters for you.

1P_PeterG
Community Manager
January 18, 2023

Thank you Former Member for the in-depth and considered post here. Your reasoning makes sense to me. I'll pass this on to our Product team immediately so that it can inform the process going forward, and of course will update here should we have more to share. Many thanks 🙏

January 27, 2023

+1

February 6, 2023

I am looking for a password manager app... but the lack of facility to remove duplicates is a non- starter... I'll keep looking.

spinoza
February 16, 2023

I'm one of those who have been asking for this to be fixed for NINE years. Thousands of duplicates introduced when migrating from standalone to Cloud, for 1Pass 6, before someone fixed the bug that prevented the problem. Early adopters were affected (and neglected) most.

The Team came close to fixing it with a tool in 1Pass 7. The tool was still too restrictive, but it got rid of some duplicates. It always felt as though any college programmer could fix the problem in an hour or two.
They removed the tool altogether when introducing 1Pass 8.

The Team has never been willing to share exactly why they won't allow us to modify the database entries in a list fashion, or in bulk.
I'm guessing the main reason is not because this is difficult to do, but rather they're afraid that divulging the format of the database, will give away some trade secret.

spinoza
February 16, 2023

I agree with Former Member, a Merge function would help a lot.

March 13, 2023

2023 and we are still counting votes... Sorry fellows, we have been forgotten :(