barcar Wrote: > I've got this SQLPayList working against SlimServer 6.2.1 on Windows XP > running against a MySQL 4.1 back end. My database is linked to iTunes 5 > and rescans nightly. > > It seems to work fine except that all playcount values in the tracks > table are null. > > Should the playcount values be coming from iTunes? Or am I missing > something else?
The tracks table will be cleared each time you perform a full rescan in slimserver, so if you perform a full rescan every night the playcount column in the tracks table will be set to null every night. So if you want to use the playcount in the tracks table you will somehow need to transfer the play counts from iTunes to slimserver after the full rescan every night. I'm not sure if the iTunes plugin or the iTunesUpdate plugin is able to do this. Another way is to use the TrackStat plugin, it will store the playcounts in a separate table (track_statistics) which is not cleared during rescan. TrackStat can import playcounts from iTunes in the TrackStat web interface, there is however no built-in functionallity in TrackStat to do this automatically every night. Also it will simply overwrite the playcounts existing in slimserver with the iTunes playcounts, so if you need it to calculate a new playcount based on both the iTunes and slimserver playcount in some way this is not possible with TrackStat today. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
