hole/board cards in report export

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

hole/board cards in report export

Postby greedysoul » Fri Aug 17, 2012 6:22 am

Hi, when exporting a report which contains hole and board cards, the card values are in a weird format and not showing the suit. For example, Ah6d is exported in the report as "14060000". Wouldn't it be better to export as "Ah 6d"?
thx
greedysoul
 
Posts: 42
Joined: Sat Feb 23, 2008 12:41 pm

Re: hole/board cards in report export

Postby kraada » Fri Aug 17, 2012 9:12 am

That's a known issue in our system to be changed.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: hole/board cards in report export

Postby CrittHunter » Tue Jan 29, 2013 12:09 pm

Hello,

when is this going to be changed? Right now I can export AKs or AKo, which is fine too...but the suit is needed as well. Same with Flop Turn River, which has not been changed yet. Any way to get a table with matching plain text to the code number?
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Re: hole/board cards in report export

Postby kraada » Tue Jan 29, 2013 2:11 pm

I'm afraid I don't know when this particular issue will be addressed. If you create a support ticket though we can make sure you get automated notification when it is.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: hole/board cards in report export

Postby CrittHunter » Wed Jan 30, 2013 4:16 pm

Already did quiet some time ago...it would help to get the matching code table...how about that...
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Re: hole/board cards in report export

Postby CrittHunter » Fri Feb 01, 2013 9:33 pm

I will try to explain in detail:

Currently it looks like this with report...

Board: Nothing is exported (Report shows pictures)
Flop Card: 121010 (Report shows pictures)
Turn Card: 10 (Report shows pictures)
River Card: 10 (Report shows pictures)
Hand: T6s (Report shows text)
HoleCards: 10060000 (Report shows pictures)

It should look like this...

Board: Ah Tc 6s 6h 7s (Report shows pictures)
Flop Card: Ah Tc 6s (Report shows pictures)
Turn Card: 6h (Report shows pictures)
River Card: 7s (Report shows pictures)
Hand: T6s (Report shows text)
HoleCards: Th 6c (Report shows pictures)

If you could provide the matching codes, it would be a hotfix for now...I don't even know if Pokertracker imports the suits as well?
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Re: hole/board cards in report export

Postby WhiteRider » Sat Feb 02, 2013 6:05 am

The numbers exported are the ranks of the cards "10" is a 10, "12" is a queen. Suit information is not included in exported reports currently.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: hole/board cards in report export

Postby CrittHunter » Sat Feb 02, 2013 6:26 am

Are they imported in the database anywhere? Has to be...how else do the pictures show the suit correct!
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Re: hole/board cards in report export

Postby BillGatesIII » Sat Feb 02, 2013 7:54 am

CrittHunter wrote:Are they imported in the database anywhere? Has to be...how else do the pictures show the suit correct!


In cash_hand_player_statistics (and other tables) hole and board cards are stored as a small integer. I think it's coded like this:
1 = 2 of clubs
2 = 3 of clubs
...
9 = 10 of clubs
10 = J of clubs
11 = Q of clubs
12 = K of clubs
13 = A of clubs
14 = 2 of diamonds
15 = 3 of diamonds
...
26 = A of diamonds
27 = 2 of hearts
28 = 3 of hearts
...
39 = A of hearts
40 = 2 of spades
41 = 3 of spades
...
52 = A of spades

Be aware this is not what the report is exporting. You'll have to query the tables directly. In the report export there are no suits, only the numbers 2 till 14.
BillGatesIII
 
Posts: 740
Joined: Fri Dec 16, 2011 6:50 pm

Re: hole/board cards in report export

Postby CrittHunter » Sat Feb 02, 2013 1:18 pm

Thank you...is it possible to query those table columns within the report feature of PT4? Something like custom column?

Configure->Statistics
CrittHunter
 
Posts: 41
Joined: Sat May 19, 2012 10:33 am

Next

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 16 guests

cron