Remove Unused Genres

Any ideas about how to improve MediaMonkey? Let us know!

Moderator: Gurus

nduke
Posts: 55
Joined: Sat Jul 09, 2005 7:29 am
Location: Marietta, GA

Remove Unused Genres

Post by nduke » Sun Dec 09, 2007 7:41 pm

This has been requested numerous times, but I was hoping it could be added to MM3 (or if it can be done through a script, that would be great too!).

I have a number of unused genres that don't have any tracks assigned to them, so they do not appear in the genre node. They do, however, appear in any genre drop down boxes.

Most of these tend to be misspellings which just makes them that much annoying! They all appear in the 'Genre' table of the database. I've found some of the SQL tools that let me view the list, but not delete entries.

It seems like the Maintain Library tool should also have a 'Remove Unused Genre' along with the unused artists & albums.

Any thoughts of adding this, or does anyone have a script that can do it?

G0lluM
Posts: 25
Joined: Mon Jun 11, 2007 6:22 pm

Post by G0lluM » Mon Dec 10, 2007 3:28 pm

I would heartily suggest the Tagging Inconsistencies script. It won't actually delete the genre's but it will list the offenders and you can then delete them manually without TOO much trouble, although I guess that depends on your situation.
Image

nduke
Posts: 55
Joined: Sat Jul 09, 2005 7:29 am
Location: Marietta, GA

Post by nduke » Mon Dec 10, 2007 3:35 pm

G0lluM wrote:I would heartily suggest the Tagging Inconsistencies script. It won't actually delete the genre's but it will list the offenders and you can then delete them manually without TOO much trouble, although I guess that depends on your situation.
Actually I'm a big fan of Tagging Inconsistencies, but that script will only help with genres that actually have tracks assigned to them (unless I've missed a feature!).

I'm looking to delete orphan genres that only appear in the database or through various dropdown menus, but not on the genre node or on any tracks.

MusicBringer
Posts: 622
Joined: Wed Oct 25, 2006 12:53 pm

Post by MusicBringer » Mon Dec 10, 2007 4:14 pm

nduke wrote:[...I'm looking to delete orphan genres that only appear in the database or through various dropdown menus,
Hello nduke, dunno if this will help with your unwanted genres but to get rid of stuff on a drop down list I use Shift+Delete (or is it Ctrl+Delete) anyway try both it might help you :P

nduke
Posts: 55
Joined: Sat Jul 09, 2005 7:29 am
Location: Marietta, GA

Post by nduke » Mon Dec 10, 2007 4:26 pm

MusicBringer wrote:Hello nduke, dunno if this will help with your unwanted genres but to get rid of stuff on a drop down list I use Shift+Delete (or is it Ctrl+Delete) anyway try both it might help you :P
I got excited when I saw this tip, but unfortunately the main place I see these orphan genres isn't a drop down list after all, it's a combo box so this doesn't work in this particular situation.

To see what I mean create an autoplaylist and go to the advanced tab. For the search criteria choose 'Genre contains'. In the list below it lists not only genres in use, but essentially everything that's ever been in the genre field of a track.

I know that not everyone may have tons of stray entries there but I do. I know I could start with a fresh database, but then I'd loose all my autoplaylists and that's just too much hassle. (the orphan genre thing isn't THAT irritating to me!)

kingoomieiii
Posts: 61
Joined: Mon Jun 18, 2007 5:03 am
Contact:

Post by kingoomieiii » Mon Dec 10, 2007 4:41 pm

Forgive my ignorance if I'm wrong, but I think using Compress Database (or whatever it's called, I'm at school) will remove unused things like this.

nduke
Posts: 55
Joined: Sat Jul 09, 2005 7:29 am
Location: Marietta, GA

Post by nduke » Mon Dec 10, 2007 4:47 pm

kingoomieiii wrote:Forgive my ignorance if I'm wrong, but I think using Compress Database (or whatever it's called, I'm at school) will remove unused things like this.
It has the option to remove unused artists and unused albums, but not genres.

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

Post by Bex » Tue Dec 11, 2007 11:59 pm

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

MusicBringer
Posts: 622
Joined: Wed Oct 25, 2006 12:53 pm

Post by MusicBringer » Wed Dec 12, 2007 4:42 am

nduke wrote:...
To see what I mean create an autoplaylist and go to the advanced tab. For the search criteria choose 'Genre contains'. In the list below it lists not only genres in use, but essentially everything that's ever been in the genre field of a track.

I know that not everyone may have tons of stray entries there but I do. I know I could start with a fresh database, but then I'd loose all my autoplaylists and that's just too much hassle. (the orphan genre thing isn't THAT irritating to me!)
Hey now you come to mention it, I found that irritating too. I fully understand what you mean! I think it's time to try the script that Bex suggested. Let us know how you get on...

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

Post by nohitter151 » Wed Dec 12, 2007 9:21 am

MusicBringer wrote:
nduke wrote:...
To see what I mean create an autoplaylist and go to the advanced tab. For the search criteria choose 'Genre contains'. In the list below it lists not only genres in use, but essentially everything that's ever been in the genre field of a track.

I know that not everyone may have tons of stray entries there but I do. I know I could start with a fresh database, but then I'd loose all my autoplaylists and that's just too much hassle. (the orphan genre thing isn't THAT irritating to me!)
Hey now you come to mention it, I found that irritating too. I fully understand what you mean! I think it's time to try the script that Bex suggested. Let us know how you get on...
I tried it - I had 137 unused Genres in there! I had no idea... but now they're gone :D
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.

nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Post by nynaevelan » Wed Dec 12, 2007 9:31 am

Have you tried it on the unused classifications, AWESOME!!!! :D

Nyn
Last edited by nynaevelan on Wed Dec 12, 2007 9:56 am, edited 1 time in total.
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files

Dennis
Posts: 22
Joined: Tue Apr 10, 2007 7:23 am
Location: Rotterdam, The Netherlands

Post by Dennis » Wed Dec 12, 2007 9:32 am

It worked! Great! Thanks for the tip.

Dennis

MusicBringer
Posts: 622
Joined: Wed Oct 25, 2006 12:53 pm

Post by MusicBringer » Wed Dec 12, 2007 9:56 am

nohitter151 wrote:I tried it - I had 137 unused Genres in there! I had no idea... but now they're gone :D
You did better than me. I only scored 23. As you say " I had no idea" 8)

nduke
Posts: 55
Joined: Sat Jul 09, 2005 7:29 am
Location: Marietta, GA

Post by nduke » Wed Dec 12, 2007 11:37 am

Bex-- I am eternally grateful!! This is exactly what I needed!

I'm also happy to see that I'm not the only one annoyed by things like this. MM definitely attracts those of us who are hopelessly and compusively an@l-retentive about our music and tags!

For the record, I had 49 unused genres, so it looks like I didn't win either!

MusicBringer
Posts: 622
Joined: Wed Oct 25, 2006 12:53 pm

Post by MusicBringer » Wed Dec 12, 2007 1:07 pm

nduke wrote:MM definitely attracts those of us who are hopelessly and compusively an@l-retentive about our music and tags!
:P :lol: :P

Post Reply