rrfpacker wrote:The criteria I'm looking for is for Artists who only had one hit, mostly from the 60's and 70's. So the artist only shows up once. I'm not sure if changing the current node from one to five will accomplish what I want. Won't it just pick one song of the up to five available?
So far "guest"s mask is working after I changed the rating value from 80 to 10 (I want to include every one hit wonder even if I don't like it). I will also create an MM filter, until I figure out how to modify the mask, that filters out unwanted criteria such as genres.
Thank you, guest.
I'd do what Weatherman suggested above. That would give you all the artists that have only one song in your library. I'm pretty sure that MagicNodes only gets its information from your database so that would be the best you can do.
You'd need some other type of script to search the web for actual one-hit wonders if that's what you're looking for.
Removed & clean installed new Magic Nodes with all presets. I didn't have many changes to prior version and if I needed them again easy enough to re-create. Most of the changes were one timers to test SQL.
Anyway, browsing the presets with the new version and checked Best of nodes. The node did not quite meet my requirements. <Year> in my database is frequently release year and not original recording year. I keep that in <Original Year> where appropriate.
<Rating> >= 65 and ((<Year> Between 1950 And 1959) or (<Original Year> Between 1950 and 1959))
That works to include e.g. a 90s compilation of 50s hits in Best of 50s, but, what I would really like to do is use <Original Year> in preference to <Year>. ie. I don't want that compilation to show up in the Best of 90s node.
Any ideas?
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
Owyn wrote:That works to include e.g. a 90s compilation of 50s hits in Best of 50s, but, what I would really like to do is use <Original Year> in preference to <Year>. ie. I don't want that compilation to show up in the Best of 90s node.
Any ideas?
If I understand correctly, you don't have entered values for <Original Year> for tracks where <Year> = original recording year, so you could try this:
I exported and expanded the Best of presets to create a new custom ini file. Wanted to have a backup of these changes in case of future re-installs of the the script.
[CustomNodeMasks]
Mask1=<Group|Name:Best of...|Icon:Top level>\Best of the '20s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 1920 And 1929\<Album with Album Artist>
Mask2=<Group|Name:Best of...|Icon:Top level>\Best of the '30s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 1930 And 1939\<Album with Album Artist>
Mask3=<Group|Name:Best of...|Icon:Top level>\Best of the '40s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 1940 And 1949\<Album with Album Artist>
Mask4=<Group|Name:Best of...|Icon:Top level>\Best of the '50s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 1950 And 1959\<Album with Album Artist>
Mask5=<Group|Name:Best of...|Icon:Top level>\Best of the '60s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 1960 And 1969\<Album with Album Artist>
Mask6=<Group|Name:Best of...|Icon:Top level>\Best of the '70s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 1970 And 1979\<Album with Album Artist>
Mask7=<Group|Name:Best of...|Icon:Top level>\Best of the '80s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 1980 And 1989\<Album with Album Artist>
Mask8=<Group|Name:Best of...|Icon:Top level>\Best of the '90s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 1990 And 1999\<Album with Album Artist>
Mask9=<Group|Name:Best of...|Icon:Top level>\Best of the 2000s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 2000 And 2009\<Album with Album Artist>
Mask10=<Group|Name:Best of...|Icon:Top level>\Best of the 2010s|Icon:Top level|Filter:<Rating> >= 65 and CASE WHEN <Original Year> > -1 THEN <Original Year> ELSE <Year> END Between 2010 And 2019\<Album with Album Artist>
I initially could not get this to import anything except "Mask10". Finally figured out that I had "Mask01".."Mask09" instead of "Mask1".."Mask9".
Thanks again.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
Thanks for the report. There is new update: v4.0.1 - 2010-04-04
- Fixed: error with Range function when "Display sorting/statistic results only if all values are defined" is turned on.
●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
<Group|name:Top 20...|Show tracks:No>\20 Most played Artists|Icon:Top level|Filter:<Played> > 0\<Artist|Sort by:Sum(Played)|Sort order:Desc|Top:20>\<Title|Sort by:Sum(Played) Desc>
ie. Sum(Played) instead of Min(Played)
Thanks, it will be modified with the next version. However, the <Played> field is actually PlayCounter from the database and every track has single value for it. So, Sum(Played) for Title is different from Min(Played) only if you have two or more tracks with same Title (and same Artist in this case).
●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
ZvezdanD wrote:Thanks, it will be modified with the next version. However, the <Played> field is actually PlayCounter from the database and every track has single value for it. So, Sum(Played) for Title is different from Min(Played) only if you have two or more tracks with same Title (and same Artist in this case).
Which is exactly my case. I have fairly extensive collections for some artists with multiple distinct versions of some titles. I considered Max instead of Sum, but, Sum seemed better. Min was definitely wrong.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
I dunno if you could help me here, but I have a question that might be done through magic nodes.
I have a number of auto-playlist (that are in fact genre playlists, that contains all tracks from a genre, one for all rock, one for all metal and so on). What I would like to do, is to be able to have a playlist made with let's say 10 random tracks from each of theses playlists, on one click.
Is it feasable and if yes, how could I set this up ?
Ashran wrote:I have a number of auto-playlist (that are in fact genre playlists, that contains all tracks from a genre, one for all rock, one for all metal and so on). What I would like to do, is to be able to have a playlist made with let's say 10 random tracks from each of theses playlists, on one click.
Not related with your auto-playlists, but you could try this:
<Group|Name:Random|Show tracks:No>\10 Random Tracks from each Genre|Icon:Top level|Child of:Playlists|Position:Child|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs, (SELECT DISTINCT GenresSongs.IDGenre AS IDGenre FROM GenresSongs) AS G1 WHERE Songs.ID IN (SELECT Songs.ID FROM Songs, GenresSongs WHERE Songs.ID = GenresSongs.IDSong AND GenresSongs.IDGenre = G1.IDGenre ORDER BY Random() LIMIT 10))
●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