Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

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

Post by Bex » Mon Feb 18, 2008 7:58 pm

Script is updated
Ver 1.2.1 (2008-02-18)
- Added SQL which removes redundant data in the ListsSongs table if it exists. This makes the script to work properly.

Enjoy!
/Bex
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

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

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18) MM3

Post by Bex » Fri Dec 12, 2008 11:33 pm

Download link fixed! :D
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

cwdavi1

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by cwdavi1 » Sun Sep 06, 2009 10:54 pm

I just found your script after having spent many hours searching for this capability. I didn't think to search for 'dropdown list' until just now. I've running MM 3.1.1 and your script still works correctly with it. It has been really annoying for the genres drop down list to have all those typos in it. That's now fixed, thank you very much!

Off this topic, your post makes me think you use MS Access to directly access the MM DB. How do you do that? I tried a long time ago and didn't get anywhere.

Thanks,

Wayne

Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by Mizery_Made » Mon Sep 07, 2009 1:04 am

The original script dates back to 2.x if I'm not mistaken. It wasn't until 3.x that the database was switched to SQLite, so the 2.x databases worked with Access. Thus, that note is likely just still lingering from those days.

Heloo

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by Heloo » Wed Sep 22, 2010 2:49 am

I cant get this plugin to work. When i install it (MM 3.2.2) nothing appears in my scripts. I then tried to manually add it to scripts.ini but then when i try to make it work it gives an error:

Error #13 - Microsot VBScript runtime error
Type mismatch: 'RemoveUnused'

Does anyone knows how to solve this problem or is there a another,new script cleaning up the genre dropdown list?
Thx!

AAA

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by AAA » Wed Sep 22, 2010 11:16 pm

Bex,
I just went to download your script and the link was valid, but it said the file was no longer available for download.

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

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by Bex » Sun Sep 26, 2010 12:58 pm

Reuploaded the script:
http://www.mediafire.com/?rfb5gbkfhd4trzp


@Heloo,
You find the script in the File menu
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

martialartsguy
Posts: 266
Joined: Mon Apr 03, 2006 9:11 am
Location: Denver, CO

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by martialartsguy » Mon Sep 27, 2010 12:16 pm

Awesome script! Saves me a lot of legwork...good job! :D
MM 4.1.10.1778

nightrocket
Posts: 72
Joined: Sun Nov 05, 2006 4:24 am

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by nightrocket » Tue Jan 04, 2011 8:39 am

Hi Bex,

Happy New Year.

Thanks for the script. Tried installing it after downloading it from the link in the previous posting. I got an installation error message. I'm using Windows 7 64 but running MM in 32 mode (as I understand it).

What advice would you offer?

Peace,

- JC

nohitter151
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by nohitter151 » Tue Jan 04, 2011 4:31 pm

nightrocket wrote:Hi Bex,

Happy New Year.

Thanks for the script. Tried installing it after downloading it from the link in the previous posting. I got an installation error message. I'm using Windows 7 64 but running MM in 32 mode (as I understand it).

What advice would you offer?

Peace,

- JC
Check the bottom of the first post:

Bex wrote: Installation Instructions:
- New Install or upgrade:

MM3 (Installer)
Avoid "Product installation error"
- Vista Users:
- - To be able to install scripts you must Run MM as an administrator.
- - It means that you must right click the MM icon and select "Run as administrator" even if you are logged in as an administrator.
- All Users:
- - Check in your task manager that you only have one instance of MediaMonkey.exe running.

1. Download the file and double click on it.
2. Goto File->Remove Unused... To run the script
MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.

nightrocket
Posts: 72
Joined: Sun Nov 05, 2006 4:24 am

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by nightrocket » Wed Jan 05, 2011 1:38 am

Bex: thank you. That worked.

Peace,

- JC

webMullet
Posts: 1
Joined: Tue Jan 25, 2011 2:44 am

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by webMullet » Tue Jan 25, 2011 2:47 am

Thanks a bunch. I hate having all that extra data in my DB. Big enough file already.

billrigsby
Posts: 40
Joined: Sat Jan 10, 2009 5:03 pm

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by billrigsby » Sat Feb 05, 2011 1:44 pm

Tried using this script, "Goto File->Remove Unused... To run the script"
Got the message "No Unused Genres Found"
I no this is not the case, Can this be used to edit the Genre list or only remove a genre if it is unused?

Should I look for a different script?


Bill

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

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by Bex » Sun Feb 06, 2011 6:18 pm

MM can now remove unused genres natively with: File->Maintain Library->Optimize Database

This script only removes unused Genres and classifications. What function were looking for?
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

Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Re: Remove Unused Genres/Classification 1.2.1 (2008-02-18)

Post by Mizery_Made » Sun Feb 06, 2011 11:32 pm

I don't see native support for Unused Genre's, only Albums and Artists. Unless it's a "hidden" task.

Post Reply