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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

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

Re: Search for a Playlist and Display the Song Titles

Post by ZvezdanD » Sun Mar 11, 2018 10:16 am

stephensimpson53 wrote:no error messages...however, no songs either.
The PlaylistSongs table, which you are using in your query, represent a list of files contained only in static playlists. If you want to find out which files satisfy criteria of some auto-playlist, you need to know its SQL query.

Maybe you could try next Filter: <AutoPlaylist> = 'F1: 4 Stars'.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  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

TribalMethods
Posts: 1
Joined: Wed Mar 28, 2018 5:34 pm

Magic Nodes -- Have to Restart To Refresh Random Playlist

Post by TribalMethods » Wed Mar 28, 2018 5:38 pm

Hello,

I am new to MediaMonkey / Magic Nodes.

I am using the "Generate 1 track for each artist" magic node to create random playlists. It works great! However, to refresh the playlist (right click -> Refresh is greyed out,) I have to close & re-open MediaMonkey. Is there a way to get around this and refresh the playlist?

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

Re: Magic Nodes -- Have to Restart To Refresh Random Playlis

Post by ZvezdanD » Thu Mar 29, 2018 3:22 am

TribalMethods wrote:I am using the "Generate 1 track for each artist" magic node to create random playlists. It works great! However, to refresh the playlist (right click -> Refresh is greyed out,) I have to close & re-open MediaMonkey. Is there a way to get around this and refresh the playlist?
Are you talking about "One random Track from each Artist" node from the Magic Nodes \ Random folder? Did you modify its original mask supplied with the add-on? More specifically, did you move that node to the Playlists folder?

If that node is still in the Random folder, then the Refresh option should not be grayed out and it seems like a bug of the program itself. You could try to press F5 or you could select some another node and re-select the mentioned node again.

All Magic nodes outside of the Playlists branch behaves like auto-playlists, i.e. they are automatically refreshed every time when you select them again.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  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

mhendu
Posts: 80
Joined: Thu Jan 12, 2006 11:18 am

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

Post by mhendu » Sat Mar 31, 2018 9:53 am

I am using the Custom4 field in MediaMonkey to store a song's Work ID from Musicbrainz, and the Custom5 field to store the AcoustID. I'm trying to create a playlist of cover versions of songs that I've rated 5 stars, but where the 5 star song is not a classical work or a jazz recording (I use the Grouping field to indicate if a track is classical or jazz).

Parameters for the SQL query need to be something like this:

Same WorkID as a 5 star recording, where the Grouping of the 5 star recording is not 'Classical' or 'Jazz' (I am OK with classical or jazz covers of 5 star popular works)
Different AcoustID from any 5 star recording (eliminate duplicate recordings)
Rating < 5 stars (I don't want to include the 5 star songs themselves)

I created the following SQL query for a magic node:

Songs.Custom4 IN (SELECT Custom4 FROM Songs GROUP BY Custom4 HAVING Count(*) > 1 AND Max(Rating) > 99 AND Custom4 <> '' AND GroupDesc <> 'Classical' AND GroupDesc <> 'Jazz')

What this appears to include is the following:

Same WorkID as a 5 star recording
Classical or jazz tracks only if the classical or jazz track is rated 5 stars and there is another track with the same WorkID that is not classical or jazz, or if the classical or jazz track has the same WorkID as a 5 star recording that is not classical or jazz
Includes duplicates of the 5 star recording, and includes the 5 star recordings themselves

Somehow then I need to filter out the 5 star classical or jazz tracks and the tracks that have the same WorkIDs as those tracks, and I need to exclude the duplicates and the 5 star recordings. I'm not really sure where to start here.

I am a SQL novice at best - would appreciate any help to modify my query to accomplish what I'm looking to do with the magic node. Thanks in advance!

ZvezdanD
Posts: 3039
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 Apr 02, 2018 4:28 am

mhendu wrote:Rating < 5 stars (I don't want to include the 5 star songs themselves)
I am not sure that understand your requirement, it would be better if you gave some examples with tagged files that you have and which files you want to get. Anyway, if you want to get only files with Rating < 5 stars, then you should append AND Songs.Rating < 100 to your query.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  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

Braciata
Posts: 1
Joined: Fri Apr 27, 2018 12:31 pm

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

Post by Braciata » Fri Apr 27, 2018 12:36 pm

I would like to use
Genre, Artist, Album (with number of items)|Icon:Top level\<Genre|Statistic:Count(Items)>\<Artist|Statistic:Count(Items)>\<Album|Statistic:Count(All)>
also for thr Grouping field. This is what I did:
Grouping, Artist, Album (with number of items)|Icon:Top level\<Grouping|Statistic:Count(Items)>\<Artist|Statistic:Count(Items)>\<Album|Statistic:Count(All)>
It works but it doesn't separate multi values like Genres do. I get for example English; Piano; Vocal while I would like to get 3 separates values.
Any chance to work on it?

dnats
Posts: 12
Joined: Sat Aug 11, 2012 1:11 am

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

Post by dnats » Mon Apr 30, 2018 5:13 pm

How do I exclude a folder path in a query? Need to prevent the result to list songs from a mix folder.

ZvezdanD
Posts: 3039
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 » Thu May 03, 2018 10:03 am

Braciata wrote:It works but it doesn't separate multi values like Genres do. I get for example English; Piano; Vocal while I would like to get 3 separates values.
Any chance to work on it?
The Genre field is a multi-item one supported as that by the program, while Grouping is not. You could try nodes/masks from the Involved People folder; just replace the Involved People field (which is also non-multi-item field) with Grouping. Also, there are some nodes from the Split Examples folder that could be used with modification, e.g. "Multi-item Custom 1 field". The point is that you need to use the Split by qualifier with the specified "; " string. You could read about its use in the Usage section on the add-on's Web page.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  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

ZvezdanD
Posts: 3039
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 » Thu May 03, 2018 10:09 am

dnats wrote:How do I exclude a folder path in a query? Need to prevent the result to list songs from a mix folder.
You could use Filter: <Folder> NOT LIKE 'c:\your_path\%'
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  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

Post Reply