Home of the Squeezebox™ & Transporter® network music players.
Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Junior Member
    Join Date
    Oct 2014
    Posts
    28

    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).

    Name:  2019-12-07 16_01_27-Logitech Media Server No Album.png
Views: 181
Size:  35.4 KB

    Name:  2019-12-07 16_01_27-Logitech Media Server No Album Listing.png
Views: 167
Size:  59.0 KB

    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.

  2. #2
    Senior Member dolodobendan's Avatar
    Join Date
    Dec 2017
    Location
    Braunschweig, Germany
    Posts
    851
    Quote Originally Posted by gstalnaker View Post
    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).

    Name:  2019-12-07 16_01_27-Logitech Media Server No Album.png
Views: 181
Size:  35.4 KB

    Name:  2019-12-07 16_01_27-Logitech Media Server No Album Listing.png
Views: 167
Size:  59.0 KB

    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.3@2.04 x64 (digimaster) with perl 5.28 dedicated to me. :D / QNAP 469L QTS 4.3.4

  3. #3
    Junior Member
    Join Date
    Oct 2014
    Posts
    28

    Can mp3tag do that?

    My collection is 57,000+ tracks, 3800+ albums. I'd not have thought mp3tag could handle that. Can it?

  4. #4
    Senior Member
    Join Date
    Jan 2010
    Location
    Hertfordshire
    Posts
    3,491
    Quote Originally Posted by gstalnaker View Post
    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

  5. #5
    Senior Member dolodobendan's Avatar
    Join Date
    Dec 2017
    Location
    Braunschweig, Germany
    Posts
    851
    Quote Originally Posted by gstalnaker View Post
    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.3@2.04 x64 (digimaster) with perl 5.28 dedicated to me. :D / QNAP 469L QTS 4.3.4

  6. #6
    Senior Member
    Join Date
    Jan 2010
    Posts
    648
    Quote Originally Posted by gstalnaker View Post
    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...

  7. #7
    Senior Member
    Join Date
    May 2010
    Posts
    112
    What happens if you browse by Album in LMS, do empty album name show up?
    1 x Touch
    1 x Radio
    Logitech Media Server Version: 7.9.2 - 0026.1567524015 @ Wed Sep 4 12:28:40 CEST 2019
    Castbridge with 2 x Harman Kardon Citation One, setup as a stereo pair
    Squeeze Ctrl
    Squeeze Player
    Phone: Samsung Galaxy Note 8

  8. #8
    Senior Member Jeff07971's Avatar
    Join Date
    Aug 2011
    Location
    London, England
    Posts
    1,415
    Quote Originally Posted by dolodobendan View Post
    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/showth...Webapp-for-LMS

  9. #9
    Junior Member
    Join Date
    Oct 2014
    Posts
    28

    Finding all tracks with nothing intheir "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.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
    >
    >

  10. #10
    Senior Member
    Join Date
    Feb 2011
    Location
    Cheshire, UK
    Posts
    4,360
    Quote Originally Posted by gstalnaker View Post
    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 storage QNAP TS419p (NFS)
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •