Ed’s Tech Blog

So, I recently bought Quicken for the first time, so that I could do line item tax deductions. Too bad my main credit card company, Chase, artificially limits the data I can import to Quicken. Only 45 days worth. I needed the whole of 2006 to do taxes.

Chase does advertise 6 years worth of statements are always available, but the devil is in the details. They only let you have pdf’s of each month’s statement.

It’s late, so here is the short. I learned Ruby and wrote a script to convert a folder full of these pdf’s into Quickens XML format, QFX. Well, I actually used the free PdfTextReader to initially pull the text out of the pdf’s. I had started using the java library, iText, to do the pdf manipulation, but they say that their library cannot pull text out of pdf’s. So, faster to use someone else’s tool.

Had to brush up a lot on my regular expressions as well. The pdftextreader pulls the text out of the pdf’s differently each time, so you can’t just count spacing to find the different columns. You have to come up with a pattern that matches for thousands of transactions. In the end, I altered a few foreign transactions by hand rather than figuring out special code for them. Also, the automatic payments by Chase broke their normal pattern too.
Anyway, all the data back into 2005 is in Quicken now! So, I can go through and find the line items. (I found out today that my tax bill is pretty steep for some 1099 work in 2006, so hopefully this will keep my travel the world plans alive.)
Originally, I was going to write this program in Java, and post it for the Quicken community to use. I figure there are many others who are in the same jam, and they might hit the donation button if I save them many hours of tedious labor. However, after iText revealed that it couldn’t help me with the pdf’s, I changed my position to “how can Ed get this done fastest for himself?” Find a pdf text extracting tool and use a language like Ruby.

Worked out pretty well. I’m satisfied, even if it conceivably took me longer to write the program than to cut and paste by hand. I’d rather spend the time gaining programming skills than getting carpel tunnel and being bored.

If anyone wants the ruby code, just leave a comment. Maybe I’ll post a link to it tomorrow.

Download the new Java Netbeans 5.5

Several of the samples are broken. Totally unprofessional.

Click on ‘Help’. Sun’s entire document website cluster is down. Totally unreliable.

What is Sun thinking? Do they realize how poorly the represent their company and technology?

If Sun can’t make the samples work, then why should anyone bother with their latest offering(s)?

Talked to an SBC/ATT rep today.

They said SF gets Fiber Optic laid to new apartment buildings and select newly built homes.

They said that my neighborhood, Western Addition, will not get the copper replaced with fiber optic (ever), because the state of California does not require SBC to offer higher speed than what we get. We currently max out on the 3Mbps ADSL, though they offer 6Mbps to neighborhoods w/ fiber lines.

This isn’t fiber to the home. SBC never plans to pay to replace copper to the home. (unlike Verizon).  If you are one of the lucky few to live in a brand new place in SF with the fiber, SBC will offer 25Mbps download speeds. (Didn’t get the cost or the upload, but it would not be synchronous).

At least they keep dropping the price for the crappy DSL. It’s down to $25/mo, but that is really $40/mo b/c we have to pay for a phone line. The phone is only used to dial in for DirectTV Tivo listings.

Crazy how San Francisco has the bottom of the barrel residential broadband for the entire United States.

Hopefully, WiMax will get offered to residents in the next year or two and change the whole scene.

Can’t be done as far as I can tell.

But here are the steps I tried after trying many tutorials.

#install ruby
mkdir ~/bin/ruby
cd ~/bin/ruby
wget ftp://ftp.ruby-lang.org/pub/ruby/ruby-1.8.5.tar.gz
tar -zxvf ruby-1.8.5.tar.gz
cd ruby-1.8.5
./configure prefix=~/bin/ruby
#replace ext/openssl/ossl.h with updated version.
#refer to:
http://groups.google.com/group/ruby-talk-google/browse_thread/thread/8f17987659b4c59d/8ef4d94184abb473?lnk=st&q=ossl_bio.c%3A+In+function+%60ossl_obj2bio%27&rnum=1#8ef4d94184abb473
wget http://edwardotis.com/public_files/ruby/rubyossl.patch
patch ext/openssl/ossl.h  rubyossl.patch
make
make install
export PATH=~/bin/ruby/bin:$PATH

#install rubygems
wget http://rubyforge.org/frs/download.php/11289/rubygems-0.9.0.tgz
tar -xzvf rubygems-0.9.0.tgz
cd rubygems-0.9.0
ruby setup.rb
#ruby setup.rb config –prefix=~/rubygems
#ruby setup.rb setup
#ruby setup.rb install

#install rails and necessary gems for rails
gem install mysql #choose option 3
gem install fcgi
gem install rails –include-dependencies

# In the file:
#~/bin/ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/dispatches/dispatch.fcgi
#Replace
#!/usr/local/bin/ruby
#with
#!~/bin/ruby/bin/ruby

Plus, I setup mongrel and everything. Still no love.

Big waste of time. Much better to find a host who supports ROR and pay them separately for development environment. I love my 250GB on 1and1.