Import of csv not working (amount not imported correctly)
Posted: 18 March 2018, 15:10
Hi,
I am trying the version 6 (have been using version 3 for years now), but I can't get the import of csv files working.
The problem is the amount. It shows up as either 0 for all transactions or skips the decimal sign (1 cent becomes 1 euro).
Import of csv is super simple in version 3, but in version 6 it seems impossible (no 1 screen back function forces me to redo everything every time I want to try a new setting, very annoying).
The format of my csv file is :
IBAN/BBAN,Munt,BIC,Volgnr,Datum,Rentedatum,Bedrag,Saldo na trn,Tegenrekening IBAN/BBAN,Naam tegenpartij,Naam uiteindelijke partij,Naam initiÎrende partij,BIC tegenpartij,Code,Batch ID,Transactiereferentie,Machtigingskenmerk,Incassant ID,Betalingskenmerk,Omschrijving-1,Omschrijving-2,Omschrijving-3,Reden retour,Oorspr bedrag,Oorspr munt,Koers
NL22BANK0123456789,EUR,BANKNL2R,101,4/1/2017,1/1/2017,"-1,20","+18,41",,Kosten,,,,db,,,,,,Rabo DirectPakket Periode 01-01-2017 t/m 31-01-2017, ,,,,,
As far as I can see, the import function does not cater for the double quotes (") and the fact that the amount field also contains the sign of the amount.
Any suggestions ?
Cheers,
Bas.
I am trying the version 6 (have been using version 3 for years now), but I can't get the import of csv files working.
The problem is the amount. It shows up as either 0 for all transactions or skips the decimal sign (1 cent becomes 1 euro).
Import of csv is super simple in version 3, but in version 6 it seems impossible (no 1 screen back function forces me to redo everything every time I want to try a new setting, very annoying).
The format of my csv file is :
IBAN/BBAN,Munt,BIC,Volgnr,Datum,Rentedatum,Bedrag,Saldo na trn,Tegenrekening IBAN/BBAN,Naam tegenpartij,Naam uiteindelijke partij,Naam initiÎrende partij,BIC tegenpartij,Code,Batch ID,Transactiereferentie,Machtigingskenmerk,Incassant ID,Betalingskenmerk,Omschrijving-1,Omschrijving-2,Omschrijving-3,Reden retour,Oorspr bedrag,Oorspr munt,Koers
NL22BANK0123456789,EUR,BANKNL2R,101,4/1/2017,1/1/2017,"-1,20","+18,41",,Kosten,,,,db,,,,,,Rabo DirectPakket Periode 01-01-2017 t/m 31-01-2017, ,,,,,
As far as I can see, the import function does not cater for the double quotes (") and the fact that the amount field also contains the sign of the amount.
Any suggestions ?
Cheers,
Bas.