+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+---- Forum: Ember Media Manager (https://forum.kodi.tv/forumdisplay.php?fid=195)
+---- Thread: v19 How to find missing actors with Custom Media Lists? (/showthread.php?tid=373460)
How to find missing actors with Custom Media Lists? - wkearney99 - 2023-06-12
Is there a way to use Custom Media Lists to find movies that haven't have their actor metadata scanned?
I'm not sure which SQL joins would find this.
Show a list of just movies that have no actor metadata.
RE: How to find missing actors with Custom Media Lists? - wkearney99 - 2023-06-12
Some more searching here turned up this post that seems to cover it: https://forum.kodi.tv/showthread.php?tid=370194&pid=3116055#pid3116055
Go into Edit->Settings->Miscellaneous->Media List Editor
Next to 'CREATE VIEW' enter a name you want to use to select this from the Filters section List drop-down. I called mine "missing_actors"
Put this in the text box below:
sql:
SELECT DISTINCT
movielist.*
FROM
movielist
LEFT OUTER JOIN actorlinkmovie ON (actorlinkmovie.idMovie = movielist.idMovie)
GROUP BY
movielist.idMovie
HAVING COUNT(actorlinkmovie.idMovie) = 0
Press the [+ Add] button. And then OK the settings and get back your list of movies.
The the Filters section (at the bottom left) select the List drop-down and you'll see the view you created above (again, I called mine 'missing_actors').
Basically we're combining two database tables into a view. One table that has the movies, joined against another table of actors with that same id (but with zero records). As in, are there any movies that don't have any actors linked?
RE: How to find missing actors with Custom Media Lists? - wkearney99 - 2023-06-12
The only downside is there doesn't seem to be a Rescrape for the actors and their thumbnails. There is one for actor thumbnails, but that presumes the actor metadata is already present, and is using that to scrape new headshots.
Near as I can tell to get both the actor metadata and their thumbnails you have to rescrape the whole movie. Not awful but takes more time.
RE: How to find missing actors with Custom Media Lists? - wkearney99 - 2023-07-27
What would be the right way to find movies where the actors didn't have a thumbnail URL?
There's an actors table with idActor and a strThumb field for the URL.
How do I get the list to contain just movies with actors missing a thumbnail image URL? My SQL join skills are pretty rusty.