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

[Champ19]

Perfect! Sorry for the confusion - I'm still a bit new to all of this. Really appreciate the help.

[Baeowulf]

Hello. Magicnodes is a great program.

I use the ISRC field to classify my music accordng to Lyrical Subject. This is very helpful with my movie soundtracks. Examples of my themes are CRIME; SEX; SCIFI; HORROR

I separate my themes with semi colons.

I need help programming my magic node so a Lyrical Subject (held in ISRC field) similarly to the way that MediaMonkey's Genre Node or Year Node list.

For example, if I have the following songs

"Jail Song" with ISRC field populated as CRIME
"Hot Girl Song" with ISRC populated as SEX
"Slasher Movie Song" with ISRC populated as SEX; CRIME; HORROR
"Future Heist Song" with ISRC populated as CRIME; SCIFI

and I am using this mask: Lyrical Subject|Child of:Library\<Isrc>

then my magic node shows the following results

-Lyrical Subject
--CRIME
--CRIME; SCIFI
--SEX
--SEX; CRIME; HORROR


This is incorrect. The result that I need in the node is

-Lyrical Subject
--CRIME
--HORROR
--SEX
--SCIFI


Although some of MediaMonkey's extant, builit-in nodes like COMPOSER could nest this information for me in the correct way, I am already using these fields. As I only have the ISRC field availbale how do I create a magic node that nests the semicolon separated values similarly to the way MediaMonkey naturally nests Genres, Composer and other multi-value fields.

Can you advise me?

[Guest]

This is incorrect. The result that I need in the node is...

Maybe it is not what you need, but it is correct. Such behavior is a result of MediaMonkey itself which has only Artist, Album Artist, Composer, Conductor, Lyricist, Genre, Tempo, Mood, Occasion and Quality as multi-item field. You would know that if you read What is New and Information sections for v3.0 - Added: support for multiple values with fields that are not multi-items, e.g. Involved people or CustomX, using Split by qualifier and Split part:-1 (mask example - Multi-item Custom 1 field in the Split examples branch). So, you should try this:

Code: Select all

Lyrical Subject|Child of:Library\<Isrc|Split by:; |Split part:-1>

[sugi]

Hello,

I just found the script and noticed how powerful it is, but I guess I need a little help starting out.
I have severall songs with multiple genres and want to build a node that only shows songs that both have the Soundtrack and the CD genre.
My current non-working version is:

Code: Select all

<Group|Name:Soundtracks...|Show tracks:No>\CDs|Filter:(<Genre> = 'Soundtrack') AND (<Genre> = 'CD')\<Custom 2>\<Custom 3>\<Album>

I also tried it without the brackets, results are the same. If I filter only for one genre I get results which for example contain "Anime; Soundtrack; CD" as genre, so there are songs that should match both filters, but still the list comes up as empty.
Any ideas what's wrong with my filter?

[Guest]

I have severall songs with multiple genres and want to build a node that only shows songs that both have the Soundtrack and the CD genre.

You could try this:

Code: Select all

<Group|Name:Soundtracks...|Show tracks:No>\CDs|Filter:(Songs.Genre Like '%Soundtrack%') AND (Songs.Genre Like '%CD%')\<Custom 2>\<Custom 3>\<Album>

If you have genres which contain "CD" in their name, it would be better to use this:

Code: Select all

<Group|Name:Soundtracks...|Show tracks:No>\CDs|Filter:(Songs.Genre Like '%Soundtrack%') AND ('; ' || Songs.Genre || '; ' Like '%; CD; %')\<Custom 2>\<Custom 3>\<Album>

[sugi]

Code: Select all

<Group|Name:Soundtracks...|Show tracks:No>\CDs|Filter:(Songs.Genre Like '%Soundtrack%') AND (Songs.Genre Like '%CD%')\<Custom 2>\<Custom 3>\<Album>

Thanks, that worked. Although I still dont understand why my variant does not.

[Guest]

I still dont understand why my variant does not.

Because <Genre> is single item, but Songs.Genre or <Multi Genre> is multi-item. For example, if you have one track which has "Soundtrack; CD" genre, resulting recordset would have two records for same track, one with <Genre> = "Soundtrack" and another with <Genre> = "CD", instead of one record with "Soundtrack; CD":
1. <Genre> = "Soundtrack", <Multi Genre> = "Soundtrack; CD"
2. <Genre> = "CD", <Multi Genre> = "Soundtrack; CD"

[sugi]

I still dont understand why my variant does not.

Ok, after playing a bit with SQL I think I understand why it doesn't work, although it feels strange if you only look on it from the user side.
As far as I understand MediaMonkey it stores all genres in a table like this

Code: Select all

GenreID | Genre
1       | Soundtrack
2       | CD

Then there's another table for the N:N connections:

Code: Select all

ID | SongID | GenreID
1  | 1      | 1
2  | 1      | 2

Which basically means that the song with the ID 1 is in genre 1 (Soundtrack) and in genre 2 (CD).
As the simple "<Genre> = 'Soundtrack'" filter turns into an SQL roughly like the following:

Code: Select all

SELECT SongID FROM SongGenreNN, Genre WHERE SongGenreNN.GenreID = Genre.GenreID AND Genre.Genre = 'Soundtrack';

And for the "<Genre> = 'Soundtrack' AND <Genre> = 'CD'" probably leads to something like this:

Code: Select all

SELECT SongID FROM SongGenreNN, Genre WHERE SongGenreNN.GenreID = Genre.GenreID AND Genre.Genre = 'Soundtrack' AND Genre.Genre = 'CD';

Which of course, never returns anything as that basically says "only use rows from the genre table when one row is Genre = 'Soundtrack' and that same row also has Genre = 'CD'".
It should work if the Genre table is joined into the query as many times as a genre check is done, and the 2nd check is done against the 2nd instance, but I assume that does not happen currently.

Thanks for the workaround!

[MonkeyBone]

Hello, monkey heads! hehe..

I was wondering if some here could help me with a somewhat difficult node..

The problem: I try to listen to all of my albums, from start to finish, to listen to all of the songs.. but, sometimes some songs are missed, I quit the listening of the album early, etc.. So, I want a node that can help me find, list and locate the the albums that have a difference in "Played #".

So, if I have an album that's been played, say, 5 times, and two of the songs on that album is played 6 times, I want that album to be listed..

Is this possible?!

If if is, it would be very cool (cause I have the same function with recently played albums), if it's possible to list 20 albums at random that has uneven(?) "played #" !?


Is it possible!?


EDIT: In other words, I want the find the albums, which songs in the album is not equally listened to..

Thank you very much for helping!

[Guest]

I want a node that can help me find, list and locate the the albums that have a difference in "Played #".

Select the "Albums with multiple multi-item Genres" mask and change "Genre" to "PlayCounter" in the Filter string.

[MonkeyBone]

Ah, thank you! I will try that..

But, can anyone export that node to me? I never added all the nodes that followed, I've just made my own that I'm using..

Or, is it any other way to easily access it?


Thanks, again!

[Vyper]

Code: Select all

<Group|Name:Albums with multiple...|Show tracks:No>\Albums with multiple multi-item Genres|Icon:Bottom level|SQL Filter:Songs.IDAlbum IN (SELECT IDAlbum FROM Songs WHERE IDAlbum > 0 GROUP BY IDAlbum HAVING Count(DISTINCT Genre) > 1)\<Album>\<Genre|Statistic:Count(All)>

[Guest]

can anyone export that node to me?

Code: Select all

<Group|Name:Albums...|Show tracks:No>\Albums with tracks having different Play count|Icon:Bottom level|Filter:Songs.IDAlbum IN (SELECT IDAlbum FROM Songs WHERE IDAlbum > 0 GROUP BY IDAlbum HAVING Count(DISTINCT PlayCounter) > 1)\<Album|Unknown:No>\<Genre|Statistic:Count(All)>

[MonkeyBone]

Thank you, all of you!! This was just aweome!!

God, I love this program.. !!

[Baeowulf]

This is incorrect. The result that I need in the node is...

Maybe it is not what you need, but it is correct. Such behavior is a result of MediaMonkey itself which has only Artist, Album Artist, Composer, Conductor, Lyricist, Genre, Tempo, Mood, Occasion and Quality as multi-item field. You would know that if you read What is New and Information sections for v3.0 - Added: support for multiple values with fields that are not multi-items, e.g. Involved people or CustomX, using Split by qualifier and Split part:-1 (mask example - Multi-item Custom 1 field in the Split examples branch). So, you should try this:

Code: Select all

Lyrical Subject|Child of:Library\<Isrc|Split by:; |Split part:-1>

[/color]

Thank you, this node worked great for splitting my semi-colon delimited descriptors into individual Magic Nodes.

Is it possible to have the same node in such a fashion that I can edit the split listings? That way I can edit mispellings such as

-Lyrical Subject Magicnode
--Comedy
--Crime
--Horror
--Horrrorr (need to fix spelling here so I'd like to edit this magic node listing)
--SciFi
--Television

Thanks!

Vic
using MM 3 Gold