Get entire database for a platform

[David Maisonave]

I'm having problems getting ROM details for over 930 Nintendo DS ROM files. It seems to be triggered by the file names not matching close enough to what is in the LaunchBox database.

I like to get a list of all the Nintendo DS ROM files listed in LaunchBox so that I can try to create a program that would rename my files to the expected title.

How can I get the full Nintendo DS list?

I've attached a list from LaunchBox showing which DS ROM's are missing LaunchBox ID.

FYI:

I also have this issue with other platform, but in those platforms it's only a few dozen ROM's in each platform vs 100's in DS.

RomListWithoutLaunchBoxID.ods

[dragon57]

While the Launchbox database isn't tied, per se, to the No-Intro naming scheme, I have found if you start with a set of games that are already named per the No-Intro database, you will have much better coverage when Launchbox tries to download media.

I just created a new DS platform and told Launchbox to download box - 3d, box - front, cart - front images, screenshot - game title and clear logos. This started from a No-Intro DS set consisting of 1563 titles. This was only from the Launchbox database and didn't include anything from EmuMovies. Edit: I added EmuMovies and those totals are in parentheses.

Here is a count of the number and type of files downloaded.
Box - 3D: 1545 (w/EmuMovies, 1554)
Box - Front: 1546 (w/EmuMovies, 1554)
Cart - Front: 1421 (w/EmuMovies, 1439)
Screenshot - Game Title: 1326
Clear Logo: 1526 (w/EmuMovies, 1553)

As you can see, I got nearly full coverage. The only ones with missing media were the multi-game carts and a few homebrew that aren't official anyway, although there were a couple I had to manually tweak in the Edit Game panel to force a match.

If you want to see what is contained in the LaunchBox database for a particular platform, the easiest way is to make sure LaunchBox and/or BigBox are not running, then use a SQLite editor to open the LaunchBox.Metadata.db file found in the Metadata folder. You can perform a select statement for the platform in question for any or all the fields in the database. Make sure you only perform a read-only query and don't change anything while accessing that file.