How can I identify songs not on any playlist

[wolfstiles]

I am just starting with MM5. I came from Itunes and am overwhelmed with all of the options and flexibility. I have about 120K songs that I want one or more playlists assigned to each song. I accomplished this during the import process hopefully. Now I want to determine if there are any songs that do not have a playlist associated with it. I have been playing around with a auto playlist but just can't get it working. I imported 1 song without any playlist so I know that there is at least 1 song to be selected.

Does anyone have any examples that they would be willing to share? Or any advice on how I can accomplish this?

Help will be greatly appreciated.

wolfstiles

[Timo_Beil]

It's a little tricky, because there is no filter "unknown" Playlist.
So collect all your lists in a new one, that can be filtered with "Is Not".
1. Go to the node Playlist
2. in the Main List select all Lists (Ctrl & A) and
3. Rightclick SendTo>Playlist: New Playlist. (Let all doublets remain in the Lists)
4 . In the node Entire Archive>All Tracks build a new Filter : Playlist, Is Not, the new collection list

[Erwin Hanzl]

Sorry Timo, mein Senf :

Create an "Auto-Playlist" with the following criteria:
Collection "Music"
Playlist - is not - and select playlists.
Result: rename this AutoPlaylist in the NODE "Playlists" to "Not in Playlists"
This auto-playlist is updated and reacts to changes if a song is entered into another playlist (F5=refresh).

[wolfstiles]

It's a little tricky, because there is no filter "unknown" Playlist.
So collect all your lists in a new one, that can be filtered with "Is Not".
1. Go to the node Playlist
2. in the Main List select all Lists (Ctrl & A) and
3. Rightclick SendTo>Playlist: New Playlist. (Let all doublets remain in the Lists)
4 . In the node Entire Archive>All Tracks build a new Filter : Playlist, Is Not, the new collection list

I am not understanding. Are you saying to send all of my playlists into a new playlist in step 3. and in step 4 I also don't understand. Can you please clarify. Sorry

[Timo_Beil]

Hi Wolfstiles,
If you have only a few Playlists, the method from Erwin Hanzl is a much better way.
I'd assumed, you have a huge amount of Playlists. That would result in endless clicking at:

Playlist - is not - and select playlists.

because there is no way to select all Playlists at once (only imported) [Feature Request?].
The auto update feature works for added tracks, but not for new playlists.

If you have a large number of Playlists, it may be easier to make a static overview of the current status.
Yes, copy all of your playlists into a new playlist (Step 3) [All Lists]
OR:
(3. b) MOVE all your list into All Lists (and use this List as the root for further lists)
Then you don't have only a static image of this moment.
But be careful: If you delete "All lists", all your lists are really gone. (Backup MM5.db!)
Now, you have the chance to build a Node with ONE click to select all tracks without PL. (Step 4)

[Barry4679]

I am just starting with MM5. I came from Itunes and am overwhelmed with all of the options and flexibility. I have about 120K songs that I want one or more playlists assigned to each song. I accomplished this during the import process hopefully. Now I want to determine if there are any songs that do not have a playlist associated with it. I have been playing around with a auto playlist but just can't get it working. I imported 1 song without any playlist so I know that there is at least 1 song to be selected.

Does anyone have any examples that they would be willing to share? Or any advice on how I can accomplish this?

You could query the database.

1. in MM5, go to Tools>Addons, and search for an add-on called SQL Editor ... is written by drakinite from MM ... thanks drakinite
2. if it is not in the list, press the Get More button at the bottom of the panel, and look in MediaMonkey5>DeveloperTools
3. install the addon
4. that puts a small icon in the Toolbar, a couple of icons to the right, past the funnel ... it looks like a picture frame
5. Press the icon, and paste the following into it

6. Code: Select all

   select distinct albumartist, album, songtitle
   from songs
   where id not in (select distinct idsong from PlaylistSongs)
   order by 1,2

7. Press Execute ... the result should be like this

Caveat: The addon will return a maximum of 1,000 rows ... so this is assuming that you have less than a thousand tracks that are not in a playlist. There are workarounds, but from what you have said, you won't need them.