Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[MusicMon]

Over the years I have ripped the same CD into different file formats. Now it is time to cleanup the database. The following code finds duplicate names AND duplicate Albums

[Media Type]=[Audio] ~dip=[Name] ~dup=[Album]

I want to add one more condition, that is different file types. Would you please help? Also I couldn't find a definition for command ~differences. TIA

[RoderickGI]

As per the Wiki, you can reduce that Dup functions down to:

~dup=[Name],[Album]

That will show you all potential duplicates by Name and Album as you say, and will include all duplicates with different File Types, which you can show in a View or Smartlist, and hence decide what to keep. So if you have ripped to MP3, AAC, and FLAC, you will see all three versions and decide what to keep.

I'm not sure what you want to do with the File Type and ~differences. Are you expecting to find multiple FLAC versions, and only want to show the one FLAC file and the MP3, or something?

[MusicMon]

I want to find duplicate names with same album names but different file types.

[RoderickGI]

Just ~dup=[Name],[Album] should do that.

If you have tried that, what isn't it doing for you? Maybe some examples.

[MusicMon]

It produces duplicate names & album. This query output is large. I have a large database. So I am trying to filter one more time for different file type. I am also trying to understand the query language better. I read the wiki and didn't find a definition for ~difference. Thanks for your help

[RoderickGI]

Okay, as you are only trying to shorten the list, I suggest you use something other than the File Type to select what to show. For a start, when showing duplicates you would want to show the FLAC, MP3, AAC, etc. versions together, so selecting of File Type wouldn't make sense, at least to me.

I suggest you create a Pane type of view using ~dup=[Name],[Album] as the selection criteria, and then set up a Pane Category of Album and set a Group Size of 3. I added a File Type Category so that after select the "J-L" Group, for example, I could easily compare the files, then just select the MP3 files and delete them, if that was my choice. I also added a "File Path" (shown as "Location") Category so that I could easily see where the duplicates were stored, and if they were all in one folder, just select that folder to show only the duplicates, regardless of the file type, and delete the duplicates.

See the attached images for how I set that up.

PS: I haven't found a definition for ~differences either, other than when the function was added back in MC18. But I haven't tried to work out exactly how it would be used. But if you do the above, it won't be required.

23.0.88 (12/6/2017)
5. NEW: Added the smartlist rule "Only differences of" the will find files with different values in the selected fields.

[MusicMon]

Thank you very much. I'll follow your advice.