Play History & Stats Node 4.1.0 (2012-08-12)

[nynaevelan]

Another suggestion: Use Bex's Tagging Inconsistencies script to identify any Tracks with play discrepancies. You want to use the Tracks with.... section, there are several sections to check discrepancies with the plays.

[Weatherman]

Yep...tried that before I write to the forum :0) All relevant nodes of the track inconsistencies are clear of apparent problems. No tracks stated as having more plays than history, no indication of history plays that are not in played history, etc. Bex's script must have a memory that is additional to MM's. It's not a problem, just weird, and of course Play History and Stats Node will give different results from similar nodes in the MagicNodes scripts.

Thanks for your suggestion...very kind and helpful as is typical of this fantastic forum of people.
Best wishes
Jim

[Bex]

Bex....this update is excellent. The Browse History is brilliant and the overall feel is extremely smooth. Well done!!

One question...is there any way to "reset" the playhistory and stats? At the moment my play history shows a month of July 2009 as having played 700 tracks. In the Browser, it will even tell me how many tracks I played on a particular day in July. However, when I click on the day, or month, the tracks are not listed and I think this is because MM's internal history only begins in August 2009. This may have been due to a re-install of MM.

Why would my Play History and Stats node still think, or recognise that in July I was playing tracks through MM when MM itself doesn't remember?

Can I reset Playhistory to reflect MM's internal history?
Thanks
Jim

Thanks!
It's not 700 tracks it's 700 plays. That would explain it all wouldn't it?

[Bex]

I like the new Browse History node, one minor request for a future version, could you add the total count to the year node as well, the same as it is for the months? It would be very interesting to know what the total count is for each year.

Nyn

Sure, it'll be in the next release!

[Weatherman]

To Bex....yes, of course, 700 plays. But still, the basic issue is still there. I don't see how this explains that the Play History and Stats node "sees" those plays when MM doesn't see them, and neither does the Tagging Inconsistencies nodes in "Files To Edit".
Jim

[Weatherman]

Oh Bex...I have also got a small request. In the next version of this wonderful node, could you also make the individual times of plays in descending mode so that the latest play is top? So, in the browser we would have for example:

February
04
03
02
01

and undereneath each day would be the time of play and track name in descending order?

[Bex]

To Bex....yes, of course, 700 plays. But still, the basic issue is still there. I don't see how this explains that the Play History and Stats node "sees" those plays when MM doesn't see them, and neither does the Tagging Inconsistencies nodes in "Files To Edit".
Jim

It's hard for me to understand what you mean exactly, can you provide some screenshots which clearly displays the issue?

[Bex]

Oh Bex...I have also got a small request. In the next version of this wonderful node, could you also make the individual times of plays in descending mode so that the latest play is top? So, in the browser we would have for example:

February
04
03
02
01

and undereneath each day would be the time of play and track name in descending order?

The day-nodes are already in descending order? As for the Individual plays, I first made them descending but I changed that since you couldn't get them to play in the order they were played that day otherwise. With that said are you sure you still need it?

[Weatherman]

Hi Bex - no of course I don't need it.

On the other matter, I can't get screen shots I'm afraid. But the thing is, the PlayHistory and Stats script shows that there have been 700 plays in July 2009. When I click on the nodes for july, the tracks don't show up, so apparently these must have been tracks I have since deleted from the MM Library and/or pc. So it shows that there has been 700 plays of something in July 2009.

With all other scripts and MM itself, this does not show up. Magicnodes doesn't show this, for example. All play stats only show is from August 2009.

Even with uninstalling Play Histroy &Stats script and then re-installing it, it still for some reason is able to detect that in July 2009 I had 700 plays of something. It can even tell how these plays were split across the 31 days in July, even though it can't show the actual tracks played in a window.

I just find it curious as to how come Play Histroy and Stats knows this but other scripts or MM itself seem to have forgotten about it.

That's the best way I can dexcribe it. I find it fun and interesting.
Jim

[Onweerwolf]

I have something similar as Weatherman.

In my history there is mention of 2 tracks being played in December 2007 en 1 track in January 2008. This was during the time when I was doing my final tests of MM with a sample library to see if I would migrate from iTunes to MM.

I migrated on the 16th of January 2008 and I'm pretty sure I cleared my sample library and then replaced it with my real library.

If I click on the 'ghost weeks' no tracks are shown and when I click to expand the expand button just dissapears.

[Bex]

I think I found the reason to your issue. It seems that when a song gets deleted from MM, its reference in the PlayHistory table should also get deleted but in your case it has not. Why I don't know but to see if that's the case, download and install SQL-Viewer:

SQL-Viewer: viewtopic.php?f=2&t=24841

Then run this SQL which only displays these redundant records, if they exist:

Code: Select all

SELECT *, Date(playdate+2415018.5) Date FROM Played
WHERE IDSong NOT IN (SELECT ID FROM Songs)
ORDER BY 3 desc

This SQL actually deletes them. Press "Execute DDL/DML Statement":

Code: Select all

DELETE FROM Played WHERE IDSong NOT IN (SELECT ID FROM Songs)

[Onweerwolf]

Thnx Bex! I will try this in a few days (I'm currently running a 48 hour exact best of marathon in MM this weekend and would hate to have to close MM and restore my .db in case I make an error and not end at Sunday 23:59 exactly) and will let you know if that was what was causing it.

On another note: this script was the first one that I permanently installed when I migrated to MM after Trix helped me to import the date added data from iTunes and it's still integral part of my setup and I'm still loving it. Thanks for that!

[Bex]

Thank you, Onweerwolf!

This script was actually my first script - ever! And I still use it almost daily, Currently I'm listening to some old "playlists" played on some parties, quite fun. Even though it seems to be the very same songs over and over again that gets played. I've found some cool songs I forgotten about. I'm glad I have history from 2004!

[Weatherman]

Bex...you're a genius! That has done the trick. It does seem that the deleted songs did not get deleted from the memory of MM in some way.

I ran your scripts in SQL Viewer, and I seem to be back to normal.....if you can call a guy who would worry about things like this "normal"!!!.

Thanks for writing out the SQL commands...I wouldn't have known how to do that...the only field that seemed to make sense was the field with the dates. Thanks again, Bex, much appreciated.
Jim

[Bex]

Thank you, Weatherman!