note to self

Finding duplicate records in a books to prisoners database application

December 9th, 2009 by Geoffrey Hing | No Comments

High on my list of neglected tech. projects is the Testament books to prisoners database web application.  This is the database program that projects like the Midwest Pages to Prisoners Project use to track packages sent and returned and books requested in the hopes avoiding delays in delivering books to incarcerated people and to provide […]

String mangling in Excel/VBA

December 7th, 2009 by Geoffrey Hing | No Comments

Often, I find myself needing to do string mangling in spreadsheets. For instance, in an Excel dump of an MS Access database, the names of institutions were sometimes written as “Foo, University of” or “Foo U”. I wanted these to be formatted as “University of Foo” and “Foo University” respectively. I may be misinformed but […]

Custom django-admin commands and PYTHONPATH

November 20th, 2009 by Geoffrey Hing | No Comments

Note to self:  If you want to make your custom django-admin command work, you need to have your django app in your PYTHONPATH.

Django: Querying data from the Python shell

April 13th, 2009 by Geoffrey Hing | No Comments

I needed to get some stats for some research that we’re doing and was happy to see that you can use Django and the python shell to query testament data in a way that’s database independent.  It’s a little unintuitive if you’re thinking in SQL mode, but it is usable and super-helpful.  I wanted to […]

Struggling Toward Diversity

March 13th, 2009 by Geoffrey Hing | 1 Comment

Next week is spring break for IU and public school students in Bloomington.  I have heard that many students’ spring break trips to Mexico have been cancelled because of parental fears related to reports of drug-trade related violence in Mexico.  Bz came over last night for dinner and brought some mole sauce she got on […]

hfs+ on linux

February 27th, 2009 by Geoffrey Hing | No Comments

I got a new MacBook from work and need to migrate files from my old Dell notebook running Xubuntu Linux.  Luckily, I had recovered a drive from a bricked machine that was donated to pages that I could use to transfer the files. I don’t like the Fat32 file system, so I formatted the external […]

Imapfilter certs

January 29th, 2009 by Geoffrey Hing | 2 Comments

I was having trouble SSHing into my workstation.  It would just hang at the login.  I was worried that I had gotten 0wn3d.  I logged in at the console and ran top and saw that there were a bunch of runaway imapfilter proccesses from my cron runs. I ran imapfilter from the command line and […]

Setting up Embarq DSL with Wifi using Microsoft MN-700 wireless access point

January 13th, 2009 by Geoffrey Hing | 2 Comments

My parents and brother use Embarq DSL and they just got a used Wireless router. Like most folks, they either had the DSL set up for them, or did the initial configuration without understanding or remembering what they did, so I’m writing this as a reference for them, for other family tech support people working […]

Who’s Your Legislator?

December 10th, 2008 by Geoffrey Hing | No Comments

I found this useful tool and realized that my state rep was Matt Pierce and that my state Senator was Vi Simpson. Update: Vi Simpson has a web form specifically addressing issues that people in her district have with the Family and Social Services (FSSA), that is food stamps, medicare, Healthy Indiana Plan (HIP).  Report […]


December 4th, 2008 by Geoffrey Hing | No Comments

Doing some web design and making stuff work for IE is making me crazy.  This is largely in part to the hasLayout property in IE.  On having layout gives a super-helpful rundown.  I’ve been using the IE Developer Toolbar to help me hunt down some of these problems, and this forum post provided a good […]