FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › General Discussion › Playlist Debugging
- This topic has 9 replies, 2 voices, and was last updated 18 years, 9 months ago by rpedde.
-
AuthorPosts
-
10/03/2006 at 4:52 AM #198AnonymousInactive
I have about 2,500 tracks, 98% of which are either rock, pop or alternative.
I have the following playlist:genre includes “rock” OR genre includes “pop” OR genre includes “alt”
so this playlist should have 2,000+ tracks in it.
I’ve been playing this playlist on my SoundBridge using shuffle for the last few days (total of maybe 6-8 hours), however I keep hearing Queen’s Bohemian Rhapsody for some reason. Probably 5 or 6 times now. It also seems to play tracks from certain albums a lot as well.
OK, so I believe that the SoundBridge performs the shuffling, but how I can I found out how large this playlist is in terms of number of tracks? I want to work out if the playlist is not right or the SoundBridge shuffle doesn’t work properly (or how I expect)?
Thanks.
Andy
Post edited by: ajayre, at: 2006/03/09 20:53
10/03/2006 at 7:56 AM #4087rpeddeParticipantit’s in the playlists table, in the “items” column.
foo@bar:~$ sqlite3 /path/to/songs3.db
sqlite> select name, items from playlists;
Library|0
Some playlist|20
Some other playlist|50
— Ron
p.s. if you are using sqlite2, then it’s “sqlite /path/to/songs.db”
10/03/2006 at 8:22 AM #4088AnonymousInactiveI did the following:
sqlite> select title, items from playlists;
and got:
80's Music|0
90's Music|0
Music from Today|0
Rock, Pop and Alternative|0
80's Rock|0
80's Pop|0
80's Alternative|0
90's and Later Rock|0
90's and Later Pop|0
90's and Later Alternative|0
Recently Played|0
Recently Added|0
which doesn’t appear to be right.
Andy
10/03/2006 at 11:48 AM #4089rpeddeParticipantIt should update playlist counts when you connect. That’s really strange.
Try connecting with iTunes, then disconnecting. Then see if the total are updated.
10/03/2006 at 12:19 PM #4090AnonymousInactiveEven with the SoundBridge connected and playing, and after turning off the SB, it shows the same result. Only two playlists have values and those are the iTunes xml playlists.
Andy
10/03/2006 at 12:28 PM #4091rpeddeParticipantDunno. Should be updating playlist item counts after every scan.
You can always enter that query manually:
select count(*) from songs where genre like ‘%rock%’ or genre like ‘%pop%’ or genre like ‘%alt%’
10/03/2006 at 12:35 PM #4092AnonymousInactiveThat worked, thanks. 🙂
Andy
10/03/2006 at 12:47 PM #4093rpeddeParticipantIf you have firefox or explorer, or a browser capable of displaying xml without a dtd (NOT safari), then you could also do something like:
http://server:port/databases/1/containers?output=xml
then you’d see all your playlists, including the dmap.itemid of a playlist you wanted to inspect. Say the dmap.itemid was 307. To see what files are on that playlist, do:
http://server:port/databases/1/containers/307/items?output=xml
and you’ll have a list of all your items, probably just with itemkind, itemid, and itemname. To see more interesting stuff, try something like this:
http://server:port/databases/1/containers/307/items?output=xml&meta=daap.songartist,daap.songalbum,dmap.itemid,dmap.itemname
See, wouldn’t a nice ajaxian front-end on the web server be cool?
sigh.
— Ron
10/03/2006 at 12:55 PM #4094AnonymousInactivePretty nice. Can you use this interface to get things like play_count, bpm, etc?
Andy
11/03/2006 at 1:10 PM #4095rpeddeParticipantYup. Everything.
-
AuthorPosts
- The forum ‘General Discussion’ is closed to new topics and replies.