Local Library to TMDB Compare Tool - Flags Missing Movies

[rocketkarl 1]

The attached Power Script generates a CSV output file that can be dropped into the attached Excel file to generate numerous reports including:

1) Missing Movies from all Collections in Library (breaks this out into past, recent, and future releases)
2) Drift between Local Library Collections and TMDB (such as renames, splits, merges, etc.)
3) Metrics based on directory stucture (assumes format: Multiverse\Universe\Collection\Movie - but this can be easily adjusted)

Foreach NFO file in your library:
  * Reports local meta data
  * Extracts TMDB ID and looks up meta data via TMDB API including release date, collection ID, name, and size
Foreach Collection in your library:
  * Reports movie parts missing from library

To start:
1) Add your TMDB API Key
2) Set the top directory in your movie library
3) Adjust (or disable) the directory path parsing to match your structure (assumes format: Multiverse\Universe\Collection\Movie)
      Note: if you're not sure how to do this, try dropping the script in AI and describe your file structure.  It can help you adjust the code accordingly
4) Run the script from Terminal
5) Copy & paste into the Excel file (currently has example data in it to demonstrate the various pivots and graphs)

I'll credit CoPilot with building this script, though it was obviously a collaborative effort.  I've never coded in Power Script before (my coding days were mostly Linux), but got this humming in no time.
Enjoy!

LocalToTMDBCompare.ps1 SRC_Movies.xlsx

[Luke 42077]

Thanks for sharing.