Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
w3wilkes wrote: > Can't speak to custom skip but you can include/exclude genres in DPLC. > @AF1 does have a version of Custom Skip on GitHub though. Do you know if I can open a playlist that I created with SQLPlaylist in DPLC for modification? nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
w3wilkes wrote: > I was a long time Erland SQLPlaylist user too. I've been playing with > the new DPL4 and DPLC (Dynamic PlayList Creator) and it does everything > I was using SQLPlaylist for. To access DPLC you will need to add this > Github url to your Plugin repos; > https://raw.githubusercontent.com/AF-1/lms-dynamicplaylistcreator/main/repo.xml > DPLC should seem fairly familiar if you used SQLPlaylist templates. My > biggie is random songs of chosen genres with BPM filtering which I > manually had to add the SQL statements for BPM to the SQL generated with > Erlands SQLPlaylists. The new DPLC has added BPM filtering to the > template so I'm a very happy camper. DPLC currently works with DPL3, but > I think @AF1 plans to make DPLC a DPL4 only thing down the road. One question I have about the combo of DPL4 and DPC is whether I can recreate my main playlist, which is random songs from my entire collection, but excluding certain genres and also using Custom Skip for songs that are in my Skip playlist. I have it functioning from my old SQLPlaylist version, but I have to edit it every once in a while if I add music from a new genre that I don't want to play. I hope that all makes sense. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
nyindieguy wrote: > Got it. Thanks for making that change in SQL Playlist. That fixed > everything. Last night, I had to rebuild my entire LMS setup because of a power outage. For the moment I am sticking with DPL 3 until I have enough time to play with DPL 4 and learn how best to use it. In the meantime, if I am recalling correctly from the referenced thread above, there was a slightly updated version of SQLPlaylist that I was using that seems to be no longer available. I can only get access to Erland's final version. Is there any way I can get that version again? I added the link the repository where it used to be, but it no longer shows up. Thanks once again. --Ira nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
I'm having an issue with DPL that has been happening intermittently going all the way back to when I was using Erland's original version. I set up the parameters of DPL and hit play, and the playlist just plays the first 15 songs and then stops. If I start again with the same parameters, it keeps playing beyond the first 15 songs and lasts pretty much forever (big collection). This behavior doesn't happen every time, but it happens often enough that I always have to monitor closely until I get beyond 15 songs, and if it does, I know I can leave it alone to keep playing. It doesn't seem to matter what playlist I use or what parameters I use. I happens with the built-in DPL3 playlists as well as the ones I created with SQL Playlist. Any thoughts about what might cause such behavior? Much appreciated, as usual. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
AF1 wrote: > *IMPORTANT: DROPPING LEGACY FILE EXTENSION* > > IF YOU HAVE CREATED YOUR OWN -CUSTOM- DYNAMIC PLAYLISTS[/B], PLEASE MAKE > SURE THEIR *FILE NAMES HAVE THE CORRECT EXTENSION: -.SQL- > > The legacy extension [B].xml.sql* will no longer be supported in future > DPL3 versions (3.6.10+). > > Just remove the *.xml* part so that the file extension is only "*.sql*". > That's it. Thanks for your understanding. Just a quick clarification. When I look at custom lists in my setup, they all seemed to be named as follows: *.sql.values.xml Do I remove the sql and also the values? nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
I 've been using the new versions of DPL and Custom skip for months and really enjoying the new functionality. In particular, I've been loving the built-in playlist that allows you pick random songs with multiple selected genres and also select a decade. My only question is whether Custom Skip can be applied to a built-in list. I have a secondary filter that skips any songs I have placed in the playlist called "skip." For my custom playlists, I just apply that filter. Is there a way to also apply it to the built-in playlists? Thanks, as usual, for keeping this alive. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Dynamic Playlists 3 - get help with your custom playlists
afriend wrote: > There was a line I forgot to delete. Fixed. > > > > I recreated this as best I could. A static playlist with about 1500 > tracks incl. all Beatles tracks I could find. > Then I called the DPL context playlist from above (with year=1967 and > the genres of the tracks in the static playlist) - and no problem, 1967, > Beatles and all. Reasonably shuffled as well - though if the source is a > playlist with albums (compared to your entire library) I would expect > groups of tracks from the same album to show up. > > P.S. Your posts are easier to read if you don't quote/repost the entire > playlist code :-) Sorry about all that quoting. I've removed them so no one gets confused about your revised code. And thanks again. I'll try it out. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115501 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Dynamic Playlists 3 - get help with your custom playlists
afriend wrote: > With *year* you'll have to choose a year. Not optional. > > > Code: > > -- PlaylistName:Songs - multiple genres & year (from selected playlist) > -- PlaylistGroups: > -- PlaylistMenuListType:contextmenu > -- PlaylistParameter1:playlist:Select playlist: > -- PlaylistParameter2:multiplegenres:Select genres: > -- PlaylistParameter3:year:Select year: > select distinct playlist_track.track from playlist_track > join tracks on > tracks.url = playlist_track.track > join genre_track on > genre_track.track = tracks.id and genre_track.genre in ('PlaylistParameter2') > left join dynamicplaylist_history on > dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer' > where > playlist_track.playlist='PlaylistParameter1' > and tracks.year='PlaylistParameter3' > and tracks.audio = 1 > and tracks.secs >= 'PlaylistTrackMinDuration' > and dynamicplaylist_history.id is null > group by playlist_track.track > order by random() > limit 'PlaylistLimit'; > > > > > With *decades* it's optional (select -any-). > > > Code: > > -- PlaylistName:Songs - multiple genres & decade (from selected playlist) > -- PlaylistGroups: > -- PlaylistMenuListType:contextmenu > -- PlaylistParameter1:playlist:Select playlist: > -- PlaylistParameter2:multiplegenres:Select genres: > -- PlaylistParameter3:customdecadechained:Select decade:select cast(((ifnull(tracks.year,0)/10)*10) as int),case when tracks.year>0 then cast(((tracks.year/10)*10) as int)||'s' else 'Unknown' end from tracks where tracks.audio=1 group by cast(((ifnull(tracks.year,0)/10)*10) as int) order by tracks.year desc > select distinct playlist_track.track from playlist_track > join tracks on > tracks.url = playlist_track.track > join genre_track on > genre_track.track = tracks.id and genre_track.genre in ('PlaylistParameter2') > left join dynamicplaylist_history on > dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer' > where > playlist_track.playlist='PlaylistParameter1' > and tracks.year='PlaylistParameter3' > and tracks.audio = 1 > and tracks.secs >= 'PlaylistTrackMinDuration' > and dynamicplaylist_history.id is null > and > case > when 'PlaylistParameter3'!=9 then tracks.year>='PlaylistParameter3' and tracks.year<('PlaylistParameter3'+10) > else 1 > end > group by playlist_track.track > order by random() > limit 'PlaylistLimit'; > > > > > And without year/decade: > > > Code: > > -- PlaylistName:Songs - multiple genres (from selected playlist) > -- PlaylistGroups: > -- PlaylistMenuListType:contextmenu > -- PlaylistParameter1:playlist:Select playlist: > -- PlaylistParameter2:multiplegenres:Select genres: > select distinct playlist_track.track from playlist_track > join tracks on > tracks.url = playlist_track.track > join genre_track on > genre_track.track = tracks.id and genre_track.genre in ('PlaylistParameter2') > left join dynamicplaylist_history on > dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer' > where > playlist_track.playlist='PlaylistParameter1' > and tracks.audio = 1 > and tracks.secs >= 'PlaylistTrackMinDuration' > and dynamicplaylist_history.id is null > group by playlist_track.track > order by random() > limit 'PlaylistLimit'; > > > I tried these out and it appears that there is either a flaw in the code or a bug in the plugin. With the "multiple genres/select decade" playlist, it selected only 9 songs in spite of there being hundreds that would have qualified. All of the 9 songs were from 1960, in spite of having selected that entire decade of the '60s. When I tried a second time, the exact same 8 songs came up. With the "multiple genres/select year" playlist, the songs seemed like they were correct, though not as shuffled as I might have wanted, but ended after several hours of play, when there should have been enough songs to last all day. The big tipoff was no Beatles included when Rock and Roll was one of the selected genres and 1967 was the selected year. Any thoughts? nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread:
Re: [SlimDevices: Plugins] Dynamic Playlists 3 - get help with your custom playlists
afriend wrote: > With *year* you'll have to choose a year. Not optional. > > > Code: > > -- PlaylistName:Songs - multiple genres & year (from selected playlist) > -- PlaylistGroups: > -- PlaylistMenuListType:contextmenu > -- PlaylistParameter1:playlist:Select playlist: > -- PlaylistParameter2:multiplegenres:Select genres: > -- PlaylistParameter3:year:Select year: > select distinct playlist_track.track from playlist_track > join tracks on > tracks.url = playlist_track.track > join genre_track on > genre_track.track = tracks.id and genre_track.genre in ('PlaylistParameter2') > left join dynamicplaylist_history on > dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer' > where > playlist_track.playlist='PlaylistParameter1' > and tracks.year='PlaylistParameter3' > and tracks.audio = 1 > and tracks.secs >= 'PlaylistTrackMinDuration' > and dynamicplaylist_history.id is null > group by playlist_track.track > order by random() > limit 'PlaylistLimit'; > > > > > With *decades* it's optional (select -any-). > > > Code: > > -- PlaylistName:Songs - multiple genres & decade (from selected playlist) > -- PlaylistGroups: > -- PlaylistMenuListType:contextmenu > -- PlaylistParameter1:playlist:Select playlist: > -- PlaylistParameter2:multiplegenres:Select genres: > -- PlaylistParameter3:customdecadechained:Select decade:select cast(((ifnull(tracks.year,0)/10)*10) as int),case when tracks.year>0 then cast(((tracks.year/10)*10) as int)||'s' else 'Unknown' end from tracks where tracks.audio=1 group by cast(((ifnull(tracks.year,0)/10)*10) as int) order by tracks.year desc > select distinct playlist_track.track from playlist_track > join tracks on > tracks.url = playlist_track.track > join genre_track on > genre_track.track = tracks.id and genre_track.genre in ('PlaylistParameter2') > left join dynamicplaylist_history on > dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer' > where > playlist_track.playlist='PlaylistParameter1' > and tracks.year='PlaylistParameter3' > and tracks.audio = 1 > and tracks.secs >= 'PlaylistTrackMinDuration' > and dynamicplaylist_history.id is null > and > case > when 'PlaylistParameter3'!=9 then tracks.year>='PlaylistParameter3' and tracks.year<('PlaylistParameter3'+10) > else 1 > end > group by playlist_track.track > order by random() > limit 'PlaylistLimit'; > > > > > And without year/decade: > > > Code: > > -- PlaylistName:Songs - multiple genres (from selected playlist) > -- PlaylistGroups: > -- PlaylistMenuListType:contextmenu > -- PlaylistParameter1:playlist:Select playlist: > -- PlaylistParameter2:multiplegenres:Select genres: > select distinct playlist_track.track from playlist_track > join tracks on > tracks.url = playlist_track.track > join genre_track on > genre_track.track = tracks.id and genre_track.genre in ('PlaylistParameter2') > left join dynamicplaylist_history on > dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer' > where > playlist_track.playlist='PlaylistParameter1' > and tracks.audio = 1 > and tracks.secs >= 'PlaylistTrackMinDuration' > and dynamicplaylist_history.id is null > group by playlist_track.track > order by random() > limit 'PlaylistLimit'; > > > You make all this seem easy! nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115501 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Dynamic Playlists 3 - get help with your custom playlists
Glad to see this new thread as I am one of those folks who can't code to save my life. My holy grail is a context menu that uses an existing static playlist and allows me to choose a subset of that playlist that chooses multiple genres and/or a year. If anyone wants to tackle that, I would be grateful. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115501 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
I see that a new update was uploaded today. Can we hear more about what was changed/fixed, and how it might affect any existing playlists? Thanks. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > Unless you know how to manually install old GitHub commit versions, no. > > BTW I think the DPL error you mentioned is irrelevant. It just used to > display the currently playing dynamic playlist there. Doesn't seem to > affect any of SQLPlayList's main features: helping you create dynamic > playlists if you don't want to/know how to write SQLite code and making > these dynamic playlists available to DPL3. > CustomSkip is a different matter. Please read the CustomSkip FAQ again. > I've added a paragraph to address this problem. Got it. Thanks for making that change in SQL Playlist. That fixed everything. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > No, you didn't. What you are witnessing are some effects of the DPL3/CS3 > renaming on the SQLPlayList plugin. The SQLPlayList plugin code expects > the old names - which will obviously never come back. That's why I try > to minimize or avoid ties between plugins. Thank you for letting me > know. I'll revise the FAQ notes on SQLPlayList compatibility in the next > days. > > BTW the dropdown menu only ever existed in SQLPlayList but you probably > called SQLPlayList from DPL with the -edit- button (which just redirects > you to the SQLPlayList plugin). This redirect has probably led some > users to believe that DPL is involved in *creating* dynamic playlists. > But it -never- has been and -never will-, it just -plays- them. > Unless somebody else starts maintaining the SQPlayList plugin and > makes/keeps it compatible with DPL3 & CS3 this dropdown menu is gone. > > The good news is that you can still make DPL use CustomSkip filter sets > by adding a playlist parameter to the SQLite code. Save your playlist in > SQPlayList as -Customized SQL- and on the next screen *before* the > sqlite statement itself, where the playlist parameters are (starting > with --), add the playlist parameter for your customskip filter set as > explained in the '*DPL wiki*' > (https://github.com/AF-1/lms-dynamicplaylists/wiki/DPL-playlist-format#general-parameters) > in the paragraph below -Action/CLI parameters-. > > And, of course, the renaming opened up the possibility of sticking with > the old versions (2.x). If you need CustomSkip2 you'd have to make a > pull request to the LMS repo ('see Erland's post' > (https://forums.slimdevices.com/showthread.php?115073-Announce-Dynamic-Playlists-3-(mod)=1037619=1#post1037619)). Is there any chance I get get access to the prior versions of your plugins before the name change? Everything was working perfectly until I stupidly made the change. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
I just followed the directions to transition to the new (and properly named) versions of DPL and Custom Skip. I'm having two issues that I can't seem to fix. 1. When I click on SQL Playlist, I get the following error: "ERROR!!! Cannot find DynamicPlayList plugin, please make sure you have installed and enabled at least DynamicPlayList 1.3" 2. If I look at my custom playlists, either in SQL PLaylist or in DPL 3, there is no longer the dropdown box for Custom Skip. Did I do something wrong? nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
erland wrote: > Unsupported plugins only appear after a user have manually installed > them, confirmed that they work and issued a pull-request towards the > unsupported repo: > https://github.com/LMS-Community/lms-plugin-repository/blob/master/unsupported.xml > If people dont know how to make a pull request they can also just tell > mherger or another community developer to do it for them. > > So the reason Custom Skip doesnt appear is that nobody has done this > yet. People using Custom Skip on 8.0 have installed it before they > upgraded to LMS 8.* or manually installed it after they setup LMS 8.* > > The reason for the above process is to ensure plugins which have never > worked on 8.* doesnt appear in the unsupported list. Once the dust settles, it would be helpful to have step by step instructions to transition to the newly named plugins. Right now I still have version 3.2.7 of DPL and 3.0 of CS installed and working, with the original names. I assume these won't update if you post new versions, but will continue to work as is. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > Ok, one more thing. Using your example try this: > > in the web UI home menu, go to CS and create *2 different filter > _sets_*. > - Leave the *first* filter *set* empty or at least *don't* include a > rule to skip "Revolution #9". > - In the *second* filter *set* do *enable* filtering for "Revolution > #9". > - Then on that very same screen (home menu > CustomSkip) *click on the > _first_ filter -set-* to make it your *primary/default filter set* > (=always on, filtering on all playlists). The name of the active primary > filter set should be displayed at the top: *Active filter set:...* > > Then *in your SQLPlayList playlist* choose the *_second_*(!) filter set > (that should filter "Revolution #9") and save it. > > Testing: > > - add "White Album" to your client playlist (*without DPL, no dynamic > playlist*) and slowly skip forward to "Revolution #9." and see if it's > skipped. It shouldn't be because the primary filter doesn't have a rule > for this and the secondary filter set is not enabled. > > - then start your dynamic playlist that includes the "White Album". Now > "Revolution #9." should be skipped - *as long as DPL is active* - > because DPL/SQLPlayList enabled the secondary filter set when you > started your dynamic playlist. If I doubt verify that DPL is still > active/involved (as described in a previous post). > > So in short: *my testing shows that secondary filtering*, started and > stopped by DPL (as requested by my SQLPlayList dynamic playlist) *does > work as expected*. It makes no difference if you tell SQLPlayList to add > this code to your dynamic playlist definition that starts/stops your > selected (secondary) CS filter set or if you do this manually in a > custom dynamic playlist that use directly in DPL. > > The main difference between DPL v2 and v3 with CustomSkip is that DPLv2 > had some kind of legacy support for calling CS filters *before* adding > tracks to the current playlist to filter tracks whereas the enabled > secondary filter skips tracks at playtime. > Since one of my objectives was to disentangle the dependencies between > DPL and deprecated plugins I've removed this legacy support because #1 > you can filter out tracks in your playlist definition (recommended) and > #2 additionally you have the option to enable a (secondary) CustomSkip > filter set when you start your dynamic playlist. > If anything, the way forward would be to have CustomSkip skip not only > the -current- track at playtime but also check the -next x tracks- in > the client playlist against any (primary and secondary) filter. But > that's another story. > > MY ADVICE: SET THE MAX. NUMBER OF UNPLAYED TRACKS DPL ADDS TO A LOW > NUMBER SO DPL DOESN'T STOP TOO SOON AND DISABLE THE SECONDARY CS FILTER. > > I hope I could help and give a little insight in how this all works. I'm > afraid that's all I can do at this point. Good luck. You are a genius. This method worked and it looks like I'm back in business. Thanks so much for all your help. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > I have good & bad news. The good news is that testing showed that the > revised CustomSkip version 2.5.85 works as expected. The bad news is > that I don't know why it doesn't work for you. > I've created a dynamic playlist with SQLPlayList ('-Random playlist > songs - Random songs from a saved playlist-'), then created a filter set > ('-Test-') that skip songs with years equal to or greater than the > selected year. And it works. > > To help you find the cause maybe some information on how CustomSkip > works might be useful: > > In CS you can choose 1 *active* filter (set) for each client (let's call > it *primary* filter). If global skipping is enabled (as it should be) it > will -always- filter unwanted tracks. I do that for tracks < 90 seconds > and tracks with 'never' in comment tag. > > When you choose a CustomSkip filter (set) in -SQLPlayList-, it's a > *secondary* filter. It's enabled when a dynamic playlist is started and > disabled when the dynamic playlist is stopped. > > A dynamic playlist is also stopped when DPL can't find any more tracks > to add (matching your search criteria) meaning it will disable the > secondary filter this very moment (I haven't changed that) because DPL > has stopped and is not involved any longer. Therefore no more secondary > filtering even if the current client playlist still has some remaining > tracks to play. And if those remaining tracks include tracks that should > be filtered by the secondary filter, they won't be because DPL has > disabled the secondary filter before exiting. > > You can verify if a dynamic playlist is active if you check "Show name > of active playlist in main menu" in DPL settings and then enter the DPL > menu from the home menu. If a dynamic playlist is active it will show > its name on top. But it's -not dynamically updated-, you need to reenter > this menu to verify again after a song change. It wasn't designed for > debugging. > > If the criteria for your static saved playlists return too few matches > too soon then secondary filtering will not work great for you I guess. > If you don't want to deal with SQLite and custom dynamic playlists maybe > use constant filtering (primary filter) instead. I've attached a > screenshot of my test setup so you can recreate it. > > BTW please note that I've pulled DPLv3+ from the LMS main repo. If you > want to keep using it please follow the instructions on the github page > (adding repo url). > Good news: you can now easily switch back to DPLv2 and CustomSkip 2.5.83 > if you want to. > I'm really sorry but that's really all I can do now in my limited time. > > 35985 Thanks once again for your patient explanation. After more experimentation, it is clear that the filter only works if it is applied to all playlists. I know you are done with this and completely respect that. I'm going to put this out there in the hope that someone else decides to tinker with CustomSkip and fix this one remaining issue. In order to frame why this an issue (at least for me), I'll offer up an example. If the setting for CustomSkip is to apply to ALL playlists, it applies to EVERYTHING, including just playing an entire album. So my example is if I want to play The Beatles "White Album," i actually do want it to include "Revolution #9." But I have that song in my Skip list so that it never plays in a random playlist. So, right now I have to make a choice between those two outcomes. In the old version, CustomSkip could be set to only apply to lists played through Dynamic Playlists. I know I have the option of going back to the old versions of both plugins, but I love the new functionality in afriend's updated DPL. Wondering out loud if anyone else out there has this issue, and if someone would be willing to help solve it. Thanks for hearing me out. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > Please try again. Yes, it worked this time. Testing whether it actually works is difficult since I have to use one of my playlists and wait for it to skip a song that is in the list to skip. From one test it seems that it is not working. I played a custom playlist that I created in SQLPLaylist that randomized songs from a particular year, knowing that at least one song from that year was on the "skip" list, and let it play until that song actually came up on the list (hoping it would skip it), but it went ahead and played. Sorry if I'm being a pain in the neck. I would gladly contribute something to support your efforts. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
I'm trying to test out the revised (unsupported) version of CustomSkip via these instructions: Using repo URL Uninstall your previous CustomSkip version Add the repo URL below at the bottom of LMS > Settings > Plugins: https://raw.githubusercontent.com/AF-1/lms-customskip/main/public.xml Install the new version I get as far as seeing the new version but it won't install. Anyone have any ideas? nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > Just think of DPL as some kind of random play with lots of options for > fine-tuning the selection of the tracks you want to listen to. > DPL uses sql queries to fetch tracks. Before DPL v3 the -source- of > these sql queries had to be other plugins like SQLPlayList, TrackStat, > or CustomScan. DPL asks these plugins if they want to provide any sql > queries (=dynamic playlists) and if so, DPL will list them. > With DPL v3 I've added 2 new options: -built-in- dynamic playlists and > the option to create your own -custom- dynamic playlists and use them > directly in DPLv3, without relying on other plugins. > For dynamic playlists think of SQLPlayList as a sql query generator with > a user interface. It takes your playlist parameter choices and creates a > sql query file (either sql.xml or as a xml template). It assists you in > creating sql queries. > Since DPL and SQLPlayList use the same sql query format you could easily > export most of your SQLPlayLists as customized sql query files and uses > them in DPL directly. That's probably good to bear in mind if > SQLPlayList should ever stop working properly. > > So when I talk about using custom dynamic playlists I usually mean > creating custom sql query files and putting them in the DPL custom > playlist folder. It's a very powerful option because you can create > exactly the kind of dynamic playlist you want. And it probably sounds > more difficult than it actually is. > > > It seems that CustomSkip does not properly skip songs in dynamic > playlists because there's a block of code in CustomSkip that prevents > that. I've uploaded a slighly revised version of CustomSkip to > '*github*' (https://github.com/AF-1/lms-customskip) that should fix > this. > > In your case you would certainly benefit from a custom dynamic playlist > tailored to your specific needs. Below is custom dynamic playlist based > on your screenshot. Open your text editor, copy the sql code below > and save it as "nameofyourchoice*.sql.xml*". The file extension > *.sql.xml* is important. Now put this file into the -DPL custom playlist > folder- (should be in your playlist folder if you haven't changed the > location). > > > Code: > > > -- PlaylistName:Random songs from collection - ignore songs in selected playlist > -- PlaylistParameter1:playlist:Select playlist to ignore: > select distinct tracks.url from tracks > left join dynamicplaylist_history on > dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer' > where > tracks.audio = 1 > and tracks.secs >= 'PlaylistTrackMinDuration' > and dynamicplaylist_history.id is null > and not exists (select * from tracks t2,playlist_track > where > t2.url=tracks.url and > tracks.url = playlist_track.track and > playlist_track.playlist != 'PlaylistParameter1') > and not exists (select * from tracks t3,genre_track,genres > where > t3.id=tracks.id and > tracks.id=genre_track.track and > genre_track.genre=genres.id and > genres.name in ('Alternate Version','Avantgarde','Baseball','Broadway','Christmas','Comedy','Country','Electronic','Ethnic','Hip Hop','Jazz','Jazz-Fusion','Live','Novelty','Raga','Soundtrack','Spoken Word','Standards','Unreleased Rarity')) > group by tracks.url > order by random() > limit 'PlaylistLimit'; > > > > > This new playlist should now appear in the not-classified group. Adapt > it to your needs (name, excluded genre list). > > > I'm not sure I understand. Same as in v2 you can't -create- new > dynamic playlists in DPL with the user interface. The only way you can > add new dynamic playlists to DPL (as explained in the beginning) is by > adding sql query files to the DPL custom playlist folder or in other > plugins like SQLPlayLists. > I don't know how "adding to favorites" plays into this. But please > note that you can only add dynamic playlists to LMS favorites that > don't request further user input. Same as in v2, that hasn't changed. Thanks again for the detailed response. I'm now beginning to understand. Since I have absolutely no capacity to write SQL, can I assume that SQLPLaylists can still be used to create custom play lists? From what I can see, this still works. Regarding your fix for CustomSkip, has anyone tested it yet? I'm not sophiticated enough to replace it and then go backwards if necessary. The use of
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > With v3.2.1 you have 2 options to achieve this: > > - I've added a dynamic playlist that plays random songs but ignores all > tracks from a selected playlist. You'd have to choose the genres to > exclude on the botton of DPL's settings page. That should work. Only > downside: these excluded genres will apply to all built-in dynamic > playlists. > > - Or you can create a *custom* dynamic playlist to use in DPL *directly* > - _-*without*-_ SQPlayList. For that you'd have to post the sql code > here so I can take a look and post my version. To get the sql code: on > the screenshot page at the bottom choose the radio button "-Customize > SQL-", then press -Save- but *_don't_ press any button on the next page* > (save/save) or SQLPlaylist will always show this playlist in sql > code. Instead copy the sql query code from the box and post it here in > code tags. Then click on Home or close the window. Thanks for this. I guess some of this is over my head as I really don't understand the relationship between DPL and SQL Playlist. I believe that you said in a prior post that if I set Custom Skip to work on all playlists, that would solve the issue. If so, I think that would be OK for my purposes, even though all my static playlists wouldn't really need it. What I'm finding confusing is that if I go into your version of DPL and create a new list by selecting the parameters and then I save it as a favorite, it creates a new SQL file. Then I have to go into SQLPLayist and refresh. Once I do that, the new playlist appears within DPL and seems to work. Sorry if my questions are too basic. And thanks for your responsiveness. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > -How- do you create it? In SQLPlayList? DPLv3+ still supports > SQLPlayList playlists in general. But this plugin is deprecated. It > simply doesn't know and therefore can't add any of the new parameters > and so on. In the case of CustomSkip it might still work if the filter > set is enabled using the -startaction- playlist parameter. As I wrote on > github it's probably best to do as much filtering as possible in the sql > code. And if you set CustomSkip to global skipping as suggested it > should skip unwanted tracks anyway regardless of what DPL or other > plugins do. If you need help with your playlist definition export it > from SQLPlayList (as described on the '*github*' > (https://github.com/AF-1/lms-dynamicplaylists) page) and post your sql > code here (incl. what you want to achieve, the playlist parameters you > want to use and such). This is a screenshot of one of the playlists that I use. I plays everything in my collection randomly, excluding the genres marked, and uses the Custom Skip filter to exclude any songs that are in a playlist called "Skip." 35969 +---+ |Filename: Screenshot 2021-10-19 181728.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=35969| +---+ nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > The only thing that you could configure in CustomSkip's settings > (besides the folder path) was whether to limit skipping to DPL playlists > or not. Just set it *yes* (= global skipping = not limited to dynamic > playlists) and you should be fine. As I said I think most excluding or > filtering should probably be done in the dynamic playlists (i.e. the sql > queries). But for a static playlist with lots of different single tracks > skipping them with CustomSkip is just as good I guess. > BTW did you have a chance to test the latest github version, esp. the > built-in playlists and the playlist I added for you? Just updated to the latest version and yes, the playlists you created do exactly what I was hoping for. Thanks so much for doing it and for continuing development of the plugin. Regarding CustomSkip, the option still appears when I create a Dynamic playlist. Are you saying that even if I reference it, it won't work? nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
nyindieguy wrote: > Regarding Custom Skip, the way I use it is to omit certain songs that I > keep in a static playlist called "Skip" which omits them from any random > playlist that I create with DPL. I'm assuming that functionality still > exists (I hope). I'm waiting until you publish it with the latest debugged version. Thanks again. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > First off, there is actually a section on how to revert to DPL v2.+ and > not auto-update to DPL v3+ in the future. Just in case. BTW if you did a > *wipe* (=clear) & rescan (not simply scan for new & changed files) > -after- you'd renamed your files your database should be ok. > > And yes, DPL adds "only" a max. of 15 new tracks *by default* but *you > can change that number* on the plugin's settings page (up to 50 tracks), > it's actually the first setting. > Customskip used to be more closely integrated with DPL but DPL playlists > can still enable customskip filters even though the goal would be to > filter out unwanted tracks etc. in SQL queries from the very beginning. > > The built-in DPL lists are just a starting point. The real power of DPL > is that you can create tailor-made dynamic playlists (within the limits > that SQLite allows) that should give you exactly what you want. And > since you can filter/exclude anything unwanted from the very start you > won't even need CustomSkip. You can use these user-provided custom > dynamic playlists -directly- in DPL 3+, without any other plugin like > SQLPlayList or TrackStat. > > This would be a very specific playlist tailored to your personal needs > so I'd obviously not add it to the built-in playlists. > But I could help you create it by posting the sql playlist definition of > such a dynamic playlist here so you can test it. But I'd need to know > -all- the parameters. > > So it's > - an *album* playlist, > - never played before: -entire- album never played before or just > -containing 1 or more tracks- never played before? > - *excluding albums from which genres?* (exact name of genres) > - no min. track duration? > - for all albums or only those with a -minium number of tracks- in it? > (thereby excluding "albums" like CD singles with only 2 tracks for > example) > - in album order or randomly ordered? > ... > > If you want to give this a try please list all the parameters you can > think of incl. what CustomSkip would have skipped. > Otherwise if you prefer to revert to DPL 2.x please visit the github > page for more information on how to do that. Regarding Custom Skip, the way I use it is to omit certain songs that I keep in a static playlist called "Skip" which omits them from any random playlist that I create with DPL. I'm assuming that functionality still exists (I hope). nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
afriend wrote: > Hi. I didn't get a message from the system about your post. True, that > would be a context menu playlist. Before uploading the latest changes to > github I've quickly added such a playlist so you can already test it. It > should end up in the next release once testing shows no more major bugs. Huge thanks for this and for the continuing development of a plugin that I've become dependent on! nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
nyindieguy wrote: > Please let me know if there is a more appropriate thread to ask this, > but here's my question... > > I have an enormous static playlist of all my favorite songs, and I use > Dynamic Playlists to randomize it. I would like the option of choosing a > particular genre within the static playlist. Is something like this > possible? > > Thanks. context menu After reading through more of the documentation, it would seem that the way to do this would be a CONTEXT MENU dynamic playlist like the one at 'https://github.com/AF-1/lms-dynamicplaylists/blob/main/DynamicPlayList/Playlists/zz_contextmenulists/for_playlists/zz_CONTEXTMENU_for_selected_playlist_a01_songs_random.sql.xml ' (https://github.com/AF-1/lms-dynamicplaylists/blob/main/DynamicPlayList/Playlists/zz_contextmenulists/for_playlists/zz_CONTEXTMENU_for_selected_playlist_a01_songs_random.sql.xml), but with the further parameter of selected genres. I don't do code, so if someone is willing to walk me through this, i would greatly appreciate it. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Dynamic Playlists 3 (mod)
Please let me know if there is a more appropriate thread to ask this, but here's my question... I have an enormous static playlist of all my favorite songs, and I use Dynamic Playlists to randomize it. I would like the option of choosing a particular genre within the static playlist. Is something like this possible? Thanks. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] [Announce] Spotty v1.9.0 - now with experimental Spotify Connect support!
I made the mistake of installing the addin without having read much about it. I simply checked it on the addins page. Anyway, after installing it, my squeezebox server will no longer start up. It seems like the addin is not compatible with my version of the server software, but because I can no longer access the settings page, I can't uninstall it. I tried manually deleting all instances and mentions of the addin that I could find, but I still can't start the server service. Can anyone help in trying to remove it? Much appreciated. nyindieguy's Profile: http://forums.slimdevices.com/member.php?userid=62092 View this thread: http://forums.slimdevices.com/showthread.php?t=108030 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins