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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

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

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by RobertSmith » Mon Jul 20, 2009 4:09 am

Is it possible to use local qualifiers like <Title|Left of: (> in SQL filters (where is no instr only substr in SQlite, or maybe I have missed it)?

What I try to do is a MN for what include all variants of tracks xxx, xxx (demo), xxx (radio edit) etc.

Code: Select all

Songs.SongTitle || '@#$' || Songs.Artist IN (SELECT SongTitle || '@#$' || Artist FROM Songs WHERE Length(SongTitle) > 0 GROUP BY SongTitle, Artist HAVING Count(*) > 1 AND Count(DISTINCT Artist) = 1)
What does || '@#$ || mean?
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: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by RobertSmith » Mon Jul 20, 2009 4:52 am

RobertSmith wrote:Is it possible to use local qualifiers like <Title|Left of: (> in SQL filters (where is no instr only substr in SQLite, or maybe I have missed it)?
I was only checking this page I forgot to check MediaMonkey Database structure

This mask is OK.

Code: Select all

My Tracks with same Title (...) from same Artists|Icon:Top level|Statistic:Count(Tracks)|Filter:CASE WHEN InStr(SongTitle,' (')=0 THEN SongTitle ELSE SubStr(SongTitle,1,InStr(SongTitle,' (')-1) END || '@#$' || Songs.Artist IN (SELECT CASE WHEN InStr(SongTitle,' (')=0 THEN SongTitle ELSE SubStr(SongTitle,1,InStr(SongTitle,' (')-1) END || '@#$' || Artist FROM Songs WHERE Length(SongTitle) > 0 GROUP BY CASE WHEN InStr(SongTitle,' (')=0 THEN SongTitle ELSE SubStr(SongTitle,1,InStr(SongTitle,' (')-1) END HAVING Count(*) > 1 AND Count(DISTINCT Artist) = 1)\<Artist|Statistic:Count(Tracks)>\<Title|Statistic:Count(Tracks)|Left of: (>\<Album artist with album>
is '@#$' used to "ensure" a unique combination of title & artist?

Edit: Added CASE WHEN... to mask
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: 3090
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by ZvezdanD » Mon Jul 20, 2009 11:05 am

RobertSmith wrote:Is it possible to use local qualifiers like <Title|Left of: (> in SQL filters
No, it isn't.
RobertSmith wrote:What I try to do is a MN for what include all variants of tracks xxx, xxx (demo), xxx (radio edit) etc.
Well, with your formulas you would include titles which have parentheses as well, like Don't You (Forget About Me). This is a reason why I prefer brackets for variants like demo, live, remixes...
RobertSmith wrote:What does || '@#$ || mean?
RobertSmith wrote:is '@#$' used to "ensure" a unique combination of title & artist?
Yes, it is.
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

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

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by RobertSmith » Mon Jul 20, 2009 11:29 am

ZvezdanD wrote:Well, with your formulas you would include titles which have parentheses as well, like Don't You (Forget About Me). This is a reason why I prefer brackets for variants like demo, live, remixes...
As long as it's the same artist (Simple minds?). However the formula works of course if you substitute " (" with " [". But you gave me an idea to write a similarly MN for tagging Inconsistencies (find titles without subtitles).

Title (subtitle) [variant] is not so bad I will think about it (easy to change with RegExp).
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: 3090
Joined: Thu Jun 08, 2006 7:40 pm

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by ZvezdanD » Mon Jul 20, 2009 12:13 pm

RobertSmith wrote:Title (subtitle) [variant] is not so bad I will think about it (easy to change with RegExp).
It is not bad at all. All Music Guide is using such format...
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

51graphix
Posts: 6
Joined: Mon Apr 13, 2009 6:56 pm

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by 51graphix » Wed Jul 22, 2009 9:13 am

Media Monkey v. 3.1.0.1256
Magic Nodes v. 2.7

Possible bug in "Artists with different Genres" node:

If a track has multiple artists separated by ";" in the "artist" field, then magic nodes specifies this artist as having more than one genre.

For example, this artist/song is appearing as having more than one genre, but there is only one song in the node:

- Chad Hugo
Pop

File: 07_Run to the Sun.mp3
Title: Run to the Sun
Artist: Chad Hugo; N.E.R.D.
Genre: Pop
Album: In Search Of...

If I replace the ";" with a "," in the artist field, like such: Chad Hugo, N.E.R.D.

... then it disappears from the node results.

Is there a way to adjust the node so that this doesn't happen, or am I supposed to get rid of ";" in my artist fields in entire db?

Thanks for the help,

-- Brian

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

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

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

51graphix wrote:Possible bug in "Artists with different Genres" node:

If a track has multiple artists separated by ";" in the "artist" field, then magic nodes specifies this artist as having more than one genre
You could try with the following mask:

Code: Select all

<Group|Name:Artists...|Show tracks:No>\Artists with different Genres (modified)|Icon:Top level|Statistic:Count(Artist)|Filter:Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND SongArtists.ID IN (SELECT Artists.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = Artists.ID AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY Artists.ID HAVING Count(DISTINCT Songs.Genre) > 1)\<Artist|Statistic:Count(Genre)>\<Genre|Statistic:Count(Tracks)>
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

51graphix
Posts: 6
Joined: Mon Apr 13, 2009 6:56 pm

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by 51graphix » Fri Jul 24, 2009 6:12 pm

ZvezdanD wrote:
51graphix wrote:Possible bug in "Artists with different Genres" node:

If a track has multiple artists separated by ";" in the "artist" field, then magic nodes specifies this artist as having more than one genre
You could try with the following mask:

Code: Select all

<Group|Name:Artists...|Show tracks:No>\Artists with different Genres (modified)|Icon:Top level|Statistic:Count(Artist)|Filter:Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND SongArtists.ID IN (SELECT Artists.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = Artists.ID AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY Artists.ID HAVING Count(DISTINCT Songs.Genre) > 1)\<Artist|Statistic:Count(Genre)>\<Genre|Statistic:Count(Tracks)>
When I edit the node, and paste the code above in the "Mask:" section I get the following error.

"The mask is not valid!"

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

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by RobertSmith » Sat Jul 25, 2009 1:26 am

51graphix wrote:"The mask is not valid!"
Try to remove the leading spaces from the mask.
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)

51graphix
Posts: 6
Joined: Mon Apr 13, 2009 6:56 pm

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by 51graphix » Sat Jul 25, 2009 4:45 pm

RobertSmith wrote:Try to remove the leading spaces from the mask.
Doing so allowed me to save the node, but then got the following errors:

Image
Image

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

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by ZvezdanD » Sun Jul 26, 2009 10:23 am

51graphix wrote:Doing so allowed me to save the node, but then got the following errors:
Sorry, I tried the mask with my working version of the script which has removed that bug. You could try with removed Statistic qualifier from the global node:

Code: Select all

<Group|Name:Artists...|Show tracks:No>\Artists with different Genres (modified)|Icon:Top level|Filter:Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND SongArtists.ID IN (SELECT Artists.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = Artists.ID AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) GROUP BY Artists.ID HAVING Count(DISTINCT Songs.Genre) > 1)\<Artist|Statistic:Count(Genre)>\<Genre|Statistic:Count(Tracks)>
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

tableguy
Posts: 109
Joined: Thu Jun 30, 2005 3:15 pm

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by tableguy » Tue Aug 11, 2009 6:16 pm

Someone tell me where the 170 scripts are? I saved some of the orginal and added a few of my own but can't find
anything adding up to 170. I would like to look at the "Multi" nodes, since I don't understand how you can have two Genre's when there
is only one field. But that might be another message.

k_r_eriksson
Posts: 185
Joined: Mon Aug 14, 2006 4:26 pm
Location: Gotland, Sweden

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by k_r_eriksson » Tue Aug 11, 2009 7:21 pm

tableguy wrote:Someone tell me where the 170 scripts are? I saved some of the orginal and added a few of my own but can't find
anything adding up to 170. I would like to look at the "Multi" nodes, since I don't understand how you can have two Genre's when there
is only one field. But that might be another message.
The Genre are split with a ";".

Rock;Pop

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

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by ZvezdanD » Wed Aug 12, 2009 2:46 am

tableguy wrote:Someone tell me where the 170 scripts are? I saved some of the orginal and added a few of my own but can't find
anything adding up to 170.
This question was asked several times before, so it is a time to put it in the FAQ section, but I doubt that anybody read it. The answer:
By default, the Magic Nodes script installs only initial 83 masks. If you want to add 90 additional masks, you should open the Edit /Magic Nodes Export/Import dialog box, choose File, specify c:\Program Files\MediaMonkey\Scripts\Auto\MN-Onenonymous.ini file and click on the Import button.
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 / 5.4  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.7 / 4.0  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.3 / 2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2

deneuve

Re: Magic Nodes 2.7 w/ 170+ masks & real GUI (2009-06-29)[MM2+3]

Post by deneuve » Thu Aug 13, 2009 2:17 pm

Can someone help please?
I'm trying to make a node to list all where the genre doesnt match the tags on Custom 4 (its a backup tag coz I usually mess up the genre by dragging it somewhere.. )
I tried basing it off the included node "artist does not match original artist" but it gives me an error everytime.. I tried different things I just cant find the right way to script it.. (no programming background at all)

Thank you

Post Reply