John Smith solrevdev

How to "Schedule Automatic Backups" of your Google Sheets

This tutorial demonstrates how to use Google Apps Script to:

Create copies of the Google Sheet in the desired destination folder automatically at set intervals.
Append the time stamp with each backup file's name.
Adjust time trigger for backing up every day/hour/minute.

macOS Keyboard Shortcuts You Should Know

These keyboard shortcuts will work in most, if not all text editing places in macOS. (Form input, text editors, web browsers etc.) These keyboard shortcuts will also work on Windows (replace CMD with CTRL).

Jump Over Words

ALT + Left/Right

Go to end of line

Option 1: Command-line download extension as zip and extract

extension_id=jifpbeccnghkjeaalbbjmodiffmgedin   # change this ID
curl -L -o "$extension_id.zip" "https://clients2.google.com/service/update2/crx?response=redirect&os=mac&arch=x86-64&nacl_arch=x86-64&prod=chromecrx&prodchannel=stable&prodversion=44.0.2403.130&x=id%3D$extension_id%26uc" 
unzip -d "$extension_id-source" "$extension_id.zip"

Thx to crxviewer for the magic download URL.

Add Git Branch Name to Terminal Prompt (Linux/Mac)

Open ~/.bash_profile in your favorite editor and add the following content to the bottom.

# Git branch in prompt.

parse_git_branch() {

Auto-deploying built products to gh-pages with GitHub Actions

This is a set up for projects which want to check in only their source files, but have their gh-pages branch automatically updated with some compiled output every time they push.

A file below this one contains the steps for doing this with Travis CI. However, these days I recommend GitHub Actions, for the following reasons:

It is much easier and requires less steps, because you are already authenticated with GitHub, so you don't need to share secret keys across services like you do when coordinate Travis CI and GitHub.
It is free, with no quotas.
Anecdotally, builds are much faster with GitHub Actions than with Travis CI, especially in terms of time spent waiting for a builder.

Exporting (iCloud) Keychain and Safari credentials to a CSV file

Update (October 2021)

Exporting password + one-time code data from iCloud Keychain is now officially supported in macOS Monterey and Safari 15 (for Monterey, Big Sur, and Catalina). You can access it in the Password Manager’s “gear” icon (System Preferences > Passwords on Monterey, and Safari > Passwords everywhere else), or via the File > Export > Passwords... menu item). You shouldn't need to hack up your own exporter anymore.

Original, Obsolete Content (2014)

After my dad died, I wanted to be able to have access any of his online accounts going forward. My dad was a Safari user and used iCloud Keychain to sync his credentials across his devices. I don’t want to have to keep an OS X user account around just to access his accounts, so I wanted to export his credentials to a portable file.

	# Simple No-ip.com Dynamic DNS Updater
	#
	# By Nathan Giesbrecht (http://nathangiesbrecht.com)
	#
	# 1) Install binary as described in no-ip.com's source file (assuming results in /usr/local/bin)
	# 2) Run sudo /usr/local/bin/noip2 -C to generate configuration file
	# 3) Copy this file noip2.service to /etc/systemd/system/
	# 4) Execute `sudo systemctl daemon-reload`
	# 5) Execute `sudo systemctl enable noip2`
	# 6) Execute `sudo systemctl start noip2`

	#!/bin/bash

	# Shell script to scan files using VirusTotal service (https://www.virustotal.com)
	#
	# Author : saf1
	# Home : http://www.linuxac.org
	# Date : Mon Aug 20 2012
	# Dependencies : md5sum, curl, And don't forget to be connected

	help(){

	#!/usr/bin/env ruby
	#
	# Convert blogger (blogspot) posts to jekyll posts
	#
	# Basic Usage
	# -----------
	#
	# ./blogger_to_jekyll.rb feed_url
	#
	# where `feed_url` can have the following format:

	#!/bin/sh

	# Alot of these configs have been taken from the various places
	# on the web, most from here
	# https://github.com/mathiasbynens/dotfiles/blob/master/.osx

	# Set the colours you can use
	black='\033[0;30m'
	white='\033[0;37m'
	red='\033[0;31m'