101
Support / Dealing with movie duplicates
« on: December 28, 2010, 07:29:26 pm »
Hi,
I'm having a minor issue with duplication of movies in my database. Here's what's happening:
I like to maintain a [reasonably] complete filmography for each of the actors in my database. So, for each actor, I use the IMDB People plugin to import the filmography from IMDB. The plugin is set to overwrite filmographies, and "Merge filmography" selected in Preferences.
This works well enough most of the time. But occasionally, for certain movies, IMDB lists a different release year than the one I already have in my database record for that movie. This causes the actor's filmography to have TWO entries with that movie title, one for the complete movie record I already had, and another linking to an "invisible" movie record with the release year from IMDB.
Now, I can usually get rid of the duplicate entry by editing my "complete" movie record to match the release year from IMDB (this has the effect of merging the two records, as long as the titles match exactly). Occasionally, though, I also have to take the additional step of clicking on the imported IMDB title in the actor's filmography to make the movie record visible in Movies View, then holding down the CTRL key while deleting it.
What I'd like to know is, is there a simple way to scan through all of my actor filmographies to find these duplicates? Right now, I'm dealing with them as I notice them, but I suspect there are a ton more I haven't found yet. I don't know if the "Delete movie duplicates" in "Tools/Optimoze Database" will do what I want, and I'd rather not risk having it delete any "complete" movie records.
Aimhere
I'm having a minor issue with duplication of movies in my database. Here's what's happening:
I like to maintain a [reasonably] complete filmography for each of the actors in my database. So, for each actor, I use the IMDB People plugin to import the filmography from IMDB. The plugin is set to overwrite filmographies, and "Merge filmography" selected in Preferences.
This works well enough most of the time. But occasionally, for certain movies, IMDB lists a different release year than the one I already have in my database record for that movie. This causes the actor's filmography to have TWO entries with that movie title, one for the complete movie record I already had, and another linking to an "invisible" movie record with the release year from IMDB.
Now, I can usually get rid of the duplicate entry by editing my "complete" movie record to match the release year from IMDB (this has the effect of merging the two records, as long as the titles match exactly). Occasionally, though, I also have to take the additional step of clicking on the imported IMDB title in the actor's filmography to make the movie record visible in Movies View, then holding down the CTRL key while deleting it.
What I'd like to know is, is there a simple way to scan through all of my actor filmographies to find these duplicates? Right now, I'm dealing with them as I notice them, but I suspect there are a ton more I haven't found yet. I don't know if the "Delete movie duplicates" in "Tools/Optimoze Database" will do what I want, and I'd rather not risk having it delete any "complete" movie records.
Aimhere