Open Side Menu Go to the Top
Register
Holdem Manager Support Holdem Manager Support

07-24-2007 , 11:00 PM
ETA on Ipoker support?
Holdem Manager Support Quote
07-24-2007 , 11:25 PM
Quote:
I want to retrieve the VPIP of a player with playername = 'Caide' and player_id = 6.

I've tried:

SELECT * FROM compiledplayerresults WHERE compiledplayerresults_id = (SELECT compiledplayerresults_id FROM compiledresults WHERE player_id = 6)

But that didn't work because the inner select statements return several compiledplayerresults_id's. How do I handel this?
pm sent
Holdem Manager Support Quote
07-24-2007 , 11:25 PM
Quote:
ETA on Ipoker support?
This week
Holdem Manager Support Quote
07-24-2007 , 11:32 PM
Quote:
Quote:
ETA on Ipoker support?
This week
Sweet.
Holdem Manager Support Quote
07-24-2007 , 11:40 PM
Quote:
prima doesnt save hand histories on machine.. so how do i put them into Holdem Manager.. i have requested hand history which saves all hand histories into one file.. this is unable to be put into holdem manager... what can i do??
lobby >menu >my account >game history
latest version of HM
works for me with a few errors
Holdem Manager Support Quote
07-25-2007 , 01:23 AM
Would it be possible to include a "note feature"? What it would do is, if you are reviewing HHs and stats and you want to make a note for a player, you can use the HManager to write the note and it will show up during play on the site?

I think it would be very helpful to be able to review player's histories and then make notes that show up later while playing that person.

Basically Manager would have to be able to edit the poker sites note txt for you. PT has a notes feature, but the notes dont show up on the actual site.
Holdem Manager Support Quote
07-25-2007 , 02:25 AM
Grab the latest update from www.holdemmanager.net

The biggest feature addition in this update is you can now get any stat for all of your reports by simply selecting the stat group from the drop down list before running the report.

If you have the 0 import problem please go to www.holdemmanager.net/Zero_Import_Problem.html

If you have imported lots of hands and are concerned about report performance, just realize that this is a beta and the DB auto indexing / vacuuming is not setup yet and a few other things need to be tweaked. I've run HM with a 10 million hand DB and it was fine provided these things were done. Future updates will focus on performance.

July 24th - 0.16b
* In the sessions tab right clicking a session now selects that session. Previously right clicking and selcting "Update Filter to Session Date and Time" would load the currently selected row to the hands tab not the row that was right clicked on
* Added Avg # Players in the Sessions Tab
* Bug Fix: Prima players showed up as ?? in the Selected Player box
* You can right click on a player in the "Players" tab to select him as the default player
* Added "Could River Cbet" and "Did River CBet" to Hands tab and changed all of the check boxes to either "Yes" if the event happened or blank if it did not to make sorting on those rows possible
* Temporarily removed the tooltips for the cells in the Players tab due to performance issues. Will bring this back using a different method to ensure performance does not suffer.
* Added Stat Groups to the Reports tab - you can now return any of the available stats for any report (Limped Flop, vs PFR and as PFR stat groups currently disabled)
* Fixed issue where some hands imported as 0.50/1.00 and other 0.5/1
* Fixed issue where player names that are the same on two different sites would have their stats combined.
* Fixed issue where using the between argument on a filter would cause the query to error
* Fixed Full Tilt import bug when there are multiple side pots plus a main pot
* Fixed Full Tilt import bug when there were ties for a side or main pots in hands with multiple side pots
* Fixed Full Tilt import bug where posting blinds puts the player all-in
* Fixed Full Tilt import bug on hands with antes
* ReportStats.xml is no longer being used (it is being used internally but not being loaded from a file). For people that have been customizing / adding stats I will be providing you a way to do this in an upcoming release.

rvg
Holdem Manager Support Quote
07-25-2007 , 03:05 AM
Quote:
* Fixed issue where player names that are the same on two different sites would have their stats combined.
W00t! Big update. This is what I've been waiting for, so I can finally re-import all of my hands. I was wondering if it'd be possible to add some way to tell which hands/files are causing errors. There are some hands that PT is able to import that HM is not (since all of the hands I'm importing came from the PT export). If you added a way for us to check, we could send you those hand histories and you could see what's wrong.
Holdem Manager Support Quote
07-25-2007 , 03:25 AM
you should have a file named c:\importerrors.txt (sorry about the location... keep on forgetting to change it)

Failed hands go in there. Updates will become more and more accurate - I fixed 4 Full Tilt issues today related mainly to tourneys.

Thanks,

rvg
Holdem Manager Support Quote
07-25-2007 , 04:30 AM
Hey RVG, great job so far!

When I try to login I get an error saying something to the effect of: Connection Error: There is no established connection because the destinationcomputer active denied it.

How do I solve that?
Regards, Youcan
Holdem Manager Support Quote
07-25-2007 , 07:58 AM
Quote:
you should have a file named c:\importerrors.txt
Ah! so you can reimport them from there?
Holdem Manager Support Quote
07-25-2007 , 08:56 AM
It looks like my 10/20 NL hands on PS got imported as 1/20 NL. Any idea why this might be?

Also, after doing an import, I noticed the files that had errors were the ones that PT named "pty ...". At Party, to my understanding, they have two formats for the hands. There was an old one, which PT exports as "pty" and a new one, which PT exports as "pty_new". But if you request hand histories from Party, they will send you the hand in the old format instead of the new format. During the import, I got a slew of errors from the files containing the old format. If you need samples, please let me know.

I was also wondering if people think that 6-max/9-max/10-max /HU hands should be separated or not. I'm used to having them separated as they are in PT, but maybe others like the way HM does it.
Holdem Manager Support Quote
07-25-2007 , 09:59 AM
How does HM handle 6-max/9-max/10max?
Holdem Manager Support Quote
07-25-2007 , 10:01 AM
Hi Roy, first off, I would like to say a big THANK YOU for taking the time and effort in creating and supporting this program. I truly believe that this program can and will (provided the players use it even to a fraction of its ability) help improve its users games.

That massive compliment aside, I do have a functional question. I may be missing something very obvious, but how do I run a report that would show my (or any players, for that matter) results based on hand type (I don't mean simply TPTK on flop, but rather by one pair, two pair, set, trips gernically, like PT showed in a table), enabling me to browse through hands where I had a certain made hand so that I can review them (eventually in the replayer, with opponents stats showing) to see if I played them optimally? Hopefully this question came out as I intended. basically, I know that the reports and hands filters enable you to see any type of hand, but I was lookuing to run a more generic report so I can see, for example, what type hand I lose money with the most or play the most suboptimally. Thanks in davance.

Ryan
Holdem Manager Support Quote
07-25-2007 , 11:47 AM
Quote:
how do I run a report that would show my (or any players, for that matter) results based on hand type (I don't mean simply TPTK on flop, but rather by one pair, two pair, set, trips gernically, like PT showed in a table
Does the "By Showdown hand Value" report give you what you are looking for? If not let me know what you want and I'll show you how to tweak the report to show exactly what you want.

Quote:
How does HM handle 6-max/9-max/10max?
Right now I am not storing the actual table size but I do store the number of players playing. My thoughts were that does it matter if I was playing 4 handed on a 6 max table or a 9 max table? In the Income tab (still to come) I was going to combine all 3 to 6 players cash as 6 max and 7 to 10 as full ring. However, after discussing this with some people I will be also tracking the table size so you can have a bit more flexibility on how you want this to look.

Quote:
It looks like my 10/20 NL hands on PS got imported as 1/20 NL
ugg... sorry, thought I tested them all before releasing 0.16b. This only affects the game description though and will be fixed.

Quote:
Ah! so you can reimport them from there?
Yeah, that should work once I fix whatever the problem was that caused the hand to import in error in the first place.

Quote:
When I try to login I get an error saying something to the effect of: Connection Error: There is no established connection because the destinationcomputer active denied it.
It might just be Postgres isn't running or something - first try rebooting and see if it works. If not then go into your program files\rvg software\holdem manager\config folder and open holdemmanager.config in notepad and you will see a section that looks something like:

<setting name="ConnectionString">DATABASE=HoldemManagerB eta;SERVER=localhost;PORT=5432;UID=postgres;PWD=ab c123</setting>

Close HM and change that to

<setting name="ConnectionString"></setting>

When you relaunch HM you will be prompted for settings to connect to your database.

Quote:
Would it be possible to include a "note feature"?
Yes

rvg
Holdem Manager Support Quote
07-25-2007 , 12:08 PM
Quote:
Would it be possible to include a "note feature"? ..... PT has a notes feature, but the notes dont show up on the actual site.
Yeah, this would be neato!

BTW, PT's notes need to be imported from the site-specific notes file and can be edited in PT and exported again to the note file. Also you can export many stats of a player into the site specific notes file. All that is very useful and I belong to the probably 0.5% users who still do that.

I use the notes, the PT-autorate, the floating gametime window, PAHUD + its pop-up stats. Lol, let's better say I have all those available to be used.
Holdem Manager Support Quote
07-25-2007 , 12:11 PM
Is bodog supported in the Beta version yet? If not, is there any time table on that?
Holdem Manager Support Quote
07-25-2007 , 12:54 PM
River stats often have too few hands to make a conclution. Is it possible to see how many hands\situations these % are based on? (not just the total nr of hands on the player)
Holdem Manager Support Quote
07-25-2007 , 01:43 PM
The two most exciting things here are the flexibility of the reports, which is brilliant, and the possibility of reducing the total number of pieces of software I have to juggle to manage online poker. I <3 the possibility of using one thing to graph, track rackback, provide HUD displays, etc. and would encourage such functionaity (even to the point of table selection) to be high on the feature list as you continue development.
Holdem Manager Support Quote
07-25-2007 , 01:49 PM
Looking at the players tab, I activated Default and 3/4-bet stats.
In the first row, it shows my stats, beneeth are the other players. While there are the same columns, they are in a different order, which is kinda confusing...
Holdem Manager Support Quote
07-25-2007 , 01:55 PM
Quote:
The two most exciting things here are the flexibility of the reports, which is brilliant, and the possibility of reducing the total number of pieces of software I have to juggle to manage online poker. I <3 the possibility of using one thing to graph, track rackback, provide HUD displays, etc. and would encourage such functionaity (even to the point of table selection) to be high on the feature list as you continue development.
I plan on doing this to an extent - I have a plugin model that will allow developers of other functionality to build apps that essentially run within a new tab on the interface. This is still a little ways off but that's the idea. Of course they don't have to do it this way but it does make it easier for the user. Things like Table Selection I'll leave to guys like Mr.Snood and Sixth Sense and deep EV analysis to guys like Poker EV Phil. I'm trying to create a rich framework for next generation tools and of course I'll be building lots of my own as well.

Quote:
River stats often have too few hands to make a conclution. Is it possible to see how many hands\situations these % are based on? (not just the total nr of hands on the player)
Yes - they are all there I'm just working on some performance issues related to the tooltips on the grid so they are not being shown right now.

Quote:

Is bodog supported in the Beta version yet? If not, is there any time table on that?
Not supported yet and no timeline yet for Bodog. IPoker is coming this week and then after that I'll probably be putting my head down and cranking out lots of HM code. Once things are running along well I'll be spending a good chunk of time dedicated to sites and they only take about 3 or 4 hours to add to the manager using the model I've created for this.

rvg
Holdem Manager Support Quote
07-25-2007 , 01:56 PM
Quote:
Looking at the players tab, I activated Default and 3/4-bet stats.
In the first row, it shows my stats, beneeth are the other players. While there are the same columns, they are in a different order, which is kinda confusing...
This is temporary - real version will have the current selected player always appear as the first row and frozen in place when you scroll. Having some troubles getting this to work the way I want so this was the backup plan.

Columns should be the same and in the same order though... I'll check that out, might be a bug

rvg
Holdem Manager Support Quote
07-25-2007 , 02:20 PM
Most, this looks AMAZING. A few things in my first 30 mins of use:

* Whenever I make a selection in a pop up window (for example, the Alias box), the program minimizes.

* Importing is going at about 10 hands / sec. Is that normal?

* I often have to switch back and forth between two different import paths (when I'm playing, it is local, when I'm datamining, it's on the network). Is it possible to enter more than one path for import files, and have it scan both? Or, save them and select which one is local?

* Is the auto import from PT working yet? This is my major issue to switching over.

* It looks like Alias settings don't carry over to reports. That is, in the PLAYER reports, I'd like to see all of my aliases grouped together as a single row. Is that possible?
Holdem Manager Support Quote
07-25-2007 , 03:20 PM
Would it be possible to add a few stats?

Called a 3-bet when in/out of position

Called/folded/raised a continuation bet after calling a 3b in/out of position.

Called/folded/raised a turn continuation bet after calling a 3b and cb in/out of position.
Holdem Manager Support Quote
07-25-2007 , 05:24 PM
i quoted myself since u might have overlooked it and i still witness those things in the current version:
Quote:
i looked through your program and database and noticed that you "cut" partypoker HHs wrong: theres always the "Game #5609898428 starts." and "#Game No : 5609898428" lines at the end of a stored HH, but this stuff actually belongs to the next hand

another thing:
with party poker handhistories you might want to get rid of all ">You have options at Table XYZ.." lines before storing them in your DB!

i had to write my own program to do this on ptrackers existing databases.
also the postgres logs still warn:
Quote:
2007-07-25 22:29:37 WARNING: nonstandard use of \\ in a string literal at character 63
2007-07-25 22:29:37 HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
....
2007-07-25 22:23:14 WARNING: nonstandard use of escape in a string literal at character 94
2007-07-25 22:23:14 HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
see http://www.postgresql.org/docs/8.2/s...ompatible.html under "escape_string_warning (boolean)". the default for this setting is "on", so everyone should have these warnings in their log.

FIX:
Quote:
Applications that wish to use backslash as escape should be modified to use escape string syntax (E'...'), because the default behavior of ordinary strings will change in a future release for SQL compatibility.
also, the total hands of the report by game buyin (for my screenname) still (slightly) differ from the handcount i get from the players tab when filtering for everyone with >2k hands.

another thing i noticed in the postgres log while importing party HHs is this:
Quote:
2007-07-25 22:09:50 ERROR: invalid byte sequence for encoding "UTF8": 0xe4e46b
2007-07-25 22:09:50 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
Holdem Manager Support Quote

      
m