Posted by Andre Foeken Wed, 23 Jan 2008 19:38:23 GMT
Like lots of you I bought the incredible MacHeist app bundle last week. One of the appz was Cha-Ching, a finance program to keep track of your money.
One of the most useful features is the import. You can simply import all of your bank's records and be done with it. Unfortunately the dutch banks (or at least the Rabobank and Postbank) don't support the same formats Cha-Ching supports (like OFX/QIF).
I wrote a small ruby script to convert the banks CSV files to OFX files. There are two separate files below (one for each bank):
CSV convertor - Postbank (Ruby)
CSV convertor - Rabobank (Ruby)
Before you can run the files you need two additional gems (if you haven't got them already).
sudo gem install extensions
sudo gem install builder
After this you can use the scripts like this:
ruby csv_convert.rb [CSV FILE] > export.ofx
ruby csv_rabo_convert.rb [CSV FILE] > export.ofx
Update: Now supports Tiger using PHP version of script and (optional) automator
For the next files you don't need anything else than a vanilla Tiger install of OSX.
CSV convertor - Postbank (PHP)
CSV convertor - Rabobank (PHP)
You can use them like this:
php csv_convert.php [CSV FILE] > export.ofx
php csv_rabo_convert.php [CSV FILE] > export.ofx
For the simple version, use the automator zip file! Read the README to get it to work.
