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

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

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

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

Post by ZvezdanD »

chrisdukes wrote: Wed Apr 21, 2021 1:10 pm How do I change this example...
It is much simpler to change the mask "Artists with at least <ID:1> (complete) Albums having at least <ID:3> files":
- replace SongArtists.ID with Publishers.ID
- replace IfNull(ArtistsSongs.PersonType, 1) = 1 with ArtistsSongs.PersonType = 8
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
chrisdukes
Posts: 75
Joined: Mon Nov 18, 2013 3:15 pm

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

Post by chrisdukes »

Thanks for the reply!

I replaced everything but I'm getting an error. Here's the mask:

Code: Select all

Songs.IDAlbum || '@' || Publishers.ID IN (SELECT DISTINCT IDAlbum || '@' || T0.IDArtist FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.PersonType = 8 INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID INNER JOIN (SELECT IDArtist, ',' || RTrim(Group_Concat(IDAlbum)) || ',' AS ConcFld FROM Albums INNER JOIN (SELECT IDAlbum, ArtistsSongs.IDArtist, Count(*) AS CountFld1 FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.PersonType = 8 INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID GROUP BY IDAlbum, ArtistsSongs.IDArtist) ON ID = IDAlbum AND Tracks = CountFld1 WHERE Tracks >= <Number|Caption:Min. number of files per album|Value:5|MinValue:1|MaxValue:20|ID:3> AND IDAlbum > 0 <If|Caption:Only complete albums having number of files equal to maximal track #|Value=1|ID:2>AND IDAlbum IN (SELECT IDAlbum FROM Albums INNER JOIN (SELECT IDAlbum, Count(*) AS CntFld FROM Songs GROUP BY IDAlbum, DiscNumber HAVING CntFld = Max(Cast(TrackNumber As integer))) AS T1 ON Albums.ID = T1.IDAlbum GROUP BY IDAlbum HAVING Albums.Tracks = Sum(CntFld)) <End If>GROUP BY IDArtist HAVING Count(*) >= <Number|Caption:Minimal number of albums|Value:2|MinValue:1|MaxValue:20|ID:1>) AS T0 ON T0.IDArtist = ArtistsSongs.IDArtist AND T0.ConcFld Like '%,' || Songs.IDAlbum || ',%' WHERE Songs.IDAlbum > 0)
Thanks!
https://soundcloud.com/chris_dukes
------------------------------------------------
MediaMonkey Gold Lifetime v4.1.31.1919
Discogs Tagger 5.8
Magic Nodes 6.0.0.29
Windows 10 Pro
Intel Core i7-3770k 3.5GHz, 16GB RAM
ZvezdanD
Posts: 3257
Joined: Thu Jun 08, 2006 7:40 pm

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

Post by ZvezdanD »

chrisdukes wrote: Sat Apr 24, 2021 6:59 pm I replaced everything but I'm getting an error. Here's the mask:
It works fine on my computer. And that is not a full mask, only the Filter qualifier.
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
chrisdukes
Posts: 75
Joined: Mon Nov 18, 2013 3:15 pm

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

Post by chrisdukes »

My bad:

FILTER

Code: Select all

Songs.IDAlbum || '@' || Publishers.ID IN (SELECT DISTINCT IDAlbum || '@' || T0.IDArtist FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.PersonType = 8 INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID INNER JOIN (SELECT IDArtist, ',' || RTrim(Group_Concat(IDAlbum)) || ',' AS ConcFld FROM Albums INNER JOIN (SELECT IDAlbum, ArtistsSongs.IDArtist, Count(*) AS CountFld1 FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.PersonType = 8 INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID GROUP BY IDAlbum, ArtistsSongs.IDArtist) ON ID = IDAlbum AND Tracks = CountFld1 WHERE Tracks >= <Number|Caption:Min. number of files per album|Value:5|MinValue:1|MaxValue:20|ID:3> AND IDAlbum > 0 <If|Caption:Only complete albums having number of files equal to maximal track #|Value=1|ID:2>AND IDAlbum IN (SELECT IDAlbum FROM Albums INNER JOIN (SELECT IDAlbum, Count(*) AS CntFld FROM Songs GROUP BY IDAlbum, DiscNumber HAVING CntFld = Max(Cast(TrackNumber As integer))) AS T1 ON Albums.ID = T1.IDAlbum GROUP BY IDAlbum HAVING Albums.Tracks = Sum(CntFld)) <End If>GROUP BY IDArtist HAVING Count(*) >= <Number|Caption:Minimal number of albums|Value:2|MinValue:1|MaxValue:20|ID:1>) AS T0 ON T0.IDArtist = ArtistsSongs.IDArtist AND T0.ConcFld Like '%,' || Songs.IDAlbum || ',%' WHERE Songs.IDAlbum > 0)
MASK

Code: Select all

Publisher w2 Albums|Position:Last child|Child of:Library|MM filter:Reconcile|Filter:Songs.IDAlbum || '@' || Publishers.ID IN (SELECT DISTINCT IDAlbum || '@' || T0.IDArtist FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.PersonType = 8 INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID INNER JOIN (SELECT IDArtist, ',' || RTrim(Group_Concat(IDAlbum)) || ',' AS ConcFld FROM Albums INNER JOIN (SELECT IDAlbum, ArtistsSongs.IDArtist, Count(*) AS CountFld1 FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.PersonType = 8 INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID GROUP BY IDAlbum, ArtistsSongs.IDArtist) ON ID = IDAlbum AND Tracks = CountFld1 WHERE Tracks >= <Number|Caption:Min. number of files per album|Value:5|MinValue:1|MaxValue:20|ID:3> AND IDAlbum > 0 <If|Caption:Only complete albums having number of files equal to maximal track #|Value=1|ID:2>AND IDAlbum IN (SELECT IDAlbum FROM Albums INNER JOIN (SELECT IDAlbum, Count(*) AS CntFld FROM Songs GROUP BY IDAlbum, DiscNumber HAVING CntFld = Max(Cast(TrackNumber As integer))) AS T1 ON Albums.ID = T1.IDAlbum GROUP BY IDAlbum HAVING Albums.Tracks = Sum(CntFld)) <End If>GROUP BY IDArtist HAVING Count(*) >= <Number|Caption:Minimal number of albums|Value:2|MinValue:1|MaxValue:20|ID:1>) AS T0 ON T0.IDArtist = ArtistsSongs.IDArtist AND T0.ConcFld Like '%,' || Songs.IDAlbum || ',%' WHERE Songs.IDAlbum > 0)\<Publisher|Sort by:Count(Album)|Statistic:Count(Album)>
ERROR

Code: Select all

The mask defining this Magic Node produced an error.  Edit the mask and try again.  (The error probably resides in the Filter or SQL filter qualifiers.)
MAGIC NODES 5.2.0.55

Thanks again!
https://soundcloud.com/chris_dukes
------------------------------------------------
MediaMonkey Gold Lifetime v4.1.31.1919
Discogs Tagger 5.8
Magic Nodes 6.0.0.29
Windows 10 Pro
Intel Core i7-3770k 3.5GHz, 16GB RAM
ZvezdanD
Posts: 3257
Joined: Thu Jun 08, 2006 7:40 pm

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

Post by ZvezdanD »

chrisdukes wrote: Sun Apr 25, 2021 10:08 am MAGIC NODES 5.2.0.55
Why didn't you install the latest version that I sent you?
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
chrisdukes
Posts: 75
Joined: Mon Nov 18, 2013 3:15 pm

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

Post by chrisdukes »

Whoops! I upgraded and it works. Thanks again!
https://soundcloud.com/chris_dukes
------------------------------------------------
MediaMonkey Gold Lifetime v4.1.31.1919
Discogs Tagger 5.8
Magic Nodes 6.0.0.29
Windows 10 Pro
Intel Core i7-3770k 3.5GHz, 16GB RAM
chrisdukes
Posts: 75
Joined: Mon Nov 18, 2013 3:15 pm

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

Post by chrisdukes »

Do the old examples have anything the new ones don't? Or, can I just delete the old examples?
https://soundcloud.com/chris_dukes
------------------------------------------------
MediaMonkey Gold Lifetime v4.1.31.1919
Discogs Tagger 5.8
Magic Nodes 6.0.0.29
Windows 10 Pro
Intel Core i7-3770k 3.5GHz, 16GB RAM
ZvezdanD
Posts: 3257
Joined: Thu Jun 08, 2006 7:40 pm

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

Post by ZvezdanD »

chrisdukes wrote: Mon Apr 26, 2021 11:57 am Do the old examples have anything the new ones don't? Or, can I just delete the old examples?
The old sample masks are kept or upgraded, so you could remove them during uninstall of the old version. In fact, I already told you so in the e-mail sent with the new version, to get correctly installed and sorted the new sample masks.

However, it is highly recommended that you make a backup of your own created masks before uninstalling the old version.
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
Haaden2
Posts: 23
Joined: Thu Sep 09, 2010 12:03 pm

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

Post by Haaden2 »

I'm using Magic Nodes 6.0.0.33, and it's fantastic all that it can do.

I'm trying to figure out if I can get nodes of parts of the Involved People field that meet a specific criteria.

For example, suppose the Involved People field can have multiple people with multiple roles with multiple subroles formatted like this:

Role1 (Subrole1, Subrole2), Role2 (Subrole3, Subrole4): Person; Role3 (Subrole5): Person; Role4: Person

I want to get nodes of only the Subroles that have more than one per Role, From the above example:

Subrole1, Subrole2
Subrole3, Subrole4

I've gotten as far as this mask:

<Group|Name:Involved People|Show tracks:No|Icon:48>\( .. , .. )|Statistic:Count(Tracks)|Icon:48|Child of:Files to Edit|MM filter:Tag Cleaning|Show tracks:No\<Involved people|Split by:; |Split Mode:Categories|Exclusive right of: (|Exclusive right until:): >

But this doesn't work right in two ways:

1. It creates nodes of all the Subroles, not just the ones that have more than one per Role. If I could identify which split parts have a "," in them after the split, that would work, but I can't figure out how to get the mask to do that.

2. For Persons with more than one Role with Subroles - like the first Person in my example above - the split part is wrong. I need the Exclusive right until to be either "):" or ")," and I can't figure out how to do that either.

Is it possible to make a mask that will create nodes in the way I want? Should I do that with a split mask? Or should I be trying another way?
MMFrLife
Posts: 2894
Joined: Fri Oct 26, 2012 9:04 pm
Location: MM Forum

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

Post by MMFrLife »

Just curious, does 'cover storage' filter refer to:
Image file = image file(s) contained in a folder and
tag = image saved to tag of file?

So, 'cover storage - doesn't equal - tag' should give me,
files that are "missing" art saved to tags?
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
😜
ZvezdanD
Posts: 3257
Joined: Thu Jun 08, 2006 7:40 pm

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

Post by ZvezdanD »

Haaden2 wrote: Tue Apr 27, 2021 7:20 pm Is it possible to make a mask that will create nodes in the way I want? Should I do that with a split mask? Or should I be trying another way?
It is not possible that you create nodes in the way you want. Maybe I could try to allow such thing in the future, but for now, if your only goal is just to find the files with Involved People having two or more subroles, you could try this Filter: <Involved People> GLOB '*(*,*)*'

Or you could try RegExp Find & Replace to find the same files, e.g.: .*\(.*\,.*\).*
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: 3257
Joined: Thu Jun 08, 2006 7:40 pm

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

Post by ZvezdanD »

MMFrLife wrote: Sat May 01, 2021 9:07 pm So, 'cover storage - doesn't equal - tag' should give me,
files that are "missing" art saved to tags?
That will give you files that have covers, but not in tags. If you want all files with "missing" art in tags, maybe you could try this Filter:
Songs.ID IN (SELECT Songs.ID FROM Songs LEFT JOIN Covers ON Songs.ID = Covers.IDSong WHERE Covers.CoverStorage IS NULL OR Covers.CoverStorage <> 0)
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
MMFrLife
Posts: 2894
Joined: Fri Oct 26, 2012 9:04 pm
Location: MM Forum

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

Post by MMFrLife »

Thanks for the above filter!
________________________________________________________________________________________________

Inline caption editing issue- MM API or MN bug?
(you may have already mentioned this somewhere?)

Steps to Reproduce

1. create a node or use an existing one

2. Make sure a statistics count is set (mine is set for album/series)

3. If open, close edit dialog

4. check caption title in tree to make sure it displays properly (a single instance of the count)

5. 'inline edit' the caption (just make up an edit)

6. check to see if a second instance of the count appears (you may need to move your cursor
'over to/on top of' the caption (no clicking necessary) to get it to show the addition of a second count

7. You can try just collapsing/reopening at the tree, but that will not refresh/clear it off
(opening up the edit dialog should show you that it is actually adding it to the caption title itself and
the only way to get rid of it is to edit it out of the caption in the dialog box)
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
😜
ZvezdanD
Posts: 3257
Joined: Thu Jun 08, 2006 7:40 pm

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

Post by ZvezdanD »

MMFrLife wrote: Sun May 23, 2021 10:54 am ...a single instance of the count
...
...a second instance of the count appears
I don't understand what you want to say. What do you mean by "instances of the count"? Could you post a full mask and tell me which node should be inline-edited? And please provide a few real examples of the result that you expect to get.
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
MMFrLife
Posts: 2894
Joined: Fri Oct 26, 2012 9:04 pm
Location: MM Forum

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

Post by MMFrLife »

1. When you set a count it shows up in the tree next to the caption (that is expected)

B10_ (AMI.A1.P) (11 albums)

2. When you slow press your cursor on that caption in the tree it allows you to inline edit it and
gives you what you want (that is expected).

B10_ (A1.P) (11 albums)

However, this doesn't last because it will show a second instance of the album count when you move the cursor back
over to the caption (in the tree); don't click again anywhere after the edit, just touch it, or hover over it with your cursor while it is still highlighted (result is unexpected) .

B10_ (A1.P) (11 albums) (11 albums)

3. If you open the edit dialog box you'll see that the inline editing 'seems' to be oddly causing the count to actually write
to the caption itself. The only way to get rid of it is editing in the dialog box, not reusing the inline approach or collapsing/reopening the tree for a refresh.

Code: Select all

<Group|Name:63 (MN) Tech 4- fix elements (temp)>\<Group|Name:Special Rel. IDs>\B10_ (AMI.A1.P)|Position:Before|Child of:Now Playing|Filter:<Path> LIKE '%\AMI.A1.P\%' AND <Path> LIKE '%B10_%'|Statistic:Count(Album)\<Album artist>
note: the edit in the example doesn't 'seem' to matter, you could create any node/caption and edit it in the tree any way you
want (the key seems to be having a count next to it). You could try it on one of your own.

EDIT:
Actually, I just discovered you can 'inline' edit it back out. I was trying to edit out the wrong instance (the expected count instance) and that is why both remained. I also discovered that every additional inline edit you make creates a new instance of the
count. But nonetheless, the central issue remains.
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
😜
Post Reply