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

Post a reply

Visual Confirmation

To prevent automated access and spam, you are required to confirm that you are human. Please place a check mark next to all images of monkeys or apes. If you cannot see any images, please contact the Board Administrator.

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON
Topic review
   

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

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.

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!

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 -- 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?

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'.

Search for a Playlist and Display the Song Titles

Post by stephensimpson53 » Sun Mar 11, 2018 9:41 am

I am trying to get Magic Nodes 5.x to locate the autoplaylist named 'F1: 4 Stars' which is a Child of another playlist in MM4.x. After it locates the autoplaylist named 'F1: 4 Stars', I will want it to display only 30 random songs from that playlist. This is what I have so far. This is my first real attempt at trying to create a major Filter with MN.

Code: Select all
<Group|Name:Tasks>\In Particular Autoplaylist|Filter:Songs.ID IN (SELECT IDSong FROM PlaylistSongs INNER JOIN Playlists ON Playlistsongs.IDPlaylist IN (SELECT IDPlaylist FROM Playlists WHERE Playlists.PlaylistName = 'F1: 4 Stars'))


Finally after 2 days, no error messages...however, no songs either. Actually, after the script runs I get nothing. What am I doing wrong?

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

Post by JimRPh » Wed Feb 07, 2018 7:33 pm

Thanks lowlander. Found the file was SQLite. Found utility "DB Browser for SQLite" that said the file was locked. Downloaded Microsoft's Process Explorer. Turned out MediaMonkey was still running, despite what the taskbar icon showed. I killed the process. Now, my library is back. First item of business is backup.

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

Post by Lowlander » Wed Feb 07, 2018 7:06 pm

You could try MediaMonkey 5 from it's own forum and see if it can maintain your Library. It can do this better than MediaMonkey 4.

Library corrupted?

Post by JimRPh » Wed Feb 07, 2018 6:21 pm

I installed this script. I looked at the node for songs in 2 or more playlists. I then added a song in one playlist to another playlist and didn't see a change. So, I decided to exit MediaMonkey and restart it. Noww I get an error message that my Library File can't be opened. Sadly, it was not backed up and as I just started using MediaMonkey, I had done a lot of work on setting up a lot of filtered views. Is there any way to recover this file? Thanks.

Magic Nodes Experts

Post by MPG » Thu Nov 02, 2017 10:14 pm

I have a challenge for all you Magic Nodes experts!
I'm looking for a query that will return a random list of albums where:
1) I have all of the songs on the album
2) I have not listened to all of the songs on the album (if you can get it to be an album where I haven't listened to any of the songs....even better)
3) They are in the genre of Blues, Classical, Comedy, Country, Documentary, Easy Listening, Jazz, Pop, or Rock
4) Return a maximum of 40 albums.

Any takers?

Re: magic nodes filter by <Type> fails

Post by ZvezdanD » Fri Oct 27, 2017 2:59 am

SteveMills wrote:The "manual" is 9 years old and for a previous version. I am using MN 4.3.1 on MM 4.1.18.1853 Gold

The manual implies that Type is not a valid field.

The manual is 9 years old indeed, but the add-on's Web page and its Usage section is quite new and up to date.

If some field cannot be found in the Fields and Filter combo boxes in the Mask Settings dialog box, then it is not supported.

By the way, the donation-only version has a support for the fields added in MM4 as Type:
v5.0 - 2014-04-19
* Added: new MM4 fields: Actor(s), Producer, Season #, Episode #, Episode # - Title, Parental Rating, Framerate, Resolution, Video Width, Video Height, Bookmark, Start Time, Stop Time, Skipped #, Type

magic nodes filter by <Type> fails

Post by SteveMills » Thu Oct 26, 2017 7:27 pm

LET ME TRY AGAIN:
>For a "MagicNode", I would like a filter of:
><Type> = 'Classical Music' but that does not seem to be accepted.
>Suggestions?

When I try to open a node with that filter, I get the message:

"The mask defining this Magic Node produced an error. ... probably resides in the Filter or SQL filter ..."

The "manual" is 9 years old and for a previous version. I am using MN 4.3.1 on MM 4.1.18.1853 Gold

The manual implies that Type is not a valid field.

---
How can I filter a Magic Node to show only Type='Classical Music'???

magic node filter

Post by SteveMills » Thu Oct 26, 2017 1:54 pm

For a "MagicNode", I would like a filter of:

<Type> = 'Classical Music'

but that does not seem to be accepted.

Suggestions?

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

Post by ZvezdanD » Sun Oct 15, 2017 2:31 am

This mask works only in MM4 with MN5.x:
Code: Select all
<Group|Name:Playlists...>\Songs in playlists modified in last <ID:1> days|Icon:Top level|Filter:julianday('now') - julianday(Playlists.LastModified) <= <Number|Caption:Maximum number of days|Value:7|MinValue:1|MaxValue:1000|ID:1>\<Playlist>

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

Post by ZvezdanD » Sat Oct 14, 2017 2:55 pm

MagGyver wrote:So if I wanted to use this information somehow (about when playlist is last modified) in a node, would it give me a workaround for the list I'm looking for?


I don't know what you mean by "workaround". As I said, you cannot find a date when some particular file is added to the playlist. There is no a workaround for such thing. But there is information when some playlist was modified and that info could be used in Filter, e.g. to display all files from playlists that are modified on a specified date, or something like that. "Modified" means that some file is added to or removed from or moved inside a playlist.

Top