Page 32 of 46
Posted: Wed Nov 08, 2006 6:01 am
by Note
harpagornis
Delete the space before the word filter. It should work.
Posted: Thu Nov 09, 2006 1:23 pm
by Guest
thx for the help! problem solved
Using Magic nodes to filter songs by # of tracks
Posted: Wed Nov 15, 2006 12:11 pm
by MCSmarties
Hi,
I would like to use magic nodes to help me conditionally organize my files.
I
posted in a separate thread but since it concerns the use of magic nodes masks
I thought I would link it into this thread as well.
Thanks!
Posted: Wed Nov 29, 2006 11:53 am
by MCSmarties
bump... sorry
Posted: Wed Nov 29, 2006 4:45 pm
by Bex
This should do it:
Code: Select all
Artist with less than 5 tracks|SQL Filter: IDArtist in (SELECT IDArtist FROM Songs GROUP BY IDArtist HAVING IDArtist>0 AND Count(*)<5)\<Artist>
Extremely slow on big collections though...I didn't have time to let it ran to the end but it should work as expected.
Posted: Thu Nov 30, 2006 9:24 am
by MCSmarties
Thanks a lot, Bex. I will try this out tonight.
So, can I also expand on that code to get the following nodes as well (just guessing here!):
Code: Select all
Albums with more than 5 tracks|SQL Filter: IDAlbum in (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING IDAlbum>0 AND Count(*)>4)\<Album>
Albums with less than 5 tracks from artists with more than 5 tracks|SQL Filter:IDAlbum in (SELECT IDArtist FROM Songs GROUP BY IDArtist HAVING IDArtist>0 AND Count(*)>4 AND GROUP BY IDAlbum HAVING IDAlbum>0 AND Count(*)<5)\<Album>
I bet I just coded nonsense!
Again, the important part is to get all the tracks fitting the filter on one level in the node, so I can then select them all at once and apply the corresponding Autoorganize criterion.
Thanks for your help!
Posted: Thu Nov 30, 2006 10:29 am
by Bex
Yeah, the first one is correct!
But the second one should be like this:
Code: Select all
Albums with less than 5 tracks from artists with more than 5 tracks|SQL Filter: IDAlbum in (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING IDAlbum>0 AND Count(*)<5) and Songs.IDArtist in (SELECT IDArtist FROM Songs GROUP BY IDArtist HAVING IDArtist>0 AND Count(*)>5)\<Album>
To get all the tracks into the main window simply click on the main node itself.
Posted: Fri Dec 01, 2006 2:21 pm
by MCSmarties
Thanks Bex!! Haven't had the time to really test it
but a quick glance seemed to show that it works...
Posted: Sat Dec 02, 2006 3:25 am
by narticus
Couldn't find if this was asked already, but:
Is it possible for a magic node to, not only, sort artists by the first letter/number in their name, but to ignore "The"s at the same time? I have a magic node right now that sorts them by the first letter (<album artist|trim:1>\<album artist>\<album>).
Is there some kind of filter I can add to that that will skip over "The"s when sorting? (ie: The Beatles, The Rolling Stones, etc.)
Any help would be appreciated.
Posted: Sat Dec 02, 2006 3:39 am
by Bex
Posted: Sat Dec 02, 2006 4:06 am
by narticus
Ah, thank you so much. Just saved me quite some time. It would've taken me a while to get to pg 25!
Posted: Sun Dec 03, 2006 7:52 am
by danio
Ok, I'm stuck...
I wanted to construct a node which gives me a list of Albums added based on a timeline, from most recent to oldest, grouped by year, then month then day.
I've got this so far, which gives me the list of Albums added by day, but cannot easily see how to further tighten that grouping to be by year, then month?
Code: Select all
Time since Album added|icon:top level|show tracks:no|<group by:max(days since added)>\<Date Added|sort order:desc>\<Album Artist>\<Album>
Can anyone suggest how I could achieve that please?
Order?
Posted: Tue Dec 05, 2006 5:23 am
by votrexflame
I hope I didn't overlook the post about it, but can anyone tell me if it's possible to "move" a note up or down within a Magic Node tree? If it's possible, can you describe how?
Thanks a lot for such a great script!
Posted: Tue Dec 05, 2006 7:15 am
by Note
votrexflame
The order (under the MN node) is determined by the Mask# in the ini file.
To change the order - Open Mediamonkey.ini from ..\My Music\MediaMonkey
Find the heading [CustomNodeMasks]
Change the Mask numbers to sort the nodes the way you want them displayed, eg Mask7= would become Mask6= and the previous 6 is changed to 7.
I've noticed that, as magic nodes are added and deleted, the ini entries get a little messy. The only way to tidy them (that I know of) is manually, as described above. Would be handy if the script could auto re-sort the entries. Beyond my compass, though.
Hope that helps.
Posted: Tue Dec 05, 2006 12:08 pm
by tirefire
I'm sure this is an easy node to make, but I've been trying to come up with something for the past day or so, and it's still over my head.
I have a custom field 'Mix' which I flag with a 'Y' for tracks that are part of a mixtape. I want a node that displays only those flagged tracks, and has them grouped by genre like:
-Mixtapes
--Afro-Jazz
--Blues
--Booty Bass
and so on
This is the stub I've been working on. What have I done wrong so far, and/or what do I need to do from here?
Mixtapes|filter:mix=Y|icon:top level\<genre>