All,
I see in my LMS web UI a listing for "No Album" in, for example, New Music (see screen show below). When I click on it, I see 100s of tracks (see screen show below). 28712 28713 GAH! Now, I know why this is, so that's doesn't worry me. But, I want to fix them by assigning appropriate tracks to Albums, etc. Issue -- how can I get a complete list of these tracks (without using the LMS web UI)?? I've spend a fair bit of time (days, actually) trying to figure out how to get a list of these tracks that have no information in their mp3tab "album" tag. I've searched to find Linux/Windows commandline tools that can get to the file mp3tag data directly. Nothing (not even using RegEx). So I turned to LMS itself to see what may be possible. Seems the best approach is to use queries directly against the LMS db. But, how to do that? ErlandI created a SQL query plugin but there is no documentation I can find that explains how to use it. Nor do I find documentation on the DB structure to know how one might write an SQL query to do this. The CLI interface also doesn't see promising as a method to query the DB. I thought I could, perhaps, copy the contents of the Cache folder to a local drive, then set up phpLiteAdmin and open the DB in it, and try to use it's UI to do some SQL digging, but phpLiteAdmin persistently says that the files I copied (all of them) from the LMS ./Cache folder are not SQLite db files. Again, what I want is a list of these tracks that have a blank, NULL, empty, "", value in the Album mp3tag. The data should reference the path/filename (so they can actually be found on the harddrive). Since my music is on a NAS I can easily get to the physical files. Anyone have an idea how to get this list?m Thanks. +-------------------------------------------------------------------+ |Filename: 2019-12-07 16_01_27-Logitech Media Server No Album Listing.png| |Download: http://forums.slimdevices.com/attachment.php?attachmentid=28713| +-------------------------------------------------------------------+ ------------------------------------------------------------------------ gstalnaker's Profile: http://forums.slimdevices.com/member.php?userid=63504 View this thread: http://forums.slimdevices.com/showthread.php?t=111324 _______________________________________________ Squeezecenter mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/squeezecenter
