Q: how to delete duplicated songs all at one time?

Brilliant. Now in one of those images could you point out some of the tracks that FindTracks is failing to pick up, or mark out the successes, whichever is easier. I'm interested in the failures at this point.

tt2

deadmau5 - Ghosts 'n' Stuff (although the d is lowercase)

Deep Purple - Child in Time

Deep Purple - Smoke in the Water

Def Leppard - Too Late for Love

Def Leppard - Let It Go

Def Leppard - Love Bits

Def Leppard - Pour Some Sugar on Me

....

Default - Wasting My Time

Del Amitri - Roll to Me

Hmm, download a fresh copy of the script. I made a minor change two days ago while troubleshooting a different issue, but it might solve the problem for you too. So far I've picked up all of the first dozen test tracks I've made to match your examples.

tt2

Aha, I thought we were still trying to repair the broken links!

I'm thinking what you want is a DeDuper that ignores Album, Disc & Track number? Danger with that is that if you have both live and studio versions that aren't distinguished by track names then you'll throw out one at random. It would take a little thinking about and testing, but I could probably shoehorn that in as an option.

In fact, dirty and untested, simply change these 6 lines in DeDuper (currently starting at line 246):

          Case 2                        ' Physical dupes, same details and size

            If L<>"" Then Key=LCase(.Artist & "\" & .Album & "\" & DN & "." & .TrackNumber & " " & .Name & "=" & .Size)

          Case 3                        ' Alternate dupes, same details but different size

            If L<>"" Then Key=LCase(.Artist & "\" & .Album & "\" & DN & "." & .TrackNumber & " " & .Name)

          Case 4                        ' Missing dupes, same details but file missing

            If L="" Then Key=LCase(.Artist & "\" & .Album & "\" & DN & "." & .TrackNumber & " " & .Name) Else Key=""

for these:

          Case 2                        ' Physical dupes, same details and size

            If L<>"" Then Key=LCase(.Artist & "\" & .Name & "=" & .Size)

          Case 3                        ' Alternate dupes, same details but different size

            If L<>"" Then Key=LCase(.Artist & "\" & .Name)

          Case 4                        ' Missing dupes, same details but file missing

            If L="" Then Key=LCase(.Artist & "\" & .Name) Else Key=""

And it should do what you want.

I guess you'll also want a more liberal pattern matching system for the SyncStats script as well.

tt2

Yes!  I was trying to repair broken links.

But then, when I wasn't able to repair all of them, I added the songs that weren't repaired and tried to merge them with DeDuper (which worked for some).  And I have very few duplicates of songs.  Usually picked which one I liked most.

Yeah, the SyncStats, I plan to use when I get this first broken links part complete.  I haven't tried it yet.  The play counts on my iPod are hundreds more, for some reason.

I think, I used to save Playlists, and those playlists contained play counts.  When iTunes deleted or corrupted my playlists in updates, I think iTunes reset the playcounts to the "music" counts on this computer.

Should I try Find Tracks again (is that the one that is a new version?) and then run DeDuper again?

Try a fresh download of FindTracks first. If you've only got one remaining physical file track from two originals (one currently lost and one found) then iTunes should show the same metadata for both once things are reconnected, and the unaltered DeDuper will then behave as it is meant to.

tt2

The fuzzy matching scheme obviously works better when there aren't so many tracks all lumped into the same folder, and with so many sharing the same starting characters, nevertheless there are some surprises there.

Looking at it there will be a fuzzy match from the Name to the Artist. I'm sure I can find a way to tweak the script to prevent those. See Soundex for the rule scheme. Cream & Cryin' both get a soundex code of C650.

tt2

Before I posted on here, I created a setup that is Artist -> Song in a folder structure.

The same thing happened with Find Tracks with the same files.  When it didn't work, I abandoned trying that way.

I've added another tweak to FindTracks so that it uses two soundex patterns rather than one when the search string contains " - ". Hopefully this won't negatively impact the behaviour elsewhere (I haven't had time to test or consider it deeply enough) but it should prevent the song name is similar to the (completely unrelated!) artist name matches that you've been seeing. Grab a fresh download and see if it has helped.

tt2