AgentJohnnyP

Hummm... I know I've seen with other plugins you have to right click on the file and go into the properties to unblock it? Let me know. I'll look into adding some checking to make sure the metadata file is loaded. Thanks for the feedback!

I finally got around to it, but I've released the web version of the Missing Games Checker as a full LaunchBox plugin! Haven't touched C# in about 10 years, but it was a fun project 😁 Check out the release in the Downloads section. Let me know if you find any issues or have any suggestions. Star Rating sorting is available as well with export functionality 👍

Missing Games Checker Plugin View File Missing Games Checker (MGC) is a powerful LaunchBox plugin designed to help collectors instantly identify missing games from their platform libraries based on official LaunchBox metadata. Compare your local collection against the LaunchBox database, track completion percentages, filter regional variants, and export missing titles directly into LaunchBox Wishlists! NEW in v2.1! Dedicated "Wishlists" Category Nesting: When exporting missing games to LaunchBox, MGC can now seamlessly create a custom Wishlists root category in your sidebar—complete with an auto-installed Wishlists.png Clear Logo icon Dynamic Hardware vs. Wishlist Categorization: Toggle between nesting wishlist platforms under the new Wishlists category or keeping them inside their default hardware categories (Consoles, Handhelds, etc.). Moving platforms back and forth carries all scraped metadata and box art automatically without duplicates! Enhanced Right-Click Context Menu: Added "📋 Copy Title to Clipboard" alongside existing title/platform export tools for ultra-quick search workflows. One-Click Search Clear: A sleek, interactive 'X' button now appears beside search boxes whenever text is typed, allowing you to reset your search filter instantly. Title Columns Locked: The 'Title' columns are now locked in place while scrolling across the table details. Improved UI & Stats Layout: Moved Platform Completion Statistics directly above the Owned Games grid for immediate visual feedback. CORE FEATURES AT A GLANCE Powered by LaunchBox SQLite: Built on LaunchBox’s modern SQLite database for sub-second load times, instant processing, and a ultra-lightweight ~1.3MB footprint. Platform Completion Statistics: Color-coded completion metrics give you immediate percentage feedback ($80\%+$ Green, $30\%-79\%$ Yellow, $<30\%$ Red) on your library progress. Export Wishlist Platforms Directly to LaunchBox: Generate shadow platforms filled with placeholder games for missing titles. Download box art, banners, and media in LaunchBox for games you don't even own yet! Regional & Released Filters: Strict-filter missing games by region (North America, Europe, Japan) or toggle the safety-net checkbox to capture titles with missing region data. Interactive Grid Search & Column Filters: Real-time global search, column header sorting, multi-value field filtering (Genres, Region, Developers), and frozen title columns for easy horizontal scrolling. Collector Clipboard & eBay Search Integration: Right-click any missing game to quickly copy formatting, spreadsheet-ready tabbed data, or launch an instant eBay search query in your browser. Clickable Media Links: Direct links to YouTube gameplay videos, Wikipedia articles, and LaunchBox Games Database entries right inside grid cells. CSV Exporting: Export owned or missing game tables to standard CSV format for offline library management. Instructions for Using the Missing Games Checker (MGC) v2.1: Requirements: LaunchBox v13.19 or higher. (v13.18 and lower should use MGC v1.2) Games in LaunchBox. The LBMissingGamesCheckerPlugin.dll file. Installation and Usage: 1. Install the Plugin: Download the latest release of the MGC plugin from this page. Make sure LaunchBox is closed. Unblock the downloaded zip file (Right-click on the zip -> Select Properties -> Click or Check "Unblock" if available) For help on Unblocking files, check out this article. Open the zip file and place the `LBMissingGamesCheckerPlugin.dll` file into your LaunchBox\Plugins folder (example R:\LaunchBox\Plugins). 2. Access the Plugin: Launch LaunchBox, then access the Tools menu and find Missing Games Checker(v2.1). 3. Using the Plugin: Select a platform from the dropdown menu and click Check It! MGC will display a list of games owned and a list of games missing from your collection based on the LaunchBox metadata. You can export the list of missing games to a CSV file for easy reference. Extra Notes: The Owned Games list is pulled from YOUR collection. If fields are missing information, make sure your collections metadata is up to date. Check out this LaunchBox Video on how to do that. The Missing Games list is pulled from the local LaunchBox.Metadata.db file. If you find information is missing, visit the LaunchBoxDB website to see how you can contribute! I've worked HARD to make the plugin as robust and efficient as I can. That being said, some computers may experience delays in processing the metadata at the start, processing any large collections' of games, and filtering/sorting large lists. Please be patient! Once you begin a process, it will complete! But the UI may become unresponsive during processing. NO data is modified in this plugin. Data is compared from the local Database file (which updates automatically by LaunchBox) and your collection data reported from LaunchBox. Troubleshooting: Reporting Issues & Feature Requests Click on the "Bug" to open the debug log after the issue occurs. Click the Copy to Clipboard button and provide the relevant debug log here for review. When reporting issues, please provide the following: A brief description of the issue. The output from the Debug Log (via the Bug icon). (Optional) Your exported .CSV file or a screenshot of the error window. I'll review the information and post a fix/suggestion as soon as possible. Also, if you would like to have MGC perform additional tricks, let me know!! I do appreciate the feedback and will enhance the plugin over time based on your findings/suggestions. Special Thanks A huge thanks to the LaunchBox team and their API documentation for making this project possible, as well as Jason's helpful video tutorial. Check out the source code on GitHub if you're interested. Cheers! 🍻 Submitter AgentJohnnyP Submitted 09/07/2024 Category Third-party Apps and Plugins  

Thanks again for the feedback! I've worked some changes in to the page, probably about the best I can get with the XML files. I got the validation down pretty good so users shouldn't be able to proceed with the wrong info. I'll try and work some export options in at some point too, but I've already started down the C# path lol ... Gonna take a bit, but I'll get a plugin working which I suspect will be a lot better. Cheers!

You read my mind for some of the enhancements I'm looking to do with it! And thanks, I was hoping someone with familiarity with the structure would give me some advice, appreciate it! I wanted to add additional filtering as well to weed out hacks/beta/etc.. from the list. And yeah, validation for the user platform xml to the platform selection was probably the next thing I was going to tackle. I'll be changing the code to verify against the other platform file (..\Data\) and will probably work it in then. Honestly, my boss has been wanted me to 'branch' out so I'll be digging into .net 6 this fall and will use the plugin as my learnding project lol I haven't touched .net since the ASP.NET 4.5 👴 But I was looking over the API docs and there's a lot of good stuff to use so excited to get in and make it happen! Thanks again for the input!

Awesome thanks! I just point to the Platforms.xml to populate the dropdown for the platform selection and use that to query against the larger Metadata.xml file (try to trim the process lol). I've updated the UI so it's a little clearer as to what files to use. Cheers!

I see what's happening! I didn't see there is a Platforms.xml file in the ..\Data\ folder which causes the page to hang. I'll have to work a better validation in to make sure it get the right file. Make sure to use the Platforms.xml file in the ..\Metadata\ folder. Thanks again for the feedback!

Hey thanks for the feedback! I had an urge and just started coding with no plan in place, so it is a little rough 😬 The UI is still very BETA lol and I will clean it up. Until then let me clarify it a little. These are based on the base files/locations in Launchbox: The Platforms.xml (Step 1) and Metadata.xml (Step 4) are from the ..\Metadata\ folder. The platform XML (Step 3) is from your ..\Data\Platforms\ folder (should be based on your collections). The Metadata.xml is BIG (370+MB) so depending on the computer, it might take awhile. I've run it on my i7 3xxx with 16gb Alienware laptop and it does take a few minutes. I was testing with a "trimmed" version of the Metadata.xml file until I got the async code in to handle the larger file. ONLY DO THIS IF YOU'RE FAMILIAR WITH XML AND TAKE A BACKUP OF YOUR LAUNCHBOX!!!! lol (Just had to FYI that). So I made a copy of the Metadata.xml and stripped out the excess code so it only included 2 platforms. But you have to make sure the base structure of the XML is intact. Then use that file as your 'Metadata.xml'. You could in theory make a copy for each of your platforms to speed it up. But I do believe the Launchbox Metadata.xml file is updated often which will put your copies out of sync. Hope that helps and thanks again! I'll pick away at it as I can 👍 Cheers!

Hey everyone! My first post and thought I would share a tool I created to check your games collection against the LaunchboxDB. I looked for a plugin or similar but couldn't find anything, apologies if this has already been done. I gave a stab at doing a proper plugin in C#, but it's been eons (and many versions ago) since I worked in it and gave up quickly lol. Went back to my comfort zone and made the tool in JavaScript. Game Checker Expectations Just to give some heads up on what to expect from this: This only checks against local copies of the XML files and local Metadata.xml file (NOT the actually LaunchboxDB website). Some basic validation to verify files. Designed against Launchbox 13.5 file formatting and XML naming conventions. This is not a complete platform library check as Launchbox states their DB may not be complete and could be missing games. Feel free to leave feedback and any issues you might find. Also, my chance to give a shoutout to all the folk that make this scene possible!!!! Excelsior! https://www.johnprinz.com/gamechecker