https://bugs.kde.org/show_bug.cgi?id=494159
Bug ID: 494159
Summary: Wrong decimal separator in CSV import
Classification: Applications
Product: skrooge
Version: 2.33.0
Platform: Debian testing
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: general
Assignee: steph...@mankowski.fr
Reporter: pa...@web.de
Target Milestone: ---
Hi,
with a German bank, the CSV export uses comma as a decimal separator and a
point as a digit group separator
(https://en.wikipedia.org/wiki/Decimal_separator#Digit_grouping). However, for
integer values, the bank does not include the fractional part in the CSV output
resulting in something like "1.234" for 1234 €. This, however, is imported by
Skrooge as a fraction resulting in 1.23 € (i.e. a euro and 23 cent).
I see at least four possibilities how this can be solved
1. Argue with the bank to avoid using a point as a group separator as this is
against the standards
(https://en.wikipedia.org/wiki/Decimal_separator#Current_standards). I'll try
that, but this is unlikely to change anything (we are talking about Germany
here, where more than 25 years after introducing ISO 8601 via DIN EN 28601 kids
still do not learn in school how to write a date correctly).
2. Use the decimal and group separators from the current locale when doing the
CSV import in Skrooge.
3. Have an option to change the decimal and group separators when doing the CSV
import in Skrooge.
4. Interpret the point as a group separator if there are three trailing digits.
--
You are receiving this mail because:
You are watching all bug changes.
