Computer

Automation, coding, the use of a computer for productivity.

Excel Sorting and Grouping

by

I had two tables downloaded from Amazon: Items Order Date Order ID Title Category 1/26/14 102-4214073-2201835 Everyday Paleo Family Cookbook 1/13/14 115-8766132-0234619 Awesome Book A 1/13/14 115-8766132-0234619 Awesome Book B and Orders Order Date Order ID Subtotal 1/6/14 102-6956821-1091413 $43.20 1/13/14 115-8766130-0234619 $19.42 1/16/14 109-8688911-2954602 $25.86 I’m building our Q1 2014 taxes and needed rows … Read more

OFX for USAA via Ruby

by

My wife and I have been through roughly 10-15 different budget/financial tracking systems. We started with every penny in MS Money, used several different spreadsheets, spent several years in Mint and have pretty much dropped all of that for a top-down strategy that has us budgeting savings, non-discretionary spending, and a rainy day buffer and … Read more

MiCasa Verde (MiOS) DataMine Logging

by

For my home automation goals, I chose MiCasaVerde VeraLite due to my friend’s recommendation. The VeraLite is a small linux controller that runs the MIDIbox Operating System MiOS and gives a homeowner the ability to easily control lights, security cameras, door locks, alarm systems, and even the thermostat, among many other home systems. For example, … Read more

WordPress Development Workflow

by

When I work with WordPress, I am still a ruby coder in a PHP environment. I spent several years doing PHP only and have watched the language develop nicely, but still like to focus on Concept/Design, CSS3, Ruby and JavaScript when I’m doing web development work. In the hope that someone might benefit from my workflow, I’m sharing my basic setup.

Read more

Radiant to WordPress Conversion

by

First I had to backup my database from Heroku — so I created the database in PostGresSQL. heroku pgbackups:capture curl -o latest.dump `heroku pgbackups:url` pg_restore –verbose –clean –no-acl –no-owner -h localhost -d booher_blog latest.dump Armed with that and the handy Induction I then needed to get my data into a format easily imported by WordPress. … Read more

Find corrupted images

by

So I deleted all my pictures, and I restored them which resulted in a bunch of corrupted images; thousands of corrupted images. To fix this, I wrote the following script in MATLAB using the image processing toolbox: // insert blog here Using matlab I tried to determine what a corrupted image is. First when using … Read more

Your key with fingerprint … is not authorized to access heroku with Ubuntu

by

This error was pretty hard to solve. I emailed heroku support and they recommended: “https://github.com/ddollar/heroku-accounts”:https://github.com/ddollar/heroku-accounts bq. For git commands to work git needs to use the ssh key associated with that account. It’s probably choosing a key associated with a different account which is causing these permissions errors. You can use a ~/.ssh/config file to … Read more