MediaMonkey forum

Posted: **Wed Feb 10, 2010 2:52 pm**

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

Posted: **Sun Feb 14, 2010 11:19 pm**

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?

Posted: **Mon Feb 15, 2010 4:52 am**

Baeowulf wrote: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>

Posted: **Wed Feb 17, 2010 6:51 am**

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?

Posted: **Wed Feb 17, 2010 11:23 am**

sugi wrote: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>

Posted: **Thu Feb 18, 2010 4:52 am**

Guest wrote:

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.

Posted: **Thu Feb 18, 2010 6:03 am**

sugi wrote: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"

Posted: **Thu Feb 18, 2010 6:39 am**

sugi wrote: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!

Posted: **Fri Feb 19, 2010 5:51 am**

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!

Posted: **Fri Feb 19, 2010 9:36 am**

MonkeyBone wrote: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.

Posted: **Fri Feb 19, 2010 9:47 am**

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!

Posted: **Fri Feb 19, 2010 8:32 pm**

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

Posted: **Sat Feb 20, 2010 3:46 am**

MonkeyBone wrote: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)>

Posted: **Sat Feb 20, 2010 4:58 am**

Thank you, all of you!!

This was just aweome!!

God, I love this program.. !!

Posted: **Sun Feb 21, 2010 1:32 pm**

Guest wrote:
Baeowulf wrote: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

MediaMonkey forum

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

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]

Re: Magic Nodes 3.0 w/ 245 masks & real GUI (2009-09-08) [MM2+3]