Jump to content
LaunchBox Community Forums

LaunchBox Game Info Utility


Recommended Posts

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

 

  • Like 3
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites


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?

Link to comment
Share on other sites

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.

  • Like 1
Link to comment
Share on other sites

  • 3 weeks later...

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 3 weeks later...

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 by billyc999
mistake
Link to comment
Share on other sites

  • 4 weeks later...

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 :)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...