Filtered Statistics Report 1.5.1 (2009-10-09) [MM3]

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

ZvezdanD
Posts: 3106
Joined: Thu Jun 08, 2006 7:40 pm

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by ZvezdanD » Wed Jun 24, 2009 1:18 pm

The play count is an information from the Songs table which is now used in the reports. As I said, I suppose that MM during sync with iPods updates that information only (and maybe Last Played Date which is also in Songs table) instead of the Played table which contains informations about playing date/time for each playing. In theory, the number of record in the Played table should be same as a sum of the play counts from the Songs table, but if MM updates only the Songs table during iPod sync then the play count is more accurate than number of records from Played table.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2

RobertSmith
Posts: 157
Joined: Wed Jun 24, 2009 1:05 am
Location: Stockholm, The home of Icebears

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by RobertSmith » Thu Jun 25, 2009 11:54 am

ZvezdanD wrote:There is a new release (1.4.1), please let me know if it works as it should. I don't have an iPod, so I cannot test it.
It works perfect, once more many thanks for all great scripts!! :D

A little O.T.
The extremely fast response is fantastic. Just think if M$ or Apple could open where products for all great programmers out where. I have been writing to apple for the last three year trying to convince them to come with an update so podcast mp3 is only found in the podcast folder and not mixed up with songs and artists, it must be where easy to use genre, but no luck so far...

RobertSmith
Posts: 157
Joined: Wed Jun 24, 2009 1:05 am
Location: Stockholm, The home of Icebears

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by RobertSmith » Tue Jul 21, 2009 12:01 pm

What do you think about a options to select minimum no of tracks (no CDS/CDM) and/or minimum no tracks with rating, minimum X no tracks from one artist (avoid one hit artist from VA album) or is it better to solve this using MM filter?
Boys Don't Cry
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)

Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by Mizery_Made » Tue Jul 21, 2009 2:30 pm

The filter ability was pretty much added to do things like this, and since it's accomplish-able through filters, I don't see a need to hard code the option into the script. Though I'm not the scripts author, so he might feel differently.

RobertSmith
Posts: 157
Joined: Wed Jun 24, 2009 1:05 am
Location: Stockholm, The home of Icebears

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by RobertSmith » Tue Jul 21, 2009 11:24 pm

Mizery_Made wrote:I don't see a need to hard code the option into the script.
No hard code, an option were you could select the number. If you set it to 0 (zero) it would be exact as now, but if you for instance set minimum tracks from one artist to 5 you can avoid one-hit wonders, or minimum 8 rated tracks per album you avoid CDS/CDM and albums there you only has play/rate a few tracks (VA/compilations albums). But as you said it's up to the author :)
Boys Don't Cry
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)

ZvezdanD
Posts: 3106
Joined: Thu Jun 08, 2006 7:40 pm

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by ZvezdanD » Wed Jul 22, 2009 1:07 am

RobertSmith wrote:
Mizery_Made wrote:I don't see a need to hard code the option into the script.
No hard code, an option were you could select the number. If you set it to 0 (zero) it would be exact as now
How do you expect this to work if necessary SQL queries are not hard-coded into the script? As Mizery_Made said, it would be better if you use MM filters for that. Anyway, I have another idea how to use different SQL queries to get statistical reports without a need to hard-code them into the script (I already talked about it), but there are some more important things that should be done first.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2

RobertSmith
Posts: 157
Joined: Wed Jun 24, 2009 1:05 am
Location: Stockholm, The home of Icebears

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by RobertSmith » Wed Jul 22, 2009 6:32 am

ZvezdanD wrote:it would be better if you use MM filters for that.
But the MM filter it not so bright (or maybe it's me that have misunderstand the function), e.g. with # Tracks by artist => 100 I expect a report with only my favourites but in top of chart I have Chrissi Poland since he is feat. artist on one Moby album (I'm using multi artist) (not possible to have # Album Artist => 100)
Boys Don't Cry
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)

ZvezdanD
Posts: 3106
Joined: Thu Jun 08, 2006 7:40 pm

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by ZvezdanD » Wed Jul 22, 2009 10:21 am

RobertSmith wrote:e.g. with # Tracks by artist => 100 I expect a report with only my favourites but in top of chart I have Chrissi Poland since he is feat. artist on one Moby album (I'm using multi artist) (not possible to have # Album Artist => 100)
Well, even if I decide to add such option, I still don't understand on which sections it should be applied. For example, limiting artist only to those which have number of tracks greater than xx has not much sense for Top xx Artist With Most Tracks section.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2

RobertSmith
Posts: 157
Joined: Wed Jun 24, 2009 1:05 am
Location: Stockholm, The home of Icebears

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by RobertSmith » Wed Jul 22, 2009 11:40 am

ZvezdanD wrote:Well, even if I decide to add such option, I still don't understand on which sections it should be applied. For example, limiting artist only to those which have number of tracks greater than xx has not much sense for Top xx Artist With Most Tracks section.
If you limit # of tracks to 5-8 per artist (minimum for calc. average) you will avoid one-hit wonders and featured artist (multi) in "Top-XX Rated artist" the effect on "Top XX Artist With Most Tracks" is unimportant since position XX (according to personal settings) will be greater when the track limit 5-8. If not, you have a very small collection and no need for MM :D

Most of filtering could be done with MM, but not all. Avoiding CDS/CDM etc. could be done with MM filter since I have (CDS), (VLS) etc. in album title. I believe all sections looks OK with the exception of the rated once.
Maybe it's enough to have an option to select minimum # tracks per artist. I can live with what some of my albums looks strange due to what I haven't rated the complete album (minimum 5-8 tracks per album must be rated before an average is calculated?)

Edit: minimum 5-8 tracks per genre must be rated before an average is calculated. Top XX Rated Genre
Boys Don't Cry
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)

ZvezdanD
Posts: 3106
Joined: Thu Jun 08, 2006 7:40 pm

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by ZvezdanD » Wed Jul 22, 2009 1:42 pm

RobertSmith wrote:Maybe it's enough to have an option to select minimum # tracks per artist. I can live with what some of my albums looks strange due to what I haven't rated the complete album (minimum 5-8 tracks per album must be rated before an average is calculated?)

Edit: minimum 5-8 tracks per genre must be rated before an average is calculated. Top XX Rated Genre
There are currently 24 sections and I need some simple and obvious way to implement just one or two new values for all sections. For example, if a section is Album then limit could be a minimal number of tracks per album, if a section is Artist then limit could be a minimal number of tracks per artist, and so on. So, what should be a criteria? Minimal number of tracks or minimal number of rated tracks or minimal number of played tracks or something else?
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2

RobertSmith
Posts: 157
Joined: Wed Jun 24, 2009 1:05 am
Location: Stockholm, The home of Icebears

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by RobertSmith » Wed Jul 22, 2009 2:48 pm

ZvezdanD wrote:There are currently 24 sections and I need some simple and obvious way to implement just one or two new values for all sections. For example, if a section is Album then limit could be a minimal number of tracks per album, if a section is Artist then limit could be a minimal number of tracks per artist, and so on. So, what should be a criteria? Minimal number of tracks or minimal number of rated tracks or minimal number of played tracks or something else?
Image
If possible, three values/scroll boxes with effect on 7 sections (calc of average rating)
1. Minimum # tracks (per artist/lyricists/composer/conductors/original artists)
2. Minimum # rated tracks per album
3. Minimum # rated tracks per genre

Or only one value: Minimum # for calculating Rating average. I believe it will be sufficient with only one value, same value for all three (5-8)?
with effect to either all 24 or only the above 7 sections
Boys Don't Cry
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)

ZvezdanD
Posts: 3106
Joined: Thu Jun 08, 2006 7:40 pm

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by ZvezdanD » Thu Jul 23, 2009 1:46 am

I suggest just one value which would be implemented differently depending of sections. If a section is Top xx Rated yy then this value would be the minimal number of rated tracks; if a section is Top xx Played yy then this value would be the minimal number of played tracks. That value would not apply to the Top xx yy With Most Tracks sections at all.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2

RobertSmith
Posts: 157
Joined: Wed Jun 24, 2009 1:05 am
Location: Stockholm, The home of Icebears

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by RobertSmith » Thu Jul 23, 2009 3:49 am

ZvezdanD wrote:I suggest just one value which would be implemented differently depending of sections. If a section is Top xx Rated yy then this value would be the minimal number of rated tracks
Perfect!
Top xx Rated yy is three tables where yy stands for Artist, Genre or Album with a optional minimum value of rated tracks when calculating average.

You might consider to set a max value for this "scroll box" (1 -> 10 or 12?) to avoid getting questions like "were are no rated albums in my table?" :-?
Boys Don't Cry
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)

RobertSmith
Posts: 157
Joined: Wed Jun 24, 2009 1:05 am
Location: Stockholm, The home of Icebears

Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]

Post by RobertSmith » Thu Jul 23, 2009 4:00 am

RobertSmith wrote:You might consider to set a max value for this "scroll box" (1 -> 10 or 12?) to avoid getting questions like "were are no rated albums in my table?" :-?
Or if it's possible use minimum of the option value and total number of tracks (all tracks most be rated) for album when calc. average for Top xx Rated Album? (CDS/CDM and incomplete "junk" folders/album can be handled by MM filter)
Boys Don't Cry
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)

ZvezdanD
Posts: 3106
Joined: Thu Jun 08, 2006 7:40 pm

Re: Filtered Statistics Report 1.5 (2009-07-23) [MM3]

Post by ZvezdanD » Thu Jul 23, 2009 9:45 am

There is a new update: v1.5 - 2009-07-23
- Added: option to set minimal number of rated/played tracks for Top sections.
Magic Nodes 4.3.3 / 5.2 RegExp Find & Replace 4.4.9 / 5.2  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.8 / 4.0.1  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.5 / 2.3  Inherit Child Playlists 1.0.3  Add Currently Playing/Selected Track(s) to Playlist 1.2

Post Reply