MSX and ColecoVision ROM sorter released

Prophet (2379)

16-01-2020, 21:40

I created a python script with a SQLLite3 database that takes the openMSX romdatabase data and sorts ROM accordingly if they are known.

Download here: https://www.vampier.net/MSX/romsorter.zip

I only ran this on linux but windows should work too.

To start run the python script once, it will create a directory structure to start sorting.
Drop all your ROMS in the 'unsorted' folder and run the script agian.

It only works on ROM Files and not ZIP files. All files that are not found will be put in the 'notfound' directory.

The ROM sorter will also rename your files to make sure there are no duplicates. I will continue developing the script so that it will be easier to use.

If you have any ROMs that are working but aren't found by the script please let me know. I can add the sha1 value and ROM mapper to the database.

By gdx

Prophet (3933)

17-01-2020, 00:17

I made a discussion thread about it and a very complet application to do it is almost ready. (Only some options are buggy)

https://www.msx.org/forum/msx-talk/development/i-looking-for...

By Vampier

Prophet (2379)

17-01-2020, 01:16

that's nice - I'm the maintainer of the openMSX database and the sorter script is made "as is". I could just as well have done some Good Tools but this it much easier. Good luck with your application, you want to use my data? 16 years of hard work to keep the thing up to date - feel free to use it.

By Vampier

Prophet (2379)

17-01-2020, 06:14

it's based on https://romdb.openmsx.dev/ you can download the SQLLite3 database from the download page - it's grouped in with the openMSX softwaredb.xml file. There are over 5000 entries in there, let me know if I miss a few ROMs I will gladly add them.

By gdx

Prophet (3933)

17-01-2020, 10:53

The developper is Pencioner but unfortunately he does not have much time to finish the application.
The database (about 3500 entries) is not based on that of openMSX. I made it from zero 6 or 7 years ago. The format is also different because the goal was different. I indicated the thread because your new script looks like what we started and almost finished. Too bad you haven't seen this before.

My database contains MSX and SG1000 Roms (Good and many bad dumps).

By Vampier

Prophet (2379)

17-01-2020, 17:29

I started the script about 12 months or so ago. The database is used for a few other things - like generating a webpage for gr8net to load roms with the correct mapper directly from the build in rombrowser. It also contains the memory addresses for the openMSX trainer file. The rom database is just one of the uses at this point.

By Hydragon

Paladin (716)

18-01-2020, 11:52

Great job on the good work vamp!

By OeiOeiVogeltje

Paragon (1383)

18-01-2020, 13:21

good busy!!!

By Vampier

Prophet (2379)

25-01-2020, 07:02

i'm building in support for zip files (auto unzip and sort) - I've also added the known SVI 318 roms to the database (since openMSX supports the computer)

By gdx

Prophet (3933)

25-01-2020, 18:26

I looked at your list a little. It is impressive.

I found errors. I have noted some of them:

Cheating Wifes -> Cheating Wives
Esta en la Caja (S) [v1.1] is missing
Erusurid - Elslid -> Elthlead
FlappY Bird -> There are two version: Flappy Bird (SCS) and Flappy Bird [Rev.B] (Crunchworks)
Tertis -> Tetris (MSXosaure)

Can you send me a PM?

By Vampier

Prophet (2379)

27-01-2020, 19:53

I sent you a PM over the weekend