GnuCash
Contact   Instructions
Bug 793156 - Incorrect sort order in Generic import transaction matcher window
Summary: Incorrect sort order in Generic import transaction matcher window
Status: RESOLVED FIXED
Alias: None
Product: GnuCash
Classification: Unclassified
Component: General (show other bugs)
Version: 3.2
Hardware: Other Linux
: Normal normal
Target Milestone: ---
Assignee: general
QA Contact: general
URL:
Whiteboard:
Keywords:
: 674255 788966 796817 (view as bug list)
Depends on:
Blocks:
 
Reported: 2018-02-03 22:08 EST by rvernica
Modified: 2018-11-18 05:54 EST (History)
8 users (show)

See Also:

Attachments
Screenshot showing incorect sort order (15.72 KB, image/png)
2018-02-03 22:08 EST, rvernica 		no flags Details
wrong date order in dd.mm.yyyy format (28.14 KB, image/png)
2018-09-19 11:29 EDT, Gunter Kramp 		no flags Details
Incorrect sort in CSV Import Window (35.73 KB, image/png)
2018-09-21 06:06 EDT, Gunter Kramp 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Description rvernica 2018-02-03 22:08:48 EST 
Created attachment 367871 [details]
Screenshot showing incorect sort order

In Generic import transaction matcher it is possible to click on the "Date" header and have the transactions sorted by date. The sort order is not correct. 

See the attache screenshot. As you can see, it looks like an increasing order (11/09, 11/13, 11/14), but the 1/31/18 transactions are at the top for some reason.
Comment 1 Gunter Kramp 2018-09-19 10:49:52 EDT 
This Bug is also present in Version 3.1.

If the Date Format is set to Day.Month.Year as common in Germany the transactions will be sorted mainly by day, so the example result might be something like this:
1.8.18
1.9.18
2.8.18
2.9.18
...
Comment 2 Gunter Kramp 2018-09-19 11:29:38 EDT 
Created attachment 372982 [details]
wrong date order in dd.mm.yyyy format

wrong sort order in Version 3.1. with Date Format dd.mm.yyyy under Windows 7 Language German
Comment 3 Gunter Kramp 2018-09-20 03:46:24 EDT 
*** Bug 674255 has been marked as a duplicate of this bug. ***
Comment 4 Gunter Kramp 2018-09-20 03:47:52 EDT 
Citation from Bug 674255
"When you import an OFX, in the window that list the operations, if you click on the "date" column in order to sort by date, the sort seems to be done one the string representation of the dates, which is wrong unless the date format happens to be YYYY/MM/DD."
Comment 5 Gunter Kramp 2018-09-20 03:55:24 EDT 
*** Bug 788966 has been marked as a duplicate of this bug. ***
Comment 6 Gunter Kramp 2018-09-20 03:56:29 EDT 
*** Bug 796817 has been marked as a duplicate of this bug. ***
Comment 7 Gunter Kramp 2018-09-20 04:17:30 EDT 
similar behavior when sorting the accounts list by last reconciled date
see bug 788332
common cause due to same function or just same logical error?

Bug persists in 3.2.
Comment 8 Gunter Kramp 2018-09-21 06:06:00 EDT 
Created attachment 372984 [details]
Incorrect sort in CSV Import Window

Screenshot showing that sort bug is also present in CSV Import Window in Version 3.2
Comment 9 Bob 2018-10-31 06:25:36 EDT 
I have a possible fix locally, will add to a PR in due course.
Comment 10 Bob 2018-11-04 05:16:42 EST 
Added possible fix to PR432.
Comment 11 Geert Janssens 2018-11-18 05:54:06 EST 
The fix was accepted and will be included in GnuCash 3.4. Thanks!
Note You need to log in before you can comment on or make changes to this bug.