On Sun, Sep 22, 2019, at 7:27 AM, Ottorino wrote:
Hi Reuben, here is Ottorino
I'm also "an open source enthusiast", since I strongly believe in
cooperation rather than in competition.
I'm using git and github as a single user, but I'm not sure I'm able to
fork and modify your repository: that's why I'm contacting by email
I'm a soil chemist teaching at the university, and the only programming
language I'm proficient with is R.
I've found your csv2ofx a very valuable resource to convert my paypal
and bank statements to import them in gnucash.
In particular, my local bank, is able to provide me either an "amiable"
xlsx file or a useless qif file.
I've been studying csv2ofx on github and then I wrote two bash scripts
to manipulate the original files from paypal and from my bank
I must thank you because on writing the scripts I was forced to push
forward my (scarce) regexp knowledge. Writing those scripts has been
challenging but formative.
The two scripts are at your disposal and attached, just let me clean
them up and translate the comments into English. Also the mappings are
attached
I've started to use the scripts "on the field" and I realized that
(probably) I've stepped on a bug: if the amounts are in the form 0,xx
("," is our local decimal sign) csv2ofx throws errors.
To be sure that it was not due to my inexperience, I've changed your the
amount cell of the last line in ~/.../csv2ofx/data/testdefault.csv from
50000 to 0.50000 and run
csv2ofx defaultModif.csv
only to get
........ValueError: Invalid number format for 0.50000.
The defaultModif.csv file is attached for your convenience.
Again, this could be due to a bug or to my limited knowledge in
programming, that's why I'm reporting it to you.
I would be more than happy if I were able to find a way to amend
csv2ofx, but I'm not so smart in programming.
reubano
commented
4 years ago