Hi Andrew,
On Sun, Nov 7, 2010 at 2:11 PM, Andrew Cantino <[email protected]> wrote:
> Hey guys,
>
> I've been slowly working on a Ruby gem for converting arbitrary CSV
> files into ledger format, and also for guessing accounts based on how
> you have named them in the past. Check it out and let me know what
> you think, or if you find CSV files that it can't guess correctly. I
> think of it as Mint for the command line. :)
>
> https://github.com/iterationlabs/reckon
>
Looks great and I tried to use it but couldn't get it to run.
I'm using ubuntu 10.04 (Lucid) and this is the command I ran
# gem install reckon
WARNING: Installing to ~/.gem since /var/lib/gems/1.8 and
/var/lib/gems/1.8/bin aren't both writable.
WARNING: You don't have /home/petdr/.gem/ruby/1.8/bin in your PATH,
gem executables will not run.
Successfully installed reckon-0.2.1
1 gem installed
Installing ri documentation for reckon-0.2.1...
Installing RDoc documentation for reckon-0.2.1...
# export PATH=/home/petdr/.gem/ruby/1.8/bin:$PATH
# reckon -f TransactionHistory.csv
What is the account name of this bank account in Ledger? |Assets:Bank:Checking|
/home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:289:in
`columns': undefined method `strip' for nil:NilClass (NoMethodError)
from /usr/lib/ruby/1.8/erb.rb:719:in `each_with_index'
from
/home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:287:in
`each'
from
/home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:287:in
`each_with_index'
from
/home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:287:in
`columns'
from /usr/lib/ruby/1.8/erb.rb:719:in `inject'
from
/home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:284:in
`each'
from
/home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:284:in
`inject'
from
/home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:284:in
`columns'
from
/home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:245:in
`detect_columns'
from /home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/lib/reckon/app.rb:15:in
`initialize'
from /home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/bin/reckon:7:in `new'
from /home/petdr/.gem/ruby/1.8/gems/reckon-0.2.1/bin/reckon:7
from /home/petdr/.gem/ruby/1.8/bin/reckon:19:in `load'
from /home/petdr/.gem/ruby/1.8/bin/reckon:19
Here is TransactionHistory.csv (it was in dos format
--- cut here ---
10-Nov-10,-432.12,,,TRANSFER DEBIT INTERNET TRANSFER,INTERNET TRANSFER
MORTGAGE,0.00,
09-Nov-10,432.12,,,SALARY SALARY,NN1010NHCO00056276 NORTHERN HEALTH,432.12,
04-Nov-10,-1234.00,,,TRANSFER DEBIT INTERNET TRANSFER,INTERNET
TRANSFER SAV TO MECU,0.00,
04-Nov-10,1234.00,,,TRANSFER CREDIT INTERNET TRANSFER,INTERNET
TRANSFER SALARY - PRO MISSIONCRITICAL,1234.00,
28-Oct-10,-123.12,,,TRANSFER DEBIT INTERNET TRANSFER,INTERNET TRANSFER
SAV TO MORTGAGE,0.00,
--- cut here ---
