International currency support

[reubano]

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.

All the best from Italy