[RESOLVED] Number of times played list?

[bkenobi]

I remember playing a game 3 or 4 times around a year ago, but, other than a basic description of game play, I can't remember anything. I've been getting some assistance at BYOAC on finding the game that way, but I was thinking that if I were able to see a list of games played and manually parse it, that would be easiest. Unfortunately, I've been struggling with network connectivity on my cabs since we moved and can't easily log in to check the database that way. The TV and keyboard/mousing setup are less than ideal to perform this task either. SO, what file contains the number of times played? Is that the DATA.mdb file, or do I need a different one? I'll copy it to a USB stick and parse it on better setup if I can grab the data.

[fRequEnCy]

I remember playing a game 3 or 4 times around a year ago, but, other than a basic description of game play, I can't remember anything. I've been getting some assistance at BYOAC on finding the game that way, but I was thinking that if I were able to see a list of games played and manually parse it, that would be easiest. Unfortunately, I've been struggling with network connectivity on my cabs since we moved and can't easily log in to check the database that way. The TV and keyboard/mousing setup are less than ideal to perform this task either. SO, what file contains the number of times played? Is that the DATA.mdb file, or do I need a different one? I'll copy it to a USB stick and parse it on better setup if I can grab the data.

Yes! It is the DATA.mdb file located in the DATA directory of your GameEx install.

[Draco1962]

Since reimaging my system I have only played a few games and only through MAME. The Data.mdb appears to be where the System Statistics draws the data as it shows the emu number (0 being MAME), ROMFile, Favorite, Times Played, Last Played, Minutes Played, Video Position and Aspect Ratio. I think it is safe to say that is where I would start. You could easily export it to a .csv file so you could "drill down" through the data and sort much more easily to find what you are looking for.

[bkenobi]

I have access on another system, so I was planning on checking there. Are you saying GameEx can export system statistics to .csv? If so, that must be a new feature (at least to me ).

[fRequEnCy]

I have access on another system, so I was planning on checking there. Are you saying GameEx can export system statistics to .csv? If so, that must be a new feature (at least to me ).

Don't think he meant GameEx can do this cuz I'm not aware of such a thing either. Just something that can be done by other means.

[bkenobi]

Yup, that's what I figured. What if the game wasn't in the main MAME list. I think the game may have been a mature title and loaded in a different list (second MAME instance so it could be turned off if not appropriate for the company. Mature titles are GREAT for shock value!

DATA.mdb is just for MAME, isn't it?

[fRequEnCy]

Yup, that's what I figured. What if the game wasn't in the main MAME list. I think the game may have been a mature title and loaded in a different list (second MAME instance so it could be turned off if not appropriate for the company. Mature titles are GREAT for shock value!

DATA.mdb is just for MAME, isn't it?

No. It's for all emulators. Listed by EmuNumber (Emulator Number). 0 being MAME as mentioned by Draco1962 before. Best to just open up the file so you can see the details of what's in there.

[Draco1962]

bkenobi you are so silly! Tom hasn't released that version of GameEx yet!

If you open the data.mdb in MS Access, you have the ability to export to .an excel spreadsheet or Comma Separated Values (.csv) file, and, if using Office 2007 or later, a few other formats including PDF. Of course, if you don't have MS Office, you can always grab a copy of Sun's (or is it Oracle now?) OpenOffice which is compatible with the MS formats and is free.

[bkenobi]

I checked the data.mdb file the other day and found no mention of any of the candidate games. Although that was a bit disappointing, it was actually helpful. I wasn't sure if the game was "clean" or "mature" before, but now that don't see it in the main list, I know that it must have been played through my "mature MAME" list which is set up as a different emulator. Anyway, after narrowing that down, I played the 3 candidate games and determined which one I must have been remembering.

Party Time: Gonta the Diver II / Ganbare! Gonta!! 2 (World Release)

[fRequEnCy]

I checked the data.mdb file the other day and found no mention of any of the candidate games. Although that was a bit disappointing, it was actually helpful. I wasn't sure if the game was "clean" or "mature" before, but now that don't see it in the main list, I know that it must have been played through my "mature MAME" list which is set up as a different emulator. Anyway, after narrowing that down, I played the 3 candidate games and determined which one I must have been remembering.

Party Time: Gonta the Diver II / Ganbare! Gonta!! 2 (World Release)

Glad you got it figured out! Resolved? If so I'll let you make the change on this one.