Selectively deleting data?

[chrisnewman]

Is is possible to delete all my cash game hands? Or all my games at certain limits? But to keep the tournament database intact...

Something broke. I ended up with my cash games tab showing a loss of $92,000 over 3,000 hands. I definitely haven't played $3/$6 - not to mention that the loss rate shown is actually impossible I think (5BB/hand). Looks like some of my SNG hands have ended up in the cash games database because if you replay them there's always 9x$1500 at the table...

I've tried reloading my saved HH into a fresh database, but I apparently have some tournament summaries missing so that's no good.

So I'd be happy enough with trashing my cash game history from the old database and reloading just those if it's possible. Otherwise I guess I'll have to maintain separate DBs for tourney/cash now???

[WhiteRider]

Are these tournament hands which imported incorrectly from Pokerstars?
Which version of PT3 were you running when you imported them?

You can't yet remove certain sessions/levels/cash games, but this will be added soon ("Selective Purge").
Development Timeline.

[chrisnewman]

Originally imported in 3.02, now using Beta 18. I don't know at what point they imported incorrectly, the tournament data always seemed fine, but the other day I went to start playing a cash game and saw the $3/$6 rubbish. It could have been there a while.

I thought it might be possible to export all the hands to text files and reload on the SNGs as the filename indicates whether it's tourney or cash, but I got this message during the export:

Error: Access violation at 0x77948169 (tried to read from 0x00156A68), program terminated.

[WhiteRider]

Ah, OK, thanks.

You should be able to reimport as you say., but you will need to import into an empty database.
If you have a registered copy you can use a new database, otherwise you will have to Purge first.
See the 'how to' post in the Database / Postgres FAQ if you need more help.

You probably still have all your hands in the 'processed' folder (see auto import 'move processed files to' section.
If not, The Export should work fine - give it another go.

After you do this, if you see new hands imported into Beta 18 doing the same thing, please let us know.

[chrisnewman]

(posted prematurely, please ignore)

[chrisnewman]

I got all the tourney data recovered now thanks.

Strange problem with my cash game hands now though. I manually imported some fine but then played a few hands with auto import on and nothing updated. The auto import status said it found each file in turn and listed the hand numbers it was loading, but the number of hands played and other stats did not change.

Then when I was done playing I forced a manual import from the processed HH folder and everything updated. Any ideas?

[WhiteRider]

That sounds strange - if you see this behaviour again, please generate and submit a log file.