Page 1 of 1

Help ! Change currency + delete duplicates

PostPosted: Tue Feb 24, 2009 1:35 am
by Highstakes0
I don't know if this is the right forum.
I use PostGre SQL.
I don't know how to run quaries against the database or how to write SQL
( so if I have to do that I need your - simple - instructions.)

What I have is 40 000 hands on blind level "5 kr" (the Swedish currency).
I also have 20 000 hands on blind level $5. But these should be under the label "5 kr" !!
They are mislabelled. (This because of a previous program I used which changed them to $ but can't change it back)

Also, when I've done this re-labelling of the 20 000 hands there will be some duplicate hands, 50 maybe. I need a way to delete those.

Thanks

Re: Help ! Change currency + delete duplicates

PostPosted: Tue Feb 24, 2009 1:22 pm
by kraada
There isn't currently a way in PT3 to automate the changing of currency. However, you can purge the individual sessions via the Database --> Database Management --> Purge... options, and then if you change the hand histories back to their original format you can reimport them and they should be imported properly. If you attempt to reimport the hands before purging them, PT3 will ignore any duplicated hands (PT3 won't cause any problems ever by trying to reimport duplicated hands).