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

[RobertSmith]

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?

[RobertSmith]

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

[ZvezdanD]

Is it possible to use local qualifiers like <Title|Left of: (> in SQL filters

No, it isn't.

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

What does || '@#$ || mean?

is '@#$' used to "ensure" a unique combination of title & artist?

Yes, it is.

[RobertSmith]

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

[ZvezdanD]

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

[51graphix]

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]

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

[51graphix]

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]

"The mask is not valid!"

Try to remove the leading spaces from the mask.

[51graphix]

Try to remove the leading spaces from the mask.

Doing so allowed me to save the node, but then got the following errors:

[ZvezdanD]

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

[tableguy]

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]

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]

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.

[deneuve]

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