erland;228387 Wrote:
> Ok, let me know.
>
> It seems a bet strange that it should have solved that problem, but I
> guess it could since it has worked in my setup all the time.I have now
> specifically tested this from my W2k3 box. I selected
multiple attributes in each listbox, saved the query and then viewed
the resulting .sql.values file. My selections were as follows:
Genre: Rock
Mood: Earnest + Energetic
Theme: Drinking + Empowering
Style: Acid Rock + Acoustic + Adult Alternative
The resulting .sql.values file contents is as follows:
Code:
--------------------
<?xml version="1.0" encoding="utf-8"?>
<sqlplaylist>
<template>
<id>customscan_randommixedtags.sql.xml</id>
<parameter type="text"
id="playlistname"><value>zTesting</value></parameter>
<parameter type="text" id="playlistgroups"></parameter>
<parameter type="text"
id="notrepeat"><value>1</value></parameter>
<parameter type="text" id="minyear"></parameter>
<parameter type="text" id="maxyear"></parameter>
<parameter type="text" id="minalbumrating"></parameter>
<parameter type="text" id="maxalbumrating"></parameter>
<parameter type="text" id="startoftitle"></parameter>
<parameter type="text" id="partoftitle"></parameter>
<parameter type="text" id="startofalbumtitle"></parameter>
<parameter type="text" id="partofalbumtitle"></parameter>
<parameter type="text"
id="onlycompilation"><value>0</value></parameter>
<parameter type="text"
id="noncompilation"><value>0</value></parameter>
<parameter type="text" id="includedperformer"
quotevalue="1"></parameter>
<parameter type="text" id="excludedperformer"
quotevalue="1"></parameter>
<parameter type="text" id="includedartist"
quotevalue="1"></parameter>
<parameter type="text" id="excludedartist"
quotevalue="1"></parameter>
<parameter type="text" id="includedcomposer"
quotevalue="1"></parameter>
<parameter type="text" id="excludedcomposer"
quotevalue="1"></parameter>
<parameter type="text" id="includedconductor"
quotevalue="1"></parameter>
<parameter type="text" id="excludedconductor"
quotevalue="1"></parameter>
<parameter type="text" id="includedgenre"
quotevalue="1"><value>Rock</value></parameter>
<parameter type="text" id="excludedgenre"
quotevalue="1"></parameter>
<parameter type="text" id="includedmood"
quotevalue="1"><value>Energetic</value></parameter>
<parameter type="text" id="excludedmood"
quotevalue="1"></parameter>
<parameter type="text" id="includedtheme"
quotevalue="1"><value>Empowering</value></parameter>
<parameter type="text" id="excludedtheme"
quotevalue="1"></parameter>
<parameter type="text" id="includedstyle"
quotevalue="1"></parameter>
<parameter type="text" id="excludedstyle"
quotevalue="1"></parameter>
</template>
</sqlplaylist>
--------------------
Could it be that the sheer number of attributes in the listboxes are
perhaps causing memory leak or other issues? Any chance of making the
listboxes dynamic ie if one selects a genre, only the attributes
present in tracks belonging to that genre are selectable in the
subsequent listboxes. Apply same logic to STYLE/MOOD/THEME? I imagine
the many-to-many relationships between GENRE, STYLE, MOOD & THEME can be
stored at scan time?
erland;228387 Wrote:
> The problem if the query is slow is that you might get audio dropouts
> when it should retrieve new tracks. It retrieves new tracks when a few
> tracks has played, if I remember correctly the default is that it tries
> to add tracks so there is 10 tracks in the current playlist after the
> currently playing one. The number of tracks are configurable in the
> Dynamic Playlist plugin web interface. So try to play a few tracks and
> look at the current playlist to see when it adds new tracks and listen
> if you get audio dropouts at this time.
The dropouts occur whilst defining, saving or editing a playlist. If a
dynamic playlist is playing and I'm not attrempting to add/edit new SQL
playlists there is no dropout. I'm hoping some indexing of the tables
will take care of this, but in reality it is not a major issue as I
don't envisage spending a lot of time editing/defining playlists. Too
many combinations/permutations would likely become meaningless anyhow.
erland;228387 Wrote:
> Does it take a lot of time also when you select to edit a playlist ?
Yes, much the same as creating a new playlist or saving a playlist
erland;228387 Wrote:
> Yes, that should be possible. A agree that this feels more logical so
> I'll change the order in the template.
I'll look for updates on your website.
erland;228387 Wrote:
> With exclude criteria I suppose you mean the maximum rating that results
> in a <= criteria ?
Sorry, I should have been clearer. I meant that it is probably only
necessary to have a single ALBUM RATING listbox such that when a user
selects a value in the listbox they are setting the minimum ALBUM
RATING ie all tracks whose ALBUM RATING is >= ALBUM_RATING_VALUE are
elegible for inclusion in the playlist.
erland;228387 Wrote:
> I think it should be in the template, because it makes it possible to
> listen through all your low rated tracks to decide if you like to raise
> the ratings on any of them.
I hadn't thought of that. Good idea, ignore my previous suggestion :)
erland;228387 Wrote:
> I'm not sure where it should be accessed yet, but the preliminary plan
> looks like:
>
> - By holding play button on remote down on a track in one of the Browse
> menus, you get the "Dynamic Playlists" mixer and can select the seed
> based playlist.
> Unfortunately it is not currently possible to do it from the "Now
> Playing" menu because that doesn't support mixers.
> Additionally I'm think that it might be useful to also have this if you
> have Custom Browse plugin installed:
> - By holding play button on remote down on a track in one of the Browse
> menus in Custom Browse plugin, you would get a seed based browse menu to
> browse similar tracks. This will only be possible in Custom Browse based
> menus.
> - By navigating right on a track in the Browse menus or in Now Playing
> menu, you would get a "Dynamic Playlists" entry where you can select
> the seed playlist.
> - By navigating right on a track in the Browse menus or in Now Playing
> menu, you would get a seed based browse menu where you can browse
> similar tracks.
> I'm not completely sure all this is easily accomplished yet, but I
> think it should be.
Sounds great, the only limitation / difficulty I see in implementing
this type of dynamic playlist is that I'm guessing you will need to use
all the attributes of the GENRE, STYLE, MOOD & THEME tags, which may
produce a pretty limited dynamic playlist. Perhaps we need to give
some thought as to what would make sense here eg, option to limit
criteria to GENRE & STYLE, STYLE only, GENRE, STYLE & MOOD etc. I'm
guessing the more flexible the more complex it will become from a UI
perspective, particularly at the remote end of the equation.
--
egd
Thecus N5200PRO >> Transporter >> ATC SCA2 >> ATC SCM100SLAT
------------------------------------------------------------------------
egd's Profile: http://forums.slimdevices.com/member.php?userid=3425
View this thread: http://forums.slimdevices.com/showthread.php?t=38256
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
