Results 1 to 10 of 10

Thread: Sorting by disc when sorting by track to list tracks on each disc in order

  1. #1
    Join Date
    Mar 2012
    Posts
    103

    Default Sorting by disc when sorting by track to list tracks on each disc in order

    Well, I don't think this is working quite as I had hoped

    In music, drilling down into the out of the box "Album Artist" playlists. In my original feature request, I used this example:

    To listen to any double album (or more, like Wagner's Ring) each disc in the collection has to have a different value for the "Album" field. As an example, I have to have "Album Name [D1]" for the first disc, and "Album Name [D2]" for the second disc. This means that to have any album play all the way through, I have to either create a customized playlist with all of the song in order, or let Disc 1 play through, then change to another playlist, and let Disc 2 play all the way through. to listen to all the songs on a given album in order.

    If I tag all of the songs in a given album with the same Album tag value, I have to renumber them. Say there are 10 songs on Disc 1. I need to renumber disc 2 to start at '11' and so on.

    What would be desired is that when creating any auto-generated playlist, Mezzmo takes the Disc tag into account when properly tagged (or modified in the Mezzmo database directly). So what the result is that I would get is that songs are ordered first by disc number, then by track number. So using Pink Floyd's "The Wall" as an example, the result would be:

    Album Artist --> Pink Floyd --> The Wall

    Disc 1, Track 1, In the Flesh?
    Disc 1, Track 2, The Thin Ice
    ...
    Disc 1, Track 13, Goodbye Cruel World
    Disc 2, Track 1, Hey You
    Disc 2, Track 2, Is There Anybody Out There?
    etc, etc, etc...

    What happens now is if the value for the 'Album' tag is the same across all discs, Mezzmo orders by track number and then randomly, which is not correct (I'd call it a bug myself):

    Disc 1, Track 1, In The Flesh?
    Disc 2, Track 1, Hey You
    ...
    Disc 2, Track 3, Nobody Home
    Disc 1, Track 3, Another Brick in the Wall, Part I

    Mezzmo should absolutely order all tracks first by disc number, then by track number, in any place where the 'Disc' tag is properly populated. It seems as though Mezzmo ignores the 'Disc' tag completely when indexing music. It's really very frustrating, as I have to rename all of my albums as though they are 2 different albums by the same artist, and I can't just click "Play" on double albums, and have the whole album play all the way through without doing a lot of workarounds. This should be REALLY easy to repro and fix.
    Last edited by hsbrown2; 09-27-2020 at 09:57 AM.

  2. #2
    Join Date
    Jun 2012
    Posts
    541

    Default

    I haven't tried it with albums yet but with TV series it works perfect, just like you described. It will put the first season first (episodes 1 to X) and then the second season (episodes 1 to X) etc... I'll try to give it a shot when I get some time and see if I am seeing the same thing.


    Jeff

  3. #3
    Join Date
    Jun 2012
    Posts
    541

    Default

    I just tested a 3 disc audio set and it worked fine. You need to ensure that the disc and tracks are set properly in the properties tab for the audio tracks. Mine all still said disc 0 and I had to change them to disc 1, disc 2 and disc 3 but with a shift multi-select it was very quick. Once I fixed this it worked perfectly.


    Jeff

  4. #4
    Join Date
    Mar 2012
    Posts
    103

    Default

    Capture.JPGCapture2.JPGCapture3.JPG

    No joy. They are all correctly set, unless I am missing something.

  5. #5
    Join Date
    Mar 2012
    Posts
    103

    Default

    Adding to this...

    Maybe where wires are being crossed is in the fact that I am using the out-of-the-box active playlist that is at the "Album" level of the "Album Artist" playlist. At the album level, with the out-of-the-box playlists, I have one option to modify. You can only sort these by a single criteria. Default is "Track/Episode (Ascending)". I can select "Disc/Season (Ascending)", but then each track is just sorted alphabetically, but grouped by the disc number.

    "Track/Episode (Ascending)" *should* always sort by "Disc/Season (Ascending)", then by "Track/Episode (Ascending)" by default. Or there should be some sort of option to select that does this. But I can't find it.

  6. #6
    Join Date
    Mar 2012
    Posts
    103

    Default

    A little bit more to add to this. I was able to construct a query that gives me what I want - although I can't say for sure if I'm using the correct tables that Mezzmo actually uses to build playlists. However what I can say is this query returns exactly what I want (for the particular album ID - in this case The Wall is 4192):

    SELECT File,Disc,Track
    FROM MGOFile
    WHERE ID IN
    (SELECT FileID
    FROM MGOFileAlbumRelationship
    WHERE ID LIKE '4192')
    ORDER BY Disc,Track

    The results return this (imagine it as a playlist). Sorry for the formatting, but you could paste it into a grid I suspect:

    D:\Music\Pink Floyd\The Wall\Disc 1\In the Flesh!.flac 1 1
    D:\Music\Pink Floyd\The Wall\Disc 1\The Thin Ice.flac 1 2
    D:\Music\Pink Floyd\The Wall\Disc 1\Another Brick in the Wall, Part 1.flac 1 3
    D:\Music\Pink Floyd\The Wall\Disc 1\The Happiest Days of our Lives.flac 1 4
    D:\Music\Pink Floyd\The Wall\Disc 1\Another Brick in the Wall, Part 2.flac 1 5
    D:\Music\Pink Floyd\The Wall\Disc 1\Mother.flac 1 6
    D:\Music\Pink Floyd\The Wall\Disc 1\Goodbye Blue Sky.flac 1 7
    D:\Music\Pink Floyd\The Wall\Disc 1\Empty Spaces.flac 1 8
    D:\Music\Pink Floyd\The Wall\Disc 1\Young Lust.flac 1 9
    D:\Music\Pink Floyd\The Wall\Disc 1\One of My Turns.flac 1 10
    D:\Music\Pink Floyd\The Wall\Disc 1\Don't Leave Me Now.flac 1 11
    D:\Music\Pink Floyd\The Wall\Disc 1\Another Brick in the Wall, Part 3.flac 1 12
    D:\Music\Pink Floyd\The Wall\Disc 1\Goodbye Cruel World.flac 1 13
    D:\Music\Pink Floyd\The Wall\Disc 2\Hey You.flac 2 1
    D:\Music\Pink Floyd\The Wall\Disc 2\Is There Anybody Out There!.flac 2 2
    D:\Music\Pink Floyd\The Wall\Disc 2\Nobody Home.flac 2 3
    D:\Music\Pink Floyd\The Wall\Disc 2\Vera.flac 2 4
    D:\Music\Pink Floyd\The Wall\Disc 2\Bring the Boys Back Home.flac 2 5
    D:\Music\Pink Floyd\The Wall\Disc 2\Comfortably Numb.flac 2 6
    D:\Music\Pink Floyd\The Wall\Disc 2\The Show Must Go On.flac 2 7
    D:\Music\Pink Floyd\The Wall\Disc 2\In the Flesh.flac 2 8
    D:\Music\Pink Floyd\The Wall\Disc 2\Run Like Hell.flac 2 9
    D:\Music\Pink Floyd\The Wall\Disc 2\Waiting For the Worms.flac 2 10
    D:\Music\Pink Floyd\The Wall\Disc 2\Stop.flac 2 11
    D:\Music\Pink Floyd\The Wall\Disc 2\The Trial.flac 2 12
    D:\Music\Pink Floyd\The Wall\Disc 2\Outside the Wall.flac 2 13
    Last edited by hsbrown2; 10-03-2020 at 10:29 AM.

  7. #7
    Join Date
    Jun 2012
    Posts
    541

    Default

    I played with this a bit more and in a folder with all of the discs when I sort by track / episode it sorts like you want, by disc and then by episode. With a Smart playlist where I specify Album Artist contains the artist I want, I had to sort by disc and then it would put everything the way you want, by disc and then by episode. Active playlists get slightly different because of the other criteria used to select and group the playlist contents. Peter may have to weigh in here or you might try sorting by disc. I am not aware of an option for nested sorting like by artist and then by disc for active playlists.


    Jeff

  8. #8
    Join Date
    Mar 2012
    Posts
    103

    Default

    I can't get it to work in any way I try. I tried everything that seemed logical to me, and like I said, I'm using the out of the box playlists for the "Album Artist" category, I could recreate it, but it doesn't seem to work in any way I can figure it out.

  9. #9
    Join Date
    Jun 2012
    Posts
    541

    Default

    Peter will probably need to look at this. To recreate your SQL query above you can create a new Smart Playlist and select the file path contains "Pink Floyd\The Wall" and then sort by disc. You might try this to see if it works and matches your SQL query. This will at least tell us that it is working the same as I am seeing it. I believe the stock playlists you are using are all active playlists.


    Jeff
    Last edited by jbinkley60; 10-07-2020 at 12:47 AM.

  10. #10
    Join Date
    Sep 2009
    Posts
    2,367

    Default

    I tried in the artist playlist changing the track number of a file to 1 and disc to 2 so that I had two tracks with track 1 and a disc 1 and disc 2 and it did not order them correctly so I will need to check this.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

Similar Threads

  1. Replies: 1
    Last Post: 09-20-2020, 09:26 AM
  2. Multi-Disc CD Ausio Sorting
    By hsbrown2 in forum Mezzmo Wish List and Feedback
    Replies: 5
    Last Post: 10-01-2019, 07:44 AM
  3. Sorting by watch order
    By texasmidnight in forum Mezzmo Questions and Support
    Replies: 2
    Last Post: 09-01-2015, 10:28 AM
  4. Mezzmo for DVD/BR-Disc Streaming to TV
    By OnScreen in forum Mezzmo Wish List and Feedback
    Replies: 6
    Last Post: 06-04-2014, 12:00 PM
  5. Does not respect disc number
    By hsbrown2 in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 07-19-2012, 11:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •