Bug 267103 - kmymoney4.5.3 non integer total of operation in QIF file multiplies on 100 (skip or ignore float point separator)
Summary: kmymoney4.5.3 non integer total of operation in QIF file multiplies on 100 (s...
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: SVN
Platform: Compiled Sources Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-24 22:36 UTC by Alexander Trubitsyn
Modified: 2011-02-25 07:22 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
my little QIF file for testing import (255 bytes, text/plain)
2011-02-24 22:36 UTC, Alexander Trubitsyn
Details
screen snapshot after import test.qif (174.48 KB, image/png)
2011-02-24 22:38 UTC, Alexander Trubitsyn
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alexander Trubitsyn 2011-02-24 22:36:45 UTC
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
Comment 1 Alexander Trubitsyn 2011-02-24 22:38:27 UTC
Created attachment 57508 [details]
screen snapshot after import test.qif
Comment 2 allan 2011-02-25 02:25:39 UTC
(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.
Comment 3 Alexander Trubitsyn 2011-02-25 07:22:38 UTC
Thank you very mach. it helps. now all values with comma separator imported fine.