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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

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 » Sun Oct 08, 2017 8:52 am

If I'm trying to isolate certain words in say, the title, how would I filter out any variations of that word?

For ex.,
If I do something like: <Title> Like '%polar%' OR <Lyrics> Like '%polar%'
How do I prevent it from including words that have that at their root, like "polarize"; without having to add negations
for all the variations to the filter?
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]

ZvezdanD
Posts: 3070
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 » Sun Oct 08, 2017 10:08 am

Well, without regular expressions, hardly. MM devs promised that they will implement regex to their database engine, but there is still nothing in sight.

It could be relatively simple if you have only space character in the front and/or the end of such word, but problem will rise if you have also some punctuation characters, e.g. dot or comma or dash or parentheses.

It would be much easier if you use RegExp Find & Replace for such things.
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

MagGyver
Posts: 79
Joined: Mon Oct 17, 2005 5:06 pm
Location: Venice Beach
Contact:

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

Post by MagGyver » Fri Oct 13, 2017 9:24 pm

Hi all, does anyone know if it's possible to create a node that lists tracks that were recently added to playlists? I know I can have a node that shows when tracks were added to the database, but I'd like one for when I add them to playlists. I'm getting turned around trying to modify an existing node for this...

Thanks!

ZvezdanD
Posts: 3070
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 » Sat Oct 14, 2017 1:35 am

MagGyver wrote:does anyone know if it's possible to create a node that lists tracks that were recently added to playlists?
That is not possible since the PlaylistSongs table, which contains information about files in playlists, doesn't contain a field with a date when file is added to the table.

However, the Playlist table, which contains information about playlists and their relations, contains information when a playlist is last modified in any way. This is not what you want, but just as a note.
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

MagGyver
Posts: 79
Joined: Mon Oct 17, 2005 5:06 pm
Location: Venice Beach
Contact:

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

Post by MagGyver » Sat Oct 14, 2017 12:25 pm

ZvezdanD wrote:
MagGyver wrote:does anyone know if it's possible to create a node that lists tracks that were recently added to playlists?
That is not possible since the PlaylistSongs table, which contains information about files in playlists, doesn't contain a field with a date when file is added to the table.

However, the Playlist table, which contains information about playlists and their relations, contains information when a playlist is last modified in any way. This is not what you want, but just as a note.
Thanks. 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?

ZvezdanD
Posts: 3070
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 » 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.
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

ZvezdanD
Posts: 3070
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 » 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>
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

SteveMills
Posts: 3
Joined: Sun Mar 22, 2015 11:24 am

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?

SteveMills
Posts: 3
Joined: Sun Mar 22, 2015 11:24 am

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

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

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

MPG
Posts: 210
Joined: Tue May 13, 2008 11:22 pm

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?
TIA
MPG
Totals:
Artists: 28,006
Albums: 66,333
Tracks: 493,635
Length: (h:mm:ss) 34,562:16:34
File size: 3.29TB

JimRPh
Posts: 2
Joined: Wed Feb 07, 2018 6:15 pm

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.

Lowlander
Posts: 44870
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 » 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.
Lowlander (MediaMonkey user since 2003)

JimRPh
Posts: 2
Joined: Wed Feb 07, 2018 6:15 pm

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.

stephensimpson53
Posts: 1
Joined: Sat Apr 09, 2016 1:11 pm

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?

Post Reply