Sony Playstation database has duplicate entries

[rabidpuppy]

EDIT/UPDATE (I worked out the problem before submitting this post): Okay the reason seems to be my database has duplicate entries. There are 7151 entries, most but not all are duplicated. Out of the duplicated ones, 1 of the 2 entries has blank fields for all the Publisher -> Description info. Generally the blank entries are first, which is why I only get 3 matches (those 3 games in bold have the non-blank info entry first in the table).

Now, how do I fix this? How do I update that database, or find out if it is just my database, or a fresh install will have the same dupes?

Cheers

(Original post:)

I have just set up ePSXe in GameEx, and it works fine (have not explored how multiple cds work yet), however I cannot get the GameEx database game info to show up for all games.

I have ensured all the database options are enabled in the emu config, and have updated my game names to match what is in this file:

\GameEx\DATA\EMULATORS\[Console] Sony Playstation.mdb

The games are all ripped from my own Playstation CDs, as *.ccd *.img *.sub files, which are named the same as the .7z archive. If nothing came up for any of them, I could assume I have stuffed it completely and go from there, but out of the following the bold ones display fine, even though all names match those in the database file.

Any ideas please?

Area 51.7z

Crash Bandicoot 2 - Cortex Strikes Back.7z

Crash Bandicoot.7z

Duke Nukem - Time To Kill.7z

Formula 1 Championship Edition.7z

Forsaken.7z

Hercules.7z

Medievil.7z

Moto GP.7z

Need For Speed V Rally.7z

Pitfall 3D.7z

Road Rash 3D.7z

South Park.7z

Star Wars Masters Of Teras Kasi.7z

Star Wars Rebel Assault 2 Disc 1.7z

Star Wars Rebel Assault 2 Disc 2.7z

Street Fighter Ex Plus Alpha.7z

Tactics Ogre - Let Us Cling Together.7z

Tom Clancy's Rainbow Six - Lone Wolf.7z

Tomb Raider 2.7z

Top Shop.7z

Vigilante 8.7z

War Hammer Dark Omen.7z

WCW Nitro.7z

[Lawrence]

The databases are far from finished -- particularly the PSX, which I only started recently.

Nothing to do but wait.

If you want your images to match the names in the database, you needn't do it manually. The program PSX Renamer will do it for you automatically.

[rabidpuppy]

  Lawrence said:

The databases are far from finished -- particularly the PSX, which I only started recently.

Nothing to do but wait.

If you want your images to match the names in the database, you needn't do it manually. The program PSX Renamer will do it for you automatically.

Ok no worries. I edited my database to remove the duplicate entries that had no info.

Keep up the good work!

edit: where do I get the PSX Renamer "dbase.ps1" file? It doesn't appear to be included in the app and is not on the website?

edit2: found it

[saajan4u]

  rabidpuppy said:

EDIT/UPDATE (I worked out the problem before submitting this post): Okay the reason seems to be my database has duplicate entries. There are 7151 entries, most but not all are duplicated. Out of the duplicated ones, 1 of the 2 entries has blank fields for all the Publisher -> Description info. Generally the blank entries are first, which is why I only get 3 matches (those 3 games in bold have the non-blank info entry first in the table).

Now, how do I fix this? How do I update that database, or find out if it is just my database, or a fresh install will have the same dupes?

Cheers

(Original post:)

I have just set up ePSXe in GameEx, and it works fine (have not explored how multiple cds work yet), however I cannot get the GameEx database game info to show up for all games.

I have ensured all the database options are enabled in the emu config, and have updated my game names to match what is in this file:

\GameEx\DATA\EMULATORS\[Console] Sony Playstation.mdb

The games are all ripped from my own Playstation CDs, as *.ccd *.img *.sub files, which are named the same as the .7z archive. If nothing came up for any of them, I could assume I have stuffed it completely and go from there, but out of the following the bold ones display fine, even though all names match those in the database file.

Any ideas please?

Area 51.7z

Crash Bandicoot 2 - Cortex Strikes Back.7z

Crash Bandicoot.7z

Duke Nukem - Time To Kill.7z

Formula 1 Championship Edition.7z

Forsaken.7z

Hercules.7z

Medievil.7z

Moto GP.7z

Need For Speed V Rally.7z

Pitfall 3D.7z

Road Rash 3D.7z

South Park.7z

Star Wars Masters Of Teras Kasi.7z

Star Wars Rebel Assault 2 Disc 1.7z

Star Wars Rebel Assault 2 Disc 2.7z

Street Fighter Ex Plus Alpha.7z

Tactics Ogre - Let Us Cling Together.7z

Tom Clancy's Rainbow Six - Lone Wolf.7z

Tomb Raider 2.7z

Top Shop.7z

Vigilante 8.7z

War Hammer Dark Omen.7z

WCW Nitro.7z

Hi Mate. i know this is not gonna solve your problem. but how do u rip old psx games?

can you tell me please?

[Lawrence]

redump.org has an excellent guide on dumping.

http://redump.org/guide/cddumping/

[rabidpuppy]

Since I had a few dozen games I wanted to do quickly, and that redump process seemed rather involved, I just used Alcohol 120% - make image, playstation profile, save to location, next disc repeat. I'd like to learn the "proper" way, but really they all work fine and I'm not contributing them to any project.

7zip, and works fine in GameEx. Even got the video snaps going from EmuMovies and boxes from somewhere.

Made my own background in line with the other ones I use, based on the PSD template posted by... someone here whose name escapes me right now (thanks for the good work):

EDIT: It's Palmore of course! Cheers!

[bkenobi]

You've probably noticed this, but if you 7zip those images then it will take several seconds to a few minutes to load a game. If that doesn't bother you and the space saved is important to you, then no problem.

[Lawrence]

A nice way to compress PSX images but have no slowdown in loading is to use PSX Emulator (http://psxemulator.gazaxian.com/) which has a specialized compression built in -- images can be converted from the gui or the included commandline utility (I wrote a short batch file to do my whole set at once). Personally, I think PSX Emulator is superior to ePSXe -- it emulates the PSX exactly as it was rather than changing the graphics around. It can also load images directly from the command line, so set up in GameEx is quick and simple. The built in compression works very well -- 50% or more on many games. A nice side effect is that if the image is broken it won't compress -- so it helps to get bad images out of your set. Before compressing, I highly recommend to run your images through PSX Renamer -- video snaps from Emumovies will work better, and so will the GameEx database (although the PSX one is still under construction).

[rabidpuppy]

  bkenobi said:

You've probably noticed this, but if you 7zip those images then it will take several seconds to a few minutes to load a game. If that doesn't bother you and the space saved is important to you, then no problem.

Yes I've noticed, since I have a new fairly decent PC in my newly built 1st cabinet loading time is acceptable. However I plan on putting larger HDs and uncompressing them and other emu disc images once I'm completely out of space.

@Lawrence, http://psxemulator.gazaxian.com/ does not load for me. Thanks for the PSX Renamer tip previously advised. I am rather pleased my Playstation setup in gameex looks and works as flawlessly as other rom based emulators.