Import creates duplicates

[GoogleCodeExporter]

If a secrets.csv is imported into an existing DB, and there are identical
entries, the import creates new, duplicate records from the import.

The import should overwrite the existing data (although this could be
optional behaviour). A key match could be on description. 

My master password data is held on my desktop PC and manually sync'ed with
Secrets whenever it changes. Currently this requires me to export-to-csv,
remove all unchanged data, import and remove the older duplicate entries in
Secrets. 

Seen on G1 running Android 1.5.

Original issue reported on code.google.com by nWaHmAeT on 12 Aug 2009 at 2:02

[GoogleCodeExporter]

I'm not sure "description" is unique enough to determine duplicates.

Original comment by roge...@gmail.com on 28 Aug 2009 at 1:19

• Added labels: Type-Enhancement
• Removed labels: Type-Defect

[GoogleCodeExporter]

Make a checksum on every entry and then validate if there are two entry's whit 
the
same checksum.

Original comment by FamDragic on 17 Sep 2009 at 6:43

[GoogleCodeExporter]

Original comment by roge...@gmail.com on 21 Sep 2009 at 11:34

• Changed state: Accepted

[GoogleCodeExporter]

Original comment by roge...@google.com on 14 Jan 2010 at 4:54

• Added labels: Import

[GoogleCodeExporter]

It would be good to offer some choices on import. Actually, in my case, just a 
confirmation dialog would be good since it's easy to accidentally run import. 
Another option would be to import from a different file name than what is 
written.

In the mean time, I wrote a script to de-dupe the .csv file using autohotkey 
(autohotkey.com).

Original comment by wink...@gmail.com on 2 Dec 2010 at 8:23

Attachments:

• dedupe_android_csv_secrets.ahk

[GoogleCodeExporter]

Hi winkcom,

Yes, it would be good to add a confirmation dialog before doing the import.

Original comment by ro...@tawacentral.net on 3 Dec 2010 at 12:44