export my hands..

[sym25]

How to export only my hands?

[kraada]

There is not an easy built in method to do this. The easiest way is to export all hands, import them into a new database, then purge observed hands.

[sym25]

There is not an easy built in method to do this. The easiest way is to export all hands, import them into a new database, then purge observed hands.

purge take's too much time...

[kraada]

The only other way then would be to do it manually via PostgreSQL.

Click Start --> Programs --> PostgreSQL --> psql to 'postgres'. Enter your postgres password (default is 'dbpass') and hit enter (it doesn't show *s, just type and hit enter). At the prompt type \l and hit enter to list your databases. Type \connect "Your Database Name" (and if the database name has a space, you do need those quotes) and hit enter and the prompt will change.

Type \o exportedhands.txt and hit enter.
Then enter this query and hit enter:
select history from holdem_hand_histories, holdem_hand_player_detail, player where holdem_hand_histories.id_hand = holdem_hand_player_detail.id_hand and holdem_hand_player_detail.id_player = player.id_player and player.player_name = 'Your Username Here';

Keep the quotes if your username has a space, and it is case sensitive. Once the prompt is displayed again, locate the exportedhands.txt file on your computer and that should contain your hands (I believe it'll be in C:\Program Files\PostgreSQL\8.3\bin\).

[sym25]

nothing happens...
file exportedhands.txt is empty.

[sym25]

have done.
but query must execute from file - \i sql.txt
thanks.

[sym25]

:roll: can't import hands from this file to new db...
Import beginning
2010/04/06 12:48:26: Import file: D:\555\f747.txt
2010/04/06 12:48:40: + Complete (0 hands, 0 errors, 0 duplicates)

but file contains about 30000 hands and have size ~ 33mb.

[kraada]

Can you zip the file up and attach it to a support ticket? There may be something obvious we can fix quickly for you in it.

[sym25]

http://www.pokertracker.com/support/tic ... t_id=86552

[kraada]

It's the extra space at the beginning of the line. I'll have a fixed version for you momentarily.