Music DB Not just for albums
But probably like alot of people here i dont just store albums in it, i also have alot of singles.
Which have no album tag cos there singles.
so anychance of if the songs have no ablum tag & you select "Artists"
it would be.... "daftpunk -> around the world" instead of "daftpunk -> unknown -> around the world"
Just a thought that was all
If not, any kind Dev point me in the right direction to mod the code (not that good with C, but i'll give it a go! lol)
Thanks
I had a similar query before and like you mentioned named all my various singles, one off songs under a single album name. I have these singles tagged with embedded album art for each individual file.
So if I tag all singles with "Misc Dance" or whatever and scan them to the library, the will show up under Misc Dance Album but they will all have the same embedded art from the first song scanned in.
I presume this is deliberate as the library presumes all songs in an album will want/have the same album art but is there any way to change this.
The only way around this I have found is to leave the album tag empty so they all show as Unknown Album and then they will be in the library with correct embedded art for each file.
If you can reproduce with just a couple of files and can provide said files, I'll take a look.
I suggest you tag the single's album tag using the single name. At least that way they'll display as you want them to.
Alternatively, you could tag them with the "Singles" album name I guess - that way they'll show up as "Singles" under both albums view and artists view.
As for modding the code to skip the "Unknown" album and show the songs directly under there, you'd have to alter the SQL query used for Artists view (GetAlbumsNav, called with idArtist != -1). You can look at the songs view (GetSongsNav) for appropriate queries for the song level retrieval, and it's just a matter of combining the queries to yield the appropriate result.
You don't have to know any C++ to get the query working - just SQL. Just open MusicDatabase.cpp and find the appropriate queries in GetAlbumsNav() - you are dealing with the case where artist id != -1 and genreid = -1 (there may be more than one to alter). Dump the query into something like SqliteSpy (a db app for Windows) and check that you know how it's working, and alter it to suit. The GetSongsNav() queries may be helpful in this regard.
Once you have the query working as you want, you'll need a bit of C++ code to retrieve song items rather than album items, but that should be reasonably straightforward - check GetSongsNav() for how that does it.
An alternative:
You could do it at a higher level by altering the GetAlbumsNav() routine to ignore the "Unknown" album - compare with how the GetArtistsNav() ignores the "Various Artists" item for instance.
Then I'd create a new routine which:
1. Calls GetAlbumsNav() that you've altered to get all the albums.
2. Calls GetSongsNav() with the artist id and "Unknown" album id and concat the results.
Cheers,
Jonathan
I have a few screenshots to try and explain things and then I'll upload some files if needed.
In Mp3Tag I named all the songs with Album tag "Random Rock" and Band tag to "Misc Artists" and then scanned the updated files to the library and this is what I got.
http://i9.tinypic.com/6fyxutl.jpg
http://i2.tinypic.com/5z4jf9e.jpg
http://i7.tinypic.com/4z1bmf4.jpg
You're going to have to remove the albumartist if you want them to have separate covers.
#If you have any other info about this subject , Please add it free.# |
January 9th, 2009, posted by admin
