After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 709220 - Allow to override LC_NUMERIC temporarily (e.g. to understand usage of different decimal marks)
Allow to override LC_NUMERIC temporarily (e.g. to understand usage of differe...
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Import - CSV
2.4.x
Other All
: Normal enhancement
: ---
Assigned To: gnucash-import-maint
gnucash-import-maint
Depends on:
Blocks:
 
 
Reported: 2013-10-01 18:28 UTC by Paul Fertser
Modified: 2018-06-29 23:19 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Paul Fertser 2013-10-01 18:28:44 UTC 
Some locales (ru_RU.UTF-8 in my case) specify decimal mark as a comma but that doesn't mean local banks always use it, so it can become problematic to import statements from them. I would expect at least some consistency on their side, so probably the best way to deal with this issue is to allow manual specification for LC_NUMERIC (assuming the user can recognise the convention and set the appropriate value).

Alternatively, some heuristic can be employed to normalise the numerical fields prior to parsing.
Comment 1 Geert Janssens 2017-02-20 20:50:31 UTC 
Thank you for your report and apologies for the time it took to reply.

In gnucash 2.6 and more recent it's possible to specify a number format while importing. It's fairly simple, providing 3 choices:
- use whatever the locale prescribes
- use . as decimal separator
- use , as decimal separator

I believe this handles the most common use cases. Would this work for you ?
Comment 2 John Ralls 2017-09-24 22:17:52 UTC 
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
Comment 3 Geert Janssens 2018-04-28 16:04:19 UTC 
Closing this bug report as no further information has been provided. Please feel free to reopen this bug report if you can provide the information that was asked for in a previous comment.
Thanks!
Comment 4 Paul Fertser 2018-04-28 16:16:41 UTC 
Hello,
For my specific usecase new interface would be functional and obvious enough. I would be surprised if any GnuCash user would need to use something else but comma and dot as decimal separators. So I think this can be closed as FIXED.
Comment 5 Geert Janssens 2018-04-28 16:18:14 UTC 
Ok, thanks for your feedback.
Comment 6 John Ralls 2018-06-29 23:19:34 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=709220. Please update any external references or bookmarks.