Hi, Probably you have forget about it... but in my database are already 50 movies with the same name... and think I am not alone. Without year, search for duplicate is not so usefool as it may be.
I have take a look now but its not so quick to make this.
When you use the Special Filter "Duplicates", XMM shows you all titles found in the grid. You can show in the grid the year too to correctly see what movies are really duplicates.
I think you use SQL to find duplicates like this: SELECT Title FROM(Movies) GROUP BY Title HAVING(COUNT(Title) > 1) if you add Year in the GROUP BY SELECT Title FROM(Movies) GROUP BY Title,Year HAVING(COUNT(*) > 1) it will solve this problem.
At the moment I use Access to find and remove duplicates in my DB, but then I have to manually removes corresponding movie files.
Probably it would be better not to break actual workflow (probably some user don't wont any changes in it) and add it as additional options like Use Year in Duplicate movie search... or second Duplicate Movie (with Year)... or ... Thank Vlad
FindDuplicates using Name + Year
Posted - 25 Jan 2009 : 22:55:11
