>and so SC7 has ALBUMARTIST as blank i'd imagine.
No, you misunderstand/haven't been reading.
Every album has exactly 1 album artist (main contributor). It is set when you
scan the library. If you haven't defined a Txxx ALBUMARTIST tag, then the
artist associated with an album record will be:
If the same artist contributor(s) appears on all songs of the artist,
that artist(s) name will also be the album artist.
If there are different artists on songs on an album, the album artist
will be the record meaning "Various Artists".
Eg. I have an album "No Pussyfooting" by Robert Fripp and Brian Eno. That's
two contributors to every track on the album. I also set the Txxx ALBUMARTIST
to "Fripp & Eno". I see the album listed under "Fripp & Eno" as an artist. I
also see it listed under Robert Fripp and also under Brian Eno, because I have
other albums by those artists as solo performers.
In addition, the "list albums by band" *might* be intending to use BAND as
album artist, such that at scan time, the album artist is set to the artist in
the BAND tag, otherwise the artist of the songs, or Various Artists. I say
might, because I don't know for sure how that option was intended to work. But
the point is that after a scan, every album will have an album artist.
If you were to examine the content of the database, the following query would
confirm it for you:
SELECT distinct(namesort)
FROM albums a
JOIN contributors c on a.contributor = c.id
ORDER BY namesort
would return all main contributors (album artists) sorted by album artist name
sort order. Every album has a contributor.
I believe I would have no quarrels if "list album by band" caused the scanner
to read a band tag and store it as the album artist, like rule 1 above. It
should remain an option, as I consider the current implementation without "list
album by band" to be correct. BAND is not ALBUMARTIST in my mind.
By the way, there is a description of the database tables available at
http://wiki.slimdevices.com/index.cgi?SlimServerDatabaseStructure
Phil
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
