Does the auto-import box show that it is importing files? or are you just getting .........................

Sorrow

I don't recal if it makes one bit of difference to the importer, it probably does to the HUD - On all the Everleaf softwares i've seen, the poker exe is called "Poker.exe"..

I've got the program installed and HUD running without problem. Do I have to enter my SN and find the HH folder every time I start the auto import? I'm trying to find out if there is a way to save my SN and settings.

There is a way through the properties menu:
fpdb->supported_sites->site->HH_path and screen_name

The other way is to edit the config file directly.

Sorrow

hi,
I have installed latest .exe on a win7 system and the positional stats in the veiwer does not work this is the log I get after trying to select it-
fpdb starting ...Traceback (most recent call last):
File "fpdb.py", line 864, in tab_positional_stats
File "GuiPositionalStats.pyc", line 122, in __init__
File "GuiPositionalStats.pyc", line 176, in fillStatsFrame
File "GuiPositionalStats.pyc", line 187, in createStatsTable
sqlite3.OperationalError: near "' '": syntax error,
player stats and graphing seem to work, also I have used the hud and bulk imported with no errors so far.
This as prob been asked b4 but is there a way of stopping the mucked cards(I think thats what they are) from showing after every hand.
Thanks

when i click on "Start Autoimport" i get:
i start playing but nothing change



yeah, u're right...i changed it in Poker.exe but still doesn't work

wait...the autoimport works, but the hud doesn't work, when i play i get
(AP_Piemonte_I is the name of the table)

Thanks for your persistence. I went back to square 1 and ran through it all again. Finally, I still had a problem which I "think" was that 2 of the seat stats got switched round when I was manually moving the stat windows around.

Everything seems to be working fine now (it works first time on FT too).

Thanks again guys for a great product and excellent support.

It works!!!!
Thank you guy, a very good job!
Just a question for help a friend: He has windows vista 64bit, but the Hud doesn't work and he close it.. The program can run under a 64bit software?
Now, when he tries to launch again the program, it appears only an MSDos window, and doesn't start nothing..

This is probably some permissions problem. One thing to try is to open a command line window, navigate to the pyfpdb folder and run it from the command line. Some people run it as administrator to get around permissions problems.

It looks like it's finding the hands and importing them, which is good.

Can you find the pyfpdb/ folder and double click Tables.py please?

Hi guys, I'm trying to import 70mb worth of hand histories and it has a bar moving saying importing that has been running for 1.25-2 hours now. Is it normal for the importing of 70mb worth of HHs to take this long? Also can I still play on my poker site while the import is taking place?

The log file should indicate any activity going on.

Wherever your config file is, you should have a directory called 'log' with a file fpdb-log.txt within it

Help->Log Messages should open the same file, though i'm not sure how much testing that code has had.

Sorrow

Find the line in your HUD_config.xml that looks like this

<game aux="mucked" cols="3" db="fpdb" game_name="holdem" rows="3">

and delete the word "mucked", thus:

<game aux="" cols="3" db="fpdb" game_name="holdem" rows="3">

This is the original post answering the question.

I can't help with your other problem, however.

Apologies - missed this post earlier.

That looks like a short lived bug that is already fixed, if you are using the latest .exe version then we need to track.

From memory it occurred when a stud game was imported, but the limits were corrupt.

Can you re-create your database then bulk-import a small number of files at a time and let me know which file caused the issue please?

I'll pm my email address shortly.

Sorrow

Ok, the below is what was listed in the log from the time I started the import, on. A little over half an hour ago I think I accidentally closed out the importing screen somehow, but it still said importing and had the moving bar 2-3hrs after I started. I was away from my comp while it was importing and the screen/energy saver mode kicked in a couple times, maybe an issue? Dunno how much if anything was imported? Here is the edited down log...

22:03:16,551 - config Reading configuration file C:\Documents and Settings\Administrator\Application Data\fpdb\HUD_config.xml
22:03:16,894 - db Creating Database instance, sql = <SQL.Sql instance at 0x01E25238>
22:03:16,894 - db Connecting to SQLite: C:\Documents and Settings\Administrator\Application Data\fpdb\database\fpdb.db3
22:21:13,239 - config Reading configuration file C:\Documents and Settings\Administrator\Application Data\fpdb\HUD_config.xml
22:21:13,380 - db Creating Database instance, sql = <SQL.Sql instance at 0x01E25238>
22:21:13,380 - db Connecting to SQLite: C:\Documents and Settings\Administrator\Application Data\fpdb\database\fpdb.db3
22:21:37,676 - db Creating Database instance, sql = <SQL.Sql instance at 0x01E25238>
22:21:37,676 - db Connecting to SQLite: C:\Documents and Settings\Administrator\Application Data\fpdb\database\fpdb.db3
22:21:37,676 - db Creating Database instance, sql = <SQL.Sql instance at 0x01E25238>
22:21:37,676 - db Connecting to SQLite: C:\Documents and Settings\Administrator\Application Data\fpdb\database\fpdb.db3
22:22:59,614 - importer Started at 2010-03-08 22:22:59.614000 -- 1 files to import. indexes: auto
22:22:59,614 - db commit finished ok, i = 0
22:22:59,614 - importer Converting C:\Program Files\Full Tilt Poker\HandHistory\*\*_*.txt
22:22:59,691 - parser INFO HandHistory init - Fulltilt subclass, in_path 'C:\Program Files\FTP\HH\*\*_*.txt'; out_path 'C:\Documents and Settings\Administrator/.fpdb/HH/FTP\*-*.txt'
22:23:12,816 - parser Parsing 1***** hands
22:23:13,176 - parser Unsupported game type: unmatched
22:23:13,176 - parser Unsupported game type: unmatched
22:23:13,473 - root Didn't match re_HandInfo
22:23:13,473 - root FullTiltPoker Game #*: Table **** (6 max) - $0.10/$0.25 - No Limit Hold'em - *** ET - 2009/**/**

1 files to import

70 Mb in 1 file? The biggest file i've imported is 2.x Mb and that took a lot of memory [1]

If the importer crashes you will see the symptom of the progress bar never stopping - and you'll get pretty bored waitiing.

If any of the files cause a crash in the log i'd like to track that down.

Sorrow.

[1] To optimise we parse _all_ hands before inserting them into the database - this can take a lot of memory. I was up to ~1.4Gb on just the 2.x Mb file.

Does the log I posted tell much about what if anything was completed during the import? What would you recommend as my next step? Should I retry the import? Also, could the comp going into energy saver while away have messed up the process? If it didn't work I should be trying to find away to import them 2mb at a time? Thanks.

Just a thought: I think this is a real problem, not an isolated case, since I believe Pokerstars sometimes sends you hands in one great big file, or several big files, if you request them from support. (I'm not sure about this as I've never requested a history myself; but other sites, if not Pokerstars, may do this.)

This was FTP. They sent two files, somehow I think they combined into one after moving them from the email(that's what the programmer friend i had help me get them from the emails to the import said). It was about 70 megabytes.

If that is the entire log, then it is failing on the first file (I assume that the '*'s represent names that were removed.

If it did crash hard you may need to recreate the tables and restart fpdb to get going again.

The biggest file pokerstars has sent me is the 2.2Mb file - and through the GUI noone can currently import those files. they have an additional line between each hand that needs removing - the switch (-s) hasn't been added to the gui interface yet, but is available from the command line.

I'm not sure if FTP does something similar - until very recently i'd only played < 2k hands there, which was why i asked the question.

Sorrow.

Oh. Wow.

As i said above - i've never seen a FTP hh archive file, if it is anything like Stars then it will probably need some special cajoling to get working.

Are you willing to send me a portion of that file? Say the first 10k hands or something like that?

Sorrow.

It looks like all the tables that are "AP" are private (at least private to me, i can't join them) Euro tables. Euro cash games are not currently supported, although it's likely a trivial fix to the Everleaf module .. I haven't looked into it yet, because I believe there would be problems with stats not making any sense at all if i'm playing on the same site with two different currencies.. and I've got a job doing some professional programming right now, so I really don't have time to work on the multi-currency implementation

If someone else wants to add support for the Euro HH's on Everleaf, it's probably pretty easy to do. While they are at it, Tournament play and Omaha play could use some tweaking, since the win stats are all terribly far off on tourney and omaha hands.

ehrrr i can't find the log folder, i used the help->log messages and i get this:
http://img202.imageshack.us/img202/760/logj.jpg

yeah, and i can't join dollars tables(i don't see them in the lobby)
what should i know if i want to add it myself? Should i learn some language or it is easy?

When we bulk import a file we slurp the whole file into memory, chop it up into individual HHs and then import each HH. This is speedy for the fairly small files usually found in a player's hand history folder. If the file is large (like the 100M file we're talking about here) and the computer has low memory (512M or less, maybe), then we run out of memory and the import gets very slow. We should take a good look at how we handle those files.

I have a dir of not-so-old HHs that I use for testing bulk import. It is 97M of FTP HHs in the original (small) files. This folder imports in about 5 min (= 100 hands/sec) on my machine (3 GHz, 4 GB).

3-4blitzpackage -- Could you try importing a smaller file of HHs, just to make sure things are working?

Caution--Make sure your big HH file from FTP is backed up before you open it with a text editor. FTP encodes HH files in utf-16, which is not supported by common windows editors like Wordpad. If you want to break that file up by hand, download vim or a similar programmer's editor. Also, some mail clients take it upon themselves to change the utf-16 to something they like better, so if you send a file to sorrow, he might not get what you actually sent.