Posted by: rick.ca
« on: March 05, 2010, 08:23:15 pm »Quote
I really do prefer to be kept informed of such things when adding movies, so I'm just going to leave the dialog enabled for now and deal with the peculiarities...
The problem is, as you've found, it's not very effective. And there are other related issues... When a filmography is added, any series are added with the year being the first year of the person's appearance. If this is not the same as the year of inception of the series, then a duplicate record is created. If the person is also shown in the series record credits, then both records appear in the filmography. If not, the series in the filmography will not appear as being a member of the collection and will not be linked to the series.
There needs to be a more robust way of maintaining the IMDb relations involving credits. I wonder if that might involve recording filmography items separately, and explicitly recording their relations with people and movies in the collection. That, of course, would be a major change in the structure and operation of the database. In any case, any routine for controlling or fixing duplicates is going to be much more effective after records are created and data is downloaded. Then, instead of trying to prevent the user from creating what might be a duplication, the program can inform the user of what is a duplication (because the downloaded URL is the same as an existing one) and offer to fix it (if asking is even necessary).