Re: [SlimDevices: Plugins] Trackstat restore only partially restores ratings
I did all that last month. Did you get a chance to take a look? yocky's Profile: http://forums.slimdevices.com/member.php?userid=16305 View this thread: http://forums.slimdevices.com/showthread.php?t=104919 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore only partially restores ratings
yocky wrote:
> I re-ran the restore operation with exactly the same result. The same
> ratings are missing as before.
>
> I can see the same musicbrainz tag referred to in the backup file as in
> one of the tracks still missing its rating.
>
Would it be possible for you to do the following ?
1. Shutdown LMS and take a copy of library.db file in LMS Cache
directory and zip it and mail it to me
2. Mail me the server.log file or the section of the server.log file
which contains the errors regarding the files that aren't properly
restored
3. Zip and mail me the TrackStat backup file which you are trying to
restore
This will make it a bit easier for me to understand what's going on.
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
LEAD PLATFORM DEVELOPER OF 'ICKSTREAM MUSIC PLATFORM'
(HTTP://WWW.ICKSTREAM.COM) - A WORLD OF MUSIC AT YOUR FINGERTIPS
(Also developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland). If you like to
encourage future presence on this forum and/or third party plugin/applet
development, 'consider purchasing some plugins'
(http://license.isaksson.info))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=104919
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore only partially restores ratings
I re-ran the restore operation with exactly the same result. The same ratings are missing as before. yocky's Profile: http://forums.slimdevices.com/member.php?userid=16305 View this thread: http://forums.slimdevices.com/showthread.php?t=104919 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore only partially restores ratings
erland wrote: > Have you waited for the restore operation to finish ? > It runs in the background and it can take a few hours if you have a > large library or a large backup file. > There is a message in the LMS server.log file when the restore has > completed. > > If you have the "Find alternative files" option enabled in TrackStat > backup settings page it should find the files as long as it's only the > beginning of the path that has changed. However, it can take a long time > to run the restore operation with this option enabled. Yes, I left the operation running and went out for the day (I remember it taking a long time previously). I think I checked the server log and saw that the restore has finished, can't be sure though. I did have the "find alternative files option enabled" as well as using musicbrainz tags...but like I said the strange thing is that some rating have been restored and some haven't. I'll re-run the restore and see what happens. yocky's Profile: http://forums.slimdevices.com/member.php?userid=16305 View this thread: http://forums.slimdevices.com/showthread.php?t=104919 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore only partially restores ratings
yocky wrote:
> I just installed LMS 7.9 on a second PC and copied my music library
> over.
>
> The file names are identical but the path is slightly different
> (e:\music\ instead of i:\all\music), however the files I'm really
> interested in are musicbrainz tagged so I didn't think this was
> important.
>
> I did a fresh scan and then a trackstat restore from my latest backup
> file.
>
> This has partially worked. Some ratings have been restored and some
> haven't. Even stranger is that the playcount seems to have been restored
> for even the tracks that haven't had the ratings restored.
>
> Any ideas?
Have you waited for the restore operation to finish ?
It runs in the background and it can take a few hours if you have a
large library or a large backup file.
There is a message in the LMS server.log file when the restore has
completed.
If you have the "Find alternative files" option enabled in TrackStat
backup settings page it should find the files as long as it's only the
beginning of the path that has changed. However, it can take a long time
to run the restore operation with this option enabled.
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
LEAD PLATFORM DEVELOPER OF 'ICKSTREAM MUSIC PLATFORM'
(HTTP://WWW.ICKSTREAM.COM) - A WORLD OF MUSIC AT YOUR FINGERTIPS
(Also developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland). If you like to
encourage future presence on this forum and/or third party plugin/applet
development, 'consider purchasing some plugins'
(http://license.isaksson.info))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=104919
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Restore
MeSue wrote: > I disabled the option to look for alternates, and it seems to be > throwing a lot less errors. Hopefully this speeded it up, too. > Disabling the "Find alternative files" option should speed up the restore process significantly. If it does a rescan in the middle of the restore I think you need to redo the restore to ensure everything is restored safely. MeSue wrote: > > I am still getting "no matching file" entries in the log for files I > really did remove from my library. How do I generate a Trackstat backup > that is cleaned of all these non-existant files? Some of these were > deleted years ago. > After the restore have completed, use the "Delete unused statistics" button in TrackStat settings page in the "Backup/Restore/Clear" section, this will remove any TrackStat entries that points to non existing files. This operation is likely going to completely hang LMS for a while, so don't executing it when you are about to use the system to play music. The TrackStat data consists of: - Current rating, playcounts and last played times: This is what you see in most TrackStat based menus - History of previous, ratings, play counts and last played times: This is what you see in the "... recently..." TrackStat browsed menus The current rating, playcounts and last played times are restored first and later in the restore process the history is restored, so possibly this might be what makes it look like it had restored files which were at the end of the file, it probably had restored the current statistics for that file but not the history. erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=98959 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Restore
Got it! Thanks for answering my many questions. No pain no gain. This new server has already cut my scan times in half so when the painful switching part is over, it's going to be nice. By the way, I continued having problems with MIP stalling when dynamically update was enabled in custom scan for MIP export. I now just update it during scans. MIP doesn't crash or hang, but the database just stops updating and the service has to be restarted to make it work again. (Sent from my iPad using Tapatalk. Please pardon any typos!) MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=98959 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Restore
Does Trackstat import in the same order that files are listed in the backup XML file? If so, then it appears everything is there, even though Custom Scan said it was still running. And the songs with those "no matching path entries" have their stats when I check them. I will do a TrackStat export now, and see if the filesize matches pretty closely to the one I imported. No, it is only 1/3 of the file size, so I will try restoring again. MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=98959 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Restore
For the record, Trackstat restore took 3 hours the second time with the option disabled for trying to match files. For around 25,000 tracks. I also had MIP update disabled because that seems to slow it down, also. After it finished, I did what you said to remove unused statistics. It only took a minute or two to complete, and then when I created a backup it was very close in file size to the one I just restored, so I'm not sure if that did anything. I'll check the XML when I gat back to my PC. Anyway, hopefully won't need another restore for a long long time. lrossouw wrote: > I also upgraded my server recently and it was a bit painful getting > everything as it was. I ended up dropping MusicIP. SmartMix plugin > does what MusicIP does and does it better in my mind. I kind of like having MIP as a secondary storage for my stats. I have needed it a few times when my ratings got hosed. I wasn't using Smart Mix all that much because of the volume changes between local music and Rhapsody, but I see Michael has included a setting for that and I'm going to install it today. It's exciting to have some LMS development going on again! (Sent from my iPad using Tapatalk. Please pardon any typos!) MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=98959 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Restore
MeSue wrote: > Got it! Thanks for answering my many questions. > > No pain no gain. This new server has already cut my scan times in half > so when the painful switching part is over, it's going to be nice. > > By the way, I continued having problems with MIP stalling when > dynamically update was enabled in custom scan for MIP export. I now just > update it during scans. MIP doesn't crash or hang, but the database just > stops updating and the service has to be restarted to make it work > again. > > > (Sent from my iPad using Tapatalk. Please pardon any typos!) I also upgraded my server recently and it was a bit painful getting everything as it was. I ended up dropping MusicIP. SmartMix plugin does what MusicIP does and does it better in my mind. lrossouw's Profile: http://forums.slimdevices.com/member.php?userid=3416 View this thread: http://forums.slimdevices.com/showthread.php?t=98959 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Restore
I disabled the option to look for alternates, and it seems to be throwing a lot less errors. Hopefully this speeded it up, too. I am still getting "no matching file" entries in the log for files I really did remove from my library. How do I generate a Trackstat backup that is cleaned of all these non-existant files? Some of these were deleted years ago. MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=98959 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Restore
By the way, I continued having problems with MIP stalling when dynamically update was enabled in custom scan for MIP export. I now just update it during scans. MIP doesn't crash or hang, but the database just stops updating and the service has to be restarted to make it work again. Unless this is Erland's custom MIP code in his plugins and he did a better job than we did, then the issue might be that the plugin is still using synchronous HTTP calls to MIP. This can block the server when responses take a long time. It's been a thorn in our flesh for a long time, but we never got around to fix it... -- Michael ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Restore
mherger wrote: > > By the way, I continued having problems with MIP stalling when > > dynamically update was enabled in custom scan for MIP export. I now > just > > update it during scans. MIP doesn't crash or hang, but the database > just > > stops updating and the service has to be restarted to make it work > > again. > > Unless this is Erland's custom MIP code in his plugins and he did a > better > job than we did, then the issue might be that the plugin is still using > > synchronous HTTP calls to MIP. This can block the server when responses > > take a long time. It's been a thorn in our flesh for a long time, but we > > never got around to fix it... > > -- > > Michael > I think the issue MeSue is is that MIP isn't updating its database, I don't think this is related to the synchronous HTTP calls. However, you are correct that my MIP integration is using synchronous HTTP so if MIP stops responding it can cause LMS to be slow or unresponsive. erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=98959 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] TrackStat restore on SBS 7.6
erland;643884 Wrote: > If you like to ensure TrackStat data is ok, you can install the > "Database Query" plugin and look at its "TrackStat Statistics" query. > In a setup that has been using TrackStat for a while the "Number of > history entries" entry should be considerably higher than the "Number > of songs" entry. Great thanks for the tip :) -- ltb76 ltb76's Profile: http://forums.slimdevices.com/member.php?userid=5763 View this thread: http://forums.slimdevices.com/showthread.php?t=89076 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] TrackStat restore on SBS 7.6
ltb76;643879 Wrote:
>
> Do I need to press "Delete unused statistics" to clean up my DB?
>
No I don't think that should be necessary it should be clean if you
just upgraded to 7.6 as 7.6 creates a new fresh database.
ltb76;643879 Wrote:
>
> Is there a way to get the plug-in to do this "cleaning" as a part of a
> maintenance schedule?
>
Not at the moment.
If you like to ensure TrackStat data is ok, you can install the
"Database Query" plugin and look at its "TrackStat Statistics" query.
In a setup that has been using TrackStat for a while the "Number of
history entries" entry should be considerably higher than the "Number
of songs" entry.
--
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=89076
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] TrackStat restore on SBS 7.6
I'm getting the message for a large amount of tracks. However, after a reboot my trackstats appears to be back, so I'm guessing that it must be warnings about old entries. (its been months since the mentioned folder was renamed) Do I need to press "Delete unused statistics" to clean up my DB? Is there a way to get the plug-in to do this "cleaning" as a part of a maintenance schedule? Cheers, Lasse -- ltb76 ltb76's Profile: http://forums.slimdevices.com/member.php?userid=5763 View this thread: http://forums.slimdevices.com/showthread.php?t=89076 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] TrackStat restore on SBS 7.6
The backup file url's are URL encoded, so it should in the database in
tracks table match an entry referred to as:
Code:
file:///mnt/musik/ACDC/Black%20Ice%20(Rock%20-%202008)/02%20-Skies%20On%20Fire%20.flac
Which on the file system should match:
Code:
/mnt/musik/ACDC/Black Ice (Rock - 2008)/02 -Skies On Fire .flac
Is this the correct path on the file system ?
With "Rock - 2008" in the middle and not just "Rock - " as you wrote ?
And an extra space before .flac at the end ?
Do you get these warnings on all files or just a few of them ?
If you have renamed files previously, this might just be warning about
old entries in the backup which no longer exist on the file system but
if you get them for all or most entries something is wrong.
--
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=89076
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
noguru;467548 Wrote: > > Now just need to work out why Squeezebox server is taking up to an hour > to start up. > It's probably caused by TrackStat (or possibly Custom Scan) plugin if you have that installed. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
Not even sure how it happened, but after a reinstall of 7.4 now seem to have Trakstat stats restored. Thanks to everyone who offered help. Now just need to work out why Squeezebox server is taking up to an hour to start up. Noguru -- noguru noguru's Profile: http://forums.slimdevices.com/member.php?userid=27520 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
Still banging my head against a brick wall with this. Any one any suggestions. I can't see where trakstat data is stored. Error log seems to suggest to me that the location no longer exists so restore is not possible. Noguru -- noguru noguru's Profile: http://forums.slimdevices.com/member.php?userid=27520 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
Hi Earland Thanks for responding to my post. The only thing that may unusual is that I use Google Chrome as my browser. Other possible factors are that I use windows XP and AVG for viruse protection. I was not even aware of skins so assume mine is the default. Log show a whole series of this type of thing: [09-10-01 23:17:10.1876] Plugins::TrackStat::Storage::addToHistory (791) No matching alternative path found for file:///C:/Documents%20and%20Settings/Mike/My%20Documents/My%20Music/Billboard%20Top%20100%20Of%201967/Buffalo%20Springfield/For%20What%20It%27s%20Worth.mp3. I guess this is connected to my attempts to restore lost Trakstat data. After this is [09-10-01 23:17:51.5939] Plugins::TrackStat::Backup::File::doneScanning (230) Restore completed at 2009-10-01 23:17:51 Thanks Noguru -- noguru noguru's Profile: http://forums.slimdevices.com/member.php?userid=27520 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
noguru;464590 Wrote: > Unfortunately I still have the problem. Every time I try to restore I > get web page no available. Further details gives the following message - > > Error 324 (net::ERR_EMPTY_RESPONSE): Unknown error. > Any suggestions, I really can't face having to re rate 1000's of > tracks. > > Noguru > Is there anything special with your setup ? What web browser ? What skin are you using ? Anything else ? Do you get any errors in the server.log file which you can reach from the Squeezebox Server settings page Advanced/Logging ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
Unfortunately I still have the problem. Every time I try to restore I get web page no available. Further details gives the following message - Error 324 (net::ERR_EMPTY_RESPONSE): Unknown error. Any suggestions, I really can't face having to re rate 1000's of tracks. Noguru -- noguru noguru's Profile: http://forums.slimdevices.com/member.php?userid=27520 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
Progress bar was the wrong word. Meant was the loading bar of the browser. It runs for a minute and then the typical page not found webpage appears. Btw it works now. Reinstalled the plugin, rebooted the computer and used an older backup, one of this did it. Thanks for your help. -- ae67 ae67's Profile: http://forums.slimdevices.com/member.php?userid=29964 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
I am also having problems with restore (although no progress bar). I have located daily backups of trakstat data. These look OK in text editor. When attempting to restore from backup file I get egg timer for a while, then "Oops this link appears to be broken" I am using Google Chrome as browser by the way. Have tried this several times with different backup files but always with same result. -- noguru noguru's Profile: http://forums.slimdevices.com/member.php?userid=27520 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] trackstat restore
ae67;463160 Wrote: > > Restore starts and the progress bar moves, but after around half of the > process, the restore stops and a no connection webpage is shown. And > nothing is restored. It looks like a timeout. The backup size is 5 MB. > Progress bar ? Is there a progres bara somewhere in TrackStat ? Either my memory is starting to get really bad or you are looking at something else then TrackStat. Could you describe exactly how you perform the restore, what menus do you enter and what are the attribute values and what buttons to you click ? There are two ways to perform a restore as far as I know: - From the TrackStat settings menu where you will only see the progress in the server.log file. There will be one entry in the beginning that indicates which file it tries to restore and one entry at the end when the restore is finished. - From the Custom Scan interface if you have Custom Scan installed. In this case you can see directly in the Custom Scan settings interface when the restore is finished. There aren't any progress bars involved in any of the solutions as far as I know. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=68572 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore vs. MusicIP Stats restore
erland;445315 Wrote: > > The historical information is barely used in TrackStat, I think it's > only used in some TrackStat browse menus/playlists called "... recently > played ...". I've actually been thinking about removing it as I think > that most users only really need the latest state to be able to get the > browsing/playlist functionality they want. > I haven't implemented this but would appreciate keeping this in. Removing this would preclude playlists such as: - Music I often listen to on the weekend. - Or songs I listen to at night etc. I presume that it is possible to setup such Dynamic Playlists/SQLPlaylists? Maybe ones like these could be added to the default Dynamic Playlists? My trackstat history is still a bit short for those to work on SC yet. But these kind of playlists are available in Windows Media player. I don't use them there as I don't often play music on my pc. And now when I do I do it through SC/SqueezeSlave so I can consolidate my trackstats :) -- lrossouw -* 'Recently Played on my Squeezebox 3s' (http://www.last.fm/user/lrossouw/charts/?charttype=recenttracks) *- lrossouw's Profile: http://forums.slimdevices.com/member.php?userid=3416 View this thread: http://forums.slimdevices.com/showthread.php?t=66261 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore vs. MusicIP Stats restore
Thanks so much for explaining all that. Yes, "MusicIP Statistics Import" is what I was referring to. I appreciate the iTunes info too since I am thinking of getting an iPod in the future. I needed a complete restore so I'm glad I went with the Trackstat restore option. I guess if I wanted to fill in the last played counts for the time since my last good Trackstat backup, I could have done the MusicIP Statistics import after the Trackstat restore, but I'm not going to bother. I think you're safe doing away with historical information. I only care about the date added, last played, and number of plays. -- MeSue Sue http://www.last.fm/user/MeSue MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=66261 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore vs. MusicIP Stats restore
MeSue;445258 Wrote: > Just curious... Is there any difference between one or the other? Do > they both import the same data? Is one or the other any faster? > > If you have MIP being dynamically updated with stats, but a Trackstat > restore is scheduled for once a day, then the MIP stats should be the > most up to date, and it would be preferable to restore this, wouldn't > it? I suppose you with "MusicIP Stats restore" are talking about the "MusicIP Statistics Import" module provided by TrackStat and shown in the Custom Scan user interface ? Assuming you do, the difference is as follows: TrackStat restore: - Always writes the information in the TrackStat backup file directly to the database, if there already is information for a track it will be overwritten. - Restores both latest state and historical information for each track with information about exactly when it has been rated/played not just the last time. - Information in the database for tracks that isn't in the TrackStat backup file won't be removed. To remove this data you need to do a "Remove all data" operation from the TrackStat settings page before starting the restore. MusicIP Statistics Import: - Play counts are only imported if they are higher in MusicIP - Last played times are only imported if play count is higher in MusicIP and the last played time is newer in MusicIP - Ratings are always imported - It will only restore the latest state for each track, no historical information is imported regarding exactly when you have played or rated a track before it was last rated and played. The reason MusicIP is a bit smarter is to make it possible to have a two way synchronization with the Export/Import modules. This makes more sense for the iTunes Import/Export modules where you might have played some tracks on the iPod and played other tracks on SqueezeCenter and then you don't want everything in iTunes to overwrite SqueezeCenter data. There is a risk to accidentally overwrite ratings during two way synchronization, so the order is important to avoid this. I think the correct procedure to do a two way synchronization with iTunes is: 1. Synchronize the iPod with iTunes 2. Run the TrackStatiTunesUpdate.pl script to update iTunes with the change file since last time (this only exports incremental changes, not everything in the SqueezeCenter dataabse) 3. Run the iTunes Statistics Import module to update SqueezeCenter with all new ratings and play counts produced by the iPod If you perform step 2 before step 3 it will make sure that iTunes is updated with the latest SqueezeCenter changes before you run step 3 to import it the other way. This way there isn't any risk that old iTunes ratings overwrite newer ratings in SqueezeCenter. Step 2 would in the MusicIP case be the same as having the "Dynamically update statistics" option enabled in the MusicIP Statistics Export module. So to sum it up: - If you don't care about historical information, you should be fine doing a "MusicIP Statistics Import" - If you want a complete restore you should use the TrackStat restore option The historical information is barely used in TrackStat, I think it's only used in some TrackStat browse menus/playlists called "... recently played ...". I've actually been thinking about removing it as I think that most users only really need the latest state to be able to get the browsing/playlist functionality they want. Another reason to remove the historical information is that there isn't anything similar in the standard SqueezeCenter database. Currenlty TrackStat stores its information in separate tables to be able to have the above mentioned merge logic during two way synchronization but eventually I think I will switch so it uses the standard SqueezeCenter tables and then there isn't a place for the historical information. Today SqueezeCenter is able to persistently store statistics so it survives a rescan without TrackStat. TrackStat is only needed to make it possible to browse the statistics, do two way synchronzation and to change ratings directly in SqueezeCenter. As an example, if you use iTunes and only change ratings directly in iTunes or iPod, the latest ratings will be imported from iTunes to SqueezeCenter during a SqueezeCenter rescan without TrackStat. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=66261 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/
Re: [SlimDevices: Plugins] Trackstat restore vs. MusicIP Stats restore
>If you have MIP being dynamically updated with stats, but a Trackstat >restore is scheduled for once a day, then the MIP stats should be the >most up to date, and it would be preferable to restore this, wouldn't >it? I'm not sure I'd trust MIP for all stats. eg. MIP doesn't scan as well as SC scanner, eg. if you have a song not on an album, it gives the album name as "Miscellaneous", so I'm not sure album stats would be right in all cases. Also, MIP doesn't handle as many file formats as SC. eg. MIP doesn't interpret .cue files. ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore problem
Restarting slimserver seems to have fixed the problem. As best as I can tell, for some reason slimserver was caching the corrupted file and changing the name or even deleting the file didn't seem to make any difference. I restarted slimserver and resubmitted the name of the fixed file and it ran like a charm. Thanks for the help and a great plugin. I couldn't live without it. I wrote a script that uses my ratings to create a sync batch file so that I can synch my MP3 player based on the trackstat ratings. This saves me from having to rate the music twice - once for my squeezebox and once for my MP3 play synch routine. -- ZeddZull ZeddZull's Profile: http://forums.slimdevices.com/member.php?userid=7678 View this thread: http://forums.slimdevices.com/showthread.php?t=39748 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore problem
ZeddZull;238708 Wrote: > How do I turn on the TrackStat debugging parameter? I don't see it on > the web page. > That part of the file looks fine, so I suspect maybe the wrong file is read for some reason. The debug parameter is called "DEBUG LOGGING" and is found in "Server Settings/Plugins" at the bottom of the "TrackStat" section. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.homeip.net/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=39748 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore problem
How do I turn on the TrackStat debugging parameter? I don't see it on the web page. The following is an extract of the file: Code: file%3A%2F%2F%2Fmnt%2Fshare%2Fshare%2FDocuments%2520and%2520Settings%2FShared%2520Documents%2FShared%2520Music%2FThe%2520Canadian%2520Brass%2FThe%2520Essential%2520Canadian%2520Brass%2F08%2520Beale%2520Street%2520Blues.wma 1 1166125892 1135263720 << file%3A%2F%2F%2Fmnt%2Fshare%2Fshare%2FDocuments%2520and%2520Settings%2FShared%2520Documents%2FShared%2520Music%2FLiz%2520Story%2FSolid%2520Colors%2F07%2520Bradley%2527s%2520Dream.mp3 3 1176500226 1158193628 I have noted line 3672 with "<<=" -- ZeddZull ZeddZull's Profile: http://forums.slimdevices.com/member.php?userid=7678 View this thread: http://forums.slimdevices.com/showthread.php?t=39748 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore problem
Could you turn on the TrackStat debugging parameter and run it. It should log something like this in the beginning: === TrackStat: Restore from: C:\My Documents\mybackup.xml === Seems like the backup file can't be read or it reads the wrong file, could you post the first part of the backup file. Open it in a text editor, for example notepad and post the first 20 rows. Could you also post some rows around line 3672 in the backup file, since the error seems to indicate that there is something wrong there. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.homeip.net/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=39748 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat restore problem
I looked at the debug log and it has some weird stuff in it:
Code:
2007-10-29 08:47:56.7670 Scheduled task failed:
not well-formed (invalid token) at line 1, column 0, byte 0:
?xml version="1.0" encoding="UTF-8"?>
^
not well-formed (invalid token) at line 3672, column 15, byte 209576:
break
case "SEC @ø
==^
not well-formed (invalid token) at line 6663, column 14, byte 209576:
case "SECÁ
=^
not well-formed (invalid token) at line 6663, column 14, byte -2706168:
var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/hreftemplateTemplate::Provider)àq=
P ²K
Ð[1 àZ1 )`Y1 °qK«KxËT `¸0 !Z1 @ þJ!05R 05R `[ úJ°Y1 !Z1 `
^üJ)°Y1 °Y1 L¦ýJF ÐY1 ðY1 XY1 Template::Provider A M H= `* ®
=^
K8Z1 ÆG ¥C2X)¸Z1 Y1 XÿJZ1 °Y1 ®ÉÚ)`Y1 `7 KZ1 xËT erve!`Y1 `
¸Z1 AÐY1 àZ1 `* ®ùJ[1 @[1
¢C,::PrQ/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/hreftemplate
Template::ProviderÛ)àq= À8 íJÐ È\1
æJQ/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/hreftemplate
)¸|K â9 ¦¬*F `²M ²M 0^1 !ø²M ø²M À °*2)|K |K àL [EMAIL
PROTECTED] ø²M (AË( NT [EMAIL PROTECTED] he/s!pcT pcT `[ ¦cT )cT `
ä^¦r.ht(E Û*
=^
ä&ä&P }Ê3>/usr/share/slimserver/Plugins/Health/HTML/Default/hreftemplateP)hÜ8
hÜ8 $y¦EèÆJ pE @ href=" ØR ØY ä&ä& Ê
`q®
not well-formed (invalid token) at line 6663, column 14, byte -2706168:
(+ p§< `* ®9-p# 8Y1
wTQ/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/hreftemplate)[1
[1 $C-EZ1 °(+ `* $error·)@ñ* @ñ* àL !B©.EªH ñ* eH !ñ* ñ* À
¬." !°(+ °(+ @ A-AZ1 Y1 `* [EMAIL PROTECTED] hZ1 xT
Ȫ;
Q/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/hreftemplate )
äN V-6âN ØâN !H³I H³I À E-!he/sAàZ1 àZ1 `* ®D-§<
@[1
yTPQ/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/hreftemplate!âN
äN À L-"`[ !h( ¨( À [-2!ÈäN ÈäN @ 0-pageinfo!Monday,
October 29, 2007!ÒH ÒH À ô 2pageñò·` !p\1 ` 2^P')- -
¦Q'g¤`õ& P\1 (!¸\1 ¸\1 @ +ê !P]1 P]1 @ ,ë !\1 \1 `[
é re/splayerURI/EIPT X °æ> @
-ì &player=²M ACookie: SlimServer-player=00%3A04%3A20%3A06%3A65%3A34N
@Y/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/setup_input_sel.htmliNÀ¦P/var/cache/slimserver/templates//usr/share/slimserver/HTML/Default/playlist.html"browshAXAH
0AH `* ®>_1 È^1 ÌUØY
Q/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/cmdwrappersTemplate::Provider)X`1
`
7`1 `1 mpla!°[* °a1 `
?H !à`1 À O?²X< !Ø_1 ø_1 À I?"! `1 `1 `[
Y?!`1 J?^!`1 X`1 `
&Ø_1 !X`1 À K?3erve!_1 _1 `[ H?erve!À`1 À`1 Ü
L?&0_1 )x_1 x_1 _¦N?F 8`1 À`1 !Øa1 À Z?¸_1 !x`1 `
¾^M?)[* [* $P?Ex`1 x_1 èA8`1 à`1 `* ®G?a1 Ha1 ÌUX
õçQ/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/cmdwrappers/sTemplate::Providerp)]*
P ²\?
pc1 Pc1 he/s)°a1 °q`«[?¸_1 `1 erve!`b1 `b1 À S?"!c1 @
ÀV?!b1 b1 `[ R? b1 !b1 ` ¿^T?) b1 b1 a¦U?F @b1 `b1 erve
=^
O ator!¸ÕT ¸ÖT À C"tup_)øÖT ÿ¦CF ÖT ØÖT ()(c1 Øa1 XW?b1
b1 )°a1 `7 X?c1 ¸_1 !°a1 `
(c1 !a1 a1 ±F? Øi_requestùÈ2I ÈGÃ
È+Ô%Z ä&ôJÃ
not well-formed (invalid token) at line 6663, column 14, byte -2706168:
var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/setup_input_txt.htmleTemplate::ProvidersorderType!hËM
@ °
=^
Ï)Ð[1 ¨[1 W¦ÏF pZ1 Z1 ![1 [1 À Ï2Template::ProviderAÀY1 ([1
`
®àY1 P[1 ``* PrefsInTable!Z1 Z1 @ ±Ï"!ÌM ÌM `[
ÏÀY1 !Y1 ` ²^Ï
1 >!X5J X5J `[ ¨Ïx5J )x5J ` 6^ªÏor(!([1 @ ³Ï)]1 àL
XBÏEÀY1 [1
he/sY/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/setup_input_txt.html-)ø[1
0í³øY1 ([1 )]1 À8 ÏY1 ÀY1 Ð{R !]1 ]1 `
Ð[1 ApZ1 ø[1 `* ® Ï°\1 X\1 `x9
Y/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/setup_input_txt.html Template::Provider)ø`1
ø`1 àL ZBÏEð\1 è]1 é !è]1 è]1 À Ï2¸¶I
return·ISETUP_XPLINTERVAL_CHOOSEountentagen non rated trackstsSErs!_1 _1 À
Ï"8Að\1 È\1 `* ®Ï`^1 ^1 [EMAIL PROTECTED] `1 ~` Ïx^1 !È\1
@
´ÏY/var/cache/slimserver/templates//usr/share/slimserver/HTML/EN/setup_input_txt.htmlsTemplate::Providerp)È]1
[¦ ÏF 0_1 P_1 ®>Template::ProviderAp_1 `1 `
® ^1 0`1 `re/sPrefsInTabledwra!P_1 P_1 @ µ Ï"!h]1 h]1 `[ ÏÈ]1
!x^1 ` ¶^ Ï!è_1 è_1 À "Ï2 O?
at /usr/share/slimserver/Plugins/TrackStat/Backup/File.pm line 260
Re: [SlimDevices: Plugins] Trackstat restore problem
ZeddZull;238611 Wrote: > I am trying to restore my trackstat ratings from a backup file. I have > deleted all of the records (using the Plugins page). When I try to > restore, no records are created. I have checked to make sure that the > URL is the same between the backup file and the database. Any > suggestions on how I can restore my data? Have you entered the complete path to the backup file in the backup file parameter ? That is, you shouldn't just enter "mybackup.xml", you should enter something like "C:\My Documents\mybackup.xml" If that doesn't help, could you turn on the debugging messages flag at the bottom of the TrackStat section in Server Settings/Plugins and perform a restore and post the log from: http://localhost:9000/log.txt -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.homeip.net/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=39748 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
