Thanks, you to resboard, I've got some stuff going now. The problem now is my new "fish score" is given with 6 decimals and I don;t know where I can change that? If the fish score is 3.63 it shows 3.630000.

And another thing, how can I implement my fish score in Table Tracker? I know how to add a players' individual fish score in the "Table Detail" window but I don;t see how I can add this new Stat to the "Available Tables" window. I do see an empty column called "Avg Score" there but I can't figure out yet how to use my fish scores for that column.

Thanks

edit: I think I figured the Table Tracker issue out...
edit2: Argh CRAP, no...I haven't...

Is this compatible for MAC? and if not when is it going to be?

I realize that this has probably been answered before but I would enjoy a quick answer. Thank you.

Not yet, there will be a version coming out eventually. We hope to start development before the end of Fall, but that's not set in stone.

Click on the wrench at the top right of the report, double click the stat on the left to add it to the report on the right and it should show up . . .

Not sure about the 6 decimals. I know you can set decimal length in the HUD, also i think %2f is the formula for floating point statistics but I don't know if changing that forces more decimal places.

Look at the format_number function. Include that in the Statistics tab, in the Format-box, for your new stat.

Yes, almost there now . The %2f thing worked!

Now, in the Table Tracker Tab I now have a column called "Avg Score" and it shows the average fish score of the players at that table. How do I change this from "Avg Score" to "Total Score". I want the score of the table to be the total score of all the players' individual scores and not the average. So if three players are seated at the table with fish scores of 1, 2 and 3 I want the table score to be 6 and not 2.

Change "average" to "sum" on the "Summary type" drop down of the column definition.

went to start > programs> post 8.3 > start service
tried that password.. same thing...

any more thoughts?


-also looked at the "this thread" link... it started off with disclaimer indicating you must be behind a router to work..... so I read no further.

Click Start --> Programs --> PostgreSQL --> Configuration Files --> pg_hba.conf

Find the line that says , change "md5" to "trust", save the file, stop and restart PostgreSQL and you will no longer be prompted to enter a password when logging in from your own machine.

Does beta13 autoimporting miss hands for anyone else? Happened yesterday and thought it was just a fluke but it happened today too. Yesterday after the session I stopped autoimporting and started it again, and then it imported the missing hands too. Same thing seems to be happening today.

ETA on tool tip editing?

If you can locate and attach these hands to a support ticket we would appreciate it. To my knowledge there isn't any known issue of hands not importing in Beta 13; there is a known issue where new Party tables aren't always recognized but stopping/restarting the auto-import process should fix that for the time being.

Unfortunately I do not have one at this time. But we're hoping that next week we can go back to adding new features and site support once the HUD is completely stable. So hopefully you'll start getting new things to play with soon

They are total files that are not loaded, no hands are imported from those skipped files until I stop and restart autoimporting. Maybe the same bug then?

Sounds like it, yes. At least if you're playing at Party.

How long will it approximately take to make betfair work? Within this month?

I am still trying to get the piece of crap program to link on my laptop to the database on my desktop. I followed those terribly written directions and it now says this:Unable to connect to PostgreSQL database: PT3_2008_05_20_175404
Reason: "Unable to login to database (PT3_2008_05_20_175404). Reason: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "192.168.1.2" and accepting TCP/IP connections on port 5432?"

I am sure glad I paid for a program that is so laggy I still use PT2. Do you give refunds for this garbage?

just imported a 2.2million hand database and whenever I go to play about 10 mins. in I get a fatal error and the HUD has to close. is my DB too big?

I already did that but that doesn't change anything, it keeps giving an average score. Note that in the column definitions for "cnt_vpip" the "summary type" is also set to "sum" yet it gives an average value of the table when scanning with Table Tracker. Same with the other values in the "Available Tables" list in Table Tracker, all are averages.

Try clicking Start --> Programs --> PostgreSQL --> Stop Service and then S->P->P-> Start Service on the computer that is running the database server and let me know what happens when you try to connect after that.

Also, are you running Beta 13? Beta 13 is markedly faster for most people and if you're not currently using it, I recommend giving it a try. Also, I have personally noticed that having a lot of extra groups on the table slows things down considerably; you might want to try tweaking your setup to eliminate one of your extra groups if you can and see if that speeds things up.

The DB is not too big. Are you running Beta 13? Beta 13 should have fixed most of these errors.

If you are running Beta 13, please enable logging and then try renaming the C:\Program Files\PokerTracker 3\Data\Layouts.pt3 file to Layouts.backup and restart PT3 and see if that doesn't crash. (This will move your customized layout out of the way temporarily so that PT3 will create a new, default layout. If it still crashes, we can eliminate your layout as the source of the problem.)

If the layout file is the source of the problem, please submit it (you need to rename it to Layouts.txt in order to submit it) to our support system along with a description of the problem and the PokerTracker.log and PokerTrackerHud.log files (from C:\Program Files\PokerTracker 3\).

If the layout file is not the source of the problem, please submit the logs and mention in the ticket that you have tried renaming your log file. We would appreciate it.

Except VP$IP is defined as (cnt_vpip / cnt_hands) * 100. I'm not sure exactly how the logic works but I can tell you that I have created statistics and that drop down does affect how the summary line works in various reports.

I'm honestly not sure about TableTracker's report page, as I haven't played with TT all that much; I would have figured it would work the same.

If you wouldn't mind PMing me your statistics (exported) I could try and import them myself and see if I can get them working.

Mittman, have you setup postgres to allow connections from other computers on your network? The directions that you quoted are for setting up postgres to not require a password. You need to follow the instructions for listening on the network ip of the desktop and setting the desktop to allow incoming connections from the laptops ip.

How To: Setup a PostgreSQL Database for use Over a Network

I followed all that.
The end of my pg_hba.conf for both my destop and laptop look like this:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
host all all 192.168.1.2 md5
listen_addresses = '*'

The ip of my laptop is 192.168.1.5 and my desktops is 192.168.1.2, I have tried entering both. The database is on my desktop, and both computers are running from the same router. I have stoped and started the "service" multiple times on each computer and still get the error pasted above. I go into configure database in PT3 and click new. I use 192.168.1.2 as the server, 5432 as the port, and dbpass as the password.

So your laptop is .5 and your desktop is .2 and you want your desktop as the server?

You should uninstall PostgreSQL completely from the laptop (.5). You don't need it on that computer; you're going to connect over the network. I suspect that PostgreSQL being installed on that computer is causing problems.

On your desktop you should have a
host all all 192.168.1.5 md5

line. You want to allow the computer from .5 (the laptop) to connect. You connect yourself as localhost (127.0.0.1).

This forum post gives detailed instructions on how to fully delete PostgreSQL.

In the future, once you have this set up, by the way, you want to always upgrade using the WITHOUT PostgreSQL versions of PT3.

listen_addresses = '*' - this belongs in postgresql.conf, NOT pg_hba.conf

as Kraada has already said, you need 192.168.1.5 in your pg_hba.conf too, if you want it to be able to access the server.

Done, done, done, and still doesnt work. What does the bolded mean? When I click New database what do I put in server, port, and password? I have been putting 192.168.1.5 (and tried .2) in the server, 5432 in the port, and dbpass as the password.