Over the past few years, I have made numerous changes to my music library, mostly by re-ripping CDs and encoding to flac rather than mp3. Because I did not tag files with Musicbrainz Ids until recently, the TrackStat tables have a lot of records which relate to non-existent mp3 files. I'd really like to sort this out and by doing so, make my listening statistics accurate. Damn this obsessiveness!
So, can anyone comment on my plan? I reckon I can automate most of the following using Visual Basic and manipulating the Squeezebox Server database through an ODBC connection. Go for it? Not recommended? Don't do it under any circumstances? 1. Update track_history table: identify urls which no longer exist and change url field to reflect new location/file name. 2. Update track_statistics table: identify urls which no longer exist. If playcount field is null, delete record; otherwise identify record with new location/file name, update playcount field and then delete the original (incorrect url) record. 3. Backup TrackStat data via web interface 4. Delete MySQL database so Squeezebox Server creates brand new one 5. Restore TrackStat data - I assume this would populate tracks_persistent table? Or is that not necessary? Maybe I am making this too complicated and there is a far easier method. Have I missed a "tidy-up" button? Thanks for any help/advice. -- chris67 It's like, how much more black could this be? And the answer is none. None more black. ------------------------------------------------------------------------ chris67's Profile: http://forums.slimdevices.com/member.php?userid=19448 View this thread: http://forums.slimdevices.com/showthread.php?t=83051 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
