Page 77 of 162

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

Posted: Mon Jul 20, 2009 4:09 am
by 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?

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

Posted: Mon Jul 20, 2009 4:52 am
by RobertSmith
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

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

Posted: Mon Jul 20, 2009 11:05 am
by ZvezdanD
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.

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

Posted: Mon Jul 20, 2009 11:29 am
by RobertSmith
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).

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

Posted: Mon Jul 20, 2009 12:13 pm
by ZvezdanD
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...

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

Posted: Wed Jul 22, 2009 9:13 am
by 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

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

Posted: Wed Jul 22, 2009 1:13 pm
by ZvezdanD
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)>

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

Posted: Fri Jul 24, 2009 6:12 pm
by 51graphix
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!"

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

Posted: Sat Jul 25, 2009 1:26 am
by RobertSmith
51graphix wrote:"The mask is not valid!"
Try to remove the leading spaces from the mask.

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

Posted: Sat Jul 25, 2009 4:45 pm
by 51graphix
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

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

Posted: Sun Jul 26, 2009 10:23 am
by ZvezdanD
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)>

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

Posted: Tue Aug 11, 2009 6:16 pm
by 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.

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

Posted: Tue Aug 11, 2009 7:21 pm
by k_r_eriksson
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

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

Posted: Wed Aug 12, 2009 2:46 am
by ZvezdanD
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.

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

Posted: Thu Aug 13, 2009 2:17 pm
by 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