Created attachment 57507 [details] my little QIF file for testing import Version: SVN trunk (using KDE 4.4.4) OS: Linux Any non integer value from QIF file multiplies by 100 if you import it in kmymoney 4.5.3, for example, this QIF file D18.02.2011 C Mtest01 positive with comma T10,15 Ptest Ltest ^ D18.02.2011 C Mtest01 positive with point T10.72 Ptest Ltest ^ D18.02.2011 C Mtest03 negative with comma T-10,15 Ptest Ltest ^ D18.02.2011 C Mtest02 negative with point T-10.72 Ptest Ltest ^ imported with values 1015 1072 -1015 -1072 Reproducible: Didn't try Steps to Reproduce: Reproducible: Always Steps to Reproduce: 1 Click file >> Import >> QIF 2 Browse to select the file 3 default QIF profile and QIF source = "bank statement" 4 click import try to change separator from ',' on '.', but it did not help Actual Results: 1015 1072 -1015 -1072 Expected Results: 10,15 10,72 -10,15 -10,72 OS: Linux (x86_64) release 2.6.34.7-0.7-desktop Compiler: gcc
Created attachment 57508 [details] screen snapshot after import test.qif
(In reply to comment #0) > Created an attachment (id=57507) [details] > my little QIF file for testing import > > Version: SVN trunk (using KDE 4.4.4) > OS: Linux > > Any non integer value from QIF file multiplies by 100 if you import it in > kmymoney 4.5.3, for example, this QIF file > D18.02.2011 > C > Mtest01 positive with comma > T10,15 > Ptest > Ltest > ^ > D18.02.2011 > C > Mtest01 positive with point > T10.72 > Ptest > Ltest > ^ > D18.02.2011 > C > Mtest03 negative with comma > T-10,15 > Ptest > Ltest > ^ > D18.02.2011 > C > Mtest02 negative with point > T-10.72 > Ptest > Ltest > ^ > > imported with values > 1015 > 1072 > -1015 > -1072 > > Reproducible: Didn't try > > Steps to Reproduce: > Reproducible: Always > > Steps to Reproduce: > 1 Click file >> Import >> QIF > 2 Browse to select the file > 3 default QIF profile and QIF source = "bank statement" > 4 click import > > try to change separator from ',' on '.', but it did not help > > Actual Results: > 1015 > 1072 > -1015 > -1072 > > Expected Results: > 10,15 > 10,72 > -10,15 > -10,72 > > OS: Linux (x86_64) release 2.6.34.7-0.7-desktop > Compiler: gcc I think it might help if you add : !Type:Bank at the start of your file. I created a new qif profile with ',' as the decimal and '.' as the thousands separators, which I called 'new'. I selected that profile when importing and the lines with '.' decimal separators imported correctly. Using the UK default values, decimal '.' and thousands ',' produced the same results, suggesting that the profile settings appear to have no effect. The other two lines, in both cases, retained the ',' decimal separator, which possibly is being interpreted as a thousands separator, and possibly an invalid format. I can't change my locale to test other values.
Thank you very mach. it helps. now all values with comma separator imported fine.