Thats not quite true Eratosthenes - he'll get a hud coming up if fpdb imports.

HPR1978 - This isnt doable without writing some code to specifically exclude holdem hands.

fpdb_import.addImportFile() is probably the function you want to munge to do this.

Sorrow

Yeah, I was obviously thinking of the brain damage likely to be caused by playing NL holdem an razz at the same time.

anyway, to only import razz hands, find this line (line 157 in my current dev tree) in fpdb_import.py (in the pyfpdb folder):
and change it to this:
You can't do this trick if you downloaded the all in one exe. You need the source code.

BTW: I didn't test that little trick. and any holdem (etc.) files that have "razz" in the filename will get imported into fpdb--that should be a small problem.

Anyone know what "current session" includes? Please

Hi, I've been trying to get this going by reading the directions on the links from the OP, but have had to start over multi times. Here is where I am at this time...

I DLed/installed the FPDB then the MSQL windows essentials 5.5.2-m2-win32. Then the instructions on this page http://opensimuser.wordpress.com/200...install-guide/ next told me to DL toadmysql. Well I still have winzip on here from the last time i tried this FPDB process and the toad is in my DLs as a winzip. The instructions page just says "launch setup", well i dunno how i do that. I open the toad thing and it's in winzip, how do i get to this toad installation? I'm not real sure on how I work with this winzip. I gave up last time because winzip was an issue with MSQL, but it seems I got MSQL now. How do I get passed this toad thing and on to the next step? Thanks.

ok i have toad up, but the instruction page ive been using http://opensimuser.wordpress.com/200...install-guide/ says "Lets make sure you can view the ‘object palette’ by clicking on ‘View’ on the upper toolbar, and selecting ‘Object Palette’. This will allow you to create and view your database." the version of toad i have doesn't have that option under view, and I can't find the option anywhere. What should I do?

Not completely sure, I think it should include all hands played on the current table in the last 24 hours ... But with the following notes:

- the new import code doesn't adjust the hand time into GMT so I think the 24 hours figure will be slightly different. For Stars I expect it will be the last 19 hours since Stars hand histories are written in ET which I think is GMT+5. This should get corrected in the next week or two.
- starting and stopping fpdb shouldn't make any difference (unless you clear out the db or change the hudcache of course)
- the plan was to eventually add some extra code to stop counting hands if a gap of say 20 minutes is detected (the hands played on the table are retrieved in reverse order) so the stats would only include the current "sitting" if you left a table and then came back within 24 hours ... this might get done eventually - any opinions on that are welcome
- I could be wrong! If you are trying it out whatever you are observing is what it is really doing

how do i switch to using Postgres instead of the default...MySQL or whatever it is?

If you are using the most recent snapshot SQLite is enabled by default, so you don't really need mysql or postgres, unless you really want it. So you should be able to just start fpdb and use it.

If you have already edited the HUD_config.xml file to mysql, replace your database element (this will be near the end of the HUD_config) with this:

Be careful not to copy over anything other than the <supported_databases>...</supported_databases> stuff.

Oops, here's the postgres, howto from the wiki.

Just try using SQLite--see the post to Warren a couple of posts up. If that works OK and you need a heavier db, then you can try to repair mysql.

Hi!
I install fpdb on Ubuntu 9.10
I follow the instruction, but when i run the program, i can't create a database, it shows a window with the message: Unimplemented: create/delete database.. It shows this message all the time i try to click an option where is write "toto" ( Hand Replayer (toto), Player Details (toto), ecc..)
What is the problem?
Thanks for answering..

It "appears" to include all tables. I had 4 tables going, the hud totals were basically all the same (when I sat out and they caught up to each other).

I get the general idea ET is GMT-5 FWIW

PLEASE don't make it time restrictive unless.... A "session" should, IMHO, be adjustable through the config possibly. Just as now when we put a "T" and then put "7" for stat days, why not make it simple for an individual since you can't please all the people all the time...

The "session" option could be hour/mins sensitive "if more than xxx hrs (or mins) since last imported hand, then start a new session." That way a person can create his own "sessions" be it a day, couple of hours, 20 mins or whatever turns them on One other feature that would be nice (you did ask for opinions/ideas) would somewhat simplify it for all. In the "menu" in the hud have two options... "start session stats" and "end session stats" That would allow a player to start and stop stats when he pleased. Or, another option would be to allow us to "reset hud stats to zero" .

That way when a player sits down he can do a reset immediately and create their own session.

This is priceless! On a more serious note, I will play with it a bit in the .01 game and see if I can figure out and report back...

Dog

p.s. thx for the help

You can take the easy way. Download the .deb from snapshots (dated 2010-02-05). Install it with "sudo dpkg -i <filename>".

Because you are using Ubuntu, it is actually easier to set up with Postgresql. Follow the instructions at http://****************/apps/mediawik....29_postgresql and use the "Alternative: PostgreSQL in straightforward manual way" steps.

Then, issue these commands:
And edit the configuration file as instructed in the section "Local PostgreSQL database, no password".

When doing the setup like this, you don't need to know or use any complicated database passwords or user roles.

Then launch fpdb and as the first thing, select from the menu Database -> Create or Recreate Tables. This takes a few seconds. Continue by importing hands and you're set.

Configure HUD as you see fit. Use some of our existing sample configs to get started. (http://****************/apps/mediawik...itle=Howto_HUD)

Here's some facts I found on testing "current session" or the "S" choice in the config file...

I did not test for how long the session might last. I will take the word of others that it should last approx 24 hrs.. However...

When the config file is set to "S", all the tables stay that way. You can change it to "All time" or "7 days" by right-clicking the Hud Menu that shows on the table Hud. BUT, if you change anything in that menu, you change it for all tables open at the time. You cannot have one table be 7 days and another be session.

Also, when I left a table and came back, it was mean to me .. it doesn't like it when you leave and come back to the same table while is session mode. The table I left and came back to, would not pick up new hands. It did bring up my last exiting stats, but after playing several hands, it never updated.

I did get it to update by right-clicking the menu and changing the Player stats to "7 days"... but it didn't start doing 7 days, it just started updating the "session" stats. All the other tables changed to 7 days. It appears if you leave a table while on session, it does remember (for how long I'm not sure) but for some reason it objects to starting again without a good swift kick in the a$$... which means doing the above changes and then back to session... sigh

If you close fpdb, then reopen, it does not remember the session stats, or at least in my test it started the session stats over on the tables I had open... My suggestion? It needs work...

Dog

One other note on current session. It did keep separate stats on individual tables. If you changed to 7 days in the menu, naturally it combined all the tables. If you changed back to "session", it did change back to the original individual stats on each table.

Dog

Thanks Bostik for the answer!
Well, i do what you say, now i can create tables and i can import hand.. I try to use the hud, it runs but i don't see nothing on the table, except the card of the previous hand (but they are positioned wrong).. i try now to change some parametrs..
If i'll have more problem i'll write here..
Thanks a lot!

There is some weirdness about starting the HUD sometimes. Bulk import some hands before trying the HUD. If you just get mucked cards and no HUD, close fpdb, restart it, and restart autoimport.

You can move the mucked cards around with left-click and drag. when you get them where you want them, right click on the FPDB menu thingie and select save layout.

I'll give my information, hopefully it'll allow for more help...

What operating system are you using?

XP

What site are you playing on?

#1 FT #2 Pokerstars

Do you know the directory your Hand Histories are stored in?

No, the instructions page linked says start by importing 1 hand history, and that's where Im at now, I can't figure out where in my FT or PS program files my hand histories are

What snapshot (program file) did you download to do the installation?

fpdb-0.12-20100213 7z SFX Igor Pavlov

Like i said right now I'm trying to do that one hand history, but dunno where the right files are, that is my latest issue. Btw, I've probably played nearly 70k-100k++ hands in the last several months combined on FT and PS's... do you imagine all that is still in these program files? and how would that effect things.

There are definitely some weird things in the session handling, still.

When starting from an empty database (possibly the start of a totally new session too, I'm not positive), the first hand will not be included in your session stats. Tournament session stats do not carry from table to table (presumably because they have differing table names .. i'd guess we could check if it's a tournament, and yank the numbers for that tournament instead of that table .. but i don't know that area of the code in the slightest bit. . in fact, it's been so long since i've been in fpdb, i only really know the parts that i've worked in a lot, mostly the on-screen portion of the hud) .. also, something i've been meaning to look into, and might be able to now that we do have semi functioning tournament support in Everleaf, is why the HUDs don't close/reopen for tournaments, have to close manually.

Everleaf import status:

7 stud is still impossible (not nearly enough data recorded in the handhistory)
PLHE tournaments do not work
Omaha games win/loss stats are all sorts of out of whack
I suspect that the 8-max tournaments that they have just recently started will likely work, but people may need to add an 8-seat layout to their config file, and some code tweaks might be needed to get it to default to 8-seat when 8 players are detected, as is it would default to 10-seat. Unfortunatly, I don't have the bankroll to play in those tournaments right now. If anyone can send me an 8-seat-max Everleaf history, I'll take it


3-4blitz:

On FT go "Options"->"Hand History", make sure it's turned on, and you can specify the folder where your hh files for FT go. I imagine your other sites have a similar mechanism.

Neither Stars or FTP store HHs by default, you need to enable that within the client.

Are you using another tracker? That may be moving the files elsewhere.

You may only be recording HHs for a limited amount of time too.

Sorrow.

EDIT Oh ok. I had no idea. I didn't have the historys enabled yet. So I played and got a few on there. Imported. What's next? there are no instructions left on this http://****************/apps/mediawik...etting_Started page. A better link for me?

I import some hands, and it goes right. But the HUD doesn't work well, i only see the mucked hands, i try to close and restart but it doesn't work This is my terminal..


HUD_main: starting ...

Reading configuration file /usr/share/pyshared/HUD_config.xml

Loading site PokerStars
Loading site Full Tilt Poker
Loading site Everleaf
Loading site Win2day
Loading site Absolute
Loading site PartyPoker
Loading site Betfair
Loading site Carbon

Note: error output is being diverted to
/usr/share/pyshared/log/HUD-errors.txt
Any major error will be reported there _only_.

fpdb_import: sending hand to hud 6572 pipe = <subprocess.Popen object at 0xa85de4c>
tournament 248780283, table 1
0x420006c "320 No Limit Hold'em - Tournament 248780283 Table 1 - Blinds 15/30 - Logged In as Leon083": ("PokerStars.exe" "Wine") 792x546+4+47 +4+47

Window 248780283.+Table.+1 not found. Skipping.
set_opponent_aggregation 10000
setting self.hud_params[h_seats_style] = A
setting self.hud_params[seats_style] = A
setting self.hud_params[h_hud_style] = S
setting self.hud_params[hud_style] = A

Also, Quick dumb question... Will this program/hud's data only be from hands I play with people once I get hand histories in the system? Or will I be plugging into a database that has a bunch of prior information on players from before i enabled hand histories? thanks

As long as they are the proper format, any hand histories you have that will import, will show on the hud. I made the mistake of buying some hh's and their format was incorrect and had a hell of time getting them to import. Eventually, I did away with them. My lession learned. Be sure you go on PS's site "Options">"Hand History Options" and be sure they are being stored to Programs\PokerStars\handhistory\yourname and make sure they are set to something like 90 days. That way you can start storing them. I zip them every night and just add that day's hands to the prior zip file. Easier to recreate the database when you have to.

I create a zip file like "PS HH Jan-Mar2010" and do it every quarter. That's why I suggested 90 days in the above option online at pokerstars.

Dog

Thanks. So if I get this going and a month from now some guy who never played at a table with me enters a room I'm in, the "HUD" will have no information on him, correct?