My Report + 11GB Database

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Re: My Report + 11GB Database

Postby CrittHunter » Tue Feb 18, 2014 10:18 am

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.
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Re: My Report + 11GB Database

Postby kraada » Tue Feb 18, 2014 11:13 am

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

Re: My Report + 11GB Database

Postby CrittHunter » Tue Feb 18, 2014 11:45 am

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.
Attachments
pt4-2.jpg
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Re: My Report + 11GB Database

Postby kraada » Tue Feb 18, 2014 12:10 pm

Those kinds of additions are on our list, but I can't say exactly when we'll get to them.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: My Report + 11GB Database

Postby BillGatesIII » Tue Feb 18, 2014 1:45 pm

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.
BillGatesIII
 
Posts: 740
Joined: Fri Dec 16, 2011 6:50 pm

Re: My Report + 11GB Database

Postby CrittHunter » Thu Feb 20, 2014 7:53 am

@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
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Re: My Report + 11GB Database

Postby CrittHunter » Tue Mar 04, 2014 11:58 am

Works...
Attachments
Stats.rar
(9.73 KiB) Downloaded 124 times
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Re: My Report + 11GB Database

Postby CrittHunter » Tue Mar 04, 2014 12:16 pm

@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.
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Previous

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 60 guests

cron
highfalutin