Bugzilla – Bug 12658
Handle differing years for songs on an album better
Last modified: 2011-04-08 01:37:31 UTC
Currently, an album has a year property, so browsing by years shows an album under one year. For normal albums this is fine (all songs having the same year tag value). However, for compilation albums, many people tag the songs with the year of original release (the year tag refers to the song year, not album year). The effect of browsing albums by year (Browse Years) though should be that an album can appear under multiple years, because an album would contain songs from different years. If people want to use YEAR to represent the year the album was released, it would still work the same - i.e. this solution would work for both user camps without needing to introduce any new custom tags. Genres are already treated this way, I think. i.e. an album can have songs with different genres, and the album would appear when browsing any of those genres - there is no concept of an ALBUMGENRE tag. This is also like how SbS treats aritsts - the album artist is derived from the song artists (i.e. if all artists are the same, the album artist is the same; if artists on songs are different, the album artist is Various Artists, unless there's an Album Artist to override it). Having said that, there's no reason why it couldn't also support ALBUMYEAR to override the year an album was released if songs have differing years. Similarly for ALBUMGENRE.
I'd really like to see this implemented too! Also, it should be possible to have separate artwork for the album - for example, I have a compilation album of singles, and I have embedded the artwork for each single release into the appropriate tracks. A separate artwork for the album is the folder.jpg file in the folder. Currently, however, SbS selects the artwork for the last track in that album as the album artwork. Instead, it should be able to use that folder.jpg as the artwork for the album (but not each song, unless it does not have it's own artwork already, as is the current way things work, I think).
here are some thoughts I had on this which I wrote on the beta forum a couple days ago.. ============================== Hi Phillip, Yes, it would be nice to support track specific year tags. If you use id3v2.4, then you'd probably use TDOR (original release time) for the original release dates of the individual songs and TDRL (release time) for the what you might call the "album year". There's also TDRC (recording time) which Slimserver seems to be mapping YEAR, though I'd probably argue that it is better to use the release dates. Slimserver is currently ignoring TDRL and TDOR. And while we're on the subject, it'd sure be nice if Slimserver stored these as dates rather than years so multiple albums released by an artist could be correctly sorted in the browse artist page. If there's a bug open for this let me know and I'll add that info. >>>>> Philip Meyer <Philip.Meyer.3un87z1246448521@no-mx.forums.slimdevices.com> writes: > The only issue is with Browse Albums, sorted by year - if the album is > to appear only once in the list, what year would it be sorted under? > The first, last, highest, lowest? Probably max makes the most sense as a default.
> James Richardson set Keywords=new_schema, Target=7.4 I thought new_schema was now coming *after* 7.4?
(In reply to comment #3) > > James Richardson set Keywords=new_schema, Target=7.4 > > I thought new_schema was now coming *after* 7.4? It doesn't neccessarily need the new schema - there is already a year (and artwork) field in the albums table, it just needs appropriate logic in the scanner. (The case of multiple years per album might be more complex, the year field is only smallint(5))
>(The case of multiple years per album might be more complex, the year field is only smallint(5)) It doesn't need to store multiple years per album - it already has the information in tracks.year, so something like the following gets the information: SELECT a.id, CONVERT(a.title USING UTF8) as 'Album Title', CONVERT(GROUP_CONCAT(DISTINCT t.year ORDER BY t.year SEPARATOR ', ') USING UTF8) as 'Years' FROM albums a JOIN tracks t ON t.album = a.id GROUP BY a.id, a.title
see also bug 10426
Alan, i thought this might be inside the scope of onebrowser