TheBoohers.org

Leader | Engineer | Hacker | Dad

Excel Sorting and Grouping

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

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

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

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 […]

Read More

WordPress Theme Development

I’ve started to get much more serious about WordPress themes. For me that means making them from scratch instead of modifying someone else’s theme. Traditionally, I just purchased a template and modified it. Now I’m starting to work with good designers and working from scratch.

Read More

Workout Tracking Solution

I love to exercise. It gives me an excellent chance to relax and preserve my overall goal of maximizing my physical strategic margin, or keeping maximum function as long as I can. (I want to be able to wrestle with my grandkids as long as I can.) I also love data. I love to track […]

Read More

Radiant to WordPress Conversion

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

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

Removing Images of a certain size

I had a bunch of bogus images in my directory and I was going through and manually deleting them. I wised up a little bit and thought I would write a quick script. While it ran, I thought I would share with you. I had: 25760 images and probably about 15,000 of them were bunk. […]

Read More

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

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