help with magic nodes

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

rshane91
Posts: 18
Joined: Tue Aug 23, 2005 2:16 pm

help with magic nodes

Post by rshane91 » Sat Sep 17, 2005 7:59 pm

Looking for a little help with Magic Nodes.

First -- I want to be able to show songs that have the same <artist> and <title> as another song in the library. Basically a way to show duplicate songs (by the same artist).

I tried to use the "|min tracks:2" but can't figure out how to get it to treat <artist> AND <title> together when it does the compare.

Any ideas?

Second -- I would like to do the same thing as above but only for songs that have <composer> = "IPOD".

This is so i can have duplicated in my library if the same song appeared on 2 different albums -- but ensure that one is tagged to sync to my IPOD. I use <composer> = "IPOD" for the files i want to sync to the ipod.

Any help is greatly appreciated.

thanks

rshane91
Posts: 18
Joined: Tue Aug 23, 2005 2:16 pm

Post by rshane91 » Sun Sep 18, 2005 8:46 pm

ok -- i got it to work in Microsoft access using the Media Monkey database.

SELECT [Songs]![IDArtist] & " - " & [Songs]![SongTitle] AS Expr1, Count([Songs]![IDArtist] & " - " & [Songs]![SongTitle]) AS Expr2
FROM Songs
WHERE (((Songs.Author) Like "*IPOD*"))
GROUP BY [Songs]![IDArtist] & " - " & [Songs]![SongTitle]
HAVING (((Count([Songs]![IDArtist] & " - " & [Songs]![SongTitle]))>2));


Any idea how do i move it to magic nodes -- or to do duplicate the functionality in magic nodes?

thanks

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK
Contact:

Post by trixmoto » Tue Sep 20, 2005 3:19 am

I'm not good with SQL and fairly new to Magic Nodes, but don't you just create a node like this:

Duplicates|SQL filter:_yourSQL_\<artist>

rshane91
Posts: 18
Joined: Tue Aug 23, 2005 2:16 pm

Post by rshane91 » Tue Sep 20, 2005 11:48 am

i tried but it didn't work. Maybe it's a syntax issue.

Any help?

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

Post by Bex » Tue Sep 20, 2005 7:56 pm

These works, but they are slow on big collections...

Code: Select all

Dups|SQL filter: IDArtist&SongTitle IN (SELECT IDArtist&SongTitle FROM Songs GROUP BY IDArtist&SongTitle HAVING Count(Songs.ID)>1)\<Artist>

Code: Select all

DupsIPOD|SQL filter: IDArtist&SongTitle IN (SELECT IDArtist&SongTitle FROM Songs WHERE Songs.Author Like '%IPOD%' GROUP BY IDArtist&SongTitle HAVING Count(Songs.ID)>1)\<Artist>
BTW the first code does exactly what the "Duplicate Titles" node does.

Enjoy!

rshane91
Posts: 18
Joined: Tue Aug 23, 2005 2:16 pm

Post by rshane91 » Wed Sep 21, 2005 1:31 pm

thanks a lot. :)

stax76
Posts: 176
Joined: Sun Mar 12, 2006 6:45 am

Post by stax76 » Sun Apr 09, 2006 8:47 am

Whould it be possible having two nodes, one for duplicates that have a different file path and one for duplicates that have identical file path?

Hollowdays

Post by Hollowdays » Mon Jul 02, 2007 7:50 pm

Is one of those codes for finding Duplicate songs?

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

Post by Bex » Tue Jul 03, 2007 1:24 am

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

Hollowdays
Posts: 2
Joined: Mon Jul 02, 2007 7:53 pm

Post by Hollowdays » Tue Jul 03, 2007 1:42 am

thankyou Bex it works well

Post Reply