How can I make a .DAT file from EmuMovies or GameEx Databases ??

[u-man]

Hello Guys,

I would like to know, how the Emumovies in GameEx works. I have a lot of missing Artwork in SNES for example. I guess that EmuMovies have a Database that compares the roms that someone have. So my question would be, where i can find the database that is used by Emumovies. Can I open this in Romcenter or in a other Rom-Tool??

Same goes for GameEx and the .db3 files. How can I use them in a Rom-Tool?

thanks in advance

[nightwulf]

The GameEx .db3 files are just sqlite databases. They can be opened with any number of tools (I found SQLite Database Browser [standalone] and sqlite-manager [Firefox extension] very helpful). No clue where emumovies' databases can be viewed. The download utility even reads "running search on server" when starting a download so I'm guessing it uploads your file list to their server and there's no public access to whatever they're matching against.

The GameEx databases won't be of any use in a ROM tool. They don't use any means of validating your ROMs other than filename. There's no crc/md5/sha data to match against.

I've found the easiest way to minimize my missing artwork is to use emumovies' download utility then manually grab (and rename) whatever is missing via their FTP access.

[u-man]

first a big thanks for the advices .

They can be opened with any number of tools (I found SQLite Database Browser [standalone] and sqlite-manager [Firefox extension] very helpful).

The GameEx databases won't be of any use in a ROM tool. They don't use any means of validating your ROMs other than filename. There's no crc/md5/sha data to match against.

I would not use the database for validating Roms, i would use them to see what Roms are missing for example. so it seems i cannot create .dat from gameex-database

I've found the easiest way to minimize my missing artwork is to use emumovies' download utility then manually grab (and rename) whatever is missing via their FTP access.

ok, that may work, but this is for registered members only .

[nightwulf]

Well, a dat file (in clrmamepro format I'm assuming) is basically a list of files and their CRC, MD5, and SHA. The GameEx databases have none of this information; they're primarily used to define names from GoodSets / nointro / TOSEC / MAME filenames and game information (publisher, description, etc.). There really isn't any useful information for a ROM tool.

I attached the SNES database as CSV (can open with Excel, Google Docs, etc. or even a good text editor) so you can see what's there and use the list of files if you have a use for it. If your goal here is to plug holes in your artwork collection though, it really isn't relevant.

Maybe dump your ROM directory list to a text file and manually look for deficiencies in your artwork directories? Not really sure of the best way to proceed.

Console Nintendo SNES.zip

[Tempest]

If you are trying to find out what roms are missing artwork, Perfect Match can do that and more.