INTERACT FORUM

More => Old Versions => Media Center 15 (Development Ended) => Topic started by: mc_user on April 26, 2010, 07:39:22 am

Title: Sorting by filename when using a numeric prefix
Post by: mc_user on April 26, 2010, 07:39:22 am

I've got a number of mp3 files with a numeric prefix.  When I sort by file name the prefix seems to be ignored, so "0005-A.mp3" will come before "0003-D.mp3" 

I also created an expression column with just the prefix, but clicking on the column name doesn't seem to sort it (though it says it does). 

Any help getting either to work would be appreciated; I'd prefer the first to work since it's native to the application, but getting the expression to sort properly would be an acceptable workaround.

Title: Re: Sorting by filename when using a numeric prefix
Post by: Matt on April 26, 2010, 10:59:30 am

Is it possible the paths are different for the two files you're comparing?

Assuming the paths are the same, the numeric prefix should be sorted as a numbers (so 5 comes before 10, etc.)

Maybe make a playlist of the files and sort the playlist to rule out the view doing any fancy processing.

Let us know what you find.  Thanks.

Title: Re: Sorting by filename when using a numeric prefix
Post by: mc_user on April 26, 2010, 11:25:33 am

All are in the same directory, and it behaves the same when I put them in a playlist.  I've got a screen shot attached - you can see the numeric prefix as well as how it is sorting alphabetically.(http://c:\sort.JPG)

Title: Re: Sorting by filename when using a numeric prefix
Post by: gappie on April 26, 2010, 11:30:10 am

maybe a small thing to check, just to be sure.
are the 0000
all zero's or is there a capital o somewhere?
had that happen ones.

 :)
gab

Title: Re: Sorting by filename when using a numeric prefix
Post by: mc_user on April 26, 2010, 01:08:02 pm

Here is how it lists (truncated) from the command prompt:

20100413142130-Ad
20100414144309-Go
20100414144558-Wu
20100415144559-Sw
20100415144560-at
20100420102411-Av
20100420102520-B.
20100420102618-Bl
20100420102707-Co
20100420102941-JY
20100420103432-Ke
20100420103541-Lo
20100420103621-Pa
20100420103650-Vi
20100420103715-Th
20100420103750-An
20100420103941-Jo
20100420104039-al
20100420104122-Fi
20100420104124-al
20100420104126-Wa

Here's how it sorts in MC 15:

20100413142130-Ad
20100420104039-al
20100420104124-al
20100420103750-An
20100415144560-at
20100420102411-Av
20100420102520-B.
20100420102618-Bl
20100420102707-Co
20100420104122-Fi
20100414144309-Go
20100420103941-Jo
20100420102941-JY
20100420103432-Ke
20100420103541-Lo
20100420103621-Pa
20100415144559-Sw
20100420103715-Th
20100420103650-Vi
20100420104126-Wa
20100414144558-Wu

It should sort the first way (as far as I can tell).  See anything wrong?

Title: Re: Sorting by filename when using a numeric prefix
Post by: Matt on April 26, 2010, 03:39:22 pm

The smart number handler that makes 5 come before 10 (even though 5 sorts before 1 alphabetically) only handles up to 32-bit integers.

Those big numbers you're using are overflowing it.  We'll look at expanding this to 64-bit in a coming build.

Title: Re: Sorting by filename when using a numeric prefix
Post by: mc_user on April 27, 2010, 06:50:01 am

OK, thanks.  FYI, I just upgrade from MC 11 and that one handled it fine.

Title: Re: Sorting by filename when using a numeric prefix
Post by: Matt on April 28, 2010, 03:51:34 pm

The change is available here:
http://yabb.jriver.com/interact/index.php?topic=57335.0