Stu1983

The name in the database has to pretty much exactly match the name of the rom so this is one of the problems with the current databases as the names for allot of games, that exist in the database, are not the same as the name in the various GoodTools... These new sets as well as containing a hell of a lot more games have also been matched as best as possible to the current GoodTools names so allot more games should display info, the game display info on the page after you select a game from your games list before launch, I think this is an optional screen that has to be turned on, the database is also used to sort by year , category and manufacturer from the side menu. Stu

Good work, I'll hopefully get a chance to look at this later on today for you Stu

nice work man, thanks for these Stu

I had looked into this at the start but the only common rules I could find were the same as LB11 has mentioned and I found it was easier to just sort the MDB by Category and then by Non Sport and copy and paste the relevent category in, there were to many factors to conisder for nailing any more than that so I didn't see any point in writing anything for it Stu

I haven't had a chance to look at the PC XML yet but I'm wondering does it contain more than the MDB we currently have? Would it possibly be easier just to replace the current MDB with everything in the XML? I got myself a tablet PC to play with but I could possibly fire something together today or tomorrow if you've think it would be worthwhile... this would passably be useful for a few other MDB's that were a bit lacking let Me know what you'se think Stu

I use a nointro rom set but then I run GoodTools on it to rename the files to the same as in GoodTools just because this is the common naming convention for snaps and that though I think Circo mentioned somewhere that he's naming his new sets to NoIntro Stu

Couldn't agree more, you'll prob get better results with ePSXe, if you can be bothered pissing about with the settings but I have 1500 iso's stored on my cab so there's no way I'm gonna be bothered setting them all up any time soon I'm also using an ArcadVGA for graphics which wouldn't handle anything fancy like shaders anyway Stu

I go with pSX 1.13 myself, maybe other emulators have better features, pluggins and what not but for ease of use this thing rocks, compatibility from what I've tried is amazing... I don't play playstation alot on my cab but every game I've wanted to try has worked like a charm, I've no issues with it at all Stu

Cool this sounds superb... I've been thinking of investing in a couple of these for a while now but I wasn't sure how easy they'd be to setup Just wondering, I have a emulator set up for PC games which launches individual batch files for each game, I assume this pluggin will load the same profile for every batch file but will I be able to override the loaded profile by calling a command at the top of my batch file? Stu

I'm not sure why this would be but I'm wondering why you would have to Emu's set up for the same emulator? Are you using different internal settings for the 2 Project 64's to play different games better or something? This is something I thought about doing a while ago but never looked into it, if you are doing this I'd be interested in seeing the settings you using and for what games. Stu

I'll wait untill the're all done then I'll upload a zip containing them all to FileSend or something Here's the rest of the Handhelds minus PSP as there is no XML for it, there's none for any of the mobiles so we can't do them either I've also included a more complete Playstation MDB, I've filled in most of the 230 odd that were still missing but there's still 25 or so more to do Stu _Handheld__Nintendo_Virtual_Boy.zip _Handheld__Nokia_N_Gage.zip _Handheld__Sega_Game_Gear.zip _Handheld__SNK_Neo_Geo_Pocket.zip _Handheld__SNK_Neo_Geo_Pocket_Color.zip _Handheld__Tiger_Electronics_Game.com.zip _Handheld__Tiger_Telematics_Gizmondo.zip _Console__Sony_Playstation.zip

Here's a few more completed Stu _Handheld__Atari_Lynx.zip _Handheld__Bandai_Wonderswan.zip _Handheld__Bandai_WonderSwan_Color.zip _Handheld__Nintendo_DS.zip _Handheld__Nintendo_Game_Boy.zip _Handheld__Nintendo_Game_Boy_Advance.zip _Handheld__Nintendo_Game_Boy_Color.zip _Console__NEC_PC_FX.zip _Handheld__Sony_PSP.zip

I'm not sure what it could be but I've tested a couple of others there and they appear fine too Here's the SNES MDB Stu _Console__Nintendo_SNES.zip

Nice one... takes the thought out of compiling Stu

Woo thats some great work you've done LB11! I just tested your N64 mdb in my cab and its working perfect I checked all the games in the racing category and they are all driving games of some sort and Mortal Kombat is showing up in fighting as expected... it must be something on your end that messing things up for you. I've a SNES file almost complete, I've just a few games left to add... I've been manually googling any game without a category to see what it is and the assigning it one myself using the AllGames category names, I know it slow doing it manually but there's never really that many to do I'll get tucked into a few more hopefully this evening Stu

Here's a set of console MDBs that I've already renamed the column and added the extra column so you can jump straight to step 4 EDIT: Here's the rest of the MDBs ready to be dropped straight into my tool Stu

I forgot this happens with some databases but I can't work out way, the actual error is "No value given for one or more required parameters" but I've now idea how to fix it. I have a feeling it's because some of the cells in the mdb are being left blank but previously I've tried making sure all the cells have some sort of data but it doesn't fix it... maybe somebody that knows a bit more about OleDb or MDBs in general could help me out I think this only happens with 2 or 3 of the MDBs so I've just beeb ignoring it Have you tried any of the other MDBs by adding the Category header yourself? Just wondering if you first problem is Access 2003 or not Stu

These are all completly matched, I've manually matched the last few that my tool couldn't find [Console] Atari 7800 - Complete [Console] Atari Jaguar - Complete [Console] Coleco Vision - Complete [Console] Fairchild Channel F - Complete [Console] GCE Vectrex - Complete [Console] Mattel Intellivision - Complete _Console__Atari_7800.zip _Console__Atari_Jaguar.zip _Console__Coleco_Vision.zip _Console__Fairchild_Channel_F.zip _Console__GCE_Vectrex.zip _Console__Mattel_Intellivision.zip

The LDB is normal it appears everytime a MDB is opened... even when you open it in Access the LDB should appear That error means that it's not finding the Category column, the only way I can make that happen is by spelling Category wrong in the MDB, I wonder is it something to do with Access 2003, I'm using Office XP but I tested it with 2007 yesterday Try loading the database I've attached in and see if it works Stu _Console__Atari_5200.zip

I have a little something for us You'll need headkaze's xmls pack from his post here Here's the instructions 01. Open the MDB your working on in Access 02. Rename the current colum call 'Category' to 'Multi Category' 03. Add a new column called 'Category' 04. Close the MDB 05. Run my modified FuzzyTool 06. Drag and drop the MDB onto the List 1 box 07. Drag and drop the matching XML onto the List 2 box 08. Leave all other options as they are and click Match 09. Amuse yourself until the Results window appears... may take a while 10. Check down through the 2 columns and put a tick in the box if you DISAGREE with the match 11. Click 'Update MDB' That should be you, check the MDB to make sure the Categorys column in the MDB now has some data If you drop the MDB into my tool again it will only load the games that don't have a category This is handy because if you let it run again it may find some other useful results because now all the exact match have been removed it keeps my tool more options to play with eg. you may have previously match 'NHL 05' with 'NHL 2005' but now it might match 'NHL 05' with 'NHL 06' which for this case is a vaild match as both games are going to have the same category I've tested this with the SNES database and it's matched everything apart from 25 which I plan to do manually... but it's bed time now Stu FuzzyTextMatch135.zip

I was looking for something like this too, I had a quick look months ago but never turned up anything... my arcade monitor has a max of 640 by 480 which is generally ok but the newer EA sports games all default to 800 by 600 min If you find something let me know Stu

I spent a bit of time checking the SNES mdb names with the names I extracted from the SNES xml and my FuzzyTool found 540 exact matches and 192 possible matches which after checking there were 180 odd valid matches... There only are like 730 or entries in the mdb any so for that set & probably most of the rest I reckon we'll be fine just working a system at a time, that way there should be no chance of mixups. I'll need to modify my fuzzy tool to add the new categories for us then we can deal with any left overs afterwords I'll hopefully get something done for us in a few days... though everytime I go near that tool my life seems to slip away as I try to improve the match function Stu

Yeah this is why I wanted more input before battered on... I done a simple check and there are 400 odd games out off the 26000 that have the same name but a different genre, I don't know the names yet I just quickly removed the genre column in excel and then sorted and removed duplicates in the name column so I'll need to write something to find those games first... The problem is that if there were 2 games called "Stunner" on 2 different systems they would always return 100% match, so without checking on a per system level first we wouldn't know if it was the same game or not which is the bit I'm trying to avoid if we definately have a few people willing to pitch in its not so bad, I just don't fancy going through all the databases again myself... the other option I'm just thinking is merging same era sets eg. snes and genesis, master system and nes and so forth, this should give us better results and minimise mixups @LB11 The problem is to get the best matches the program needs to be comparing the whole data set each time... I think I could write my tool to to use multi threading for the bulk of the processing, haven't really done much with multi threading but I've been looking for a project to implement it on as a test it's not that much use to me though as my home pc doesn't have dual core or multiple cpu's and I'll not be able to sit in work sorting games all day It has 2 Xeon 5160 chips which are dual core themselves Stu

We have a few MyBooks in work and they just show up like any other exernal drive, when they're plugged in they'll appear as an extra hard drive and windows and everything pretty much just treats them just like any other internal hard drive. I currently have GameEX load my karaoke zips from my external media drive without any trouble Stu

I made a few more changes to the databases that I had posted in the step 2 topic so here is the complete WIP package as it stands at the moment 7zip'd MDB Package Beta3 I feel that this set, even as it stands at the moment, far surpasses the original set supplied with GameEX Stu