I'm just trying to make a little tool for checking consistency of the actors in XMM. For that I have to know which errors/incorrect entries can appear.
Actors in the movies that are not added to actors table - done
Incorrect mistypings of actors in a movie like included html codes - done (for actors table itself: done)
Actors that are more than 1 times in database with different actor IDs - done (Attention: Same name different actor)
Different actors with same WebID (difficult as sometimes same actor with another name/pseudonym/spelling)
new:
Adding missing WebIDs to actors in table Movies when actor's data is already imported from IMDB - done (Attention: No check between movie and actor's filmography)
Bugs fixed: - Missing actors in DB: I haven't recognized that not all actors were processed - Adding missing actors in DB: double ActorIDs were used on the new entries Additions: - Adding missing WebIDs to actors in table Movies when actor's data is already imported from IMDB. ATTENTION: NO CHECK BETWEEN MOVIE AND ACTOR'S FILMOGRAPHY!!!
In order to achieve what is possible, you have to try the impossible over and over again. Hermann Hesse