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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

dtsig
Posts: 3030
Joined: Mon Jan 24, 2011 6:34 pm

Re: How do you use Magic Nodes in MM 4.1.14.1813

Post by dtsig » Tue Dec 27, 2016 10:35 am

You need to post these questions in the Magic Nodes forum in addons section. You will get much quicker response
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

willyvds
Posts: 388
Joined: Tue Feb 24, 2009 3:30 pm

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

Post by willyvds » Tue Jan 03, 2017 6:21 am

I have made a node for my Top 20 Classical albums with the highest rating and having at least one 5-star song. This is not a very complicated query (see below). When I expand the node, it shows the list of 20 albums.
Now what I would like is that I can see all 20 albums at once. However, when I select "show all node" it shows all my classical albums, not just the top 20.
When I select "show files in filelist" (on the top level), it show some 150 albums. This is some selection (don't know why these are shown).

I vaguely remember that I had this in the past. But I don't remember how. Or maybe it was never possible.

<Group|Name:Klassieke Top ...>\20 gewaardeerde albums|Child of:Library|MM filter:Klassieke muziek|Position:Last child|Filter:<Album artist> <> 'Various Artists'|Show tracks:No\<Album|Sort by:Avg(Rating) Desc|Top:20|Min tracks:3|Filter:Max(<Rating>) = 100>

Suggestions are welcome!
Regards, Willy

ZvezdanD
Posts: 3090
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 » Tue Jan 03, 2017 2:02 pm

willyvds wrote:When I expand the node, it shows the list of 20 albums.
Now what I would like is that I can see all 20 albums at once. However, when I select "show all node" it shows all my classical albums, not just the top 20.
When I select "show files in filelist" (on the top level), it show some 150 albums.
You should combine your filters with the "Top <ID:1> (weighting) rated (complete) Albums" mask. Here is its Filter:

Code: Select all

Songs.IDAlbum IN (SELECT IDAlbum FROM Songs WHERE Rating >= 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)) AND CntFld >= <Number|Caption:Min. number of files per disc|Value:5|MinValue:1|MaxValue:20|ID:3>) AS T1 ON Albums.ID = T1.IDAlbum GROUP BY IDAlbum HAVING Albums.Tracks = Sum(CntFld)) <End If>GROUP BY IDAlbum ORDER BY <If|Caption:Average file rating weighted by track length|Value:1|ID:4>Sum(SongLength * Rating) / Sum(SongLength)<Else>Avg(Rating)<End If> DESC LIMIT <Number|Caption:Number of albums|Value:20|MinValue:1|MaxValue:100|ID:1>)
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

jgt1942
Posts: 64
Joined: Mon Feb 04, 2013 12:53 am

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

Post by jgt1942 » Tue Jan 03, 2017 3:29 pm

ZvezdanD wrote:The first post of this thread contains the Installation section and the link to the Web page of the add-on from where it could be downloaded.
In a reply to one of my post it was suggested that Magic Nodes was not the tool I should be using and suggested "RegExp Find and Replace" (see http://www.mediamonkey.com/forum/viewto ... ce#p430618) and I'm happy to report that it resolved my issue.

Lowlander
Posts: 46156
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

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

Post by Lowlander » Tue Jan 03, 2017 9:13 pm

Magic Nodes doesn't edit files, for that you'll need RegExp Find & Replace.
Lowlander (MediaMonkey user since 2003)

MMFrLife
Posts: 2774
Joined: Fri Oct 26, 2012 9:04 pm

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

Post by MMFrLife » Tue Jan 03, 2017 11:07 pm

Lowlander wrote:Magic Nodes doesn't edit files, for that you'll need RegExp Find & Replace.
That's what is being said by jgt1942. This has already been covered and is old now. See here
MM user since 2003 (lifetime since 2012) "Trying to imagine life without music gives me a headache"
track properties; dir/fn mask configurations; check out ZvezdanD's scripts
MMW 4.1.18.1842b; fav scripts > RegExp Find & Replace 5.1.0; Magic Nodes 5.1.0; Advanced Duplicate Find & Fix 3.8.2;
Backup 6.0; Clear Now Playing Button 1.2
...always back it up, especially before doing anything major!!!
Win. explorer alt. for power users [free]; great file/folder renamer [used by nasa]

PoooMukkel
Posts: 223
Joined: Thu Jul 19, 2007 8:36 am
Location: Germany

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

Post by PoooMukkel » Mon Feb 06, 2017 4:26 am

I hope that I'm in the right thread to post my question... :)

I created a node "Sampler" with the following mask:
Sampler|Filter:Songs.Album <> '' AND Songs.AlbumArtist = 'Various'\<Album|statistic:Max(Year)>\<Disc Number>

This mask works and all my "Sampler" are shown. But how is it possible to get this mask sort the entries correctly to the right numbers?

Now it looks like this:
Deep Dance 1 + 2 - Deepest Deep
Deep Dance 125.5
Deep Dance 147
Deep Dance 148,5
Deep Dance 3 + 4 - Starship Countdown
Deep Dance 5, 6, 7 - The Digital Dances - Compilation I


But I want to have this sorting:
Deep Dance 1 + 2 - Deepest Deep
Deep Dance 3 + 4 - Starship Countdown
Deep Dance 5, 6, 7 - The Digital Dances - Compilation I
Deep Dance 125.5
Deep Dance 147
Deep Dance 148,5


How can I get this to work? Is this possible? I'm using Magic Nodes V4.3.2.
Cu,
PoooMukkel

ZvezdanD
Posts: 3090
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 » Mon Feb 06, 2017 7:46 am

PoooMukkel wrote:But how is it possible to get this mask sort the entries correctly to the right numbers?
Your entries are correctly sorted. You are sorting textual field, not numerical, so you have alphabetical order. Your only solution could be to set all numbers to have fixed number of digits, e.g:
Deep Dance 001 + 002 - Deepest Deep
Deep Dance 003 + 004 - Starship Countdown
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

PoooMukkel
Posts: 223
Joined: Thu Jul 19, 2007 8:36 am
Location: Germany

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

Post by PoooMukkel » Mon Feb 06, 2017 12:12 pm

ZvezdanD wrote:Your entries are correctly sorted. You are sorting textual field, not numerical, so you have alphabetical order.
Thanks for answering. And I understand the problem... But why these folders are sorted correctly in Windows Explorer? Aren't the folders textual fields also?
Cu,
PoooMukkel

ZvezdanD
Posts: 3090
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 » Mon Feb 06, 2017 1:30 pm

PoooMukkel wrote:why these folders are sorted correctly in Windows Explorer?
Could you post the screenshot of it?
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

PoooMukkel
Posts: 223
Joined: Thu Jul 19, 2007 8:36 am
Location: Germany

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

Post by PoooMukkel » Mon Feb 06, 2017 4:26 pm

ZvezdanD wrote:Could you post the screenshot of it?
Sure...

Magic Nodes:
Image

Windows Explorer:
Image

Thanks for helping! :wink:
Cu,
PoooMukkel

ZvezdanD
Posts: 3090
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 » Mon Feb 06, 2017 6:16 pm

PoooMukkel wrote:Sure...
You are right. I don't know why Windows Explorer has such sorting, but in my opinion it is unexpected and incorrect. Total Commander doesn't have such sorting. My Computer node in MM Media Tree doesn't have such sorting either. And most importantly, SQLite, on which MM database is based, doesn't have such sorting.
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

PoooMukkel
Posts: 223
Joined: Thu Jul 19, 2007 8:36 am
Location: Germany

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

Post by PoooMukkel » Wed Feb 08, 2017 2:41 am

ZvezdanD wrote:Total Commander doesn't have such sorting.
My Total Commander 9.0a has such sorting and I didn't do anything for that behaviour...

Image

But if it is not possible to have such sorting in my magic nodes then that's the way it is. Thanks anyway! ;)
Cu,
PoooMukkel

ZvezdanD
Posts: 3090
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 » Wed Feb 08, 2017 3:36 am

PoooMukkel wrote:My Total Commander 9.0a has such sorting and I didn't do anything for that behaviour...
Well, I cannot remember if I did anything for that behavior either, but now when you mentioned it, I found that it has an option for that. I am just wondering which option is default in its Sort method combo box.
PoooMukkel wrote:But if it is not possible to have such sorting in my magic nodes then that's the way it is.
It is not currently possible, but I put it on my ToDo list. Thanks for suggestion.
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

PoooMukkel
Posts: 223
Joined: Thu Jul 19, 2007 8:36 am
Location: Germany

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

Post by PoooMukkel » Wed Feb 08, 2017 4:48 am

ZvezdanD wrote:...but I put it on my ToDo list. Thanks for suggestion.
Thanks for putting this on the ToDo list. :)
Cu,
PoooMukkel

Post Reply