Export original HH

[tgmaster]

Hello!

If I set in the import section that the original HH's will be imported too, then it will be stored in the holdem_hand_histories table. If I write a report that contains a filtered list of these HH's then I can export them into a text file for further use. I have tried quite a lot, but I don't have too much experience in writing such reports.

e.g. How can I export the original HH's that was played since 04.01.09. into a file? Or export other simple filtered HH's?

tx
Gabor

[kraada]

Click Start --> Programs --> PostgreSQL --> psql to 'postgres', at the prompt type \l and hit enter, then \connect 'Your Database Name' and hit enter. The prompt will change to indicate that you have changed databases.

Type \o C:/Hands.txt and hit enter.

Then run this query:

select history from holdem_hand_histories, holdem_hand_player_detail, player, holdem_hand_summary where holdem_hand_histories.id_hand = holdem_hand_player_detail.id_hand and holdem_hand_summary.id_hand = holdem_hand_histories.id_hand and holdem_hand_player_detail.id_player = player.id_player and player.player_name = 'Your Username Here' and holdem_hand_summary.date_played >= '2009-Apr-01';

and all of the hands played on or since 4/1/09 will be exported to the file C:/Hands.txt.

You can change the query or the output file name as needed.

[tgmaster]

I'll try it.
Thanks a lot,
Gabor

[WhiteRider]

If you only want to filter by date, limit or site you could use the Selective Export window.
Tutorial: Selective Export

[tgmaster]

If you only want to filter by date, limit or site you could use the Selective Export window.

Tx, but this was only an example. I wanted to filter by hole cards and by hands where I put money in the pot in addition to dates. I think at this moment this script was the only way to solve this. I could extend it accordingly, thanks for u both.

[kraada]

Understandable, and you're quite welcome :)