Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Vyper
Posts: 845
Joined: Tue May 23, 2006 5:53 pm

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by Vyper » Sat Apr 03, 2010 7:07 am

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.


If I'm wrong, I'm sure someone will correct me. :lol:
Stop Button Freak

Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by Owyn » Sat Apr 03, 2010 7:14 am

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
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by Owyn » Sat Apr 03, 2010 8:08 am

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. :D

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.

So, I changed, e.g.

Code: Select all

<Rating> >= 65 and <Year> Between 1950 And 1959
to

Code: Select all

<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

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

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by ZvezdanD » Sat Apr 03, 2010 9:34 am

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:

Code: Select all

<Rating> >= 65 and CASE WHEN <Original Year> > -1  THEN <Original Year> ELSE <Year> END Between 1950 And 1959
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

Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by Owyn » Sat Apr 03, 2010 6:16 pm

That worked a treat. Thanks.

I obviously need to RTFM. Missed the CASE construct completely.

Edit:
http://www.sqlite.org/lang_expr.html#case
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
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by Owyn » Sun Apr 04, 2010 3:06 am

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.

Code: Select all

[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

declan
Posts: 85
Joined: Wed Sep 20, 2006 3:55 pm

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by declan » Sun Apr 04, 2010 2:48 pm

Very nice, thanks for the update. Most working well, except I can't get "range" to work. This mask -

Code: Select all

Span\<Album artist|Unknown:No|Show rank:Yes|Top:20|Sort order:Desc|Sort by:Range(Year)>
returns this error message -

Image

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

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by ZvezdanD » Sun Apr 04, 2010 6:01 pm

Owyn wrote:Wanted to have a backup of these changes in case of future re-installs of the the script.
Don't worry. They are included now.
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
Posts: 3106
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 4.0 w/ 297 masks & real GUI (2010-04-01) [MM2+3]

Post by ZvezdanD » Sun Apr 04, 2010 6:02 pm

declan wrote:I can't get "range" to work.
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

Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: Magic Nodes 4.0 w/ 301 masks & real GUI (2010-04-04) [MM2+3]

Post by Owyn » Mon Apr 05, 2010 6:50 pm

Looking at "20 Most played Artists", noticed that some frequently played titles were missing.

Changed mask from

Code: Select all

<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:Min(Played) Desc>
to

Code: Select all

<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)
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

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

Re: Magic Nodes 4.0 w/ 301 masks & real GUI (2010-04-04) [MM2+3]

Post by ZvezdanD » Mon Apr 05, 2010 7:23 pm

Owyn wrote:Looking at "20 Most played Artists", noticed that some frequently played titles were missing.

Changed mask from

Code: Select all

<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:Min(Played) Desc>
to

Code: Select all

<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

Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: Magic Nodes 4.0 w/ 301 masks & real GUI (2010-04-04) [MM2+3]

Post by Owyn » Mon Apr 05, 2010 7:42 pm

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. :D
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

Ashran
Posts: 34
Joined: Wed Nov 19, 2008 4:10 pm

Re: Magic Nodes 4.0 w/ 301 masks & real GUI (2010-04-04) [MM2+3]

Post by Ashran » Wed Apr 07, 2010 2:54 pm

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 ?

Londinium
Posts: 4
Joined: Mon Mar 15, 2010 1:08 pm

Re: Magic Nodes 4.0 w/ 301 masks & real GUI (2010-04-04) [MM2+3]

Post by Londinium » Thu Apr 08, 2010 3:56 pm

Hi, thanks for the update, great work!
I only wonder why we can't add statistics (ex : Count(Items)) with "All Parts" enabled?

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

Re: Magic Nodes 4.0 w/ 301 masks & real GUI (2010-04-04) [MM2+3]

Post by ZvezdanD » Fri Apr 09, 2010 11:46 am

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:

Code: Select all

<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

Post Reply