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

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

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

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

Post by Bex »

PlayHistory & Stats
You find download link and installation instructions at the bottom of this post.
This script creates a “Play History & Stat” node which reveals how you have played your collection in MM..
It’s like Last-FM but more advanced and stored locally.

Image

In the “Per Week (Chart)” node. You will find all your played songs divided per week sorted descending on playcount and last played. The numbers in parenthesis are total played songs that week. Clicking on a week node will of course fill the main window with the played tracks that week:
Image


The “Per Month (Chart)” works exactly as the week node but is per month instead:

Image


In the “Top 100’s” node you’ll find top 100’s played Songs, Artists and Albums:

Image


But there are more. In the Statistic node you can browse your played songs in many advanced ways. 8)
Check out what music you have played in the Spring or on Thursdays or in the mornings, either by all times, last week, last month, per a specific year, etc. You even have a Party Music node which gives you songs played on Friday & Saturday evenings. :D
The "Per XXX" & "Party music" nodes are configurable and can be renamed to your liking in the settings.

Image


The script is more fun the longer you have had MediaMonkey since then you actually have data to fill the nodes with. But as times goes, more nodes will automatically be created.
There are more info in the script header. Pls read it.

This is my first script.
Comments, suggestions and bug reports are welcome!

Enjoy!
/Bex
___________________________________________________________
Updates:

Ver 4.1.0 (2012-08-12)
- Fixed issues with UTC time introduced in MM4
- Moved the script from the main tree into each Collection
- Tuned some SQL

Ver 4.0.1 (2010-02-07)
- Added Count of plays in Browse History's Year node
- Added possibility to sort Ascending or Descending in all "Browse History"-Nodes
- Added Check and optionally clean the Played table from invalid records

Ver 4.0 (2010-02-03)
- Added New "Browse History"-Node
- Added right click on nodes short cuts to the Option Sheet
- Fixed bug in the Statistic Node's "Custom Period"-Node

Ver 3.9.3 (2008-12-20) [MM3 only]
- Fixed "Per period of day"-nodes didn't work sometimes

Ver 3.9.2 (2008-12-20) [MM3 only]
- Fixed Chart nodes didn't add plays after 2008-12-18
- Fixed compatibility issues with MM 3.1

Ver 3.9.1 (2008-07-17) [MM3 only]
- Fixed error when changing Hemisphere
- Fixed wrong months was used in Southend Hemisphere's seasons

Ver 3.9 (2008-05-13) [MM3 only]
- Improved speed considerably in the top 100 node

Ver 3.8.1 (2008-04-15) [MM3 only]
- Fixed CheckBox incompatibility with MM 3.0.3.1159

Ver 3.8 (2008-02-1) [MM3 only]
- Added possibility to change "Top 100's node" to any number directly in the node
- Fixed various small bugs (and a rather big one)

Ver 3.7 (2008-02-1) [MM3 only]
- Added possibility to apply any configured filter to the script
- Fixed script didn't use local time when building nodes
- Changed the "Top 100's" node so it's based on total playcount instead of the PlayHistory table only
- Reworked the Option Sheet
- Numerous small fixes

Ver 3.6.1 (2008-01-24) [MM3 only]
- Fixed other "Persons" than Artist was considered in all Artist-Nodes

Ver 3.6 (2007-09-29) [MM3 only]
- Added possibilty to display Week and Month nodes with no data
- Added New Statistic Node Current Week
- Added New Statistic Node Previous Week
- Added New Statistic Node Current Month
- Added New Statistic Node Previous Month
- Added possibilty to hide various nodes (in Option sheet)
- Fixed bug in artist nodes
- Tuned some SQL statements (more todo)
- Minor fixes

Ver 3.5 (2007-09-13) [MM3 only]
- Converted the script to a separate MM3 version
- Added possibilty to hide all "Sort by"-nodes
- Added distinct count in many nodes
- Added Today and Yesterday in the stats node
- Changed some icons
___________________________________________________________
Download:
Latest version:
MM4 (Installer)
Download and rate the script from its Addon Page

MM3 (Installer)
PlayHistory & Stats 4.0.1


Installation Instructions:
- New Install or upgrade:
Avoid "Product installation error"
- Vista/Win 7 Users:
- - To be able to install scripts you must Run MM as administrator.
- - It means that you must right click the MM icon and "Run as administrator" even if you are logged in as an administrator.
- All Users:
- - Check in your task manager that you only have one instance of MediaMonkey.exe running.

1. Download the .mmip file and double click it.
2. Restart MediaMonkey if needed
3. Now you will see a new node at the end within each collection: "PlayHistory & Stats". Expand it have fun.
4. First use of either Chart-Node takes 1-2 minutes due to creation/update of a Week-table.
5. Also go to Tools->Options->Library->PlayHistory & Stats and alter the settings to your liking.
Last edited by Bex on Sat Feb 07, 2009 9:54 am, edited 65 times in total.
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
DiddeLeeDoo
Posts: 1017
Joined: Wed Mar 01, 2006 1:09 am
Location: In a jungle down under
Contact:

Post by DiddeLeeDoo »

I find it very exciting that you have 'cracked' the code.

The node is fast and a great way to see how many songs were played during any week or month. Also a great indication of favorite songs.

Hope the 'Scripting Bug' gave you a big bite ! :)
Image
paulmt
Posts: 1170
Joined: Tue Jul 18, 2006 6:06 pm

Post by paulmt »

Very nice script. It has a permanent place in my library node. Thanks
rovingcowboy
Posts: 14163
Joined: Sat Oct 25, 2003 7:57 am
Location: (Texas)
Contact:

Post by rovingcowboy »

nope not going to try it.

i don't like it.

not any good?

can't find any thing in it.

cant read it?

it looks like a big fake script to me.

8) :lol: :lol: :lol: :P :lol: :D :wink: :wink: :roll:

okay the harsh stuff was said so nobody else has to say it again.

unless of course you just want to joke around with bex as i was.

now i guess i should go read the script and check it out right? :o :roll:


one thing bex. you say it acts like a hitlist.

is it possible to fill a playlist with the information from any of the sub nodes of this playcound history node?

if you can fill a playlist with it, that would make it another way to make a weekly top of the charts list.

or maybe it is possible to play the list straight from the node?

looks good for a first script why does every one make a huge first script?
8)
roving cowboy / keith hall. My skins http://www.mediamonkey.com/forum/viewto ... =9&t=16724 for some help check on Monkey's helpful messages at http://www.mediamonkey.com/forum/viewto ... 4008#44008 MY SYSTEMS.1.Jukebox WinXp pro sp 3 version 3.5 gigabyte mb. 281 GHz amd athlon x2 240 built by me.) 2.WinXP pro sp3, vers 2.5.5 and vers 3.5 backup storage, shuttle 32a mb,734 MHz amd athlon put together by me.) 3.Dell demension, winxp pro sp3, mm3.5 spare jukebox.) 4.WinXp pro sp3, vers 3.5, dad's computer bought from computer store. )5. Samsung Galaxy A51 5G Android ) 6. amd a8-5600 apu 3.60ghz mm version 4 windows 7 pro bought from computer store.
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex »

Thanks guys!
@DiddeLeeDoo
I'm exicted too. But I still have alot to learn...

@paulmt
Glad you liked it!

@rovingcowboy
You dont need to export to playlists since you can play it from the node.
Unless you want to sort the songs in correct order but the calculated playcount is not possible to export.
Yes, you have all your weekly/montly chart hitlist in this script and they never go away. Unless you clear your library or delete some played songs.

Thanks again
/Bex
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
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto »

This is a great script, especially considering it's a first. Excellent work! :)
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex »

Thanks!
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

Post by Bex »

The script is updated. See the first post to find out what's new.

Try it out and please also leave some comments.
If anyone have a request, let me know and we'll see if I can implement it!


To other scripters:
I developed a new technique to add tracks to the main window which dramatically increases the adding speed, especially on advanced/nested SQL's. It also (sort of) solves the sorting of the tracks in the main window.
Study the four last SDB.MainTracksWindow codes to see what I've done.

@Pablo,
This technique could hopefully increase the speed of Magic Nodes!
(e.g. Advanced SQL Filters.)

@Devs
Why does not SortCriteria reset a manually sorted main window when the node is selected?
And what's the difference between SortCriteria and SortGroup.
Or am I doing this the wrong way?

Enjoy!
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
Pablo
Posts: 554
Joined: Sun Feb 22, 2004 2:59 am

Post by Pablo »

Bex wrote: @Pablo,
This technique could hopefully increase the speed of Magic Nodes!
(e.g. Advanced SQL Filters.)
Thanks much! Will definitely look into that.

PS. Very clever.
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex »

I've made a last minute change so reinstall the update again if needed...
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
DiddeLeeDoo
Posts: 1017
Joined: Wed Mar 01, 2006 1:09 am
Location: In a jungle down under
Contact:

Post by DiddeLeeDoo »

Big improvement! I'm very pleased with that you took this task and do it so well.
Image
Sammy20
Posts: 110
Joined: Thu Feb 17, 2005 5:42 am

Post by Sammy20 »

Very nice improvement over the first release. Working great for me.

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

Post by Bex »

Thanks guys!

New version is coming soon with a minor update.
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
paulmt
Posts: 1170
Joined: Tue Jul 18, 2006 6:06 pm

Post by paulmt »

Excellent script update - will you ever be able to stop tweaking it :D
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex »

The script has been updated!
Please read the first post and the script header before you install it.

Comments, bug reports and requests are welcome!

Enjoy!
/Bex
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