how do i find and delete duplicate games in chessbase 8? i see a
procedure on the internet on how to do it in chessbase 7, using the
technical menu, but not 8. tia. pete

my tools menu has no such choice as find double games. i bought fritz 8 and
this chessbase came with it, with 500,000 games. i added some games from
twic twice so i want to find how to eliminate duplicate games.

my tools menu choices a (within chessbase)
cross table
database
analysis
rating
classification
design
factory settings
customize

options none of these lead to any find double games.
yhanks
pete j.





wrote in message
...
On Thu, 08 Dec 2005 14:43:52 GMT, "PeteJohnsonNews"

using recycled electrons muttered something about:
how do i find and delete duplicate games in chessbase 8? i see a
procedure on the internet on how to do it in chessbase 7, using the
technical menu, but not 8. tia. pete

Hi Pete,

Right click on the data base. Scroll to tools/Find double games. This
opens a
new window and you get to decide what to do, e.g. delete the first game,
delete
the second game, keep the better game etc., and decide if you want the
parameters to be exact names, similar names, tournaments, moves, and so
on.


No problem is so formidable that you can't just walk away from it.

i read the manual and found that i really don't have chessbase 8, i have
fritz 8 which came with a chessbase compatable database. sorry for the
invalid question. pete

"PeteJohnsonNews" wrote in message
...
how do i find and delete duplicate games in chessbase 8? i see a
procedure on the internet on how to do it in chessbase 7, using the
technical menu, but not 8. tia. pete

PeteJohnsonNews wrote:
my tools menu has no such choice as find double games. i bought fritz 8 and
this chessbase came with it, with 500,000 games. i added some games from
twic twice so i want to find how to eliminate duplicate games.

my tools menu choices a (within chessbase)
cross table
database
analysis
rating
classification
design
factory settings
customize

options none of these lead to any find double games.
yhanks
pete j.



No, true. You don't have such features in Fritz, but in Chessbase.
The Fritz GUI isn't a databse program.

HD


wrote in message
...

On Thu, 08 Dec 2005 14:43:52 GMT, "PeteJohnsonNews"



using recycled electrons muttered something about:

how do i find and delete duplicate games in chessbase 8? i see a
procedure on the internet on how to do it in chessbase 7, using the
technical menu, but not 8. tia. pete


Hi Pete,

Right click on the data base. Scroll to tools/Find double games. This

opens a

new window and you get to decide what to do, e.g. delete the first game,

delete

the second game, keep the better game etc., and decide if you want the
parameters to be exact names, similar names, tournaments, moves, and so

on.


No problem is so formidable that you can't just walk away from it.

PeteJohnsonNews wrote:
my tools menu has no such choice as find double games. i bought fritz 8
and this chessbase came with it, with 500,000 games.

You've been confused by the rather unhelpful names so let's clear that up
first! ``Chessbase'' refers either to a particular company that makes
chess software or to its main product, a chess database. That company
also makes Fritz, a chess engine and GUI, that comes with a database.
This is what you have but it isn't Chessbase.

Now to turn to your actual question. Alas, the database that comes with
Fritz can't eliminate duplicate games. Probably the easiest way to solve
your problem is to save the database as PGN, use PGN-extract[1] to remove
the duplicates and then save the database in Chessbase format again. Be
aware that you'll need plenty of free disk space. I once converted the
Fritz 8 database to PGN format and those games alone come to something
like 350Mb in PGN. I've no idea how well PGN-extract will cope with a
file that big.


Dave.

[1] http://www.cs.kent.ac.uk/people/staff/djb/pgn-extract/

--
David Richerby Disgusting Wine (TM): it's like a
www.chiark.greenend.org.uk/~davidr/ vintage Beaujolais but it'll turn
your stomach!

David Richerby wrote:
Be aware that you'll need plenty of free disk space. I once converted
the Fritz 8 database to PGN format and those games alone come to
something like 350Mb in PGN. I've no idea how well PGN-extract will
cope with a file that big.

Just had a thought. There are some things that PGN-extract should be
happy to do even with very large files. For example, pulling out all the
games played before 1995 can be done easily without needing the whole file
in memory at once but extracting duplicates requires either having some
kind of index in memory or doing lots of very slow searches through the
file.

So, I'm sure that PGN-extract will be able to do filtering on huge files
even if it can't dedupe them. If it can't dedupe huge files, you can
probably get away with the following. I think you mentioned that your
duplicates come from TWIC so they're all recent games. Filter out all the
games played before your first TWIC game into a separate file to give a
file of old games with no duplicates and a file of new games with
duplicates. Dedupe the new games and merge.


Dave.

--
David Richerby Simple Indelible Windows (TM): it's
www.chiark.greenend.org.uk/~davidr/ like a graphical user interface but
it can't be erased and it has no
moving parts!

On 2005-12-09, David Richerby wrote:

Hi!

Be aware that you'll need plenty of free disk space. I once converted
the Fritz 8 database to PGN format and those games alone come to
something like 350Mb in PGN. I've no idea how well PGN-extract will
cope with a file that big.
So, I'm sure that PGN-extract will be able to do filtering on huge files
even if it can't dedupe them.

Actually if exporting to PGN is an acceptable solution (I
did it once at Fritz6's database), I would suggest to use a
real chess database that has the deduping feature (and a lot
more), that is freely available and handles on my box
happily a some 3*10^6 games base.

In short: use Scid and relax

http://scid.sourceforge.net

Get it, set it up, be happy It can't read chessbase'
undocumented native format though, so you have to go via
PGN. But for Fritz 8's database this is possible.

The only drawback of scid is that unfortunatley the author
does not seem to provide updates anymore. Anyway, scid is as
is in version 3.6.1 really worth to install you will
experience less bugs (if any) then in most of your other
software including your OS As I say I use it happily for
quite some time now with a really huge db. And you may
experience some features you will only find in ChessBase
itself. It's far beyond what Fritz can do as far as I can
see in Fritz. Maybe I missed some points there...

Addtionally there is a successor in the work which will be
available for Unix, Windows and MacOS X. The project is in
an early stage, but pretty promisiong indeed with a lot
going on behind the stage. Maybe some developer is here that
wants to join. See

http://newscid.sourceforge.net

(But the latter is NOT ready to solve the deduping problem
yet! Use Scid!!!)

--

Kind regards,
Alexander Wagner

thanks much to all. yes, i have scid and have used it many times and i have
eliminaded dups with it.
pete
"Alexander Wagner" wrote in
message ...
On 2005-12-09, David Richerby wrote:

Hi!
snip
Actually if exporting to PGN is an acceptable solution (I
did it once at Fritz6's database), I would suggest to use a
real chess database that has the deduping feature (and a lot
more), that is freely available and handles on my box
happily a some 3*10^6 games base.

In short: use Scid and relax

http://scid.sourceforge.net

Get it, set it up, be happy It can't read chessbase'
undocumented native format though, so you have to go via
PGN. But for Fritz 8's database this is possible.

The only drawback of scid is that unfortunatley the author
does not seem to provide updates anymore. Anyway, scid is as
is in version 3.6.1 really worth to install you will
experience less bugs (if any) then in most of your other
software including your OS As I say I use it happily for
quite some time now with a really huge db. And you may
experience some features you will only find in ChessBase
itself. It's far beyond what Fritz can do as far as I can
see in Fritz. Maybe I missed some points there...

Addtionally there is a successor in the work which will be
available for Unix, Windows and MacOS X. The project is in
an early stage, but pretty promisiong indeed with a lot
going on behind the stage. Maybe some developer is here that
wants to join. See

http://newscid.sourceforge.net

(But the latter is NOT ready to solve the deduping problem
yet! Use Scid!!!)

--

Kind regards,
Alexander Wagner