Filtered Statistics Report 1.5.1 (2009-10-09) [MM3]
Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]
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
-
- 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]
It works perfect, once more many thanks for all great scripts!!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.
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...
-
- 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]
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)
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
-
- 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]
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.
-
- 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]
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 authorMizery_Made wrote:I don't see a need to hard code the option into the script.
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)
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]
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.RobertSmith wrote:No hard code, an option were you could select the number. If you set it to 0 (zero) it would be exact as nowMizery_Made wrote:I don't see a need to hard code the option into the script.
● 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
-
- 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]
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)ZvezdanD wrote:it would be better if you use MM filters for that.
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)
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]
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.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)
● 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
-
- 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]
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 MMZvezdanD 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.
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)
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]
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?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
● 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
-
- 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]
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?
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)
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
Re: Filtered Statistics Report 1.4.1 (2009-06-24) [MM3]
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
-
- 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]
Perfect!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
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)
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
-
- 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]
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)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?"
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)
3.1.0.1256 - M$ Vista Business sp1, DELL laptop, WD USB HDD 1TB (iPhone 3GS 32GB, iPod 30GB, Archos AV500 60GB)
Re: Filtered Statistics Report 1.5 (2009-07-23) [MM3]
There is a new update: v1.5 - 2009-07-23
- Added: option to set minimal number of rated/played tracks for Top sections.
- 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