Magic Nodes 1.3b (IS OUTDATED SEE NOTE IN FIRST POST)

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Sun Sep 10, 2006 1:08 pm

1. You must use "or songpath like", since "or like" will not work.
2. Since you use OR you must also enclose the statement with ()
3. Remove * (In Access you use * in SQL you use %)
4. If you want you can remove :&chr(92)& in the beginning of the paths, but keep the % (makes the code shorter)

Like this:

Code: Select all

Complete albums2|icon:bottom level|SQL filter: (songpath Like '%Music Library&chr(92)&albums%' Or songpath Like '%Music library&chr(92)&emusic%')\<artist|sort order:asc>\<album>

/Bex
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

danflan
Posts: 7
Joined: Wed Jul 05, 2006 7:05 am
Contact:

sort albums by date added

Post by danflan » Sun Sep 10, 2006 4:13 pm

I can't figure out the different functions. How would I create a sort by date added when displaying Albums

I tried the following:

Code: Select all

Most Recent\<album|sort by:max(dateadded)|sort order:desc>

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Sun Sep 10, 2006 4:36 pm

Sort by Max(Date Added) doesnt work. I dont no why, seems to be a bug.

I use this mask to achieve almost the same thing.

Code: Select all

Albums Added Last Week|SQL filter:DateDiff('d',Songs.DateAdded,Now)<7\<date added|sort order:desc>\<Album>
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

MCSmarties
Posts: 248
Joined: Tue Dec 06, 2005 8:01 pm

Small question...

Post by MCSmarties » Mon Sep 11, 2006 8:59 am

I'd like to make a magic node for "Style" (which I store in my <Custom1> field.
How can I add the "genre" icon to my node without making it an actual subnode of genre?

Code: Select all

Style|child of:genre|icon:top level\<Style>
gives the default library icon (but places the new node at top level, below Genre)

Of course I can do something like:

Code: Select all

Style by genre|child of:genre|icon:top level\<Genre>\<Style>
but that's not exactly what I want...

Guest

Post by Guest » Thu Sep 14, 2006 9:50 am

Currently I have my magic nodes as:
Album Title
Album Artist
Year
Soundtracks
Comedy

To get the soundtrackand comedy nodes I used the quarantine example by placing the tracks into a soundtrack folder or the comedy folder. What I now want to do is to exlude any soundtrack or comedy track from appearing in the album title, artist or year nodes
Album Artist|child of:artist\<album artist|trim:1>\<album artist>\<album>

What would I add to the above to make that work, thanks in advance and I'm sorry if this is simple but I'm new to this.

Col

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Thu Sep 14, 2006 11:06 am

Add a sql filter to those nodes which would be the existing sql filter you have in the Comedy and Soundtrack Magic Nodes but with NOT LIKE instead of LIKE.

Like this,
In your Comedy and Soundtrack nodes you use this method:

Code: Select all

SQL filter:Songs.SongPath LIKE '%quarantine%'
To eclude the above In the other nodes then use:

Code: Select all

SQL filter:Songs.SongPath NOT LIKE '%quarantine%'

/Bex
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Guest

Post by Guest » Thu Sep 14, 2006 1:15 pm

Brilliant. Thanks. I'll give it a go as soon as I can get the chance.

Guest

Post by Guest » Thu Sep 14, 2006 2:52 pm

It works. But what is the correct way to string multiple not likes.
SQL filter:Songs.SongPath NOT LIKE '%Comedy%'

and also not like '%Soundtracks%' into the above.

It's probably another simple thing, but I keep getting an error.

Thanks for your time.

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Thu Sep 14, 2006 3:49 pm

Code: Select all

SQL filter:Songs.SongPath NOT LIKE '%Comedy%' and Songs.SongPath NOT LIKE '%Soundtracks%'
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Guest

Post by Guest » Thu Sep 14, 2006 4:53 pm

Brilliant, I'm in your debt. Just one last thing. Is there anyway to get rid of the title node?

Thanks, and after that I shall trouble you no more.

Col.

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Thu Sep 14, 2006 5:03 pm

It can be done with the TweakMonky script made by Teknjonky:
http://www.mediamonkey.com/forum/viewtopic.php?t=8939

No problem 8)

/Bex
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

punking
Posts: 2
Joined: Mon Jun 12, 2006 10:22 pm

Post by punking » Fri Sep 15, 2006 6:03 am

Hi

This is a great script and really allows you to unleash some power in mediamonkey but I have a couple of more questions:

Album Artist|child of:artist|SQL filter:Songs.SongPath NOT LIKE '%soundtracks%' and Songs.SongPath NOT LIKE '%Audio Comedy%' and Songs.SongPath NOT LIKE '%Recordings%'\<Album Artist>\<Album|Sort by:max(year)>

The above filters out all tracks located in the 'soundtracks' folder, the 'audio comedy' folder and the 'Recordings' folder. It then displays Album Artists, then Albums by year. The odd thing is that the first Artist is 'They Might be Giants' above 'Adam & the Ants'. Which is not in alphabetical order. Does anybody know why this happens?

The scond question is that I wnt to remove the title node using tweakmonkey but it will not go away. I uncheck everything in Tweakmonkey including Library, but when I restart the cheeky checkmarks are back in the library, and the title node is still there. Could be because I have set my magic nodes as child of artist, or album, and one is of year?

Thanks.

Guest

Post by Guest » Sun Sep 17, 2006 1:34 pm

I'd like to rearrange my music into 2 categories,
which are, western and eastern.

Please help. I'll make my MediaMonkey much more
easy to manage.

Thanks

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Mon Sep 18, 2006 2:15 pm

punking wrote:Hi

This is a great script and really allows you to unleash some power in mediamonkey but I have a couple of more questions:

Album Artist|child of:artist|SQL filter:Songs.SongPath NOT LIKE '%soundtracks%' and Songs.SongPath NOT LIKE '%Audio Comedy%' and Songs.SongPath NOT LIKE '%Recordings%'\<Album Artist>\<Album|Sort by:max(year)>

The above filters out all tracks located in the 'soundtracks' folder, the 'audio comedy' folder and the 'Recordings' folder. It then displays Album Artists, then Albums by year. The odd thing is that the first Artist is 'They Might be Giants' above 'Adam & the Ants'. Which is not in alphabetical order. Does anybody know why this happens?

The scond question is that I wnt to remove the title node using tweakmonkey but it will not go away. I uncheck everything in Tweakmonkey including Library, but when I restart the cheeky checkmarks are back in the library, and the title node is still there. Could be because I have set my magic nodes as child of artist, or album, and one is of year?

Thanks.
1. It's a sort bug. It has been fixed by ZvezdanD in this unofficial code:
http://www.mediamonkey.com/forum/viewto ... 6725#56725

2. It seems that you can't remove the Title node, I dont know why.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Mon Sep 18, 2006 2:15 pm

Anonymous wrote:I'd like to rearrange my music into 2 categories,
which are, western and eastern.

Please help. I'll make my MediaMonkey much more
easy to manage.

Thanks
What do you mean?
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Locked