Bug 503260 - CSV importer does not use the decimal dot setting
Summary: CSV importer does not use the decimal dot setting
Status: REPORTED
Alias: None
Product: kmymoney
Classification: Applications
Component: importer (other bugs)
Version First Reported In: 5.1.95
Platform: Gentoo Packages Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-24 01:36 UTC by Ciprian Ciubotariu
Modified: 2025-04-25 00:43 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Ciprian Ciubotariu 2025-04-24 01:36:10 UTC
SUMMARY

The CSV import setup has a "Decimal symbol" setting on the Formats page, but it ignores it when performing the import. This creates problems on systems that have customised locale settings. 

On my system, I have numbers as en-GB, which use . (dot) as a decimal point and currency as ro-RO, which uses , (comma). The reason for that is that many tools assume lists of numbers are separated by commas, so I cannot process files easily across my tools with the ro-RO number locale. At the same time, I cannot read the en-GB/US currency formats, with negative numbers in parentheses etc. Side comment: it was better before.

For some reason, kmymoney chose to use comma everywhere, including in the CSV importer, and not the number locale. Even if I set the Decimal symbol to dot in the bank setup, the number parser seems to walk over the dot.


STEPS TO REPRODUCE
1. Create a CSV that represents numbers using a different decimal symbol than the system locale. 
2. Setup your number format to en-GB and your currency format to ro-RO
3. Import the CSV

OBSERVED RESULT


EXPECTED RESULT


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
(available in the Info Center app, or by running `kinfo` in a terminal window)
Linux/KDE Plasma: 
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
Comment 1 Ciprian Ciubotariu 2025-04-25 00:43:50 UTC
Actually, it does not work even if I process the CSV to format numbers using commas as decimal symbol, regardless if the CSV importer settings is set to comma, dot or auto. Everything gets multiplied by 100 after the import, thus no transactions can be matched or imported correctly.

Maybe the issue appears when the system locale has a different decimal symbol than the dot?