My Report + 11GB Database

[CrittHunter]

argh...32bit software...that makes sense then. I've used to break down the export using 100K hands each, but then I need to modify the filter every single time using the hand numbers. That takes a lot of time since I have to use a custom filter in order to include other player's hands with known holecards! As I mentioned before, a preview and export all to CSV option (+progress bar) would be a solution or a build in pagination. Anyhow, thank you for the feedback. Guess we have to wait for 64bit then or mentioned options.

[kraada]

Date filters might be easier and less work. You could break it down into months or weeks depending on volume and that will make it easier to put everything into one spreadsheet later for analysis.

[CrittHunter]

I think I tried this before. I still need an additional filter since I want:

a) My player hands (Add new expression filter)
b) All player's involved in the hand with my player (Add new expression filter)

I might want only those hands with b) that have seen the flop or maybe those where I know the holecards. Therefore "Add new expression filter" with both.

PS: Would also love to see the holecards + flop + turn + river being included as text with statistics. Like "AhQd". There is a solution in the forum for cash games I am using right now, but this could go into core for tourney and cash. Also I am missing the draws statistics, which I manually added as well.

[kraada]

Those kinds of additions are on our list, but I can't say exactly when we'll get to them.

[BillGatesIII]

You could try to run the report, wait till it crashes, close PT4, open the log file, copy the last executed query, paste it in pgAdmin, copy the results from there and paste it in a spreadsheet.

[CrittHunter]

@BillGatesIII

Thank you for the hint...I am working with CSV files...easiest format for Excel etc.

@Support

Should be a matter of 30min to add additional statistics and would enhance the product Or not?

- Text Hole Cards (like "AhQd")
- Text Board Cards (like "KhTs4c")
- Text Flop Cards
- Text Turn Card
- Text River Card
- Draw Straight
- Draw Gutshot
- Draw Double Gutshot
- Draw Flush

[CrittHunter]

Works...

[CrittHunter]

@BillGatesIII

Unfortunately the pgadmin query outputs slightly different data when using the query from log. We have to wait for 64bit PT4 so report can display 1mio+ hands on one page or an option to export all hands to CSV with one call.