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)

1. Export contacts from Thunderbird to .csv
2. Make a copy of Contacts.csv for safekeeping, I called mine "Contacts-before-jiggerypokery.csv" ;)
3. Open Contacts.csv in LO Calc
4. Create a key column (A), put "Join" as the label in A1
5. 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)
6. Copy that cell and paste it down the entire column A (for every row that contains something)
7. Select A1 only, go to Data | More Filters | Standard Filter...
8. Make sure your A1 field ("Join") is selected, select "Not Empty" for the value, click "> Options" and select "No duplications" on the right
9. Hit Ok
10. Copy everything (now de-duped) to a new sheet, delete the old one
11. Create another new column (B) just to the right of the "Join" column, call it "Repeat?"
12. Paste =IF(TEXTJOIN("",1,C3:D3)=TEXTJOIN("",1,C2:D2),"REPEAT","") into B3
13. Copy B3 and paste it down the entire B column (down to the end of the data)
14. Look where you see REPEAT, and merge the rows that need to be merged
15. Delete Columns A and B (which you added), and save the CSV
16. Delete all of your contacts in Thunderbird, and import the new Contacts.csv
17. Pray
18. Sync your contacts
19. 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

Do you ever stumble upon an old Excel file that's locked with a password and you can't remember what it is? This can be incredibly frustrating, especially if the file contains valuable data! 😩

In my latest video, I show you a surprisingly easy way to remove worksheet protection from any Excel file, even if you don't have the password! This trick is perfect for those times when you're locked out of your own information.

The best part? You don't need any fancy software to do it! Just a little bit of text editing will do the trick. 😉
Check out my full video here: youtu.be/68goS6XdoW0

#excel #howto #productivity #exceltips #microsoft #office #tutorial #tech #software #spreadsheets #YouTube #Feditips

There are two ways to add your keys to #FileZilla.

You can add your keys inside the "Site Manager":

Go to:
File -> Site manager ..

Protocol:
In the settings panel for a given site select sFTP:

Add domain IP or domain name:

Logon Type:
Select "Key File"

Add the user name to log onto the server:

Browse for the .ppk you want to add and select it:
FileZilla offers you also to add .pem (privkey.pem) files, that's the #puTTy option for a file containing only the extracted private key of keyfile.ppk. At the same time FileZilla doesn't read/accept .pem files so it will prompt you to transform it into a .ppk file. If your .ppk is protected by a password (it should be), you get prompted to insert the password.
It is not clear if the newly created .ppk file from the .pem file by FileZilla is protected with the same password. It doesn't feel like that.

Save the changes and connect to your server.

The other option to add your key to FileZilla is by adding it directly to the main settings.

Go to:
Edit-> Settings ..

Choose SFTP and select the "Add key file" tab:

Add the key file and save.
If you use the input fields and quick connect options of the main FileZilla window, the keys saved in settings will be retrieved.

#linux #windows #howTo #fediVerse

Espresso is the most precious thing to me in the world and scope of coffee. For me at least, it's the ultimate expression, not to mention extraction, of what high end specialty coffee can offer. In 20 years, we've had many variants of our "How to Make Espresso" guide up on CoffeeGeek. It was revised again this summer, putting more focus on WDT and how even just using a paperclip can make your coffee better.

coffeegeek.com/guides/espresso…

#espresso #coffee #coffeeguide #howto #coffeegeek

How To Make an Espresso: the Definitive Guide » CoffeeGeek

It's the big kahuna of our How To guides, and the basis on which to build hundreds of drinks: our Espresso How To! Updated Oct 1, 2023.

^{Mark Prince (CoffeeGeek)}