Page 154 of 161

Re: How do you use Magic Nodes in MM 4.1.14.1813

Posted: Tue Dec 27, 2016 10:35 am
by dtsig
You need to post these questions in the Magic Nodes forum in addons section. You will get much quicker response

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

Posted: Tue Jan 03, 2017 6:21 am
by willyvds
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

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

Posted: Tue Jan 03, 2017 2:02 pm
by ZvezdanD
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>)

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

Posted: Tue Jan 03, 2017 3:29 pm
by jgt1942
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.

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

Posted: Tue Jan 03, 2017 9:13 pm
by Lowlander
Magic Nodes doesn't edit files, for that you'll need RegExp Find & Replace.

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

Posted: Tue Jan 03, 2017 11:07 pm
by MMFrLife
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

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

Posted: Mon Feb 06, 2017 4:26 am
by PoooMukkel
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.

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

Posted: Mon Feb 06, 2017 7:46 am
by ZvezdanD
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

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

Posted: Mon Feb 06, 2017 12:12 pm
by PoooMukkel
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?

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

Posted: Mon Feb 06, 2017 1:30 pm
by ZvezdanD
PoooMukkel wrote:why these folders are sorted correctly in Windows Explorer?
Could you post the screenshot of it?

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

Posted: Mon Feb 06, 2017 4:26 pm
by PoooMukkel
ZvezdanD wrote:Could you post the screenshot of it?
Sure...

Magic Nodes:
Image

Windows Explorer:
Image

Thanks for helping! :wink:

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

Posted: Mon Feb 06, 2017 6:16 pm
by ZvezdanD
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.

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

Posted: Wed Feb 08, 2017 2:41 am
by PoooMukkel
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! ;)

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

Posted: Wed Feb 08, 2017 3:36 am
by ZvezdanD
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.

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

Posted: Wed Feb 08, 2017 4:48 am
by PoooMukkel
ZvezdanD wrote:...but I put it on my ToDo list. Thanks for suggestion.
Thanks for putting this on the ToDo list. :)