Help ! Change currency + delete duplicates

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Help ! Change currency + delete duplicates

Postby Highstakes0 » Tue Feb 24, 2009 1:35 am

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
Highstakes0
 
Posts: 23
Joined: Mon Mar 10, 2008 6:49 am

Re: Help ! Change currency + delete duplicates

Postby kraada » Tue Feb 24, 2009 1:22 pm

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).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 3 guests