PL Recurrent Artist Remover v2.1 [MM3] Updated 2011-11-07

[Eyal]

I made this script following request by NightInAgharta: http://www.mediamonkey.com/forum/viewto ... =2&t=55519


Description
This script creates a playlist (from selected tracks) with only first occurrence of each artist.

- Select any tracks as the source, a tree node, a playlist or auto-playlist, a search result, ...
- Run the script (Tools | Scripts | Recurrent Artist Remover)
- Enter the playlist name to create.




-------------------
System Requirement: MM 3.1.0.1216 or newer.


Installation:
Download the script installation package below, then run the .mmip file to install it in MediaMonkey.
Vista/Win7 users need to install it with administrative rights (see here).


Download:
Via MediaFire : http://www.mediafire.com/file/3u9y7bbx4 ... _v2.1.mmip


Tell me what you think...

Eyal
:~)

[BestGuest]

Hmm? Strange that nobody has written here..

Anyway, thank's a lot for this great script.
I use it now and then for taking out tracks
from a list, when i only need one track to
be left, because i only need it for clicking
in artist-mode. Almost as trix's report:
"Just list Artist." but now i can click it!

I just have one whish, is there somway to
speed up this list a bit? If i select more
than 1000 files, then it takes a loot of time.
Thx again.

(Sorry for my simple english.)

[Eyal]

Yes BestGuest, you made me work hard.

Version 2.0 now uses SQL to perform the task almost instantly!
However, due to the way it's working, selected tracks order can't be kept and picked tracks seems aleotory.

See first post for download link.


Eyal :~)

[BestGuest]

Wow!?! Yes, its sure is Fast now and i thank you for the wery nice perfomance you fixed.

But, i'm sorry to say that it crashes for me and throw's up the message:
Error #-2147418113 - SongsDb.SDBPlaylist
Error excuting SQL statement "COMMIT" : SQL logic error or missing database (1, 21)
File: "Blah blah\\RecurrentArtistsRemover.vbs " , Line: 132, Column: 32
And again after "OK":
Error happening during script execution:
Error executing SQL statement "COMMIT" : Sql logic error or missing database !1, "!)

What did i do then for getting this message? Well, i selected a.. "couple" of thousen songs
and specified the outgoing playlist. It started and run for a seccond or two, and outputted 93 artist and then crashed.

Do you need more info from me, or did you understand my SWEnglish? *s*
//BestGuest

[Eyal]

Error excuting SQL statement "COMMIT" : SQL logic error or missing database (1, 21)

I did some research and found that the reason for the exception is putting a ‘NULL’ into non NULL column.

The script compare Artist ID's before inserting them in the playlist. So I suppose it happens when a track doesn't have and ID, meaning the track is not in database (library).

Make sure to select only track that are in the library ie. in Library->Location nodes, do NOT use My Computer node, nor playlists or locations that contain Missing tracks.

Otherwise you'll get an SQL error like:


I tested this script many times, with as much as 1500 selected tracks without any glitch.

:~)

[BestGuest]

Hello again EYAL.

I have tested this a looot today and, first of all, you dont test enough track's to enable the error. I'm quite sure of that.

But it's werry strange my results here. I added tracks up to 4985 to get the error and it then halts on 350 of 351 artists.
Aha i thinked, it's has something to do with some limitations around 350 then, but no.. I selected some other track's and
then it halts on 405 artists, and later 474 artsist, and so on.. (Number of tracks selected was always different.) What the hell?

Can it be possible that the error is caused by any of my swedish letters: Å,Ä or Ö maybe? In the playlists created by this script
there is only one swedish letter as the first letter in artistsfield. Perhaps it hangs up because of that?

And yes, i have all the tracks in my library and selects them sorted by genre or from some Magic Node.

Have a nice day, //BestGuest

[Eyal]

Hi again BestGuest,

Thanks to let me know, you are right there's a hung at about 5000 records.

I fixed the problem in v2.1 and enhanced the script so now it's even faster !
I have test it on 30,000+ selection with a result of 8000+ tracks.
WORKING FINE!

Get the latest version on first post in this thread.

Thanks for helping me !

Eyal :~)

[BestGuest]

Yes, i think now it's time to declare this script to be finished. (As far as i can provoke it of course..)
The speed improvment i asked for in the first place, is now almost instantly! Wrooooomm!

Thank you Eyal, and all other helpful people in here, for your gifts to make my life easier.
Mediamonkey would not be half as good without you scriptguru's help, and that's the truth. (For me.)

Thank's again. See ya. (?) //BestGuest//

[Eyal]

Thank you!