I have done the above and installed everything that came up. Then I followed the instructions in the Wiki and created the database. Then when I try to click the "fpdb.py" file a black command screen comes up with some error message(don't have time to read what is says, disappears very fast).

Have I missed some step? Any ideas what to do.
Thanks.

I still need to figure out how to automate these processes, but at least it's good to know that it's a bit closer, and the installs all went off without a hitch?

oh... hmm.. I guess I should've put a PAUSE at the end of the install bat file..

after you run fpdb.py the first time, it should put a default HUD_config.xml file in your %APPDATA%\fpdb folder (normally \documents and settings\YOUR USERNAME\Application Data\ ) .. if it is not able to do that, then it will use the HUD_config.xml file in your FPDB folder.

So, you want to edit \documents and settings\YOUR USERNAME\Application Data\fpdb\HUD_config.xml (or the same file in your FPDB folder if there isn't one in your App Data\fpdb folder) go down to the bottom of the file, and put in your database username and password.

I am interested in working on this software and making it more userfriendly. Some ideas I have include:

- Distributing the Windows version of this application as a executable file, not a bunch of Python files. Python should not be required to be installed on the Windows distributable.

- Improving the setup and install process.

- Creating a skinnable hand replayer using the pygame library.

- SNG / tournament support.

Also I'm curious why you chose MySQL for this project, why not PostgreSQL? Also I think SQLite support should be available because some people don't want to install a database server on their computer.

Also this software is useless for me (and probably many others) right now. For example, I play Razz HU SNG on Full Tilt Poker, which this software does not even support.

Welcome, we could use someone working in this area.

A little bit of work has been done in that area, check out py2exe (and .... ekdikeo?) from memory the gtk libraries are a bit problematic.
We could certainly use this.
Hand replayer is on the horizon, taking a look at pygame now.
FWIW - This works for the most part, its retrieving useful info about tournament hands that is lagging.
I personally prefer MySQL, but only because i'm more familiar with it from work, and i'd assume Steffen was in the same boat.

The development version supports both PostgreSQL and MySQL, and most parts work with SQLite now too. Postgres and Mysql support are probably equal at the moment.
What version are you looking at? My understadning is that razz sng's and tourneys are functional at the moment. I cant say i've ever seen a razz husng though.

Sorrow

My Ubuntu computer died a few days ago so I had to switch over to my M$ computer. I am now having significant problems working with FPDB in Windows. I know, its shocking. I have the same problem with PyGTK. I'm at a lost and I have no idea how to get around this problem.

Desktop\fpdb_0.11.3\pyfpdb\fpdb.py", line 35, in <module>
import pygtk

I have Python 2.6 installed along with the 2.6 versions for PyGTK, Numpy, MatPlotLib, GTK+. I've set up the database via the command line with no problem. Do I need to uninstall Python 2.6 and go with 2.5 instead? I am using the older version of MySQL. Version 5.1 would not install on windows so I went with Version 4.1 instead.

I uploaded a new installer zip created by ekdikeo recently to sourceforge. Within it is a .bat file that downloads a set of compatible versions of the various components. If you take a look in that bat file you can see which versions he is using.

It should work with either 2.5 or 2.6, the problem will likely be PYTHONPATH. I'm not sure where that is set on windows. I remember a report that OOo or pidgin set the path to a different version of python screwing things up. If you're ex-ubuntu i'm guessing you may have those installed.

Sorrow.

I haven't even installed pidgin or anything else on here yet. I really wanted to revert back to Ubuntu but I'm not allowed at the moment. Families are annoying.

I edited your bat file with "pause" and it worked this time. I was never able to read anything that was in the BAT file. I wasn't really sure what it was about so I just went and found everything I needed via google. I don't know why people are afraid to do a little searching on their own. Python is well known. Anyway I had most of the programs installed already. I was missing a couple though. I hope it will work.

I'm working on MySQL again. I'll post again if I can get it up and running before I head off to bed. If I don't I'll probably just uninstall everything tomorrow and start from scratch. Man Linux is so much easier to work in.

I'm running PY 2.6 and MySQL 5.1 on Window's Vista and it is working. Don't ask me how, as Sorrow assisted me with some initial problems I had, which were related to the password on Mysql not taking properly. We had to reset it. Other than that, I can't be of any help, but it does run on Vista.

Dog

Well I got rid of my PyGTK problem but a new one has arisen. I'm not really sure where to put the HuD Config file. My new error -

C:\Python26\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated
from sets import ImmutableSet
No HUD_config_xml found. Exiting

I thought that FPDB would use the HUD_config_xml found in my FPDB folder. I'm not sure where to put the config file.

Nevermind... I am an idiot. I forgot to rename the HuD config once I edited the file.... I downloaded a few of them today.

I use XP.

If I ever upgrade to M$ again it'll be on Windows 7. I've used Vista before and I hated it with a passion. I'm really amazed that the FPDB team has put so much effort into making it work on Vista. Most major developers were not even putting any effort into making their programs work on Vista.

phenix: it's called "HUD_config.xml" (not _xml) and it's stored in \Documents And Settings\YourUserName\Application Data\FPDB or in the folder where FPDB.PY is started.

I didn't really put much work into getting it to work in Vista, but the same problems that people had in Vista were also present for people using it in XP that do not run as administrator. I had a computer that ran vista, for a minute or so.. and my gf's mom has a laptop that runs vista.. other than that, I've not even seen Vista for more than a few minutes.

We do really want to check out 7 for our EEE pc though .. sigh.

Yep, it was a silly mistake. I downloaded the zip 3x yesterday and forgot to convert the file on the 3rd download. I am having new issues today. I had it running last night but now it is failing.

Why is the HuD not working though?

Traceback (most recent call last):
File "HUD_main.py", line 51, in <module>
import Tables
File "\fpdb_0.11.3\pyfpdb\Tables.py", line 34, in <module>
import win32gui
ImportError: No module named win32gui

One feature that is currently marked "todo" would sure help the Player stats screen/database. The ability to selectively delete a catagory. I occasionally use micro games to test this and other programs. I end up with a lot of odds and ends lines. I know, don't turn on the autodownload. I always forget it's on... sigh. Then to clean it up I have to recreate the whole database and go to backups of HH's and rebuild everything.

I also like to break my HH's into two-month segments figuring anything much older than that is somewhat a waste. Sure would be nice to have it, even if it had different abilities to delete specific HH's.

Thanks for the consideration..

Dog

You can't delete in the dev version, but i'm pretty sure that you can filter the view using both date and limit.

Hey i am seeming to have a tough time installing and than running the program was wondering if someone can help me. I read all the how to's but still seem to not be able to run the program please help me. Also mu OS is windows xp

I'm working on saving hand histories from openholdem into an fpdb postgre database. Currently, I have a c++ dll which logs most actions to a text file. I'm wondering what is the best way to insert the info into the database? Should I just write my own sql insert statements or is there a better way?

We can try, but i've not idea where you are failing at the moment - more info please, logs, command line output, written description of what you are doing... anything more descriptive than "tough time installing"

If you make the text file you are logging to the same format as stars, or write a converter (HandHistoryConverter) for your log file auto-import will just pick it up and insert.

Sorrow.

Thanks Sorrow. I think that I'll try to match the stars format and auto-import since that's already supported. Do you happen to know if there is any info on the stars hand history format anywhere? I've found some examples on the web but would feel better about working with a standard I know that fpdb will understand.

There isn't a standard. But, fpdb doesn't actually interpret Stars format directly, it interprets a Starslike format, close enough is good enough.

I suggested using HHC has that file converts several hh formats into the Starslike format that fpdb uses to insert.

Could you add a feature that tells me I'm going to get rivered BEFORE it actually happens?

ok when i am trying to start it this the error i get

C:\Python26\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated
from sets import ImmutableSet
No HUD_config.xml found, using HUD_config.xml.example.
A HUD_config.xml will be written. You will probably have to edit it.Traceback (most recent call last):
File "C:\Documents and Settings\Roxana\Desktop\fpdb_0.11.3\pyfpdb\fpdb.py ", line 465, in <module>
me = fpdb()
File "C:\Documents and Settings\Roxana\Desktop\fpdb_0.11.3\pyfpdb\fpdb.py ", line 377, in __init__
self.load_profile()
File "C:\Documents and Settings\Roxana\Desktop\fpdb_0.11.3\pyfpdb\fpdb.py ", line 269, in load_profile
self.settings['db-password'])
File "C:\Documents and Settings\Roxana\Desktop\fpdb_0.11.3\pyfpdb\fpdb_db .py", line 62, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database, use_unicode=True)
File "C:\Python26\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python26\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")
please help me

This is a stab in the dark, but something I ran into when I set it up for the first time.

If you've already updated the HUD_config.xml with your database username and password then the issue may be that the "fpdb" catalog doesn't exist on your MySQL server.

If you create an empty catalog named "fpdb" then when you run the application the first time it'll notify you and there's a menu option to create the tables/view/etc that FPDB needs.

If you're unaware of how to add a catalog you may want to check out the MySQL GUI administration tools:

http://dev.mysql.com/downloads/gui-tools/5.0.html

Just thought I'd give an update:

I'm running Vista Home Premium (64-bit) and finally got graphing to work after updating everything except python (2.5) to the latest versions. The only issue I'm having now is an issue someone mentioned back in March I believe. When I run a graph more than once without closing fpdb it will create a duplicate graph underneath itself. The data that shows up is in each graph is the same as the second request run. All successive graphs result in an additional graph under the last. I've tried clearing the dates, etc. The only way I've found to get back to one graph is by closing the fpdb entirely and re-opening it. I know this is something that at least one of the developers could not duplicate (no pun intended). Has anyone ever found a solution to this problem.

Thanks to all working on this project. I absolutely love the program and am really looking forward to its continued growth.

I've just downloaded sql's git (first attempted update in a long time ) and I'm getting "no player ids found" on almost every action, whereas I don't get such messages from the working version I have (from April). I guess this is something trivial. Any "5 seconds or less of thought" clues?

Looks like you haven't edited the config file to add the fpdb database password.