Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
esa;581851 Wrote:
My Question : I often use SQPlaylist.
I configure it in the WEB interface.
But for playing, is it compatible with SqueezeCommander or Ipeng ?
Playing should work on all clients that implements the SqueezePlay
protocol, I know this work on iPeng and SqueezePad as I'm using those
myself, I'm not sure about the others.
esa;581851 Wrote:
- view Statistics for song played : number of time song played,
rating,genre.
Statistics is related to the TrackStat plugin and that should also work
on the above mentioned clients.
esa;581851 Wrote:
- select a SQLPlaylist in the Alarm clock
Yes that works as long as you have set it up as a favorite in the
Dynamic Playlists menu.
esa;581851 Wrote:
- create a static playlist using a directory
It's only possible with only SQL Playlist if you write the SQL
yourself. However, I think you should be able to do it by using the
Multi Library plugin and create a library for the directory and then
create a SQL Playlist for the library.
esa;581851 Wrote:
- create a sqlplaylist based ona static playlist.
Yes, that works. You will ahve to configure it via the web interface as
configuration isn't supported on any other interface at the moment.
esa;581851 Wrote:
What is the best remote software to use with your application ?
This is of course a subjective matter but in my opinion SqueezePad (on
iPad) or iPeng (on iPhone) is the best remotes both for my plugins and
for everything else related to the Squeezebox. There is an iPeng
version for iPad coming which is rumored to be really good too.
esa;581851 Wrote:
Other question : do you plan to create a SQLplaylist directly from a
directory ?
Not besides the solution mentioned above through Multi Library plugin.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
Thanks Erland, I buy a SqueezeTouch ( I will receive soon ). Now, I plan to buy a remote control. At the beginning, my choice was for a IpodTouch+Ipeng. But,I realize that Ipod isn't a open product. Archos can be a better choice, if I want to stay in the open world. My Question : I often use SQPlaylist. I configure it in the WEB interface. But for playing, is it compatible with SqueezeCommander or Ipeng ? What is it possible to do. I think about : - select a SQLplaylist - view Statistics for song played : number of time song played, rating,genre. - select a SQLPlaylist in the Alarm clock - create a static playlist using a directory - create a sqlplaylist based ona static playlist. What is the best remote software to use with your application ? Other question : do you plan to create a SQLplaylist directly from a directory ? Regards Eric -- esa Synology DS107+ MARVELL_88F5281 Squeeze center Version : 7.5.0 - r30464 Version Perl : 5.8.6 Version MySQL : 5.1.34 Squeezeplay... esa's Profile: http://forums.slimdevices.com/member.php?userid=9362 View this thread: http://forums.slimdevices.com/showthread.php?t=82259 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
Dear Erland,
To check if there is a issue with the special character '!', I copy all
the directory to a other place in the NAS ( I suppress the !).
I realize the same test and same issue.
So, I go in the Customize SQL for the two Playlist :
The Dynamic is as follow :
-- PlaylistName:Random songs from playlist
-- PlaylistGroups:esa
-- PlaylistParameter1:playlist:Select playlist:
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
join playlist_track on
tracks.url=playlist_track.track and
playlist_track.playlist='PlaylistParameter1'
left join track_statistics on
tracks.url=track_statistics.url
where
audio=1
and dynamicplaylist_history.id is null
and
ifnull(track_statistics.lastplayed,0)(unix_timestamp()-604800)
group by tracks.id
order by rand()
limit 10;
The SQL is as follow :
-- PlaylistName:Random for new7b
-- PlaylistGroups:esa
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
join playlist_track on
tracks.id=playlist_track.track
join tracks playlists on
playlists.id=playlist_track.playlist and
playlists.title='new7b'
where
tracks.audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by rand()
limit 10;
This morning, I modify the SQL Playlist like this :
-- PlaylistName:Random for new7b
-- PlaylistGroups:esa
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
join playlist_track on
tracks.url=playlist_track.track
join tracks playlists on
playlist_track.playlist=playlists.id and
playlists.title in ('new7b')
where
tracks.audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by rand()
limit 10;
And, now It's working.
I can select the SQL playlist in the Clock Alarm.
All seems working, but I must check more time.
I don't know the Database structure, so, it is very difficult for me to
understand the link between tables. Is it a document for this ?
Can you analyze this modification and validate it ?
Thanks for your help
Eric
--
esa
Synology DS107+ MARVELL_88F5281
Squeeze center Version : 7.5.0 - r30464
Version Perl : 5.8.6
Version MySQL : 5.1.34
Squeezeplay...
esa's Profile: http://forums.slimdevices.com/member.php?userid=9362
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
esa;580474 Wrote:
I don't know the Database structure, so, it is very difficult for me to
understand the link between tables. Is it a document for this ?
There is a wiki page that's fairly updated:
http://wiki.slimdevices.com/index.php/SlimServerDatabaseStructure
esa;580474 Wrote:
Can you analyze this modification and validate it ?
It looks correct, the issue is that earlier you were supposed to join
with:
tracks.id=playlist_track.track
But this has changed in 7.4 or 7.5 so now you need to use:
tracks.url=playlist_track.track
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
esa;580312 Wrote:
2) a SQL playlist . In this case, there is no parameter, so it can be
used in clock alarm.
But, when I want to play it, I have a message : NO songs. Why ?
I chose the same playlist.
Do you get any errors in the server.log file when you hit play ?
You will find it in SBS Settings/Advanced/Logging
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
No error in the log file , only a message No Song for Random New07. When a create a Dynamique PL from the same playlist +New 07, it start playing. My playlist : New07.m3u There is 101 songs in this playlist #CURTRACK 3 #EXTM3U #EXTINF:251,At The River /volume1/music/!!New/!new7-carok/Cool-Chillout cd1/01-At The River - Groove Armada.mp3 #EXTINF:447,Run /volume1/music/!!New/!new7-carok/Cool-Chillout cd1/02-Run - Jackknife Lee Remix - Snow Patrol.mp3 #EXTINF:314,Mumbai Theme Tune /volume1/music/!!New/!new7-carok/Cool-Chillout cd1/03-Mumbai Theme Tune - A.R. Rahman.mp3 #EXTINF:347,The Sea This is the SQL Playlist :randomfrommixer.sql.values.xml ?xml version=1.0 encoding=utf-8? sqlplaylist template idrandomfrommixer.sql.xml/id parameter type=text id=playlistnamevalueRandom for New07/value/parameter parameter type=text id=playlistgroups/parameter parameter type=text id=notrepeatvalue1/value/parameter parameter type=text id=recentlyplayedvalue/value/parameter parameter type=text id=artist/parameter parameter type=text id=album/parameter parameter type=text id=genre/parameter parameter type=text id=yearmin/parameter parameter type=text id=yearmax/parameter parameter type=text id=playlistvalueNew07/value/parameter parameter type=text id=nooftracksvalue10/value/parameter parameter type=text id=customskipfiltervalue/value/parameter /template /sqlplaylist This is the Dyn Playlist : randomforplaylist.sql.values.xml ?xml version=1.0 encoding=utf-8? sqlplaylist template idrandomtracks.sql.xml/id parameter type=text id=playlistnamevalueRandom songs from playlist/value/parameter parameter type=text id=playlistgroupsvalueRandom/For selected/value/parameter parameter type=text id=requestfromuservalueplaylist/value/parameter parameter type=text id=notrepeatvalue1/value/parameter parameter type=text id=recentlyplayedvalue604800/value/parameter parameter type=text id=includedgenres quotevalue=1/parameter parameter type=text id=excludedgenres quotevalue=1/parameter parameter type=text id=customskipfiltervalue/value/parameter /template /sqlplaylist -- esa Synology DS107+ MARVELL_88F5281 Squeeze center Version : 7.5.0 - r30464 Version Perl : 5.8.6 Version MySQL : 5.1.34 Squeezeplay... esa's Profile: http://forums.slimdevices.com/member.php?userid=9362 View this thread: http://forums.slimdevices.com/showthread.php?t=82259 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
Do you know if it's only files with a ! character in the path that
have the problem ?
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
Dear Erland, To play a directory in Dynamicplaylist, I try the following work arround. - Making a static playlist from a directory and sub dir = very easy to do - Then Going on this playlist and there ares little icon's to build a : 1) a dynamic playlist - Random songs from playlist - working fine, but, I can not use it for wake up, because this Dynamic playlist can not be choose ( maybe, because a parameter is needed ). So, not possible to use with clock alarm. 2) a SQL playlist . In this case, there is no parameter, so it can be used in clock alarm. But, when I want to play it, I have a message : NO songs. Why ? Do you think it can be working in clock alarm ? Best Regards -- esa Synology DS107+ MARVELL_88F5281 Squeeze center Version : 7.5.0 - r30464 Version Perl : 5.8.6 Version MySQL : 5.1.34 Squeezeplay... esa's Profile: http://forums.slimdevices.com/member.php?userid=9362 View this thread: http://forums.slimdevices.com/showthread.php?t=82259 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
Dear Erland, Thanks a lot...that's working now ! What I do : 1) - I clear all SQL playlist in the web interface - I erase all sql.values.xml files. - I make only one SQL Plalist with desired genre Now, the song genre are well conform to the playlist. 2)Reset until you clear the current playlist : I create a second playlist with unique genre House. play it = yes, only House music. So, it seems is not necessary to clear the playlist. 3) Clearing the current playlist should clear any cached configuration OK 4)you can also hit the Refresh playlists link in the SQL Playlist menu I understand : - Refresh playlist will recreate all files sql.values.xml. - Erasing a playlist can be done using the little cross button. 5) is it possible to create a Dynamic playlist from one directory ( and maybe subdirectory). The solution using Multilibrary is not recomended to work with a NAS ( resource issue ). I now a little SQL Query in MS world. But how can I connect to the SQL admin ? In my synology NAS, there is two instances of MySQL installed ( one from official pkg and one from the Squeeze center ) I can connect to the First, but how to connect to the Squeeze SQL DB ? One more little question : - is it possible to display the genre, rating and number of play in the Squeezeplay or SqueezeTouch display ? Just near the tittle and not with the popup. I think, it is interesting to have such information directly on the main display, because I want to change the rating, if this is not correct. But, if I want to know the rating, I need to push and wait some time to have the informations and maybe correct it. Do you think, it is possible to do that ? Best regards Eric -- esa Synology DS107+ MARVELL_88F5281 Squeeze center Version : 7.5.0 - r30464 Version Perl : 5.8.6 Version MySQL : 5.1.34 Squeezeplay... esa's Profile: http://forums.slimdevices.com/member.php?userid=9362 View this thread: http://forums.slimdevices.com/showthread.php?t=82259 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
esa;579942 Wrote:
5) is it possible to create a Dynamic playlist from one directory ( and
maybe subdirectory).
The solution using Multilibrary is not recomended to work with a NAS (
resource issue ).
I now a little SQL Query in MS world.
But how can I connect to the SQL admin ?
In my synology NAS, there is two instances of MySQL installed ( one
from official pkg and one from the Squeeze center )
I can connect to the First, but how to connect to the Squeeze SQL DB ?
I'm not sure how MySQL is installed on the Synology but if it works the
same as a standard installation you need to connect using port 9092. I
suspect remote connections might have been disabled to avoid security
holes, so you might need to edit the my.tt file manually.
You could also install the Database Query plugin and create a new
free form query and it enter the statement you like to try. This might
be easier instead of editing the my.tt file.
By the way, I suspect Multi Library plugin might work as long as you
don't install Custom Browse. I suspect Multi Library together with SQL
Playlist might not be that resource intensive, it should be Custom
Browse that uses most memory.
esa;579942 Wrote:
- is it possible to display the genre, rating and number of play in the
Squeezeplay or SqueezeTouch display ?
Just near the tittle and not with the popup.
I think, it is interesting to have such information directly on the
main display, because I want to change the rating, if this is not
correct. But, if I want to know the rating, I need to push and wait
some time to have the informations and maybe correct it.
Do you think, it is possible to do that ?
It's possible with Custom Clock applet but you have to design your own
now playing screen and it doesn't support touch screen. It only
displays stuff, there isn't any action buttons on it.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
Dear Erland, I check if this is really the good playlist running. But, to be sure, I select it and a new list appear. The first song played is : Album : Two Against Nature Artiste : Steely Dan Genre : Jazz Funk Année : 2000 Enregistrer dans les favoris Numéro de piste : 6 Format de fichier : MP3 Durée : 6:17 Débit binaire: 147Kbps VBR Taux d'échantillonnage : 44.1 kHz Taille du fichier : 6 995 968 Emplacement : /volume1/music/!!New/___Archos/Steely Dan/Two Against Nature/06-Jack Of Speed.mp3 Dernière modification : Thursday 19 July 2007, 11:49 Version avec repère : ID3v2.3.0 Afficher les repères Enregistrer LastFM Track Description LastFM Track Image LastFM Song Tags Song Lyrics This Genre Jazz Funk isn't selected in my playlist. Ignore songs played recently = 1 week. I don't select any other parameters. I'll check the log...how is it possible to : - erase all the SQL Playlist ? Is it possible to delete the file directly ? - erase all the log file in the server. So, I will have only last error if there is one. - is it possible to create a Dynamic playlist from one directory ( and maybe subdirectory). If I got new songs, I place it on a new subdiretory and I want play it until all has been listening. Thanks Eric -- esa Synology DS107+ MARVELL_88F5281 Squeeze center Version : 7.5.0 - r30464 Version Perl : 5.8.6 Version MySQL : 5.1.34 Squeezeplay... esa's Profile: http://forums.slimdevices.com/member.php?userid=9362 View this thread: http://forums.slimdevices.com/showthread.php?t=82259 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
esa;579647 Wrote:
This Genre Jazz Funk isn't selected in my playlist.
Ignore songs played recently = 1 week.
I don't select any other parameters.
Just to make sure, you did play some other playlist or cleared the
current playlist before you played this one ?
I'm asking because if it's already playing I'm not sure any new
parameters will take effect until you clear the current playlist.
I assume this is one genre and not multiple genres Jazz and Funk
and you had selected one of them in the playlist ?
esa;579647 Wrote:
- erase all the SQL Playlist ? Is it possible to delete the file
directly ?
In the SQL Playlist settings page in SBS web interface, you will find a
Playlist directory parameter. All SQL Playlist files are stored in
this directory and have the extensions *.sql.values.xml or *.sql
Clearing the current playlist should clear any cached configuration,
you can also hit the Refresh playlists link in the SQL Playlist menu
in the web interface after you have cleared the current playlist to
make sure no cached data is left.
esa;579647 Wrote:
- erase all the log file in the server. So, I will have only last error
if there is one.
You will find the server.log through SBS Settings/Advanced/Logging in
the web interface. You can shutdown Squeezebox Server, delete the
server.log file and then startup Squeezebox Server again.
esa;579647 Wrote:
- is it possible to create a Dynamic playlist from one directory ( and
maybe subdirectory).
If I got new songs, I place it on a new subdiretory and I want play it
until all has been listening.
Yes, there are two ways to do this:
1. Manually edit the SQL statement to do what you like, I suspect you
need to use a LIKE statement towards the tracks.url column.
2. Install Multi Library plugin and setup a library by specifying the
directory. After this you can create a SQL Playlist and select to limit
it to the selected library without marking any other filtering options.
The second option is probably easiest if you don't know how to write
SQL statements.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
Dear Erland, First, thanks a lot for your work! That's a great job and I like your plugins! I search for a long time for such functionalities. I never find the possibility to wake up with a playlist that will exclude already played songs. For the issue, maybe I make something wrong. I analyze the tag for some MP3 in the playlist ( I saved it ). Song 1 : /volume1/music/!!New/___Archos/Andreas Vollenweider/White Winds (Seeker's Journey)/09-Sisterseed.mp3 --- no ID3V1 tag, ID3V2 tag only has genre New age. Song 2 : /!!New/!new-House/Music_paradise_from_Sander__20.12.09/Music_paradise - DJ Smash feat. Jetaime Arturich - Gde Zhe Ty (New Remix 2010).mp3 --- Tag V1 : House Tag v2 = House. To be sure, I check that my playlist is well Advanced-esa-06 ( in the web interface ). Is it possible to see which playlist is running in the Squeezeplay ? 1) I don't select Genre House, why is it played ? 2) I make another playlist, with excluding some genres and artists, but I remark, that excluding does'nt work. So I prefer to select artist and ommit some name ( that's working ) I will try by excluding Genre, but this is more difficult to make. For example, if I add some music House , I don't want to wake up wit it :-). And I can not exclude it until I don't have a song with such Genre. Can you help me to understand ? Best regards Eric -- esa esa's Profile: http://forums.slimdevices.com/member.php?userid=9362 View this thread: http://forums.slimdevices.com/showthread.php?t=82259 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
esa;579439 Wrote:
1) I don't select Genre House, why is it played ?
It shouldn't be played, something is wrong.
It you open up a song that is included but shouldn't be in the web
interface in the Song Info page:
- Doesn't it show one of the genres you have selected in the Genre
field ?
- Doesn't it show one of the genres you have selected in the View
Tags field ?
If it doesn't, have you checked if there is some error in the
server.log file after you have played a playlist ? (It's found in SBS
Settings/Advanced/Logging through the web interface)
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
[SlimDevices: Plugins] SQL Playlist play unwanted genre
Dear users, I create a advanced playlist : advanced-esa-06.sql.values.xml I ask to play some genre. But, When the Alarm and selected playlist wake up me, I ear songs with unwanted genre. The playlit : ?xml version=1.0 encoding=utf-8? sqlplaylist template idadvanced.sql.xml/id parameter type=text id=playlistnamevalueAdvanced-esa-06/value/parameter parameter type=text id=playlistgroupsvalueesa/value/parameter parameter type=text id=requestfromuservalue/value/parameter parameter type=text id=minlength/parameter parameter type=text id=maxlength/parameter parameter type=text id=minyear/parameter parameter type=text id=maxyear/parameter parameter type=text id=notrepeatvalue1/value/parameter parameter type=text id=neverplayedvalue0/value/parameter parameter type=text id=recentlyplayedvalue604800/value/parameter parameter type=text id=includedcomment quotevalue=1/parameter parameter type=text id=excludedcomment quotevalue=1/parameter parameter type=text id=includedgenres quotevalue=1valueAlternative/valuevalueAmbient/valuevalueBest1/valuevalueBest2/valuevalueChanson/valuevalueDisco/valuevalueFrancais/valuevalueFunk/valuevaluePop/valuevalueTop 40/valuevalueVari#36201; fran#26665;se/valuevalueVocal/value/parameter parameter type=text id=excludedgenres quotevalue=1/parameter parameter type=text id=includedartists quotevalue=1/parameter parameter type=text id=excludedartists quotevalue=1/parameter parameter type=text id=losslessvalue0/value/parameter parameter type=text id=nooftracksvalue20/value/parameter parameter type=text id=customskipfiltervalue/value/parameter /template /sqlplaylist Played sond example : Album : Music paradise from Sander (20.12.09) Artiste : Pas d'artiste Genre : House Année : 2009 Can you help me to understand ? My squeeze server ply on a NAS Synology. Version : 7.5.0 - r30464 Thanks -- esa esa's Profile: http://forums.slimdevices.com/member.php?userid=9362 View this thread: http://forums.slimdevices.com/showthread.php?t=82259 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist play unwanted genre
Do you use multiple genre tags on your music files ?
If you do, that could explain what you are seeing if the music file
contains both one of the selected genres and also one of the unwanted
genres. If you really want to exclude stuff, you should use the
Exclude genres option and select the genres you want to exclude.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=82259
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
