Categories
Random

How to setup SSH Keys (TL DR;)

SSH Keys are wonderful and easy to set up. You can SSH keys to quickly log into a remote server (like your website) from the command line WITHOUT a password prompt.

How does it work?

Essentially SSH works by generating two keys (strings) on your machine: a public and a private one. You place the public key on a external server and when you log in the server makes the connection and access is granted.

How do I do it?

Setting up SSH can be done in as little as two steps:

  1. Generate SSH key Pair
  2. Copy public key to remote server (where you want to login)

Generate SSH Key Pair

First generate the SSH key pair with ssh-keygen.

ssh-keygen -t rsa

You will be asked where you want to store the file and whether or not you want a password, I just click ENTER twice.

Copy the public SSH key

Use ssh-copy-id to quickly move the public SSH key to the remote server.

ssh-copy-id user@example.com

You must know the username of server you are trying to access.

Categories
Random

How to Match & Index with Excel & LibreOffice Calc

Match and index is a super useful tool that has personally saved me hours of manual copy and pasting of information.

Instead there is a better way. All you need is two sets of data, and a point where they match.

In my experience, I’ve used this to match two price lists based on SKU and easily copy over UPC codes, weight, our cost and other useful information you may want to upload to your wordpress database or whatever.

Here is a brief example of how to do this- it works on Microsoft Excel and LibreOffice Calc.

Essentially, we are going to use the MATCH and INDEX functions common on most spreadsheet programs to copy over some data (like price) based on a match in the same row (like SKU).

INDEX(the column you want to copy, MATCH(the cell you want to match, the column of data you are matching against))

Keep in mind

Match sure all data is formatted the same way; strings will not match numbers.

Make sure you make the row absolute (A$5).