elliot763 Posted August 13, 2016 Share Posted August 13, 2016 LaunchBox Game Info Utility View File What it does: Reads your LaunchBox.xml file to get the list of games and their properties Counts the number of Videos and Images by type (Box - Front, Clear Logo, etc.) for each game by looking through the Videos and Images directories Writes all of this data to a single CSV file which is created in the LaunchBox directory How to use it: Place the LaunchBoxInfoUtils.jar file in the your LaunchBox folder (same folder as LaunchBox.xml) Double click the JAR file (You may have to install a JRE and add it to your system path if you don't already have one) A new file, GameInfo.csv, will be created in the same directory, which you can open in Excel or any other CSV editor and filter as needed (for instance, you can filter out games that have 0 in the "# BoxArt(Front)" column to see which games need Box - Front images) Notes: As implied above, I threw this together quickly (a couple of hours) for my own use, so it is tailored my own library and may not work with everything (for instance, I don't have Steam games in my LB so I didn't include Steam Banners). So I can't guarantee that this will work for everyone, but I'd be happy to add features if there is interest Again, I haven't put a ton of time into this so currently there is no feedback when you run the program (no logs, no status window). The only way you'll know it is done is when the CSV is created. So if you run it and nothing happens after a while (it runs for my Library of ~2000 games in < 5 seconds) you may want to open your task manager and check that the Java process isn't running in the background and eating resources (kill it if it is). Let me know if you love it/hate it/have suggestions.. I'd be happy to improve it if it's helpful to the community Submitter elliot763 Submitted 08/13/16 Category Third-party Apps and Plugins 3 Quote Link to comment Share on other sites More sharing options...
Sithel Posted August 13, 2016 Share Posted August 13, 2016 Love the idea, unfortunately this did not work for me. Windows 10 Pro 64bit, I had to install Java and reboot the pc. Double clicking this file in the LaunchBox directory with the LaunchBox.xml did nothing. After 2 minutes or so I tried to just delete the LaunchBoxInfoUtil.jar file and it said I could not that the file was already in use. I had to open the task manager and kill the java process. Quote Link to comment Share on other sites More sharing options...
elliot763 Posted August 14, 2016 Author Share Posted August 14, 2016 3 hours ago, Sithel said: Love the idea, unfortunately this did not work for me. Windows 10 Pro 64bit, I had to install Java and reboot the pc. Double clicking this file in the LaunchBox directory with the LaunchBox.xml did nothing. After 2 minutes or so I tried to just delete the LaunchBoxInfoUtil.jar file and it said I could not that the file was already in use. I had to open the task manager and kill the java process. Sorry to hear that Sithel . The only time I've had the program hang was when I ran it over my network (from my laptop to my HTPC), it was still working just MUCH slower so I killed the process. I really should add at least some simple logging so I can tell what is happening if others are having trouble. Quote Link to comment Share on other sites More sharing options...
Rincewind Posted August 14, 2016 Share Posted August 14, 2016 Same thing happened when I ran it, I did try and leave it as my library of games is large but after a couple of hours I killed the process. I hope it will work in the future as it looks to be a great additional app. Thanks anyway Quote Link to comment Share on other sites More sharing options...
elliot763 Posted August 14, 2016 Author Share Posted August 14, 2016 Hey @Sithel and @Rincewind, sorry again about this not working for you. I just uploaded a new version which also creates a log file that will hopefully allow me to figure out where it is hanging. If either of you have a chance to try it out and let me know what is going on in the log I would appreciate it. Thanks Quote Link to comment Share on other sites More sharing options...
Rincewind Posted August 14, 2016 Share Posted August 14, 2016 2016-08-14T03:48:50.571 | == Starting LaunchBox Game Info Utility == 2016-08-14T03:48:50.691 | = Opening LaunchBox.xml = 2016-08-14T03:48:53.179 | = Beginning to parse game info for 15269 games = 2016-08-14T03:48:53.180 | = Getting info for game: Dragonstar Trilogy Part II, The (Sinclair ZX Spectrum) = 2016-08-14T03:48:53.181 | == Loading list of videos for Sinclair ZX Spectrum == 2016-08-14T03:48:53.402 | == Loading list of images for Sinclair ZX Spectrum == 2016-08-14T03:48:54.364 | = Getting info for game: Thingy and the Doodahs (Sinclair ZX Spectrum) = 2016-08-14T03:48:54.741 | = Getting info for game: Cosmic Sheriff (Sinclair ZX Spectrum) = 2016-08-14T03:48:54.750 | = Getting info for game: All Time Great Tour 1 (Sinclair ZX Spectrum) = 2016-08-14T03:48:54.758 | = Getting info for game: Block Out (Arcade) = 2016-08-14T03:48:54.758 | == Loading list of videos for Arcade == 2016-08-14T03:48:55.071 | == Loading list of images for Arcade == 2016-08-14T03:48:57.693 | = Getting info for game: Fall Guy, The (Sinclair ZX Spectrum) = 2016-08-14T03:48:57.693 | = Getting info for game: Averno (Sinclair ZX Spectrum) = 2016-08-14T03:48:57.703 | = Getting info for game: Kayleth (Sinclair ZX Spectrum) = 2016-08-14T03:48:57.713 | = Getting info for game: Speedway: Team Championship: 1960 (Sinclair ZX Spectrum) = 2016-08-14T03:48:58.271 | = Getting info for game: ParaglidingSimulation v1.0 2002 (Amiga) = 2016-08-14T03:48:58.271 | == Loading list of videos for Amiga == 2016-08-14T03:48:58.523 | == Loading list of images for Amiga == 2016-08-14T03:48:59.216 | = Getting info for game: Roketz v1.1 AGA (Amiga) = 2016-08-14T03:48:59.224 | = Getting info for game: Galaxian (Sinclair ZX Spectrum) = 2016-08-14T03:48:59.224 | = Getting info for game: Interphase v1.9 0067 (Amiga) = 2016-08-14T03:48:59.234 | = Getting info for game: Space Treat Deluxe (Atari 2600) = 2016-08-14T03:48:59.234 | == Loading list of videos for Atari 2600 == 2016-08-14T03:48:59.323 | == Loading list of images for Atari 2600 == 2016-08-14T03:48:59.894 | = Getting info for game: Potty Planter (Sinclair ZX Spectrum) = 2016-08-14T03:48:59.894 | = Getting info for game: FutureWars v4.0 1570 (Amiga) = 2016-08-14T03:48:59.904 | = Getting info for game: 3D Vortex (Sinclair ZX Spectrum) = 2016-08-14T03:48:59.917 | = Getting info for game: Congo Bongo (Atari 2600) = 2016-08-14T03:48:59.923 | = Getting info for game: Mortal Kombat Gold (Sega Dreamcast) = 2016-08-14T03:48:59.923 | == Loading list of videos for Sega Dreamcast == 2016-08-14T03:48:59.934 | == Loading list of images for Sega Dreamcast == 2016-08-14T03:49:00.022 | = Getting info for game: Saboteur (Atari 2600) = 2016-08-14T03:49:00.026 | = Getting info for game: Boiler House (Sinclair ZX Spectrum) = 2016-08-14T03:49:00.065 | = Getting info for game: Robyn Hode (Sinclair ZX Spectrum) = 2016-08-14T03:49:00.600 | = Getting info for game: Knights of Valour 2 / Sangoku Senki 2 (Arcade) = 2016-08-14T03:49:00.620 | = Getting info for game: Scooby Doo (Sinclair ZX Spectrum) = 2016-08-14T03:49:00.628 | = Getting info for game: Great Sluggers (Arcade) = 2016-08-14T03:49:00.644 | = Getting info for game: Bimbo (Sinclair ZX Spectrum) = 2016-08-14T03:49:00.650 | = Getting info for game: International Superstar Soccer (Super Nintendo Entertainment System) = 2016-08-14T03:49:00.650 | == Loading list of videos for Super Nintendo Entertainment System == 2016-08-14T03:49:00.744 | == Loading list of images for Super Nintendo Entertainment System == 2016-08-14T03:49:01.214 | = Getting info for game: Championship Baseball (Sinclair ZX Spectrum) = 2016-08-14T03:49:01.264 | = Getting info for game: Chrome v1.1 (Amiga) = 2016-08-14T03:49:01.757 | = Getting info for game: Scurge: Hive (Nintendo Game Boy Advance) = 2016-08-14T03:49:01.757 | == Loading list of videos for Nintendo Game Boy Advance == 2016-08-14T03:49:01.934 | == Loading list of images for Nintendo Game Boy Advance == That's the log @elliot763 any idea? Quote Link to comment Share on other sites More sharing options...
Rincewind Posted August 14, 2016 Share Posted August 14, 2016 Just checked the log again and it looks like its still going so im going to leave all night, see if just a time thing Quote Link to comment Share on other sites More sharing options...
elliot763 Posted August 14, 2016 Author Share Posted August 14, 2016 Hmm, ok.. Yea your library is about 8X larger than mine so maybe it's just taking a while, but I still wouldn't see it taking anywhere near a couple of hours like you said for your first try. I did make an efficiency improvement as well in this version so hopefully it won't be so bad. 1 Quote Link to comment Share on other sites More sharing options...
Rincewind Posted August 14, 2016 Share Posted August 14, 2016 So I woke this morning after and found the CSV file sitting there, so it does work just takes a long time if you have a large library of games. Thanks again @elliot763 this is going to be a big help 1 Quote Link to comment Share on other sites More sharing options...
elliot763 Posted August 14, 2016 Author Share Posted August 14, 2016 Good to hear @Rincewind! I still think I can make some improvements so it doesn't scale so poorly to large libraries. Out of curiosity, how long did it take? Could you compare the timestamps on the first and last entries in the log if you still have it? Quote Link to comment Share on other sites More sharing options...
Rincewind Posted August 14, 2016 Share Posted August 14, 2016 The log took 1 hour 10 mins so it was a lot quicker the second time i ran it Quote Link to comment Share on other sites More sharing options...
flores9 Posted September 3, 2016 Share Posted September 3, 2016 Hi @elliot763, I´m using Win10 x64 and I´ve the same problem. Yesterday I downloaded the offline version of JRE SE from http://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html But when I try launch the .jar file, nothing happens. Do I need another version of JRE? or I´m making a mistake? Quote Link to comment Share on other sites More sharing options...
elliot763 Posted September 3, 2016 Author Share Posted September 3, 2016 Hey @flores9, Is the log file (LaunchBoxInfoUtil.log) created at all when you launch it? It should show up in the same directory as soon as you run the program. If so let me know what it looks like. If not, try running the jar from command prompt and see if it is giving an error. You can just open the folder with the program in it in Windows Explorer, type 'cmd' into the address bar and a command prompt window should come up, then type 'java -jar LaunchBoxInfoUtil.jar' and press enter. Quote Link to comment Share on other sites More sharing options...
flores9 Posted September 4, 2016 Share Posted September 4, 2016 @elliot763 yes!, it works from the command line!. Thanks. Previously, from the Windows directly (double click on the icon), it doesn´t generate any log file, so I understand that it not works. Quote Link to comment Share on other sites More sharing options...
flores9 Posted September 4, 2016 Share Posted September 4, 2016 @elliot763 another question. I open the .csv file with Excel, but then what caracter do I use to convert text to columns?. I used the "," but there are many errors because the field title has it inside. I try to use the combination ' "," ' but Excel don´t let me do this. Quote Link to comment Share on other sites More sharing options...
elliot763 Posted September 4, 2016 Author Share Posted September 4, 2016 Hey @flores9, glad you got it working. Excel should be able to read and parse the .csv into columns correctly without any additional steps. I'm not sure what would cause it not to do this automatically. It has always worked fine for me using Excel 2013. Here is a link I found that might help. Any extra commas should be ignored since the column data is surrounded by quotations. If you can't get it working in Excel, Google Sheets seems to work for me too. Quote Link to comment Share on other sites More sharing options...
flores9 Posted September 4, 2016 Share Posted September 4, 2016 Thanks, now it works. I used to open directly the csv with excel, and in this case I got the mentioned error in some rows. Quote Link to comment Share on other sites More sharing options...
billyc999 Posted September 25, 2016 Share Posted September 25, 2016 (edited) any chnace of making anoter version of this that parses the game id at present it just says null, it works great, but what i want to do is convert my whdload amiga xml to csv fill the info in i need, then ill use a formula to convert back to xml. this is the one i mean <ID>db3297c3-98c6-439e-96f5-048afd91541e</ID> i assume LB needs this as i see it in all the xml files if anyone know a list of minimum data that is needed in the xml that would be great Edited September 25, 2016 by billyc999 mistake Quote Link to comment Share on other sites More sharing options...
billyc999 Posted September 25, 2016 Share Posted September 25, 2016 ignore last comment i've figured how to change program to my needs. all i need now is the basic list of fields needed in the new xml files and hopefully i can make a new xml for my amiga whd set Quote Link to comment Share on other sites More sharing options...
Vlansix Posted October 19, 2016 Share Posted October 19, 2016 Heya @elliot763, Noticed that this has been broken since the XML split. Are you intending on updating it? If not, I'd be interested in porting it over to a C application. Seems like a bit of fun (Kinda stupid, but parsing text is fun o.O), and it should remedy the "i can't get the .jar file to work / execution is taking too long" issues. Lemme know Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.