Error in reckon for the same format csv file

[vikrantrathore]

Reckon works with the files downloaded in previous months but then fails on the newly downloaded csv file from bank. The format pf the file is precisely same with 2 money columns. The error is cryptic and undecipherabl. I can't get an idea which line in csv is creating this issue. I checked the code and didn't find any clues either.

/usr/local/lib/ruby/gems/2.3.0/gems/reckon-0.4.4/lib/reckon/csv_parser.rb:47:in block in description_for': undefined methodempty?' for nil:NilClass (NoMethodError)
from /usr/local/lib/ruby/gems/2.3.0/gems/reckon-0.4.4/lib/reckon/csv_parser.rb:47:in reject' from /usr/local/lib/ruby/gems/2.3.0/gems/reckon-0.4.4/lib/reckon/csv_parser.rb:47:indescription_for'
from /usr/local/lib/ruby/gems/2.3.0/gems/reckon-0.4.4/lib/reckon/app.rb:241:in block in each_row_backwards' from /usr/local/lib/ruby/gems/2.3.0/gems/reckon-0.4.4/lib/reckon/app.rb:235:ineach'
from /usr/local/lib/ruby/gems/2.3.0/gems/reckon-0.4.4/lib/reckon/app.rb:235:in each_row_backwards' from /usr/local/lib/ruby/gems/2.3.0/gems/reckon-0.4.4/lib/reckon/app.rb:97:inwalk_backwards'
from /usr/local/lib/ruby/gems/2.3.0/gems/reckon-0.4.4/bin/reckon:19:in <top (required)>' from /usr/local/bin/reckon:23:inload'
from /usr/local/bin/reckon:23:in `

'

[cantino]

Hey @vikrantrathore, sorry to hear that.

Would you be able to email me (andrew at andrewcantino dot com) a copy of the CSV, or is it sensitive?

[vikrantrathore]

Cannot send you the copy as it is sensitive bank statement. Just to let you know that file contains Chinese Characters in csv file, not sure if thats the problem.

It works with newer files without Chinese characters. So probably you can look into it or just close the issue as it works wit other files not using CJK (Chinese, Japanese, Korean) unicode characters.

[vikrantrathore]

Do you still want to get a sample file with CJK?

[cantino]

Sure, that'd be helpful @vikrantrathore.

[seblemaguer]

Hello,

I faced the same problem until I realized that the csv file was malformed. Be sure that your string fields are in quotes. For me it solved the problem

[vikrantrathore]

The issue is fixed, one of the description lines in csv file contained a , and it was not enclosed in quotes. thanks @seblemaguer and @cantino for reckon.