If you're using the default sqlite database configuration you can view the schema with the Firefox plugin SQLite Manager. The database file is located at C:\Users\[Username]\AppData\Roaming\fpdb\database\fpdb.db3 on Windows Vista/7/8

Oh I hadn't dled it yet I meant whether you just had the outline somewhere I could view to decide whether I wanted to dl it or not. Thanks for the quick response.

I can't get the HUD to work on SwC 0.2.15 or 0.2.17. Is this currently supported?

I use fpdb on Seals With Clubs, and I've noticed that players who are sitting out are still recorded as being in the hand. Their hand totals continue to increase, and I'm assuming that also has some affect on stats like vp$ip and pfr...

I'm having problems with SWC as well. Seems to be working fine everywhere except for HU tables. Actually I don't have the HUD working anywhere but it is importing and storing info fine for all other than HU tables.

Hi, I'm a new user here, installed it for the 5-card PLO support.

EV line is not showing though when I graph 5 card PLO hands. Can you help me or EV line is not supported for 5 card PLO?

It's not supported, unfortunately.

Are you running the latest FPDB version? It should work with FPDB version 0.40.4. Are the hands importing, but no HUD, or are neither working?

Can you please send an example hand with someone sitting out to support@pokeit.co?

Should be if you've set your hero name correctly (case-sensitive).

Downloading it and importing a few hands is probably the best way to see how we store everything. The database schema has changed a great deal over the past few years and sadly we haven't kept up on documentation. Source code is public however, so feel free to dive in if you're feeling ambitious - https://github.com/ChazDazzle/fpdb-chaz

Quoting because I'm not sure if you've seen it or not.

Thanks again.

Thanks. Missed that one. Should be storing chips as micro-bitcoins - just the same as shown in the client. No conversion is done. Not sure why the values are off for you, maybe you're missing some hand history files? I'd check the stats for a single session and see if they match what you've won/lost/#hands

Sweet! Thanks

Can anyone confirm they have managed to get HUD working on this version for Stars on a Windows 8 laptop?

I checked hand histories are importing correctly, have set up preferred seating, turned user account control off and have set up statistics for the HUD.

Anything else I've missed or need to check in the HUD section in preferences or elsewhere?

Sent from my GT-I9505 using 2+2 Forums

If you haven't tried already, navigate to the FPDB folder and run the install_fpdb.bat file. As I think I have read before, that may clear up the no HUD issue.

I also am having great success with FPDB except for the HU hands at sealswithclubs. Neither the HUD nor the bulk importer will accept the heads up table history files. the 6-max and 9-max table import great.

here are clips from both: (names changed

(1) an importable 9-max table with two players,
HH20131031 NLHE 9max 10-20 0.txt

Hand #11206246-4 - 2013-10-27 04:15:38
Game: NL Hold'em (400 - 2000) - Blinds 10/20
Site: Seals With Clubs
Table: NLHE 9max 10/20 #0
Seat 5: Hero11 (1870)
Seat 7: Villian (2124)
Villian has the dealer button
Villian posts small blind 10
Hero11 posts big blind 20
** Hole Cards **
Dealt to Hero11 [As 3c]
Villian raises to 40
Hero11 calls 20
** Flop ** [Qh Jd 8c]
Hero11 checks
Villian bets 60
Hero11 folds
Villian refunded 60
Villian wins Pot (78)
Rake (2)


and (2) an example HU table file that wont import:
HH20131031 NLHE HU 15-30 2.txt

Hand #11442832-1 - 2013-10-31 07:53:57
Game: NL Hold'em (600 - 3000) - Blinds 15/30
Site: Seals With Clubs
Table: NLHE HU 15/30 #2
Seat 1: Hero11 (1346.42) - waiting for big blind
Seat 2: Villian (2798.10)
Villian has the dealer button
Villian posts small blind 15
Hero11 posts big blind 30
** Hole Cards **
Dealt to Hero11 [4c Tc]
Villian folds
Hero11 refunded 15
Hero11 wins Pot (30)
Rake (0)


In my three weeks playing with fpdb, this has been very consistent. All multiseat table files import great and the HUD works ; all HU tables have no HUD and their history files won't import.

for some reason when i try to use my hud ingame it disappears after 1 hand and then reappears then disappears etc. why?

This should have been fixed in FPDB version 0.40.4. Double check if this is the version you're running

Are you using multiple monitors by-chance?

i am using the new version:

Operating System: Windows ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Python: 2.7
GTK+: 2.24.10
PyGTK: 2.24.0
matplotlib: 1.1.0
numpy: 1.6.1
sqlite: 3.6.21
fpdb version: 0.40.4
database used: sqlite
language: en_US
character encoding: cp1252

Ok. Thanks. Can you also tell me what the window title would be for a HU table? We use those window titles to get the HUD latched on correctly.

NLHE HU 5/10 #1 - NL Hold'em (200 - 1000) - Logged in as Hero33

that's the window label.

fwiw i tried renaming the HU file to the same name as the ring games, and it still wouldnt import in the bulk import.

Weird. Don't worry about it. I'll see what's up

I thought I'd add my two cents. I have had problems with the HU HUD and import as well.

I have v.40.4, win 7 64, swc .17, I'm not sure what else is relevant.

This is what I have found. If you change the title in the HU hh file to read 2max instead of HU, and, open it in notepad, go to edit, choose find and replace, and replace all instances of HU with 2max, it will import. This does not fix the HUD not working, but it does import it so you can analyze your play and keep track of winnings/losses. Maybe this extra info will help programmers pinpoint the problem?

Also, I am extremely limited in my knowledge of python. But, I did look at the code to see if I saw anything. Kinda like you do when your car breaks down. You open the hood and look around and then close it without doing anything, cause you dont know much (at least I dont).

I looked at BovadaToFpdb instead of another site, because I knew it had heads up tables, and I dont know that for sure about any other site.

This was my observation. In the BovadaToFpdb.py file, under

re_GameInfo = re.compile

there is a little part that mentions HU which is this line:

(?P<HU>1\son\s1\s)?

the SealsWithClubsToFpdb.py file does not have a line like that under re_GameInfo. They both have this line a little later:

if key == 'HU' and info[key] != None:
hand.maxseats = 2

I think in the SealsWithClubsToFpdb.py when it checks "if key" equals HU, it did not previously store the HU info from the hand info so it returns an error instead of assigning 2 to hand.maxseats. I think it only stores information about the max players if it finds max in the handinfo line somewhere and doesnt store HU.

Anyways, thats just a complete shot in the dark, and I'm probably making myself look like an idiot.

Also, I dont know if both these steps are necessary, or if only changing just the title, or just the hands inside the file will work on their own. I highly suspect the most necessary part is changing each hand inside the file.

Before I posted this, I decided to confirm my hunch. If you only change each hand within the file to read 2max instead of HU, It will import. You do not have to change the title of the file. Additionally, If you change only the title to 2max and do not change each hand inside the file, it will fail to import.

Also, I just want to express my gratitude for all the work that has gone into FPDB. It is an awesome piece of software. I really do appreciate all the work that has gone into it.

Thanks!

Does the hand viewer work for 5 and 6 card PLO? Clicking on the hand viewer does nothing for me. Im running on Windows 8 64b.

Thanks for the great software! Good job guys!