Search
Items tagged with: ungoogled
Never could get any of the contacts merge scripts kindly recommended to me by the #AskFedi #HiveMind to work, but I finally found my own solution, which should hopefully work:
@libreoffice! ;) (and of course @thunderbird)
- Export contacts from Thunderbird to .csv
- Make a copy of Contacts.csv for safekeeping, I called mine "Contacts-before-jiggerypokery.csv" ;)
- Open Contacts.csv in LO Calc
- Create a key column (A), put "Join" as the label in A1
- Put
=TEXTJOIN(" ^ ",1,C2:AM2)
into A2 (You may have to replace AM2 with the end of your row if your CSV export has a different number of columns than mine) - Copy that cell and paste it down the entire column A (for every row that contains something)
- Select A1 only, go to Data | More Filters | Standard Filter...
- Make sure your A1 field ("Join") is selected, select "Not Empty" for the value, click "> Options" and select "No duplications" on the right
- Hit Ok
- Copy everything (now de-duped) to a new sheet, delete the old one
- Create another new column (B) just to the right of the "Join" column, call it "Repeat?"
- Paste
=IF(TEXTJOIN("",1,C3:D3)=TEXTJOIN("",1,C2:D2),"REPEAT","")
into B3 - Copy B3 and paste it down the entire B column (down to the end of the data)
- Look where you see REPEAT, and merge the rows that need to be merged
- Delete Columns A and B (which you added), and save the CSV
- Delete all of your contacts in Thunderbird, and import the new Contacts.csv
- Pray
- Sync your contacts
- Enjoy!!!
Disclaimer, again: I am still going through my spreadsheet, so I don't know for sure that this works!! XD
#ManageContacts #Contacts #DeDuplication #DeGoogled #UnGoogled #HowTo