Moving my music collection to a bigger heard drive did not go smoothly and I have some grayed out (orphaned) tracks and extra copies stored outside my primary library folder.
All my active tracks are stored in the folder "O:\Audio files\' whereas there is alternate storage in 'O:\Extra Music copies 2\' and
'Z:\Gary's Documents\My Music\'. Also the grayed out tracks show up and having that may give me a useful clue as to what CDs might have to be ripped again.
My goal is to have a copy of all tracks rated 2-1/2 or higher located in the \Audio files\ folder (I know how to Move them).
Since multiple copies of a track may have different ratings, I'd need to select all copies of a track even if only one had a rating>=2-1/2 stars.
Can someone please help me with a Magic Node specification that will show all tracks (sorted by artist,title,path) where at least one copy of artist-track is rated 2-1/2 stars or More?
thanks
Gary
Newbie to Magic Nodes, need help with orphaned tracks
-
- Posts: 68
- Joined: Sat Nov 24, 2007 6:16 pm
Re: Newbie to Magic Nodes, need help with orphaned tracks
I am not sure that understand what you want, but I think that you could try this mask:
You could also try this:
Code: Select all
<Group|name:Tracks...|Show tracks:No>\Duplicates where at least one track is rated 2.5 stars or more|Icon:Top level|Filter:Songs.SongTitle || '@' || Songs.Artist COLLATE IUnicode IN (SELECT SongTitle || '@' || Artist COLLATE IUnicode AS GroupField FROM Songs GROUP BY GroupField HAVING Count(*) > 1 AND Max(Rating) > 49)\<Title|Trim:1>\<Title with artist>
Code: Select all
<Group|name:Tracks...|Show tracks:No>\Duplicates with maximal rating|Icon:Top level|Filter:Songs.ID IN (SELECT ID FROM Songs WHERE SongTitle || '@' || Artist || '@' || Rating COLLATE IUnicode IN (SELECT SongTitle || '@' || Artist || '@' || Max(Rating) COLLATE IUnicode FROM Songs GROUP BY Artist, SongTitle COLLATE IUnicode HAVING Count(*) > 1) GROUP BY Artist, SongTitle COLLATE IUnicode)\<Title|Trim:1>\<Title with artist|Statistic:Count(All)>
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
-
- Posts: 68
- Joined: Sat Nov 24, 2007 6:16 pm
Re: Newbie to Magic Nodes, need help with orphaned tracks
Thank you ZvezdanD; that's a big help.
I'm working with the first construct and it looks like it's doing just what I want. I tweaked it to show the entire song title and artist, which appears more useful to me.
I'm working with the first construct and it looks like it's doing just what I want. I tweaked it to show the entire song title and artist, which appears more useful to me.
-
- Posts: 68
- Joined: Sat Nov 24, 2007 6:16 pm
Re: Newbie to Magic Nodes, need help with orphaned tracks
Almost home, but I need a refinement.
For each artist-track rated 2-1/2 stars or more, I need to find those which are not in my main music folder. I have a custom field (#1) which contains 'Yes' which I posted in all tracks in the folder 'O:\Audio Files". So I also want track that don't have a yes in any Custom1 fields.
I saw a sample Magic Node which CASt TrackNumber as an integer that was used in MAX(); maybe I need to do that.
For each artist-track rated 2-1/2 stars or more, I need to find those which are not in my main music folder. I have a custom field (#1) which contains 'Yes' which I posted in all tracks in the folder 'O:\Audio Files". So I also want track that don't have a yes in any Custom1 fields.
I saw a sample Magic Node which CASt TrackNumber as an integer that was used in MAX(); maybe I need to do that.
Re: Newbie to Magic Nodes, need help with orphaned tracks
I don't understand if you want tracks when any duplicate don't have a yes in any Custom1 fields, or if you want tracks when at least one duplicate don't have a yes in any Custom1 fields. Anyway, you could try the next two masks:
However, maybe you don't need to tag Custom1 field if you use the next mask:
Code: Select all
<Group|name:Tracks...|Show tracks:No>\Any duplicates where at least one track is rated 2.5 stars or more and Custom1 not equal 'Yes'|Icon:Top level|Filter:Songs.SongTitle || '@' || Songs.Artist COLLATE IUnicode IN (SELECT SongTitle || '@' || Artist COLLATE IUnicode AS GroupField FROM Songs GROUP BY GroupField HAVING Count(*) > 1 AND Max(Rating) > 49) AND Songs.Custom1 COLLATE IUnicode <> 'yes'\<Title|Trim:1>\<Title with artist>
Code: Select all
<Group|name:Tracks...|Show tracks:No>\Only duplicates where at least one track is rated 2.5 stars or more and none has Custom1 = 'Yes'|Icon:Top level|Filter:Songs.SongTitle || '@' || Songs.Artist COLLATE IUnicode IN (SELECT SongTitle || '@' || Artist COLLATE IUnicode AS GroupField FROM Songs GROUP BY GroupField HAVING Count(*) > 1 AND Max(Rating) > 49 AND Length(group_concat(Songs.Custom1)) = Length(Replace(group_concat(Songs.Custom1) COLLATE IUnicode, 'yes', '')))\<Title|Trim:1>\<Title with artist>
Code: Select all
<Group|name:Tracks...|Show tracks:No>\Any duplicates where at least one track is rated 2.5 stars or more and not in music folder|Icon:Top level|Filter:Songs.SongTitle || '@' || Songs.Artist COLLATE IUnicode IN (SELECT SongTitle || '@' || Artist COLLATE IUnicode AS GroupField FROM Songs GROUP BY GroupField HAVING Count(*) > 1 AND Max(Rating) > 49) AND <Folder> Not Like 'O:\Audio Files\%'\<Title|Trim:1>\<Title with artist>
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
-
- Posts: 68
- Joined: Sat Nov 24, 2007 6:16 pm
Re: Newbie to Magic Nodes, need help with orphaned tracks
Sorry to be a pest; you have been most helpful. I beg you indulgence but I wasn't clear enough. The first construct yielded over 11,000 records which was unwieldy.
My ultimate goal is to have a copy of all songs I've rated in my main library folder.
This latest code gives me songs that have any copy in the library rated 2-1/2 stars or more but are not stored in the "O:\Audio files" (Main library) folder yet all the ones I checked also had a copy in the "O:\Audio files" folder:
I want to find the tracks for which at least one of the copies of the track is rated 2-1/2 stars or more but has no tracks in the main library folder ("O:\Audio files") so I can move it to the main folder.
Ex. If The Platters 'The Great Pretender', rated 3 stars, doesn't have a copy in the 'O:\Audio files' folder but does have a copy in the "O:\Extra Music file Copies 2" folder (and/or a folder on another drive), that should appear in the result.
Ex. If Buddy Holly's 'Rave On, rated 3-1/2 stars has a copy in "O:\Audio Files', it should not appear in the result regardless of whether there is a copy in any other folder.
My ultimate goal is to have a copy of all songs I've rated in my main library folder.
This latest code gives me songs that have any copy in the library rated 2-1/2 stars or more but are not stored in the "O:\Audio files" (Main library) folder yet all the ones I checked also had a copy in the "O:\Audio files" folder:
Code: Select all
<Group|name:Tracks...|Show tracks:No>\Any duplicates where at least one track is rated 2.5 stars or more and not in music folder|Icon:Top level|Filter:Songs.SongTitle || '@' || Songs.Artist COLLATE IUnicode IN (SELECT SongTitle || '@' || Artist COLLATE IUnicode AS GroupField FROM Songs GROUP BY GroupField HAVING Count(*) > 1 AND Max(Rating) > 49) AND <Folder> Not Like 'O:\Audio Files\%'\<Title|Trim:1>\<Title with artist>
Ex. If The Platters 'The Great Pretender', rated 3 stars, doesn't have a copy in the 'O:\Audio files' folder but does have a copy in the "O:\Extra Music file Copies 2" folder (and/or a folder on another drive), that should appear in the result.
Ex. If Buddy Holly's 'Rave On, rated 3-1/2 stars has a copy in "O:\Audio Files', it should not appear in the result regardless of whether there is a copy in any other folder.
Re: Newbie to Magic Nodes, need help with orphaned tracks
So, actually you don't want to find duplicates, but you want to get all tracks which don't have copies in specific folder, right? This is something similar which I have already posted before (http://www.mediamonkey.com/forum/viewto ... 62#p268062):
Code: Select all
<Group|name:Tracks...|Show tracks:No>\Track rated 2.5 stars or more which don't have copies in specified folder|Icon:Top level|Filter:Songs.SongTitle || '@' || Songs.Artist || '@' || Songs.Album || '@' || Songs.TrackNumber || '@' || Songs.SongLength COLLATE IUnicode NOT IN (SELECT SongTitle || '@' || Artist || '@' || Album || '@' || TrackNumber || '@' || SongLength COLLATE IUnicode AS GroupField FROM Songs, (SELECT *, CASE WHEN DriveLetter IS NOT NULL THEN SubStr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', DriveLetter + 1, 1) ELSE '' END AS DriveStr FROM Medias) AS Medias2 WHERE <Folder> Like 'O:\Audio Files\%' AND Songs.IDMedia = Medias2.IDMedia GROUP BY GroupField) AND <Rating> > 49\<Title|Trim:1>\<Title with artist>
● Magic Nodes 4.3.3 / 5.2 ● RegExp Find & Replace 4.4.9 / 5.2 ● Invert Selection/Select None 1.5.1 ● Export/Create Playlists for Child Nodes 4.1.1 / 5.4.1 ● Expand Child Nodes/Expand All 1.1.2 ● Event Logger 2.7 ● Filtered Statistics Report 1.6 ● Track Redirection & Synchronization 3.4.2 ● Restore/Synchronize Database 3.1.8 / 4.0.1 ● Find Currently Playing Track 1.3.2 ● Queue List 1.2.1 ● Add to Library on Play 1.0.1 ● Tree Report for Child Nodes 1.1.1 ● Update Location of Files in Database 1.4.5 / 2.3 ● Inherit Child Playlists 1.0.3 ● Add Currently Playing/Selected Track(s) to Playlist 1.2
-
- Posts: 68
- Joined: Sat Nov 24, 2007 6:16 pm
Re: Newbie to Magic Nodes, need help with orphaned tracks
That's a big help; it narrows my job to manageble.
Thanks.
Thanks.