Glad it worked out. Sounds like you made the right choice, importing a bit at a time and exporting the data.

Post a link to your findings once you've had a chance to analyze the data!

Sure thing. Here is part 1 of my report.

Also, I just found a HH importing bug in FPDB (ver 0.30.7 on windows, using SQLite). What's the best place to report it: here or in the bug tracker?

Here is the bug description:

The following hand makes the bulk importer hang. I'm pretty sure it's because of the fact that plr5 shows down a 2-card hand, even though this is pot limit omaha. Namely, the problem is most likely due to the following two lines:
Seat 5: plr5 mucked [Ah As]
plr5: shows [Ah As]

Here is the complete HH:

PokerStars Hand #1337: Omaha Pot Limit ($0.50/$1.00 USD) - 2012/04/12 23:00:00 ET
Table 'SomeLie V' 6-max Seat #1 is the button
Seat 1: plr1 ($214.42 in chips)
Seat 3: plr3 ($146.25 in chips)
Seat 4: plr4 ($388.38 in chips)
Seat 5: plr5 ($138.24 in chips)
Seat 6: plr6 ($38.26 in chips)
plr3: posts small blind $0.50
plr4: posts big blind $1
*** HOLE CARDS ***
plr5: raises $1 to $2
plr6: folds
plr1: raises $4.50 to $6.50
plr3: calls $6
plr4: folds
plr5: raises $20.50 to $27
plr1: folds
plr3: calls $20.50
*** FLOP *** [Kc 2s Jc]
plr3: bets $58.73
plr5: raises $52.51 to $111.24 and is all-in
plr3: calls $52.51
*** TURN *** [Kc 2s Jc] [Qd]
*** RIVER *** [Kc 2s Jc Qd] [6h]
*** SHOW DOWN ***
plr3: shows [Kd Qc Jh 9h] (two pair, Kings and Queens)
plr5: shows [Ah As]
plr3 collected $281.18 from pot
*** SUMMARY ***
Total pot $283.98 | Rake $2.80
Board [Kc 2s Jc Qd 6h]
Seat 1: plr1 (button) folded before Flop
Seat 3: plr3 (small blind) showed [Kd Qc Jh 9h] and won ($281.18) with two pair, Kings and Queens
Seat 4: plr4 (big blind) folded before Flop
Seat 5: plr5 mucked [Ah As]
Seat 6: plr6 folded before Flop (didn't bet)

Excellent work. I've been meaning to do an analysis like this myself.

Thanks for the heads up. I'll add a fix for this that'll be incorporated in the next release.

HUD is not displaying for windows with title "No DP". This is on the iPoker network. The title bar states: playername: "TURBO" French (No DP) NLHE - $0.05/$0.10. HUD works with windows that don't have "No DP" like: playername: "TURBO" French NLHE - $0.05/$0.10. This is not working on 0.39.993 and 0.30.7.

Anyone know a workaround for this? I have the source available but was not able to find where the regex is.

I found a workaround. I modified iPokerToFpdb.getTableTitleRe, as shown below. Not sure if this is optimal. I already emailed devs, so hopefully they will include a fix in the next release.

def getTableTitleRe(type, table_name=None, tournament = None, table_number=None):
log.info("iPoker getTableTitleRe xxxx: table_name='%s' tournament='%s' table_number='%s'" % (table_name, tournament, table_number))
regex = "%s" % (table_name)
if tournament:
regex = "%s" % (table_number)
elif table_name.find('(No DP),') != -1:
regex = table_name.split('(No DP),')[0]
elif table_name.find(',') != -1:
regex = table_name.split(',')[0]
else:
regex = table_name.split(' ')[0]

log.info("iPoker getTableTitleRe: returns: '%s' NLHE" % (regex))
return regex

Hi.HUD(Release 0.30.7) not works with tournaments,I play in iPoker(poker770). Cash stats normal. What could be the problem? Sorry for my English

I have version .39.991 and the HUD isn't showing up, even after complete deletion, re-download and reinstallation.

The small window pops up, but the actual overlays never appear. I've been messing around with it for the last hour to no avail. Help is much appreciated!

Edit: This is on Lock Poker. The HH are getting properly auto-imported into the database.

I'm using this program with good results. but I can not make the HUD work in zoom poker. the program already supports zoom poker?? thanks

I deleted .39 and reinstalled 30.7, deleted the HUD xml file.

Still no overlays or anything showing up on my tables. I'm just really frustrated trying to get this to work.

Error log from HUD:

Traceback (most recent call last):
File "logging\__init__.pyc", line 838, in emit
File "logging\__init__.pyc", line 715, in format
File "logging\__init__.pyc", line 464, in format
File "logging\__init__.pyc", line 328, in getMessage
TypeError: not all arguments converted during string formatting
Logged from file hud.pyc, line 386
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 150, in shouldRollover
File "logging\__init__.pyc", line 715, in format
File "logging\__init__.pyc", line 464, in format
File "logging\__init__.pyc", line 328, in getMessage
TypeError: not all arguments converted during string formatting
Logged from file hud.pyc, line 386
HUD_main.exe:331: GtkWarning: gdkwindow-win32.c:2216: SetWindowLongPtr failed: Invalid window handle.
HUD_main.exe:331: GtkWarning: window 003A0192 unexpectedly destroyed
HUD_main.exe:331: GtkWarning: window 002D0516 unexpectedly destroyed
HUD_main.exe:331: GtkWarning: window 002B046C unexpectedly destroyed
HUD_main.exe:331: GtkWarning: window 001202CE unexpectedly destroyed
HUD_main.exe:331: GtkWarning: window 001802CC unexpectedly destroyed
HUD_main.exe:331: GtkWarning: window 001902C4 unexpectedly destroyed
HUD_main.exe:331: GtkWarning: window 00AA02BC unexpectedly destroyed
HUD_main.exe:331: GtkWarning: window 0044028E unexpectedly destroyed

Error log for FPDB

fpdb starting ...Traceback (most recent call last):
File "logging\handlers.pyc", line 78, in emit
File "logging\handlers.pyc", line 135, in doRollover
WindowsError: [Error 32] The process cannot access the file because it is being used by another process
Logged from file database.pyc, line 520
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file fpdb_import.pyc, line 462
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 78
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 129
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 145
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file database.pyc, line 520
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file fpdb_import.pyc, line 462
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 78
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 129
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 145
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file database.pyc, line 520
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file fpdb_import.pyc, line 462
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 78
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 189
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 129
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file handhistoryconverter.pyc, line 145
Traceback (most recent call last):
File "logging\handlers.pyc", line 77, in emit
File "logging\handlers.pyc", line 151, in shouldRollover
ValueError: I/O operation on closed file
Logged from file database.pyc, line 520

I would really like some help, I'm going insane trying to make this work.

Alright, wiped everything off, reinstalled again. It works now, but I'm afraid to edit the layout of the stats displayed.

I had been trying to build a 4x4 layout which may or may not have caused the problem.

I'd realllllllly like to set up a custom layout, but if it's going to cause the stats not to show up I can use it as is.

One other weird thing- if I resize the window, the stats get flung all over the screen. Is there a way around that?

i'm having trouble making fpdb work with bovada, not sure what i'm doing wrong seeing as how i've clicked around pretty much everywhere and tried multiple things, still no luck with the HUD/tracking/Hand History. a basic run down of what to do to get this running would be awesome.
i have .39 and got it installed/extracted, but thats about as far i've made it.

Alright, got the HUD to where I can have a 3x4 display, which works out well enough for me. Is there a tutorial on how to set the color scheme for different values?

This is from an old post I saved:

"These changes are done by editing the config. Take a backup of the config before changing these settings because fpdb will fail if the definitions are not correct.

Here is an example of a more advanced stat:

stat_name="vpip_0" hudcolor="#FFFFFF"
hudprefix="VPIP : " hudsuffix="%"
stat_hicolor="#F05000" stat_hith="35"
stat_locolor="#408000" stat_loth="15"
should give:
VPIP : 31%

explanation:
vpip_0 - means show the vpip stat, but use zero decimal places (so 67.2 becomes 67)
hudcolour #FFFFFF means by default, display this in white text (this is an RGB value in hex)
hudprefix - fixed text to be shown before the VPIP value
hudsuffix - fixed text to be shown after the value
stat_hith="35" + stat_hicolor="#F05000" - if value > 35, use orangey colour
stat_loth="15" + stat_locolor="#408000" - if value < 15, use greeny colour "

still can't figure out what i'm missing with bovada, entered my ID, and all that jazz, made it as far as the ring player stats in 'getting started', imported my hand history, but nothing happens when i refresh stats.

Using Stars, all working OK, except when playing PLO six-max, cash. The HUD appears to attach itself to seats at random. In NLHE, it seems to find me OK. In PLO six max, I have set a preferred seat. I have manually positioned the HUDs, saved and restarted, many times, but it just seems to attach to random seats.

Hi!

I'm trying to run fpdb 30.07 with lock. I have downloaded and extracted the files, but as soon as I click the "run_fpdb" folder, three things happen.

One: A black CMD box opens, but nothing appears.

Two: User account control (windows security) pops up and I click the allow access button.

Three: Something, presumably fpdb, launches for an instant, then instantly closes.

What should I do?
Thanks!

I think that since Bovada hand histories don't contain user names, your id defaults to 'Hero'. Try putting that in the id box and click 'Refresh Stats'

Try opening up a command window (by going to Start, Run and typing 'cmd'), change to your fpdb directory and try running the 'run_fpdb.bat' file from the command line. Hopefully, you will be able to see any error messages there.

Also in the pyfpdb directory there may be a file called 'fpdb.exe.log'. You could look in there for any helpful error messages.

Oh my god, you managed to give clueless me advice on a software problem that actually worked. Your amazing, thanks so much. Turns out my firewall was fighting it, which explains why it launched for an instant then quit.

Thanks so much!

No problem

Hi, a friend play in Poker770.es and HUD not work in tournament... the error in log is this:

Help please!

It looks like there's a Euro sign in the table number. Do you have a hand history from that tournament?

Hello! I'm about to install Ubuntu 13.04 64bit and I would like to know what version of Postgresql works with Fpdb? Does the latest (9.2.4 64bit) work ?

fpdb requires at least 9.2.4, so yes that should work.

For real? 9.0.x seemed to work fine for me when I last tried fpdb.