Page 1 of 1
Sort bug
Posted: Sat Jul 17, 2010 3:28 pm
by JeremyP
I have, say four studio albums by a band, and one live show
Folder/Album named as follows
10. Album 1
20. Album 2
30. Album 3
40. Album 4
1992-07-12 [Venue, City, State or Country)
The above would sort as above in Explorer; the sort is correct; in MediaMonkey, the display is as follows
10. Album 1
1992-07-12 [Venue, City, State or Country)
20. Album 2
30. Album 3
40. Album 4
Spot the error

Re: Sort bug
Posted: Sat Jul 17, 2010 3:45 pm
by nohitter151
It's not really a bug. MM is using alphabetical sorting while win explorer is using numerical.
Re: Sort bug
Posted: Wed Jul 21, 2010 5:54 am
by JeremyP
Hmmm. I beg to disagree. The sort is alphanumeric in Windows, and should be in MediaMonkey. I worked on library systems for 25 years for the likes of Oxford University, and am hence more than familiar with sorting techniques and requirements. Certainly, in a library system - which, after all, is what MediaMonkey is, the sort would be as sorted in Windows.
JP
Re: Sort bug
Posted: Wed Jul 21, 2010 6:22 am
by Bex
Actually, windows explorer is not sorting alphanumericly, it's sort order is called "natural sort order". MM is sorting alphanumericly, which gives the order in your second example above.
Anyway, the issue is entered into Mantis (MM's bug tracking system):
http://www.ventismedia.com/mantis/view.php?id=6253
Let's hope the developers addresses the issue in the near future.
Re: Sort bug
Posted: Wed Jul 21, 2010 10:26 am
by JeremyP
Thanks for that; it is my belief that "natural order" is simply the normalisation of the string (this is done in library system indexes, as well, to deal with case/punctuation, etc). Good to hear that is entered as a bug - it is, and whilst only cosmetic, upsets my orderly mind

Re: Sort bug
Posted: Wed Jul 21, 2010 10:27 am
by JeremyP
Simple way to deal with the numeric element is to prefix the numeric element with the number of characters
Hence
10
1920
20
30
sorts to
210
220
230
41920
easy !
Re: Sort bug
Posted: Wed Jul 21, 2010 1:37 pm
by Lowlander
That changes the number, leading 0's is a better work-around.
Re: Sort bug
Posted: Wed Jul 21, 2010 2:26 pm
by JeremyP
No - you just strip of the leading digit in any numeric sentence. Ideally, the index is built from each entry but held separately. I imagine MM is sql based? Regardless, you store the normalised form for indexing, and then the data as well. Oh the indexes I have built...