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

[zephyr]

Zve you are simply brilliant - thank you again!

Does ANYONE know how to convert this simple mask to show tracks by any album artist with less than 3 tracks?

Code: Select all

<Group|Name:Artist Ratings|Show tracks:No>\Artists with less than 3 tracks|Icon:Top level|Filter:Songs.Artist IN (SELECT Artist FROM Songs GROUP BY Artist HAVING Count(*) < 3)\<Artist|Statistic:Count(Tracks), Avg(Rating)>

THANKS!

[zephyr]

Sorry, one more question -

I have an album (Balkanica! by dunkelbunkt)

One track (5) is present, as are 2 others (without track numbers).

This hasn't been picked up by the incomplete album finder nodes.

Code: Select all

<Group|Name:Albums...|Show tracks:No>\Incomplete Albums (Bex's algorithm)|SQL Filter:Songs.IDAlbum IN (SELECT IDAlbum FROM (SELECT Songs.IDAlbum IDAlbum FROM Songs, (SELECT IDAlbum, SUM(Non3Digits) AS CountNon3Digits, SUM(Cnt) AS Cont FROM (SELECT IDAlbum, COUNT(CASE WHEN Length(TrackNumber) = 3 THEN NULL ELSE 1 END) as Non3Digits, COUNT(*) AS Cnt, COUNT(CASE WHEN TrackNumber = '' THEN NULL ELSE 1 END) AS NonBlanks, MAX(Cast(TrackNumber as INTEGER)) AS MaxNr, COUNT(CASE WHEN SongLength >= 2400000 THEN 1 ELSE NULL END) AS SngLngth FROM Songs WHERE IDAlbum > 0 GROUP BY IDAlbum, TrackNumber) AS Inline1 GROUP BY IDAlbum HAVING COUNT(*) = SUM(Cnt) AND SUM(Cnt) = SUM(NonBlanks) AND MAX(MaxNr) > SUM(Cnt) AND (SUM(SngLngth) > 0 OR SUM(Cnt) >= 2)) Inline2 WHERE Songs.IDAlbum = Inline2.IDAlbum AND Songs.IDAlbum > 0 GROUP BY Songs.IDAlbum, CASE WHEN CountNon3Digits = 0 THEN Substr(TrackNumber, 1, 1) ELSE '0' END HAVING Cast(Substr(MIN(TrackNumber), -2, 2) as INTEGER) || (MAX(Cast(TrackNumber as INTEGER)) - MIN(Cast(TrackNumber as INTEGER)) + 1 - COUNT(*)) <> '10' AND MAX(cast(TrackNumber as INTEGER)) >= COUNT(*)) GROUP BY IDAlbum)\<Album with album artist|Statistic:Count(Tracks), Max(Track Number)>


Any ideas why? ANy adjustments to the mask that can be made (or advice on another approach)

[ZvezdanD]

Does ANYONE know how to convert this simple mask to show tracks by any album artist with less than 3 tracks?

Just replace all Artist to AlbumArtist.

[ScottBolton]

Can I concatenate tags together so that I see

Code: Select all

"2 - 2000 - Mi Reflejo"

No, currently you cannot concatenate tags with Magic Nodes, but you could get the next format "2 - Mi Reflejo (2000)" or "2000 - Mi Reflejo (2)". Please read the PDF manual and the description of Sort by and Statistics qualifiers.

I opted for the

Code: Select all

2 - Mi Reflejo (2000)

option using this mask:

Code: Select all

<Group|Name:Master:|Show tracks:No>\Discographies|child of:Artist|icon:top level|MM filter:Music|Filter:<Custom 1> <> ''\<Album Artist|trim:1>\<Album Artist>\<Album|Statistic:Max(Year)|Sort by:Max(Custom 1)>

Thanks for the pointers.

S

[MarkODD]

Zvezdan wrote
It would be better if you edit "Tracks with same Title and Bitrate from same Artists" replacing all Bitrate with <Version>. By the way, it seems that you are using some old version of this add-on. It is recommended to install the latest one.

Great idea Zvezdan, thanks. It works perfect. Only 2660 duplicate tracks to edit now.

[bp011ysp]

Hello!
Is there a solution to access Magic-Node Trees via UPNP can be.
If it's not currently possible, then my question is whether this is being planned.
Thanks.

[Lowlander]

Magic Nodes can't be made available for DLNA sharing.

[bp011ysp]

Why MediaMonkey is not extended, that can also be accessed on any other node via UPNP.

[ZvezdanD]

Why MediaMonkey is not extended, that can also be accessed on any other node via UPNP.

Well, you should post that question in the Wishlist forum. I cannot do anything about it since MM programming interface doesn't allow such thing.

[Lowlander]

Well, you should post that question in the Wishlist forum.

Was already done: viewtopic.php?f=4&t=65435

[ZvezdanD]

Well, you should post that question in the Wishlist forum.

Was already done: viewtopic.php?f=4&t=65435

Check the posts dates. Its done after my suggestion.

[rkghadai]

Hi..I need the mask to show only those albums with at least 3 songs with rating 3 or more. Right now i use: Albums|Child of:Artist|Filter:<Rating> >= 60\<album|Min tracks:3>\<year>

But this filters out all songs below rating 3. How can I make it show all songs in an album if any three of them have rating >=3.

[ZvezdanD]

Hi..I need the mask to show only those albums with at least 3 songs with rating 3 or more.

You could use the predefined "Albums with at least 3 songs with track rating >= 4 stars" mask from the "Album Ratings" group, just adjust the rating value.

[kazadharri]

Is there a list of what the stock (380) modes do, other than opening up each one individually at looking at it? My SQl skills are very bad and I am trying to find a mask which I could modify or create that would give me the top rated tracks by artist?

What I would like is a list sorted by artist that would show me the top 5 or say ten tracks by rating, then play count. If there are more tracks with the same rating. Say Beatles with 40 tracks of 5 stars, then the tracks would be sorted by must played?

Thanks, Jeff

[keiju (cant login!!!)]

Hi.

I´ve tried the documentation, searching the forums and looking how the default magic nodes are set but I dont know how to do what I want to do.

Let´s say I have 4 songs in mediamonkey with the 3th custom fields (named "Pais" meaning country) like this:

song1 USA
song2 UK;USA
song3 UK:Spain
song4 Spain

I need a magic node that gives me this:

Code: Select all

Pais
  -Spain
      -band3
           -album3
                -song3
      -band4
           -album4
                -song4
  -UK
      -band2
           -album2
                -song2
      -band3
           -album3
                -song3
  -USA
      -band1
           -album1
                -song1
      -band2
           -album2
                -song2

The only thing I´ve got to work separates the USA;UK songs from the just USA or UK subnodes.

I´m not sure If I got to explain myself but I hope I did.

Can you help me?
Thanks in Advance!