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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by nynaevelan » Thu Feb 04, 2010 9:15 am

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.
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

Weatherman
Posts: 137
Joined: Sun Nov 19, 2006 11:08 am

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Weatherman » Thu Feb 04, 2010 10:20 am

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
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Bex » Thu Feb 04, 2010 1:03 pm

Weatherman wrote: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?
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Bex » Thu Feb 04, 2010 1:04 pm

nynaevelan wrote: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!
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Weatherman
Posts: 137
Joined: Sun Nov 19, 2006 11:08 am

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Weatherman » Thu Feb 04, 2010 4:50 pm

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
Posts: 137
Joined: Sun Nov 19, 2006 11:08 am

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Weatherman » Thu Feb 04, 2010 4:54 pm

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
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Bex » Thu Feb 04, 2010 5:14 pm

Weatherman wrote: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?
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Bex » Thu Feb 04, 2010 5:20 pm

Weatherman wrote: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?
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Weatherman
Posts: 137
Joined: Sun Nov 19, 2006 11:08 am

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Weatherman » Fri Feb 05, 2010 2:20 pm

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
Posts: 642
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Onweerwolf » Fri Feb 05, 2010 7:32 pm

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.
Image

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Bex » Sat Feb 06, 2010 2:29 pm

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: http://www.mediamonkey.com/forum/viewto ... =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)
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Onweerwolf
Posts: 642
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Onweerwolf » Sat Feb 06, 2010 3:07 pm

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! :D
Image

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Bex » Sat Feb 06, 2010 3:37 pm

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! :D
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Weatherman
Posts: 137
Joined: Sun Nov 19, 2006 11:08 am

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Weatherman » Sat Feb 06, 2010 8:49 pm

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
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: Play History & Stats Node 4.0 (2010-02-03)

Post by Bex » Sun Feb 07, 2010 4:38 am

Thank you, Weatherman! :)
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Post Reply