Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

problem of importing file #59

Closed
pfrancois opened this issue Feb 21, 2016 · 3 comments
Closed

problem of importing file #59

pfrancois opened this issue Feb 21, 2016 · 3 comments

Comments

@pfrancois
Copy link

if i try to read the following file with this command:

reckon -f 00050550715.csv -a SG -p --contain-header 4 --ignore-columns 2,5 --csv-separator ';' --comma-separates-cents -c EUR --suffixed

file

="0234500012345678";21/11/2015;19/02/2016;36;19/02/2016;1234,37 EUR

Date de l'opération;Libellé;Détail de l'écriture;Montant de l'opération;Devise
19/02/2016;VIR RECU 508160;VIR RECU 1234567834S DE: Francois REF: 123457891234567894561231 PROVENANCE: DE Allemagne ;50,00;EUR
18/02/2016;COTISATION JAZZ;COTISATION JAZZ ;-8,10;EUR

I receive an error

C:/Ruby22/lib/ruby/2.2.0/csv.rb:1874:in block (2 levels) in shift': Illegal quoting in line 1. (CSV::MalformedCSVError) from C:/Ruby22/lib/ruby/2.2.0/csv.rb:1836:ineach'
from C:/Ruby22/lib/ruby/2.2.0/csv.rb:1836:in block in shift' from C:/Ruby22/lib/ruby/2.2.0/csv.rb:1796:inloop'
from C:/Ruby22/lib/ruby/2.2.0/csv.rb:1796:in shift' from C:/Ruby22/lib/ruby/2.2.0/csv.rb:1738:ineach'
from C:/Ruby22/lib/ruby/2.2.0/csv.rb:1752:in to_a' from C:/Ruby22/lib/ruby/2.2.0/csv.rb:1752:inread'
from C:/Ruby22/lib/ruby/2.2.0/csv.rb:1298:in parse' from C:/Ruby22/lib/ruby/gems/2.2.0/gems/reckon-0.4.4/lib/reckon/csv_parser.rb:241:inparse'
from C:/Ruby22/lib/ruby/gems/2.2.0/gems/reckon-0.4.4/lib/reckon/csv_parser.rb:11:in initialize' from C:/Ruby22/lib/ruby/gems/2.2.0/gems/reckon-0.4.4/lib/reckon/app.rb:18:innew'
from C:/Ruby22/lib/ruby/gems/2.2.0/gems/reckon-0.4.4/lib/reckon/app.rb:18:in initialize' from C:/Ruby22/lib/ruby/gems/2.2.0/gems/reckon-0.4.4/bin/reckon:7:innew'
from C:/Ruby22/lib/ruby/gems/2.2.0/gems/reckon-0.4.4/bin/reckon:7:in <top (required)>' from C:/Ruby22/bin/reckon:22:inload'
from C:/Ruby22/bin/reckon:22:in `

'

@cantino
Copy link
Owner

cantino commented May 25, 2016

It looks like the CSV may have a mixture of quoted and un-quoted entries?

@benprew
Copy link
Collaborator

benprew commented Jan 31, 2020

@pfrancois this is fixed in #78, once it's merged to master, I'll close this ticket.

@benprew
Copy link
Collaborator

benprew commented Feb 5, 2020

#78 has been merged to master, closing this ticket.

@benprew benprew closed this as completed Feb 5, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants