Software development

Downloading backups from remote hosts

rsync -av --delete -e 'ssh -p 223' user@host:/dir1 local_dir

#soft #linux

Google Sheets: Bulk delete

Tools > Script ediotr Set a breakpoint at console log sheet name and Debug.

function DeleteAllSheets() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  console.log("Doc: " + ss.getName());
  var sheets = ss.getSheets();
  for (i = 0; i < sheets.length; i++) {
    switch(sheets[i].getSheetName()) {
      case "21-01":  
        break;
      default:
        console.log("Delete: " + sheets[i].getSheetName());
        ss.deleteSheet(sheets[i]);
    }
  }
}

https://spreadsheetpoint.com/delete-multiple-sheets-google-sheets/

#soft

Convert ssh2 public key to openssh format

If the pub key is in the format

---- BEGIN SSH2 PUBLIC KEY ----

then you can convert it with

ssh-keygen -i -f klucz.pub >> ~/.ssh/authorized_keys

#soft #linux