Open Side Menu Go to the Top
Register
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

11-01-2009 , 12:58 AM
Quote:
Originally Posted by p3rc4
Sweet, thanks. I'll grab the latest source and see if I can get a build going!
if that doesn't work, you might try a build that's a year or more old, too. i don't think the matplotlib devs actually test with gtk, so it took several months before anyone actually noticed it.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-01-2009 , 11:58 AM
Quote:
Originally Posted by Eleatic Stranger
2 & 3. The graph and the session graphs. I know the graphing function has existed for a while but it was only recently that I installed the necessary libraries for it, and I wasn't disappointed. In one respect it is demonstrably superior to PT's graph: it doesn't mark off the x- and y-axes in ridiculous arbitrary "units" bearing some relationship to the total winnings or whatever (I have never understood why people tolerate this).
The session viewer very new and very broken at the moment. Any opinions on what it looks like at the moment?

Note: the query needs to return a timestamp as an integer for the session detection code.
Quote:
Originally Posted by Eleatic Stranger
4. The alpha SQLite support. This database seems lightning-fast and already more or less works. Sorrow said earlier that those who wanted to test it should PM him first, but I decided to just go ahead and see what happened – sorry! I jury-rigged some of the SQL code as shown in the following Diff patch to get the player stats window to work (up to a point).
- Thanks for this, i'll have to do some more sqlite testing and get that included soon.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 04:36 AM
Quote:
Originally Posted by sorrow
The session viewer very new and very broken at the moment. Any opinions on what it looks like at the moment?
I have no advice about its appearance, since it looks pretty good at the moment. But I've noticed that it always seems to miss the most recent session. Earlier sessions seem to be shown correctly.

I've added the SQL necessary to get the session viewer to work with SQLite, as given in the following patch. Unfortunately this must contain a literal "%s" (for some reason %s means "convert to UTC time-stamp"), so I've had to alter the code that substitutes ? for %s.

In the player stats code, the bit about to_char(h.handStart, 'YYYY-MM-DD') turns out the be unnecessary (handStart alone is sufficient). It is really necessary in MySQL?

The code to put the player statistics in order is commented out ("<orderbyhgameTypeId>") as I couldn't get it to work. Hence the hole cards are initially shown out of order, but one can still force them to be sorted by clicking on the column heading (though this is obviously not a good solution).

Code:
diff --git a/pyfpdb/SQL.py b/pyfpdb/SQL.py
index 3c25963..1f4fd06 100644
--- a/pyfpdb/SQL.py
+++ b/pyfpdb/SQL.py
@@ -1895,9 +1895,9 @@ class Sql:
                 self.query['playerDetailedStats'] = """
                          select  <hgameTypeId>                                                          AS hgametypeid
                                 ,gt.base
-                                ,gt.category
+                                ,gt.category AS category
                                 ,upper(gt.limitType)                                                    AS limittype
-                                ,s.name
+                                ,s.name AS name
                                 ,min(gt.bigBlind)                                                       AS minbigblind
                                 ,max(gt.bigBlind)                                                       AS maxbigblind
                                 /*,<hcgametypeId>                                                       AS gtid*/
@@ -1939,7 +1939,7 @@ class Sql:
                                 ,100.0*avg((hp.totalProfit+hp.rake)/(gt.bigBlind+0.0))                  AS bb100xr
                                 ,avg((hp.totalProfit+hp.rake)/100.0)                                    AS profhndxr
                                 ,avg(h.seats+0.0)                                                       AS avgseats
-                                ,variance(hp.totalProfit/100.0)                                         AS variance
+                                ,0.0 AS variance
                           from HandsPlayers hp
                                inner join Hands h       on  (h.id = hp.handId)
                                inner join Gametypes gt  on  (gt.Id = h.gameTypeId)
@@ -1949,7 +1949,7 @@ class Sql:
                           and   h.seats <seats_test>
                           <flagtest>
                           <gtbigBlind_test>
-                          and   to_char(h.handStart, 'YYYY-MM-DD') <datestest>
+                          and h.handStart <datestest>
                           group by hgameTypeId
                                   ,hp.playerId
                                   ,gt.base
@@ -1967,7 +1967,7 @@ class Sql:
                                                    when '0' then 'Y'
                                                    else 'Z'||<position>
                                    end
-                                  <orderbyhgameTypeId>
+                                  /*<orderbyhgameTypeId>*/
                                   ,upper(gt.limitType) desc
                                   ,maxbigblind desc
                                   ,s.name
@@ -2501,7 +2501,16 @@ class Sql:
                      AND  h.handStart <datestest>
                     ORDER by time"""
             elif db_server == 'sqlite':
-                self.query['sessionStats'] = """ """
+                self.query['sessionStats'] = """
+                    SELECT STRFTIME('%s', h.handStart) as time, hp.handId, hp.startCash, hp.winnings, hp.totalProfit
+                    FROM HandsPlayers hp
+                     INNER JOIN Hands h       on  (h.id = hp.handId)
+                     INNER JOIN Gametypes gt  on  (gt.Id = h.gameTypeId)
+                     INNER JOIN Sites s       on  (s.Id = gt.siteId)
+                     INNER JOIN Players p     on  (p.Id = hp.playerId)
+                    WHERE hp.playerId in <player_test>
+                     AND  h.handStart <datestest>
+                    ORDER by time"""
 
             ####################################
             # Queries to rebuild/modify hudcache
@@ -3194,7 +3203,8 @@ class Sql:
             # If using sqlite, use the ? placeholder instead of %s
             if db_server == 'sqlite':
                 for k,q in self.query.iteritems():
-                    self.query[k] = re.sub('%s','?',q)
+                    if k != 'sessionStats':
+                        self.query[k] = re.sub('%s','?',q)
 
 if __name__== "__main__":
 #    just print the default queries and exit
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 06:14 AM
Quote:
Originally Posted by Eleatic Stranger
I have no advice about its appearance, since it looks pretty good at the moment. But I've noticed that it always seems to miss the most recent session. Earlier sessions seem to be shown correctly.
The candlestick graph still looks a bit odd to me - and looks really bad for any dataset with a big swing. I know about the last session not importing too - Thanks.

I'm thinking about doing a variance overlay or something similar to get an idea if my playing style is changing over time with sessions, or perhaps a 'session ev' candlestick graph.

I'm tossing around ideas for data visualisation, and considering what sets of data might lead to useful insights into my game - perhaps luck on to a killer feature feel free to throw ideas out.
Quote:
Originally Posted by Eleatic Stranger
I've added the SQL necessary to get the session viewer to work with SQLite, as given in the following patch. Unfortunately this must contain a literal "%s" (for some reason %s means "convert to UTC time-stamp"), so I've had to alter the code that substitutes ? for %s.
I changed how this was done slightly, but i've committed a variant of your patch to my repo now - Thanks
Quote:
Originally Posted by Eleatic Stranger
In the player stats code, the bit about to_char(h.handStart, 'YYYY-MM-DD') turns out the be unnecessary (handStart alone is sufficient). It is really necessary in MySQL?
Good question - i'm not sure. I had an idea about how sessions could be calculated and figured out a way to get the time data in the form i wanted - Haven't actually spent the time figuring out if it can be done another way.
Quote:
Originally Posted by Eleatic Stranger
The code to put the player statistics in order is commented out ("<orderbyhgameTypeId>") as I couldn't get it to work. Hence the hole cards are initially shown out of order, but one can still force them to be sorted by clicking on the column heading (though this is obviously not a good solution).
I think i'll leave that part of the patch out for the moment - i've added the AS name part and removed variance (it appears several standard sql aggregate functions aren't defined in sqlite yet)
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 07:12 AM
Quote:
Originally Posted by sorrow
I'm thinking about doing a variance overlay or something similar to get an idea if my playing style is changing over time with sessions, or perhaps a 'session ev' candlestick graph.

I'm tossing around ideas for data visualisation, and considering what sets of data might lead to useful insights into my game - perhaps luck on to a killer feature feel free to throw ideas out.
Actually, two possible additions to the graph have come to mind: a red line (= non-showdown winnings, if I understand this term correctly) and some sort of series of vertical lines indicating the divisions between sessions. I don't know if Pokertracker or its competitors do the latter, but it strikes me as useful to know where sessions begin and end on the graph of aggregate winnings, and the code is already there in the session graph module. It shouldn't be hard to calculate the red line, either.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 07:24 AM
Quote:
Originally Posted by Eleatic Stranger
Actually, two possible additions to the graph have come to mind: a red line (= non-showdown winnings, if I understand this term correctly) and some sort of series of vertical lines indicating the divisions between sessions. I don't know if Pokertracker or its competitors do the latter, but it strikes me as useful to know where sessions begin and end on the graph of aggregate winnings, and the code is already there in the session graph module. It shouldn't be hard to calculate the red line, either.
Redline graph is on my todo list - i dont think we have enough data for this at the moment.

An equity graph is also on the list. I dont think a session lines overlay would be hard to do either.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 10:25 AM
I have just had an errant value turn up in the player stats display: one hand is listed with a negative rake, which is very strange.... If this is not a known bug, when I have a bit more time I'll see if I can provide instructions for reproducing it.

Still, everything else is working very nicely.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 01:03 PM
I just bought a new computer and tried installing fpdb on Windows 7. It was unsuccessful; what's the best way to troubleshoot this and/or figure out whether it's a problem with what I did or a fundamental problem with Windows 7?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 01:23 PM
I've seen several posts saying, "I like the ability to sort the columns in the Player Stats window...."

What am I missing? Mine don't sort. I've left-clicked, right clicked, double clicked... no sort of any kind. I've tried every column. Do I need to set that in the config somewhere? Everything else seems to work fine, AFAIK. I've even changed the colors... or colours, depending on where you live
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 01:42 PM
Sorry, what I didn't mention in my recent posts is that I am following a Git repository (http://****************/apps/mediawik...stall_With_Git) which is more frequently updated than the official releases. You can do this too if you want to see every change the busy developers (bless them) make virtually in real time, but it's more complicated and slightly more prone to stop working unexpectedly.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 03:19 PM
Quote:
Originally Posted by Eleatic Stranger
I have just had an errant value turn up in the player stats display: one hand is listed with a negative rake, which is very strange.... If this is not a known bug, when I have a bit more time I'll see if I can provide instructions for reproducing it.

Still, everything else is working very nicely.
I had a weird one about a week ago just after a recreate. I would not have noticed it otherwise. I was testing some graphics on the hud and sat in a .01/.02 game for maybe one round. When it was done I happen to win .57 according to the hud. however, my PS table said I had won .59

Since there were so few hands, I quickly found the error. To be honest, I got overpaid .02 on a hand. I put in .06, won .07 (split pot) but my "bankroll" went up .03. Too bad it doesn't happen all the time... maybe it does and I just don't catch it. Same distortion might be in your "negative rake".

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 03:40 PM
Since we are volunteering requests on the Player Stats report, here's my views...

1. Can we have the "$/100" back. It would also make a good graph to show how one's game is improving.. or not

2. Ability to sort columns, which seems to be coming soon based on posts here.

3. A column for "W$sf" won money when saw flop is a good measure of when someone is chasing the pot too much. I use it in the hud.

4. Wish List: a "true" aggression factor "bets + raises / calls" I am used to that figure, which generally ranges from >1 (too passive) to <2.5 (starting to get too aggressive).

5. Ability to add/delete columns to keep the report simple. (Variance IMHO is a much overrated stat).

6. In the Player Stats report, give us check boxes, beside the amount boxes, to select specific games to include. I play .50/1.00 Omaha08, Holdem and Stud08, as well as various higher limits. When I do a Players stats and ask for .50, they are all mixed together. It's hard to determine individually how I am doing.

7. I know this is near impossible, but do not dump all my Omaha08 hands in the last "xx" slot. I would love to be able to analyze my starting cards (all 4 of them) I know, too many combinations.... sigh


Thanks.. Dog

Last edited by 1meandog4u; 11-02-2009 at 03:53 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 11:30 PM
Quote:
Originally Posted by Eleatic Stranger
I have just had an errant value turn up in the player stats display: one hand is listed with a negative rake, which is very strange.... If this is not a known bug, when I have a bit more time I'll see if I can provide instructions for reproducing it.

Still, everything else is working very nicely.
Hi E. S.--

Do you mind sending me that HH, if you can still find it? Either the whole file or just that hand would be fine. I think you have my email address, but I will PM it to you just in case.

thanks
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 11:55 PM
Quote:
Originally Posted by Eleatic Stranger
I have just had an errant value turn up in the player stats display: one hand is listed with a negative rake, which is very strange.... If this is not a known bug, when I have a bit more time I'll see if I can provide instructions for reproducing it.

Still, everything else is working very nicely.
I have seen this negative rake happen once early on in testing - its actually the reason why rake is still green instead of all red.

I wasn't able to repeat the bug though after importing the same group of hands.

Sorrow.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-02-2009 , 11:59 PM
Quote:
Originally Posted by 1meandog4u
I've seen several posts saying, "I like the ability to sort the columns in the Player Stats window...."

What am I missing? Mine don't sort. I've left-clicked, right clicked, double clicked... no sort of any kind. I've tried every column. Do I need to set that in the config somewhere? Everything else seems to work fine, AFAIK. I've even changed the colors... or colours, depending on where you live
Not missing anything - it was added 3-4 days after the devlopment snapshot I uploaded. I then broke my repo so i've held off creating another snapshot for a week or two.

Oh and def colours.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-03-2009 , 12:19 AM
Quote:
Originally Posted by 1meandog4u
Since we are volunteering requests on the Player Stats report, here's my views...

1. Can we have the "$/100" back. It would also make a good graph to show how one's game is improving.. or not
That could be interesting. I might take a look at this when I need a distraction
Quote:
Originally Posted by 1meandog4u
2. Ability to sort columns, which seems to be coming soon based on posts here.
This is done - the default green is now darker too
Quote:
Originally Posted by 1meandog4u
3. A column for "W$sf" won money when saw flop is a good measure of when someone is chasing the pot too much. I use it in the hud.
That shouldn't be too tough.
Quote:
Originally Posted by 1meandog4u
4. Wish List: a "true" aggression factor "bets + raises / calls" I am used to that figure, which generally ranges from >1 (too passive) to <2.5 (starting to get too aggressive).

5. Ability to add/delete columns to keep the report simple. (Variance IMHO is a much overrated stat).

6. In the Player Stats report, give us check boxes, beside the amount boxes, to select specific games to include. I play .50/1.00 Omaha08, Holdem and Stud08, as well as various higher limits. When I do a Players stats and ask for .50, they are all mixed together. It's hard to determine individually how I am doing.
All 3 are on my list. Being unable to filter an gametype is definitely annoying.
Quote:
Originally Posted by 1meandog4u
7. I know this is near impossible, but do not dump all my Omaha08 hands in the last "xx" slot. I would love to be able to analyze my starting cards (all 4 of them) I know, too many combinations.... sigh


Thanks.. Dog
Any one know of a standard method for breaking Omaha or Stud hands down? Some useful starting hand system perhaps?

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-03-2009 , 03:24 AM
Quote:
Originally Posted by 1meandog4u
I had a weird one about a week ago just after a recreate. I would not have noticed it otherwise. I was testing some graphics on the hud and sat in a .01/.02 game for maybe one round. When it was done I happen to win .57 according to the hud. however, my PS table said I had won .59

Since there were so few hands, I quickly found the error. To be honest, I got overpaid .02 on a hand. I put in .06, won .07 (split pot) but my "bankroll" went up .03. Too bad it doesn't happen all the time... maybe it does and I just don't catch it. Same distortion might be in your "negative rake".
You may be right but I have difficulty believing this! A more plausible explanation to my mind would be that you saw the kind of error known to affect PT's reported results for example, namely when you leave the table before the last hand is finished (and so before it is written to the hand history). Or perhaps one hand was in the hand history but generated an error and couldn't be imported.

Eratosthenes: Got your E-mail address. I'll see if I can isolate the problem.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-03-2009 , 01:49 PM
Quote:
Originally Posted by Eleatic Stranger
You may be right but I have difficulty believing this!
Please do not think I'm being rude, I just hate "mysteries" that can't be explained. This was the 2nd hand in the HH file. I included the beginning of the 3rd hand merely to show my "stack" increased .03 and to verify the time to show I did not alter anything, which would be stupid on my part... PokerStars just can't add, unless I'm missing something obvious. Weird to me! I put a total of .06 in, got back .07 and stack went up .03

What is just as strange is that the other player "claudioobom" in the hand with me, put in the same amount, got the same amount, but note that his stack only went up the .01 it should have. Guess someone at PS's thinks I play bad enough to need a "poker stimulus", or "Cash for Clunkers/Donkeys"

Dog

HTML Code:
PokerStars Game #34725794305:  Hold'em Limit ($0.02/$0.04 USD) - 2009/10/30 22:24:51 PT [2009/10/31 1:24:51 ET]
Table 'Galanthus' 6-max Seat #1 is the button
Seat 1: claudioobom ($1.41 in chips) 
Seat 2: 1meandog4u ($1.98 in chips) 
Seat 3: grenier44 ($0.82 in chips) 
Seat 5: artleo15 ($0.44 in chips) 
Seat 6: ogre519 ($0.37 in chips) 
1meandog4u: posts small blind $0.01
grenier44: posts big blind $0.02
ljboxer: sits out 
*** HOLE CARDS ***
Dealt to 1meandog4u [5s As]
artleo15: folds 
ogre519: folds 
claudioobom: calls $0.02
1meandog4u: calls $0.01
grenier44: checks 
*** FLOP *** [Qc Jd 8s]
1meandog4u: checks 
grenier44: checks 
claudioobom: checks 
*** TURN *** [Qc Jd 8s] [Kd]
1meandog4u: checks 
grenier44: checks 
claudioobom: checks 
*** RIVER *** [Qc Jd 8s Kd] [Ad]
1meandog4u: checks 
grenier44: checks 
claudioobom: bets $0.04
1meandog4u: calls $0.04
grenier44: folds 
*** SHOW DOWN ***
claudioobom: shows [Ac 4h] (a pair of Aces)
1meandog4u: shows [5s As] (a pair of Aces)
1meandog4u collected $0.07 from pot
claudioobom collected $0.07 from pot
*** SUMMARY ***
Total pot $0.14 | Rake $0 
Board [Qc Jd 8s Kd Ad]
Seat 1: claudioobom (button) showed [Ac 4h] and won ($0.07) with a pair of Aces
Seat 2: 1meandog4u (small blind) showed [5s As] and won ($0.07) with a pair of Aces
Seat 3: grenier44 (big blind) folded on the River
Seat 5: artleo15 folded before Flop (didn't bet)
Seat 6: ogre519 folded before Flop (didn't bet)



PokerStars Game #34725809528:  Hold'em Limit ($0.02/$0.04 USD) - 2009/10/30 22:25:35 PT [2009/10/31 1:25:35 ET]
Table 'Galanthus' 6-max Seat #2 is the button
Seat 1: claudioobom ($1.42 in chips) 
Seat 2: 1meandog4u ($2.01 in chips) 
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-04-2009 , 01:20 AM
The real questions that gives me, are how easy is it to duplicate that problem, and how long before Stars notices it?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-04-2009 , 02:42 AM
Very strange. I'll bet you now regret not having done your testing on the $25-$50 tables.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-04-2009 , 03:35 AM
Got everything installed, and was able to import a test hand history on PS. However when I try to import FTP hands nothing happens.

Here is my error log. Please help a noob..

Quote:
C:\Python26\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated
from sets import ImmutableSet
C:\Documents and Settings\Owner\Desktop\fpdb\fpdb.py:241: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
C:\Documents and Settings\Owner\Desktop\fpdb\fpdb.py:460: GtkWarning: Could not find the icon '"C:\Program Files\VideoLAN\VLC\vlc.exe",0'. The 'hicolor' theme
was not found either, perhaps you need to install it.
You can get a copy from:
http://icon-theme.freedesktop.org/releases
gtk.main()
Traceback (most recent call last):
File "C:\Documents and Settings\Owner\Desktop\fpdb\GuiBulkImport.py", line 75, in load_clicked
(stored, dups, partial, errs, ttime) = self.importer.runImport()
File "C:\Documents and Settings\Owner\Desktop\fpdb\fpdb_import.py", line 162, in runImport
(stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1])
File "C:\Documents and Settings\Owner\Desktop\fpdb\fpdb_import.py", line 234, in import_file_dict
(stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site)
File "C:\Documents and Settings\Owner\Desktop\fpdb\fpdb_import.py", line 302, in import_fpdb_file
site = fpdb_simple.recogniseSite(firstline)
File "C:\Documents and Settings\Owner\Desktop\fpdb\fpdb_simple.py", line 1481, in recogniseSite
raise FpdbError("failed to recognise site, line:"+line)
fpdb_simple.FpdbError: "failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x005\x006\x005\x003\x002\x005\x003\x008 \x008\x002\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00B\x00a\x00l\x00l\x00a\x00r\x00d\x00 \x00(\x006\x00 \x00m\x00a\x00x\x00)\x00 \x00-\x00 \x00$\x000\x00.\x000\x005\x00/\x00$\x000\x00.\x001\x000\x00 \x00-\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00H\x00o\x00l\x00d\x00'\x00e\x00m\x00 \x00-\x00 \x001\x00:\x004\x009\x00:\x004\x001\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x001\x000\x00/\x002\x009\x00"
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-04-2009 , 03:46 AM
Quote:
Originally Posted by Truthfulaj
Got everything installed, and was able to import a test hand history on PS. However when I try to import FTP hands nothing happens.

Here is my error log. Please help a noob..
Can you try the download in the snapshots directory on sourceforge please?

_Very_ basic installation instructions here: http://forumserver.twoplustwo.com/sh...postcount=1974

FTP is still broken with the old release.

Thanks

Sorrow.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-04-2009 , 03:56 AM
The HUD evidently isn't working with SQLite yet – it reports that the database is locked after importing the first hand. (It wouldn't surprise me to hear that there are difficulties associated with simultaneous multi-thread access in SQLite.)

In fact I wasn't planning to use the HUD itself, but I have got very tired of having to import manually after each session. I believe there's no way to run auto-import without running the HUD at the same time, or is there? This would be a useful feature; you could keep Fpdb running in the background and know that your database was always up to date.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-04-2009 , 04:00 AM
Quote:
Originally Posted by Eleatic Stranger
The HUD evidently isn't working with SQLite yet – it reports that the database is locked after importing the first hand. (It wouldn't surprise me to hear that there are difficulties associated with simultaneous multi-thread access in SQLite.)

In fact I wasn't planning to use the HUD itself, but I have got very tired of having to import manually after each session. I believe there's no way to run auto-import without running the HUD at the same time, or is there? This would be a useful feature; you could keep Fpdb running in the background and know that your database was always up to date.
Theres nothing serious preventing this from happening - pretty sure there is a 'send to hud' flag in the current auto-import code. A bit of manual hacking.

ekdikeo used to 'touch' all his files rather than bulk import.

Also - Bulk import now has multi-select.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
11-04-2009 , 04:49 AM
Quote:
Originally Posted by sorrow
Can you try the download in the snapshots directory on sourceforge please?

_Very_ basic installation instructions here: http://forumserver.twoplustwo.com/sh...postcount=1974

FTP is still broken with the old release.

Thanks

Sorrow.
I'm sure this is going to make me look like I shouldn't be touching a computer to move them let alone trying to work on them...
1. You need to use the updated HUD_config.xml(.example).
When doing this, I didn't realize I had to have my MySQL information ready to input into the .xml. Used the auto installer the first time and it took care of it.

Once I realized that error and was able to connect to the server, the import worked perfectly.

Thank you.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m