I noticed my import contacts icon is missing from my phone. I was messing around with that problem and now I have 5 copies of each entry in my contacts. What folder is the contacts data located? So I can clear the contents and import a backup again.
Refer https://source.puri.sm/Librem5/community-wiki/-/wikis/Tips%20&%20Tricks#contacts for the location
but that looks like a database, not a folder, so I would be cautious about just blowing it away.
If you are handy with sqlite, you can probably delete contacts more cleanly but even then it would be possible to mess something up depending on how complex the schema is.
I never did anything with sqlite.
This is a handy little tool (may want to open on a PC or L5 in docked mode as I doubt it will look good on the L5’s screen) for viewing SQLite databases.
This will let you view the tables, run queries, whatever.
If you’re not super familiar with SQL then it won’t be the easiest thing you’ve ever done. But it may be worth a shot.
That works great, I can open the database and browse data. I see the mulitple entries. Is there an automated way to delete duplicates?
I would export them to VCF file, use split to get for any contact a single file, use some Linux cmd to remove the dup files, concat the rest and import.
Yeah this may be safer than editing the SQLite database manually.
If you do delete rows in the DB, I would back up the file first in case something goes wrong.
Having done that I would just delete all contact rows from the database and then exit from sqlite and then reimport the contacts as originally done (but only doing it once ).
Thanks for the tips, I’ll give it a try this weekend