Reply to thread

Message

<blockquote data-quote="SteveV" data-source="post: 59537" data-attributes="member: 15481">Here's a very simplified overview of what happens when you scan your shares to update the database:1.) Get a song file from the share folder2.) Read the tag info3.) Using the &quot;Artist&quot; field from the tag, get the idArtist from the database.3.1) If no idArtist is returned add the &quot;Artist&quot; to the database &quot;artist&quot; table and get the idArtist.4.) Using the &quot;Album&quot; field from the tag, get the idAlbum from the database.4.1) If no idAlbum is returned, add the &quot;Album&quot; to the &quot;album&quot; table and assign the idArtist to the album.idArtist field.This all works fine if all the tracks for a given album are by the same artist.&nbsp; As you can probably guess, if the album is a &quot;Various Artists&quot; album 4.1 creates a problem--the artist id for this track is used as the artist id for the entire album.&nbsp; &quot;Scan albums for Various Artists&quot; gets around this by looking up all of the tracks for each album and counting the number of different artists after the initial scan has completed.&nbsp; If the number of artists is greater than 1 the idArtist for the album is changed to the &quot;Various Artists&quot;&nbsp; id.At the time I made the changes, making this an option seemed like a good idea.&nbsp; In reality, this probably shouldn't be an option and should just be performed automatically.&nbsp; Hope this helps clear things up.Steve</blockquote>

[QUOTE="SteveV, post: 59537, member: 15481"] Here's a very simplified overview of what happens when you scan your shares to update the database: 1.) Get a song file from the share folder 2.) Read the tag info 3.) Using the "Artist" field from the tag, get the idArtist from the database. 3.1) If no idArtist is returned add the "Artist" to the database "artist" table and get the idArtist. 4.) Using the "Album" field from the tag, get the idAlbum from the database. 4.1) If no idAlbum is returned, add the "Album" to the "album" table and assign the idArtist to the album.idArtist field. This all works fine if all the tracks for a given album are by the same artist. As you can probably guess, if the album is a "Various Artists" album 4.1 creates a problem--the artist id for this track is used as the artist id for the entire album. "Scan albums for Various Artists" gets around this by looking up all of the tracks for each album and counting the number of different artists after the initial scan has completed. If the number of artists is greater than 1 the idArtist for the album is changed to the "Various Artists" id. At the time I made the changes, making this an option seemed like a good idea. In reality, this probably shouldn't be an option and should just be performed automatically. Hope this helps clear things up. Steve [/QUOTE]

Verification