Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
I have my library on a NAS with "normal" mirrored 4Tb drives. It takes mp3tag about 45 minutes to load the whole set. But I've added the NAS mounted locally to mp3tag's Library option so that won't be a problem later. I confess I was skeptical (and mp3tag did die once), but I made great progress last night in fixing missing titles, genres, and albums. It really is a terrific tool. Now I've figured out how the "filter" option works it was a pleasure to us (and the forum is active and extensive, which is also a plus). Thanks. On 12/10/2019 10:57 AM, philchillbill wrote: I have over 70K tracks (about 50:50 mp3:FLAC) and mp3tag loads the whole lib no problem. I deliberately bought a 2TB Samsung QVO-series SSD for my music files, since it used to take over an hour to load up mp3tag with a spinning HD. With the SSD, it all loads in 5-6 minutes. If you tag often and heavily, at today's prices an SSD is not as overkill as it once was :cool: philchillbill's Profile: http://forums.slimdevices.com/member.php?userid=68920 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 -- “Happiness is the meaning and the purpose of life, the whole aim and end of human existence.” ― Aristotle ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
I have over 70K tracks (about 50:50 mp3:FLAC) and mp3tag loads the whole lib no problem. I deliberately bought a 2TB Samsung QVO-series SSD for my music files, since it used to take over an hour to load up mp3tag with a spinning HD. With the SSD, it all loads in 5-6 minutes. If you tag often and heavily, at today's prices an SSD is not as overkill as it once was :cool: philchillbill's Profile: http://forums.slimdevices.com/member.php?userid=68920 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
gstalnaker wrote: > Well, I tried using phpLiteAdmin, supposedly a SQLite version of > phpSQLAdmin, but it does not 'recognize' library.db as a SQLite db. I > even copied the entire ./Cache folder and nothing doing. > > But I'm good now -- using mp3tag is the way to go. > > Thanks. > > On 12/8/2019 5:26 AM, reinholdk wrote: > > gstalnaker wrote: > >> All, > >> > >> 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. > >> > > You would just need the library.db file. It's a sqlite db (unless you > > are running a very old LMS with MySql support or did some tweaking to > > use MySql). > > But as others suggested, loading all files with mp3tag should work. > Of > > course it might take a while... > > > > > > > > > reinholdk's Profile: > http://forums.slimdevices.com/member.php?userid=36070 > > View this thread: > http://forums.slimdevices.com/showthread.php?t=111324 > > > > For future reference - this will open library.db perfectly - https://sqlitebrowser.org/ VB2.4[/B] STORAGE *QNAP TS419P (NFS) [B]Living Room* - Joggler & SB3 -> Onkyo TS606 -> Celestion F20s *Office* - Pi3+Sreen -> Sony TAFE320 -> Celestion F10s / Pi2+DAC & SB3 -> Onkyo CRN755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - Pi2+DAC ->ToppingTP21 ->AKG Headphones *Bedroom (TV)* - SB Touch ->Sherwood AVR ->Mordaunt Short M10s Everything controlled by iPeng d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
gstalnaker wrote: > Thanks everyone ... mp3tag is the ticket. I'd be using it in any case to > > do the tag editing. Note it took MUCH longer than 10 minutes to load my > > collection, but load it did and I've exported the lists I wanted (to > have them). > > Now for the really hard part -- the actual tag editing :-/ > In case you need to load the full library into mp3tag more often, you can advise mp3tag to create its own db for caching the tags to speedup subsequent loading. See https://help.mp3tag.de/options_library.html reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
Well, I tried using phpLiteAdmin, supposedly a SQLite version of phpSQLAdmin, but it does not 'recognize' library.db as a SQLite db. I even copied the entire ./Cache folder and nothing doing. But I'm good now -- using mp3tag is the way to go. Thanks. On 12/8/2019 5:26 AM, reinholdk wrote: gstalnaker wrote: All, 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. You would just need the library.db file. It's a sqlite db (unless you are running a very old LMS with MySql support or did some tweaking to use MySql). But as others suggested, loading all files with mp3tag should work. Of course it might take a while... reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 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 -- “Happiness is the meaning and the purpose of life, the whole aim and end of human existence.” ― Aristotle ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
Thanks everyone ... mp3tag is the ticket. I'd be using it in any case to do the tag editing. Note it took MUCH longer than 10 minutes to load my collection, but load it did and I've exported the lists I wanted (to have them). Now for the really hard part -- the actual tag editing :-/ Regards! On 12/8/2019 5:24 PM, dolodobendan wrote: Jeff07971 wrote: Just tried Mp3tag on my collection of c30,000 tracks. Took about 10 miutes to load but seems OK manipulating them Jeff That's why I said what I said. 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 -- “Happiness is the meaning and the purpose of life, the whole aim and end of human existence.” ― Aristotle ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
Jeff07971 wrote: > Just tried Mp3tag on my collection of c30,000 tracks. > > Took about 10 miutes to load but seems OK manipulating them > > Jeff That's why I said what I said. 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
d6jg, Thanks for the recommendation. Doesn't fix the current problem, but useful for the future. Guy -- “Happiness is the meaning and the purpose of life, the whole aim and end of human existence.” ― Aristotle On Sun, Dec 8, 2019, 12:10 PM d6jg wrote: > > gstalnaker wrote: > > That's how I "noticed" them ... they show up in the LMS New Music > > listing. > > I'm not surprised by this. I've been digitizing old LPs, so I've > > obviously > > missed tagging them. Getting from the LMS listing to a listing that > > shows > > tracks and file paths to find the actual files so I can tag them > > correctly > > is a LOT of work in LMS UI. > > > > I was hoping someone had the knowledge for searching the LMS DB using > > an > > AddOn tool or the CLI access method to create a listing. But knowing how > > to > > format the CLI query for 'album tag = NULL or "" ' is not obvious in > > any > > post I've read or documentation I've seen. > > > > Or, some *nix guru has an idea how to do this with CLI tools like find > > and > > id3v3 or mp3info. I could not figure out how to search for what I want > > using a single line CLI. > > > > So, before I created a shell script or Perl script I figured I'd ask > > here. > > > > Guy > > > > -- > > > > “Happiness is the meaning and the purpose of life, the whole aim and > > end of > > human existence.” > > > > ― Aristotle > > > > On Sun, Dec 8, 2019, 9:04 AM T-bird < > > T-bird.9aqqwn (AT) no-mx (DOT) forums.slimdevices.com> wrote: > > > > > > > > What happens if you browse by Album in LMS, do empty album name show > > up? > > > > > > > > > > > > 1 x Touch > > > 1 x Radio > > > 1 x Harman Kardon Citation One > > > Logitech Media Server Version: 7.9.2 - 0020.1557815622 @ Tue May 14 > > > 08:51:56 CEST 2019 > > > Castbridge > > > Squeeze Ctrl > > > Squeeze Player > > > Phone: Samsung Galaxy Note 8 > > > > > > > > T-bird's Profile: > > http://forums.slimdevices.com/member.php?userid=38434 > > > View this thread: > > http://forums.slimdevices.com/showthread.php?t=111324 > > > > > > > > If you are digitising LPs then I’d strongly recommend VinylStudio which > costs about £25. Well worth the money. Yes you can produce the same > outcome for zero cost with Audacity but the naming, splitting and > tagging takes no time at all with VinylStudio > > > > VB2.4[/B] STORAGE *QNAP TS419P (NFS) > [B]Living Room* - Joggler & SB3 -> Onkyo TS606 -> Celestion F20s > *Office* - Pi3+Sreen -> Sony TAFE320 -> Celestion F10s / Pi2+DAC & SB3 > -> Onkyo CRN755 -> Wharfedale Modus Cubes > *Dining Room* -> SB Boom > *Kitchen* -> UE Radio (upgraded to SB Radio) > *Bedroom (Bedside)* - Pi2+DAC ->ToppingTP21 ->AKG Headphones > *Bedroom (TV)* - SB Touch ->Sherwood AVR ->Mordaunt Short M10s > Everything controlled by iPeng > > d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 > 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 > ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
Jeff, Much thanks!!! It takes the LMS process well over an hour to run through my collection. I could have let mp3tag attempt to load the entire thing but was obviously hesitating ... I could find nothing on mp3tag's website about any limitations it might have. I'll set it up to load the whole thing tonight when I get home from a daytrip to Chicago. I use mp3tag all the time. But usually my left-clicking on a folder to load the tracks in it to edit track tags. So I'll be happy to use it going forward. Best regards!! Guy -- “Happiness is the meaning and the purpose of life, the whole aim and end of human existence.” ― Aristotle On Sun, Dec 8, 2019, 11:12 AM Jeff07971 < jeff07971.9aq...@no-mx.forums.slimdevices.com> wrote: > > dolodobendan wrote: > > It might take a while to load. > > Just tried Mp3tag on my collection of c30,000 tracks. > > Took about 10 miutes to load but seems OK manipulating them > > Jeff > > > > *Players:* SliMP3,Squeezebox3 x3,Receiver,SqueezeLite-X,PiCorePlayer x3 > *Server:* LMS Version: Latest Nightly on Centos 8.0 VM on ESXi 6.5.0U3 > on Dell T320 > *Plugins:* > AutoRescan/BBCiPlayer/PowerSave/PowerSwitchIII/Squeezecloud/Spotty/Player > Groups > *Remotes:* iPeng9/Orangesqueeze/PC/Jivelite/SqueezeLite-X > *Music:* 522GB,1.5K albums with 25K songs by 5K artists mostly FLACs > > *Want a webapp ?* See > http://forums.slimdevices.com/showthread.php?104305-Webapp-for-LMS > > Jeff07971's Profile: http://forums.slimdevices.com/member.php?userid=49290 > 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 > ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
gstalnaker wrote: > That's how I "noticed" them ... they show up in the LMS New Music > listing. > I'm not surprised by this. I've been digitizing old LPs, so I've > obviously > missed tagging them. Getting from the LMS listing to a listing that > shows > tracks and file paths to find the actual files so I can tag them > correctly > is a LOT of work in LMS UI. > > I was hoping someone had the knowledge for searching the LMS DB using > an > AddOn tool or the CLI access method to create a listing. But knowing how > to > format the CLI query for 'album tag = NULL or "" ' is not obvious in > any > post I've read or documentation I've seen. > > Or, some *nix guru has an idea how to do this with CLI tools like find > and > id3v3 or mp3info. I could not figure out how to search for what I want > using a single line CLI. > > So, before I created a shell script or Perl script I figured I'd ask > here. > > Guy > > -- > > âHappiness is the meaning and the purpose of life, the whole aim and > end of > human existence.â > > â Aristotle > > On Sun, Dec 8, 2019, 9:04 AM T-bird < > T-bird.9aqqwn (AT) no-mx (DOT) forums.slimdevices.com> wrote: > > > > > What happens if you browse by Album in LMS, do empty album name show > up? > > > > > > > > 1 x Touch > > 1 x Radio > > 1 x Harman Kardon Citation One > > Logitech Media Server Version: 7.9.2 - 0020.1557815622 @ Tue May 14 > > 08:51:56 CEST 2019 > > Castbridge > > Squeeze Ctrl > > Squeeze Player > > Phone: Samsung Galaxy Note 8 > > > > > T-bird's Profile: > http://forums.slimdevices.com/member.php?userid=38434 > > View this thread: > http://forums.slimdevices.com/showthread.php?t=111324 > > > > If you are digitising LPs then Id strongly recommend VinylStudio which costs about £25. Well worth the money. Yes you can produce the same outcome for zero cost with Audacity but the naming, splitting and tagging takes no time at all with VinylStudio VB2.4[/B] STORAGE *QNAP TS419P (NFS) [B]Living Room* - Joggler & SB3 -> Onkyo TS606 -> Celestion F20s *Office* - Pi3+Sreen -> Sony TAFE320 -> Celestion F10s / Pi2+DAC & SB3 -> Onkyo CRN755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - Pi2+DAC ->ToppingTP21 ->AKG Headphones *Bedroom (TV)* - SB Touch ->Sherwood AVR ->Mordaunt Short M10s Everything controlled by iPeng d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
That's how I "noticed" them ... they show up in the LMS New Music listing. I'm not surprised by this. I've been digitizing old LPs, so I've obviously missed tagging them. Getting from the LMS listing to a listing that shows tracks and file paths to find the actual files so I can tag them correctly is a LOT of work in LMS UI. I was hoping someone had the knowledge for searching the LMS DB using an AddOn tool or the CLI access method to create a listing. But knowing how to format the CLI query for 'album tag = NULL or "" ' is not obvious in any post I've read or documentation I've seen. Or, some *nix guru has an idea how to do this with CLI tools like find and id3v3 or mp3info. I could not figure out how to search for what I want using a single line CLI. So, before I created a shell script or Perl script I figured I'd ask here. Guy -- “Happiness is the meaning and the purpose of life, the whole aim and end of human existence.” ― Aristotle On Sun, Dec 8, 2019, 9:04 AM T-bird < t-bird.9aq...@no-mx.forums.slimdevices.com> wrote: > > What happens if you browse by Album in LMS, do empty album name show up? > > > > 1 x Touch > 1 x Radio > 1 x Harman Kardon Citation One > Logitech Media Server Version: 7.9.2 - 0020.1557815622 @ Tue May 14 > 08:51:56 CEST 2019 > Castbridge > Squeeze Ctrl > Squeeze Player > Phone: Samsung Galaxy Note 8 > > T-bird's Profile: http://forums.slimdevices.com/member.php?userid=38434 > 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 > ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
dolodobendan wrote: > It might take a while to load. Just tried Mp3tag on my collection of c30,000 tracks. Took about 10 miutes to load but seems OK manipulating them Jeff *Players:* SliMP3,Squeezebox3 x3,Receiver,SqueezeLite-X,PiCorePlayer x3 *Server:* LMS Version: Latest Nightly on Centos 8.0 VM on ESXi 6.5.0U3 on Dell T320 *Plugins:* AutoRescan/BBCiPlayer/PowerSave/PowerSwitchIII/Squeezecloud/Spotty/Player Groups *Remotes:* iPeng9/Orangesqueeze/PC/Jivelite/SqueezeLite-X *Music:* 522GB,1.5K albums with 25K songs by 5K artists mostly FLACs *Want a webapp ?* See http://forums.slimdevices.com/showthread.php?104305-Webapp-for-LMS Jeff07971's Profile: http://forums.slimdevices.com/member.php?userid=49290 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
What happens if you browse by Album in LMS, do empty album name show up? 1 x Touch 1 x Radio 1 x Harman Kardon Citation One Logitech Media Server Version: 7.9.2 - 0020.1557815622 @ Tue May 14 08:51:56 CEST 2019 Castbridge Squeeze Ctrl Squeeze Player Phone: Samsung Galaxy Note 8 T-bird's Profile: http://forums.slimdevices.com/member.php?userid=38434 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
gstalnaker wrote: > All, > > 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. > You would just need the library.db file. It's a sqlite db (unless you are running a very old LMS with MySql support or did some tweaking to use MySql). But as others suggested, loading all files with mp3tag should work. Of course it might take a while... reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
gstalnaker wrote: > My collection is 57,000+ tracks, 3800+ albums. I'd not have thought > mp3tag could handle that. Can it? It might take a while to load. 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
gstalnaker wrote: > My collection is 57,000+ tracks, 3800+ albums. I'd not have thought > mp3tag could handle that. Can it?Probably. Try it. Sent from my SM-G900F using Tapatalk slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609 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
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
My collection is 57,000+ tracks, 3800+ albums. I'd not have thought mp3tag could handle that. Can it? 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 Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
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
[SlimDevices: SqueezeCenter] Finding all tracks with nothing in their "Album" mp3 tag
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 Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter