Thank you for the quick response. Unfortunately it did not work. I have some
errors from two different csv files. Hope this helps.
#$>reckon -f sample.csv -p
What is the account name of this bank account in Ledger?
|Assets:Bank:Checking|
/usr/lib/ruby/1.9.1/csv.rb:1892:in `block (2 levels) in shift': Unquoted
fields do not allow \r or \n (line 2). (CSV::MalformedCSVError)
from /usr/lib/ruby/1.9.1/csv.rb:1863:in `each'
from /usr/lib/ruby/1.9.1/csv.rb:1863:in `block in shift'
from /usr/lib/ruby/1.9.1/csv.rb:1825:in `loop'
from /usr/lib/ruby/1.9.1/csv.rb:1825:in `shift'
from /usr/lib/ruby/1.9.1/csv.rb:1767:in `each'
from /usr/lib/ruby/1.9.1/csv.rb:1778:in `to_a'
from /usr/lib/ruby/1.9.1/csv.rb:1778:in `read'
from /usr/lib/ruby/1.9.1/csv.rb:1365:in `parse'
from
/usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.1/lib/reckon/app.rb:334:in `parse'
from
/usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.1/lib/reckon/app.rb:12:in
`initialize'
from /usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.1/bin/reckon:7:in
`new'
from /usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.1/bin/reckon:7:in
`<top (required)>'
from /usr/bin/reckon:19:in `load'
from /usr/bin/reckon:19:in `<main>'
[kishd@dozer CSV2Ledger-1.4]$ cd ~/Downloads/
#$ reckon -f E5E1D21B-0D26-154E.csv -p
What is the account name of this bank account in Ledger?
|Assets:Bank:Checking|
/usr/lib/ruby/1.9.1/csv.rb:1869:in `block (2 levels) in shift':
CSV::MalformedCSVError (CSV::MalformedCSVError)
from /usr/lib/ruby/1.9.1/csv.rb:1863:in `each'
from /usr/lib/ruby/1.9.1/csv.rb:1863:in `block in shift'
from /usr/lib/ruby/1.9.1/csv.rb:1825:in `loop'
from /usr/lib/ruby/1.9.1/csv.rb:1825:in `shift'
from /usr/lib/ruby/1.9.1/csv.rb:1767:in `each'
from /usr/lib/ruby/1.9.1/csv.rb:1778:in `to_a'
from /usr/lib/ruby/1.9.1/csv.rb:1778:in `read'
from /usr/lib/ruby/1.9.1/csv.rb:1365:in `parse'
from
/usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.1/lib/reckon/app.rb:334:in `parse'
from
/usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.1/lib/reckon/app.rb:12:in
`initialize'
from /usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.1/bin/reckon:7:in
`new'
from /usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.1/bin/reckon:7:in
`<top (required)>'
from /usr/bin/reckon:19:in `load'
from /usr/bin/reckon:19:in `<main>'
On 8 February 2011 09:37, Andrew Cantino <[email protected]> wrote:
> Yup, you found a bug in the gem for Ruby 1.9.2. Thanks! It should be
> fixed now. Run: (sudo) gem install reckon
>
> It should find version 0.3.1 now. Let me know if it works!
>
> -Andrew
>
> On Mon, Feb 7, 2011 at 7:14 AM, Kishorelal Deva <[email protected]>
> wrote:
> > I have archlinux with ruby 1.9 and I get the following error
> >
> > reckon -f E5E1D21B-0D26-154E.csv -p
> > What is the account name of this bank account in Ledger?
> > |Assets:Bank:Checking|
> > /usr/lib/ruby/gems/1.9.1/gems/fastercsv-1.5.4/lib/faster_csv.rb:13:in
> > `const_missing': Please switch to Ruby 1.9's standard CSV library. It's
> > FasterCSV plus support for Ruby 1.9's m17n encoding engine.
> > (NotImplementedError)
> > from
> > /usr/lib/ruby/gems/1.9.1/gems/fastercsv-1.5.4/lib/faster_csv.rb:19:in
> > `method_missing'
> > from
> > /usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.0/lib/reckon/app.rb:330:in
> `parse'
> > from
> > /usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.0/lib/reckon/app.rb:12:in
> > `initialize'
> > from /usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.0/bin/reckon:7:in
> > `new'
> > from /usr/lib/ruby/gems/1.9.1/gems/reckon-0.3.0/bin/reckon:7:in
> > `<top (required)>'
> > from /usr/bin/reckon:19:in `load'
> > from /usr/bin/reckon:19:in `<main>'
> >
> > Could you help me as I really do need a way to parse some csv files quite
> > urgently. It is tax time and this would save me a lot of time. My
> > alternative is to manually type in all transactions.
> >
> >
> > On 13 November 2010 23:37, Andrew Cantino <[email protected]> wrote:
> >>
> >> BTW, thanks to Peter and Otto, Reckon now supports European currency
> >> formatting and better CSV parsing.
> >>
> >> On Wed, Nov 10, 2010 at 10:23 PM, Andrew Cantino <[email protected]>
> >> wrote:
> >> > Hey Peter, thanks for the feedback! I just uploaded a patch that
> >> > should fix this issue. Please run "(sudo) gem update reckon" and try
> >> > again and see if it works now. Adding the -p option will print out
> >> > the parsed CSV file for inspection.
> >> >
> >> > Best,
> >> > -Andrew
> >> >
> >> > On Wed, Nov 10, 2010 at 3:36 PM, Peter Ross <[email protected]>
> wrote:
> >> >> 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 ---
> >> >>
> >> >
> >
> >
> >
> > --
> > Dr Kishorelal Deva
> > [email protected]
> >
> > Shakespeare
> > "For there is nothing either good or bad, but only thinking makes it
> so...."
> >
> > From the vedas
> > "Ekam Satya Vipro Bahuda Vadanthi"
> > “God is one. Learned scholars call him with different names”
> >
> >
> >
> >
> >
>
--
Dr Kishorelal Deva
[email protected]
Shakespeare
"For there is nothing either good or bad, but only thinking makes it so...."
>From the vedas
"Ekam Satya Vipro Bahuda Vadanthi"
“God is one. Learned scholars call him with different names”
