Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 5 of 5
  1. #1
    Senior Member erland's Avatar
    Join Date
    Dec 2005
    Location
    Sweden
    Posts
    11,302

    Best way to categorise music library (local and online) ?

    I've been occupied with other stuff than music listening for a few years and my LMS setup has been stuck at LMS 7.8. This weekend I spent some time to setup a new installation of LMS using latest 8.2 release and realised that the genres in my library looks like a mess. It's a long history and I have a couple of different problems. Parts of the history is that when my wife and I joined our music library the focus was to just rip all her CDs the easiest way to get her music accessible via the Squeezebox players. I did the ripping using Vortexbox with no manual genre editing afterwards. Another part is that today I've more or less stopped buying new CD's, all new music comes from streaming services or electronic purchases today where I've less possibilities to manage this through tags.

    With the new possibilities with LMS 8.x it feels like there must be a way to clean this up.

    What I'd like is to be able to categorise the music (both local and from streaming services (mainly Spotify)) via a smart phone/tablet.
    Changing tags is unlikely to work it also needs to work for content from streaming services now when these are integrated with the LMS library.
    I'd like to do it via a smart phone/tablet because that would make it possible to work on the categorisation even when I'm not in front of a computer. The computer keyboard have a bit too many keys that are tempting to push for my two year old child, so it would be a lot easier to do it via a smart phone/tablet.

    Feels like playlists together with virtual libraries might be a way to do it. I guess I'd have to create a small plugin that makes it possible to create a virtual library based on a selected playlist unless there is a way to do that with standard LMS ? Didn't find any possibilities to do a search limited to a playlist but I might be missing something.

    The only thing I'm a bit scared of is that the playlist management functions in LMS makes it a bit too easy to accidentally destroy/replace contents of a playlist, but maybe the Playlist Manager plugin would be a solution if it supports adding tracks from streaming services to a playlist.

    Is there a better way to handle this that I'm missing ?
    Erland Isaksson (My homepage)
    Developer of many plugins/applets
    Starting with LMS 8.0 I no longer support my plugins/applets (see here for more information )

  2. #2
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,599

    Best way to categorise musiclibrary (local and online) ?

    > genre editing afterwards. Another part is that today I've more or less
    > stopped buying new CD's, all new music comes from streaming services or
    > electronic purchases today where I've less possibilities to manage this
    > through tags.


    When I buy music the first thing I do is fix the tagging. I've bought
    music in the past which wasn't just not to my liking, but even with
    incorrectly encoded tags. So this step IMHO still is required for anyone
    who cares about his music's tags.

    As for streaming services: the Online Library Integration plugin has
    some simple support for genres. You can re-define genres based on artist
    names or album titles. Rather simplistic, but it does the job for the
    music I care most about (so far).

    In addition to that my Music And Artist Information plugin can look up
    genres online. But unfortunately this often isn't any more
    helpful/precise than what you might have seen with vortexbox.

    > Feels like playlists together with virtual libraries might be a way to
    > do it. I guess I'd have to create a small plugin that makes it possible


    I'm not sure how that would help with the tags?

    > to create a virtual library based on a selected playlist unless there is
    > a way to do that with standard LMS ? Didn't find any possibilities to do
    > a search limited to a playlist but I might be missing something.


    A library definition can be (almost) as simple as an SQL statement.
    That's something you know and could get started with. Here's eg. my
    definition of the "kids music" library:

    name: Kinder
    params:
    - KINDER%
    - '% KINDER%'
    - KASPERLI%
    - '% KASPERLI%'
    - KINDERMUSIK%
    - '% KINDERMUSIK%'
    - 1
    sql: INSERT OR IGNORE INTO library_track (library, track) SELECT
    '%s', id FROM ((SELECT
    me.id FROM tracks me LEFT JOIN genre_track genreTracks ON
    genreTracks.track =
    me.id WHERE ( ( genre IN ( SELECT me.id FROM genres me WHERE ( ( (
    me.namesearch
    LIKE ? OR me.namesearch LIKE ? ) OR ( me.namesearch LIKE ? OR
    me.namesearch LIKE
    ? ) OR ( me.namesearch LIKE ? OR me.namesearch LIKE ? ) ) ) ) AND
    me.audio = ?
    ) ) GROUP BY me.id))

    Create a few libraries using advanced search, then look at the resulting
    definitions in virtualLibraries.prefs. You'll quickly learn from that.

  3. #3
    Senior Member erland's Avatar
    Join Date
    Dec 2005
    Location
    Sweden
    Posts
    11,302
    Quote Originally Posted by mherger View Post

    > Feels like playlists together with virtual libraries might be a way to
    > do it. I guess I'd have to create a small plugin that makes it possible


    I'm not sure how that would help with the tags?
    The idea would be to have one playlist per genre and create a virtual library for each playlist which would make it possible to browse the content of that tag.

    Quote Originally Posted by mherger View Post

    > to create a virtual library based on a selected playlist unless there is
    > a way to do that with standard LMS ? Didn't find any possibilities to do
    > a search limited to a playlist but I might be missing something.


    A library definition can be (almost) as simple as an SQL statement.
    That's something you know and could get started with. Here's eg. my
    definition of the "kids music" library:

    name: Kinder
    params:
    - KINDER%
    - '% KINDER%'
    - KASPERLI%
    - '% KASPERLI%'
    - KINDERMUSIK%
    - '% KINDERMUSIK%'
    - 1
    sql: INSERT OR IGNORE INTO library_track (library, track) SELECT
    '%s', id FROM ((SELECT
    me.id FROM tracks me LEFT JOIN genre_track genreTracks ON
    genreTracks.track =
    me.id WHERE ( ( genre IN ( SELECT me.id FROM genres me WHERE ( ( (
    me.namesearch
    LIKE ? OR me.namesearch LIKE ? ) OR ( me.namesearch LIKE ? OR
    me.namesearch LIKE
    ? ) OR ( me.namesearch LIKE ? OR me.namesearch LIKE ? ) ) ) ) AND
    me.audio = ?
    ) ) GROUP BY me.id))

    Create a few libraries using advanced search, then look at the resulting
    definitions in virtualLibraries.prefs. You'll quickly learn from that.
    Oh, didn't think about editing the prefs files manually. Thanks, that should be a way to do exactly what I want. :-)
    Erland Isaksson (My homepage)
    Developer of many plugins/applets
    Starting with LMS 8.0 I no longer support my plugins/applets (see here for more information )

  4. #4
    Senior Member
    Join Date
    Mar 2015
    Location
    Frankfurt
    Posts
    106
    Quote Originally Posted by mherger View Post
    > ...
    In addition to that my Music And Artist Information plugin can look up
    genres online. But unfortunately this often isn't any more
    helpful/precise than what you might have seen with vortexbox.
    [color=blue]...

    Is this genre lookup feature only working for online music services or also for locally stored music? Would be nice!
    Living Room: piCorePlayer 8.0.0 on rPi 4 & 1TB USB (LMS 8.3 & Squeezelite), RME ADI-2 DAC, Unison Research Sinfonia, Klipsch Forte III.
    Bedroom: Boom / Workspace: Boom / Kitchen: Radio

  5. #5
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,599

    Best way to categorise musiclibrary (local and online) ?

    > Is this genre lookup feature only working for online music services or
    > also for locally stored music? Would be nice!


    It's online music only. There are enough tools to "fix" the genre tags
    in your own files once and for all.

Posting Permissions

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