Updating description, year and company (1 Viewer)

[TheOncleJuna]

Do you want update the database of myEmulators in a few minutes?
With this process you will get Description, Year and Company of the games.
Genre isn't available


First you need this:

Download the last version of MAME from here:
MAME | Latest MAME Release
Now mame0128b.exe, extract the files, you only need mame.exe

Download TWXML2CSV from here:
Alle Programme von www.wenzlaff.de mit Pad Datei
Unzip twxml2csv1.1.zip, you only need xml2csv.exe

Download the last version of sqlite from here:
SQLite Download Page
Now sqlite-3_6_6_1.zip, extract the files, you only need sqlite3.exe

Download a batch file to update the database.
View attachment 29342


Or download this compressed file with the programs : MEGAUPLOAD
the applications are public domain or freeware.


Second, make a folder with the files and a copy of myEmulators3.db3
and run update.bat

>mame.exe
>myEmulators3.db3
>sqlite3.exe
>update.bat
>xml2csv.exe

Your database is updated. Rename the original database (backup),
copy the new and run MediaPortal.

With myEmulators 2.0 this batch works fine, only need change
"myEmulators3.db3" for "myEmulators.db3" in update.bat.

Explaining the batch:

-Extract information of the games from MAME, one XML of 30mb.
-xml2csv transform XML in CSV with ";" like separator, some games have
a "," in the description.
-SQLite3 search each game of myEmulators database (knights.zip) in a
MAME information, and get Description, Year and Company.

Thanks JC for your help

 

[emphatic]

As this only affects the rom database, this should work for other Emus using the MAME roms, as long as it supports listxml, right?

Emph

 

[TheOncleJuna]

If you see in romcenter the last version of MAME support 7264 games
from different consoles.

I have updated the description, year and company of the most roms
of CPS1, CPS2, CPS3, NeoGeo, Taito, Toaplan and Cave.

I'm going to try now with NES and SNES roms.

Updating the database you will see the complete name of the rom when
it is selected, and you can order the games by company or year.

 

[Chreekar]

A new feature to import/export meta data: https://forum.team-mediaportal.com/my-emulators-247/my-emulators-12771/index60.html#post348881

 

[dir]

The instructions in the first post don't quite work - there is no xml2csv.exe in the twxml2csv1.1.zip file in the link provided - it's a java script that runs a gui (all in German). It doesn't work anyway because it expects XSL files.

I found a working copy of xml2csv from http://www.download25.com/install/a7soft-xml2csv.html

Grab that and the update.bat file then works fine.

Noteworthy is that I'm using mamep.exe, not mame.exe - either rename it or modify the bat file.

 

[dir]

Have found a bug in the 2.5 unreleased version. The importing approach above allows the single quote sign to be included in the game names/descriptions/company names etc., e.g.

Magic Johnston's Basketball
'88 Games

etc.

But when you use the MyEmulator configuration program to do things like make certain games visible, attempts to save/apply changes crashes it.

I've also discovered a couple of things:

Recent versions of Mame have >7000 roms, and all of these get entered in the database using the instructions in this post.
Most of these are clones, bootleg, and language varieties. Of the 7000 roms, it's likely that less than 1000 are originals+correct language. It's going to be a bitch to manually make the right ones visible.

There's only a subset of images available for the roms. I have 2100+ flyers, or I could use 1700 cabinet images, or 4700 titles.

It'd be great if the configurator program could somehow indicate if there is a matching image available so I can quickly eliminate those that don't have images.

Of course, the best way would be to hand-pick those roms I want in the system, but as a long-time Mame freak, it's usually easiest to simply have all 7000+ roms in there and know where to go to find the ones I want to play.... But I suspect to keep things clean and neat, I'll need to be selective.

Gasp!

 

[pirivan]

Have found a bug in the 2.5 unreleased version. The importing approach above allows the single quote sign to be included in the game names/descriptions/company names etc., e.g.

Magic Johnston's Basketball
'88 Games

etc.

But when you use the MyEmulator configuration program to do things like make certain games visible, attempts to save/apply changes crashes it.

I've also discovered a couple of things:

Recent versions of Mame have >7000 roms, and all of these get entered in the database using the instructions in this post.
Most of these are clones, bootleg, and language varieties. Of the 7000 roms, it's likely that less than 1000 are originals+correct language. It's going to be a bitch to manually make the right ones visible.

There's only a subset of images available for the roms. I have 2100+ flyers, or I could use 1700 cabinet images, or 4700 titles.

It'd be great if the configurator program could somehow indicate if there is a matching image available so I can quickly eliminate those that don't have images.

Of course, the best way would be to hand-pick those roms I want in the system, but as a long-time Mame freak, it's usually easiest to simply have all 7000+ roms in there and know where to go to find the ones I want to play.... But I suspect to keep things clean and neat, I'll need to be selective.

Gasp!

Very interesting post here. So the unreleased 2.5 version has better integrated MAME configuration? I was just trying to setup MAMEUI32 using the batch file and it hasn't been going well (I see a cmd line launch for running the batch file and then it does nothing). In any case, I would be highly interested in some more serious automated MAME support like MyPrograms had. The first posters method seems like a real workaround for actually being able to browse the roms with their actual names from within the MAME emulator as opposed to just seeing the zipped file names.

Is anyone familiar with how the myPrograms MAME functionality had worked? All you had to do was use the GUI and put in the rom dir, the image directories, specify some arguments and then make sure the catver.ini and history.dat file was in the MAME dir. You then hit update database and it populated all the titles for you. It would even pull screenshots for the games (if they weren't in zipped files)/ I have attached screenshots of how smoothly and easily this worked.

Is there any way that this level of functionality/interoperability with MAME (specifically in my case MAME32UI) could be integrated into myEmulators? I would love to be able to say goodbye to myPrograms as it looks like that plugin (and its replacement myProgramsAlt) are both dead projects. In its current form myPrograms only partially works (it won't default to 'files view' it tries to browse by manufacturer every time and doesn't 'remember' it the next time you open MP if you swap it to files view).



-Pirivan-

 

[Chreekar]

Have found a bug in the 2.5 unreleased version. The importing approach above allows the single quote sign to be included in the game names/descriptions/company names etc., e.g.

Magic Johnston's Basketball
'88 Games

etc.

But when you use the MyEmulator configuration program to do things like make certain games visible, attempts to save/apply changes crashes it.

When does this bug occur? Only if you try to edit a game with this character in the title or even if the game doesn't contain it?

 

[dir]

After I've done that SQL stuff, then I go into the v2.5 configuration editor. I was trying to tick/untick the 'Visible' tick box, then hit apply/OK. I'd get a crash dialog that shows which entry it was crashing on. I think the first crash was '88 Games. I removed the ' mark, hit apply, and it would then crash on the next one that had a ' in it. I removed that one, hit apply, and it would crash on the next one.

Some of the ' marks are in different fields such as the game's name, company, etc.

 

[hulkhaugen]

I also tried this yesterday, but i used my copy/paste superskills, found some good descriptions over at mobygames (I don't have so many games). I had to manually remove all the quote symbols ( this symbol: ' ) to be able to apply and save the changes.

I also wondered if it's possible to add a line break syntax like <br /> or something in the description? (Haven't really tried yet)

BTW! it looks really good now, thanks for this great plugin!!