Mp3 Library Clean Up - Yuck!

[Novalak]

Im approaching 80k Mp3's and as freebox needs tags to be correct, ive noticed over time mp3's which are not named correctly

Until i looked properly, i thought my mp3 filename and tags were pretty close to perfect, until i had a looked properly - YUCK!!!

I used Helium Music Manager to place all mp3 information into an SQL database so i could run queries against them

Things I ran were (but not limited to..)

1. When Track - Artist - Title <> filename
2. Albums which contain same track number more then once
3. Songs which contain ( but no )
4. Songs with double ((
5. Artists which start with 'The'
6. Artists with feat in name
7. Albums with multipule artists (excluding compilations)
8. Albums with multipule albums names
9. Blank tags
10. Songs that contain  a '&'
11. Albums which contain songs not formatted correctly
12. Songs with double space
13. Tag album <> folder name
14. Tag artist <> root folder name

I then ran a perl script to find all songs which contained tags and filenames without a Title case


This was an example of one of the queries (When Track - Artist - Title <> filename)

--When Track - Artist - Title <> filename
SELECT current_track, artist, album, filename,
      CASE
      WHEN LEN(current_track) = 1 THEN '0' + CAST(current_track AS VARCHAR(20)) ELSE CAST(current_track AS VARCHAR(20))
      END + ' - ' + artist + ' - ' + title + '.mp3'
FROM dbo.tblDetail
WHERE   CASE
      WHEN LEN(current_track) = 1 THEN '0' + CAST(current_track AS VARCHAR(20)) ELSE CAST(current_track AS VARCHAR(20))
      END + ' - ' + artist + ' - ' + title + '.mp3' != filename



Now i think my mp3 collection is almost perfect....*sigh*


If anyone wants to know the rest of the queries, i can help out

[Trenscendere]

You wouldn't by any chance happen to know of any simple GUI mp3 tag program?
I'm not at 80k but need to do a major clean up of the songs I have... I've noticed that different Jukebox programs seem to find all kinds of differences (in what I thought was nicely organized songs.....).
Freebox Jukebox will most likely remain my softy of choice so it would have to be something that works well with it.

[Novalak]

i think most people here agree that tag and rename is the best app for the job

[Barcrest]

I use the config to see what albums are tagged incorrectly. You can sort by clicking the column headers and untagged stuff will sort to the top. I then scroll down and check the albums under various artists to see they are what i expect. I'm still missing a lot of covers but is too much work to sort everything out.

[Trenscendere]

Thanks alot Perhaps I can gather the strength to give it a try this weekend.