gstalnaker wrote: > 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.
Why don't you just load your library into mp3tag and sort by album? Then you can add the tags you want. Or you can export the tags %_path% and %title% or whatever info you want of these files into a text file. QLMS 7.9.2@2.04 x64 (digimaster) with perl 5.28 dedicated to me. :D / QNAP 469L QTS 4.3.4 ------------------------------------------------------------------------ dolodobendan's Profile: http://forums.slimdevices.com/member.php?userid=67663 View this thread: http://forums.slimdevices.com/showthread.php?t=111324 _______________________________________________ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
