Quote:
Originally Posted by indigo
OK, reason for the confusion is that Bulk Import is only loading the first few HH files in the Full Tilt folder, hence why I could not retrieve Villain's Stats.
If I select other individual files in the folder, then I can import them without problem, but I have to do it one by one. Any reason why Bulk Import would only do some of the files ? How can I assist debug this ?
You should be able to select a folder in the Bulk Import gui and have fpdb import all the HH files in the folder. If you are selecting a folder, but not importing all of the files in it, then something is going wrong.
First thing to do is look at fpdb-error-log.txt in the pyfpdb folder (same folder as fpdb.py). There should be a useful error message in that file.
Second thing, run fpdb from the command line so you can see the print output. (Open a terminal window, cd to the folder where fpdb.py is stored and enter python fpdb.py.) First try to import one of the files that didn't import when you selected the whole folder--see if anything interest shows up in the terminal window. Then try importing the whole folder. The output on the terminal should look something like this:
Code:
$ pyfpdb/fpdb.py -d fpdbTEST
Note: error output is being diverted to fpdb-error-log.txt and HUD-error.txt. Any major error will be reported there _only_.
Reading configuration file /home/fatray/.fpdb/HUD_config.xml
todo: implement obtain_global_lock (users: pls ignore this)
creating mysql index Players name
creating mysql index Hands siteHandNo
creating mysql index Tourneys siteTourneyNo
Finished recreating tables
started at 2009-04-05 10:42:17.816802 -- 96 files to import. drop
preparebulk: cons= (u'Hands_ibfk_1',)
dropping mysql fk Hands_ibfk_1 Hands gametypeId
preparebulk: cons= (u'HandsPlayers_ibfk_1',)
dropping mysql fk HandsPlayers_ibfk_1 HandsPlayers handId
preparebulk: cons= (u'HandsPlayers_ibfk_2',)
dropping mysql fk HandsPlayers_ibfk_2 HandsPlayers playerId
preparebulk: cons= (u'HandsActions_ibfk_1',)
dropping mysql fk HandsActions_ibfk_1 HandsActions handPlayerId
preparebulk: cons= (u'HudCache_ibfk_1',)
dropping mysql fk HudCache_ibfk_1 HudCache gametypeId
preparebulk: cons= (u'HudCache_ibfk_3',)
dropping mysql fk HudCache_ibfk_3 HudCache tourneyTypeId
Total stored: 228 duplicates: 0 partial: 0 errors: 0 time: 13.834113121
Total stored: 61 duplicates: 0 partial: 0 errors: 0 time: 3.09120512009
Total stored: 72 duplicates: 0 partial: 0 errors: 0 time: 4.56625509262
Total stored: 16 duplicates: 0 partial: 0 errors: 0 time: 0.868985891342
Total stored: 41 duplicates: 0 partial: 0 errors: 0 time: 2.65115499496
Total stored: 93 duplicates: 0 partial: 0 errors: 0 time: 6.46930217743
...
Total stored: 117 duplicates: 0 partial: 0 errors: 0 time: 8.15374302864
Total stored: 102 duplicates: 0 partial: 0 errors: 0 time: 6.73258185387
afterbulk: cons= (u'Hands_ibfk_1',)
afterbulk: cons= None
creating fk HandsPlayers handId -> Hands id
afterbulk: cons= None
creating fk HandsPlayers playerId -> Players id
afterbulk: cons= None
creating fk HandsActions handPlayerId -> HandsPlayers id
afterbulk: cons= None
creating fk HudCache gametypeId -> Gametypes id
afterbulk: cons= None
creating fk HudCache tourneyTypeId -> TourneyTypes id
GuiBulkImport.import_dir done: Stored: 6701 Duplicates: 0 Partial: 0 Errors: 0 in 584.175077915 seconds - 11/sec
The interesting line is about the 10th--it tells you how many files fpdb thinks it should be importing. The last line tells you how many hands were actually imported.
Quote:
Also, I read about needing numby & mathplotlib for the graphs. On trying to download, one of the sites recommended installing python(x,Y) in order to run, I did this and it still does not work. How can I check to see if it has been properly installed for FPDB ?
The windows installer should have installed python 2.5. Python 2.6 has been released but is not in wide use, so we have been sticking with 2.5 and probably will for a while longer--we cannot use 2.6 until all of the libraries that we use have released versions compatible with 2.6. To check your python installation, open a terminal window, type python, and hit enter. You should see output like this:
Code:
$ python
Python 2.5.1 (r251:54863, Jun 15 2008, 18:24:51)
[GCC 4.3.0 20080428 (Red Hat 4.3.0-8)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>>
Notice the version on the first line (2.5.1 on my PC.). If you are seeing something other than 2.5.x, you probably need to get rid of the 2.6.x version and use 2.5.x. Now enter import numpy at the >>> prompt. Same with import matplotlib. If numpy and matplotlib are installed properly you should see this:
Code:
>>> import numpy
>>> import matplotlib
>>> import spam
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: No module named spam
>>>
If there is a problem you should get an error like the one I got when I tried to import spam. Last time I looked at the numpy and matplotlib sites they had versions for different versions of python--you need the version for python 2.5.