| Author |
 Topic  |
|
|
Josemi
Starting Member
48 Posts |
 Posted - 31 Jan 2013 : 18:32:57
|
I just to saw It now, I've a lot of actors repeated. Why? How can I to erase them easily?
Josemi |
|
|
Michael Clarke
New Member
United Kingdom
84 Posts |
Posted - 31 Jan 2013 : 19:16:33
|
There is a people duplicate name filter in XMM8 treeview, that works very well, but it does take it's time to check through 13,000 actors in my database
Another way I have found, is to delete them from the back end database file .mdb
First make a copy
Then open the database file with Microsoft Access
then click the people table. Arrange the "actors name" field into ascending order
Duplicates will be clustered together and easier to delete.
Once you get back to one entry for each actor, you could sort the films in which they star. |
Edited by - Michael Clarke on 31 Jan 2013 19:17:05 |
 |
|
|
yan00s
Moderator
405 Posts |
Posted - 31 Jan 2013 : 20:57:56
|
quote:
Originally posted by Josemi
I just to saw It now, I've a lot of actors repeated. Why? How can I to erase them easily?
Josemi
I think not all scripts catch WebIDs from IMDB and sometimes - due to changes on IMDB or the occasional lil' bug - it doesn't even work for scripts which should fetch the ID. 
If you start to clean this up I'd recommend to check that they are indeed identical first. You know, there are quite a few Tom Smiths' out there http://www.imdb.com/find?q=Tom%20Smith&s=nm&exact=true&ref_=fn_nm_ex 
In case you're experimenting with direct db manipulations as proposed by Michael I'd recommend to incorporate the WEB_ID field. And if you do this: keep in mind that you may have to clean up the photo directory manually too or you may end with a lot of unlinked people pictures.
BTW it seems IMDB has a few duplicate entries which refer to the same person too. |
. |
|
|
|
Michael Clarke
New Member
United Kingdom
84 Posts |
Posted - 01 Feb 2013 : 00:54:05
|
| Yes without a doubt this is the best way of dealing with actors with duplicate names but not the same actor. It took me a long time to sort all the WEBID's out for each actor but it is well worth it. I'm now done all directors and producers. Still got Editors, Writers, Musicians and Photographers to go. Sometimes you really have to google hard to find the picture of the person or indeed to sort out child actors from older films that have also gone on to become adult actors. I think some of the secret is to not trust IMDB too much as there are a lot of mistakes. |
|
|
| |
Topic |
|
Repeated Actors