Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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
by 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
by 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
by 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
by 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
by 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
by 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: 53972
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by 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
by 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
by 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
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 22 guests