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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto » Wed Feb 28, 2007 9:24 am

Wow, really!? Upgrade to 2.5.5!! :)
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.

Felix H.

Post by Felix H. » Wed Feb 28, 2007 10:14 am

It works now... installed 2.5.5 (stupid... :roll: ).

ashishg

Post by ashishg » Fri Mar 09, 2007 12:24 am

Amazing script! Is it possible to have functionality to export all the stored history information in Play History node in .csv format for personal analysis :)

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

Post by Bex » Sun Mar 11, 2007 2:57 pm

Thanks!
There are no export functionality in this script. But an export could easily be done from within Access. Do you have Access?
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

crcm
Posts: 62
Joined: Wed Mar 16, 2005 12:13 am
Location: Finland

Post by crcm » Mon Mar 12, 2007 11:29 am

just find the script..its brilliant!! :D (thanks to your link in forum)

Which reminds me....
I am very annoyed because all these scripts should be somewhere in same place. Now they are spreaded in forum and they are hard to find. Sticky is outdated and clumsy!

Make special site for all these scripts. They deserve it!!! "Hint" Hint"

:)

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

Post by Bex » Mon Mar 12, 2007 11:46 am

Thanks!
A much better way to handle script is under construction in MM3, but I don't know how it's going to work.

The sticky though is only outdated in the beginning. From Trixmoto's post it's fairly updated.
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

ashishg
Posts: 40
Joined: Mon Mar 12, 2007 12:19 am
Location: India

Post by ashishg » Sat Mar 17, 2007 10:01 am

I do, but I am fairly incompetent in SQL matters.
Bex wrote:Thanks!
There are no export functionality in this script. But an export could easily be done from within Access. Do you have Access?

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

Post by Bex » Sat Mar 17, 2007 10:12 am

OK. Do this:
1. Open up a new query in Access and goto the sql view.
2. Copy and paste the code below
3. Run the query and see if it works as expected
4. Save it and goto File->Export and choose desired format.

Code: Select all

SELECT Played.PlayDate, Played.IdSong, IIf([SongOrder]=-1,"",[SongOrder]+1) AS [Track#], Format([SongLength]/1000/86400,"nn:ss") AS Length, Artists.Artist, Songs.SongTitle AS Title, Albums.Album, Artists_1.Artist AS AlbumArtist, Genres.GenreName AS Genre, IIf([Songs]![Year]=-1,"",[Songs]![Year]) AS [Year], IIf([songs]![Rating]=-1,"",[songs]![Rating]/20) AS Rating
FROM ((((Songs INNER JOIN Artists ON Songs.IDArtist = Artists.ID) INNER JOIN Albums ON Songs.IDAlbum = Albums.ID) INNER JOIN Genres ON Songs.Genre = Genres.IDGenre) INNER JOIN Artists AS Artists_1 ON Albums.IDArtist = Artists_1.ID) INNER JOIN Played ON Songs.ID = Played.IdSong
ORDER BY IIf([SongOrder]=-1,"",[SongOrder]+1), Albums.Album, Artists_1.Artist; 
Let me know if it works.
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

ashishg
Posts: 40
Joined: Mon Mar 12, 2007 12:19 am
Location: India

Post by ashishg » Sat Mar 17, 2007 2:19 pm

It does. You've been very helpful.

slapdash
Posts: 18
Joined: Tue Jan 23, 2007 7:07 pm
Location: Leuven, Belgium

Post by slapdash » Wed Mar 21, 2007 1:48 pm

Where are these statistics saved?
What do I have to do when I will format my pc, to keep the stats?

Greetz

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

Post by Bex » Wed Mar 21, 2007 2:37 pm

They are saved in the Database so make sure you backup your MediaMonkey.mbd located in your "My Music"-folder before you format your PC. Then you simply copy it back to the "My Music"-folder again. But you also need to have your music stored exactly as you had it before you did the formatting.
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

Teknojnky
Posts: 5533
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Post by Teknojnky » Wed Mar 21, 2007 2:57 pm

Also be aware, that if you actually re-format your drive with your music on it, that it will have a different VOLUME ID than previously.

You can use onkel's script to update the MM database volume id to the new one.

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

Post by Bex » Wed Mar 21, 2007 3:01 pm

Very good point Teknojnky! :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

RedX
Posts: 366
Joined: Wed Dec 27, 2006 10:32 am
Location: Germany

Post by RedX » Wed Mar 21, 2007 3:52 pm

Teknojnky wrote:Also be aware, that if you actually re-format your drive with your music on it, that it will have a different VOLUME ID than previously.

You can use onkel's script to update the MM database volume id to the new one.
Where is this script? I simply can't find it :(

I just reinstalled MM and copied the music to a new hd then i copied the old db over the new one and told mm to find the files in new location. Do i still need to update the volume ID?

Thx,
Red

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

Post by Bex » Wed Mar 21, 2007 4:10 pm

http://www.mediamonkey.com/forum/viewtopic.php?p=70462

If you did a rescan you need to copy the DB again and run this script instead. The thing is that you want to use the old entries in your old DB to preserve all playhistory, playcount, dateadded and playlists. If you do a rescan you'll just add all the songs again so you'll end up with two copies of every song, one that plays and one that don't. But if you delete the ones that don't play you'll lose all as described above.
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