software to automatically request missing tournament summaries (stars) - Page 2

Interesting... I just request my all time tournament and sng results, and PS sent 2 html files. How can I import this to PT3 in order to automatically populate results? Thanks!

HTML Code:

All RegularTournaments played by 'mflan':
Default currency:  USD
Listing: Real Money    FPP Events    Freeroll    
From: 2000-09-17-00.00.00 
To: 2009-09-17-23.59.59 

Date/Time Tourney Game Currency Buy-In ReBuys
AddOns Rake Place Entries TLB Points Prize Target ID Qualified 
7/6/2006 6:54:55 PM 26559464 NL Hold'em USD 10.00 0.00 1.00 26 107 0.00 0.00     
7/19/2006 8:34:20 PM 28152213 NL Hold'em   Freeroll 0.00 0.00 3380 7291 0.00 0.00 27706161   
7/27/2006 6:23:50 PM 27704005 NL Hold'em USD 10.00 0.00 1.00 56 117 0.00 0.00     
8/1/2006 8:38:46 PM 28841889 NL Hold'em USD 10 FPP 0.00 0.00 1280 7360 0.00 0.00 28686225   
8/2/2006 8:38:41 PM 28841892 NL Hold'em USD 10 FPP 0.00 0.00 3583 7501 0.00 0.00 28686225   
9/1/2006 8:14:49 PM 30629769 NL Hold'em   Freeroll 0.00 0.00 3863 9141 0.00 0.00 30261975   
9/4/2006 8:21:14 PM 31011959 NL Hold'em USD 10 FPP 0.00 0.00 6393 6631 0.00 0.00 30576802

Quote

09-17-2009 , 08:55 AM

#28

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

Those files cannot be imported - you need to request the full tournament results which show the finishing positions of all players.

Quote

09-18-2009 , 07:09 PM

#29

LordBrun

grinder

Join Date: Jun 2007 Posts: 564

I'm quite getting the job done. When I run the ahk wrong stuff gets pasted into pokerstars request. I canät make total sense of the things posted in this thread. How about a walkthrough for us illiterates?

Quote

10-12-2009 , 11:45 AM

#30

mugenjin

veteran

Join Date: Feb 2007 Posts: 2,385

I run the script and I just get an empty box. No list of tournaments.

Quote

10-23-2009 , 08:57 PM

#31

jmammon

journeyman

Join Date: Aug 2008 Posts: 284

Is there a script that will request Tournament Summaries instead of Hand Histories? I am very dissapointed this still hasn't been implemented into Pokertracker3.

Quote

10-24-2009 , 06:34 AM

#32

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

That's exactly what this script does.

Quote

10-24-2009 , 08:39 AM

#33

money talks

newbie

Join Date: Jun 2008 Posts: 20

I gave up trying to get this script to work a while back.

My stats are all wrong on PT3 due to the fact that I have played more than 200 SNG's before manually importing summeries as you can only get the last 200 from stars.

Anyone know if Holdem Manager is this much hassle for tourns?

Quote

10-24-2009 , 12:59 PM

#34

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

You can request tournament results from more than 200 tournaments ago, but you need to do it by number, which is what this script does. I haven't used it myself, but I have heard from people who have used it successfully. Please check that you have the latest version of it, and if you still have problems post what they are and the author (or another user) may be able to help you.

Quote

10-24-2009 , 08:48 PM

#35

hiho

old hand

Join Date: Jul 2005 Posts: 1,891

Holdem Manager has a huge step up because of this. Having to email or rely on scripts is a PITA.

Quote

10-25-2009 , 06:17 AM

#36

money talks

newbie

Join Date: Jun 2008 Posts: 20

Quote:

Originally Posted by WhiteRider

Ermm... thanks, but I wasn't asking for help trying to install this script. Like I said, I gave up a while back due to it being a head f**k and I have uninstalled everything when I last cleaned out the junk on my laptop. I don't understand why this isn't part of PT3 already!? Just seems like the delelopers/writers have given up or lost interest.

Quote:

Originally Posted by hiho

Holdem Manager has a huge step up because of this. Having to email or rely on scripts is a PITA.

That's what I thought, my mate uses HEM and swears by it but he only plays cash games so cheers for clearing that up. Just a shame I can't afford to buy it right now and also a shame I can't get a refund for Pokertracker.

Quote

10-27-2009 , 06:01 AM

#37

Mark1978

adept

Join Date: Jul 2005 Posts: 855

Quote:

Originally Posted by money talks

I don't know if I'm doing something wrong but I find HEM awful for tracking tournament results. It tries to work out the results from the HHs which it does badly and doesn't seem to allow you to import summaries, only manually change the results.
I use PT3 for results tracking and HEM for the HUD (it's great for this) because PT3 performs so so badly once you get over about 12 tables.

Quote

10-27-2009 , 08:09 AM

#38

JustCuz

grinder

Join Date: Aug 2007 Posts: 692

Quote:

Originally Posted by Mark1978

+1

I so, so wanted HEM to be the end of the tourney hassle I have with PT3, but it is worse. Table types are usually wrong, and results are inaccurate. I gave up trying and scripts for PT3 and import from email.

Quote

11-07-2009 , 12:06 PM

#39

bonaparte

centurion

Join Date: Feb 2005 Posts: 144

Quote:

Originally Posted by money talks

I don't understand why this hasn't been done already, is it a big challenge?! it was part of PT2 from what I've read

Anyway, I have tried doing evrything this thread says but not sure I done everything I was meant to, how do I check that it is working properly?

Yes PT2 did this automatically, it is built into the program. It is silly that PT3 hasn't incorporated this yet. I'm about to try the script myself, we will see how it goes.

Quote

11-07-2009 , 12:37 PM

#40

bonaparte

centurion

Join Date: Feb 2005 Posts: 144

OK so it looks like I got in 88 requests before Pokerstars gave me an error message saying I have exceeded their request limit per hour. So I wait an hour to do 88 more? This is going to take me days.

Come one PT3, is it that hard to convert over from PT2 to PT3? All my data is already in PT2, I just can't get it into PT3.

Sad.

Quote

11-12-2009 , 10:14 AM

#41

Mark1978

adept

Join Date: Jul 2005 Posts: 855

Quote:

Originally Posted by bonaparte

Can't you just import your PT2 db to PT3? I haven't tried it but I'm sure the option is there in PT3.

Quote

11-14-2009 , 02:40 PM

#42

bonaparte

centurion

Join Date: Feb 2005 Posts: 144

Quote:

Originally Posted by Mark1978

Can't you just import your PT2 db to PT3? I haven't tried it but I'm sure the option is there in PT3.

Yeah I figured that out. If you have PT2 without SQL database then you can just export your your tourney data to a folder, and then have PT3 read that folder. I wish the guy from PT had explained that to me. In the end my results are now in PT3. Not sure if I'll buy it or not yet. I already have PT2 and HEM, Just looking at PT3 again since PT2 support ends in March.

Quote

11-14-2009 , 04:26 PM

#43

hiho

old hand

Join Date: Jul 2005 Posts: 1,891

Seriously is there even any consideration to adding this to PT3 or do we need to wait for PT4?

Quote

11-14-2009 , 05:12 PM

#44

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

Yes, there is, but I do not know when it will be done.

Quote

11-14-2009 , 08:27 PM

#45

leviathan74

veteran

Join Date: Nov 2008 Posts: 3,423

The script has worked for me. With the hourly limits on asking for summaries however, it did take me a couple of days.

Quote

11-15-2009 , 12:51 PM

#46

rvg72

veteran

Join Date: Jun 2005 Posts: 3,214

Quote:

Originally Posted by Mark1978

Hi, based on your location you play 45 man tourneys (or other multi table tourneys) and unfortunately it is impossible to determine that from the hand history on Stars unless you make the final table.

The summaries should work though and if they don't I'd be happy to look into this for you. I don't want to side track this thread so just email support@holdemmanager.net with sample summaries that are not working along with the hand history files and I'll check but there shouldn't be any problems with importing Stars summaries for these or any other tourneys.

Roy

Quote

12-18-2009 , 08:22 AM

#47

pmania

centurion

Join Date: Feb 2008 Posts: 111

Quote:

Originally Posted by McFlan

Interesting... I just request my all time tournament and sng results, and PS sent 2 html files. How can I import this to PT3 in order to automatically populate results? Thanks!

HTML Code:

All RegularTournaments played by 'mflan':
Default currency:  USD
Listing: Real Money    FPP Events    Freeroll    
From: 2000-09-17-00.00.00 
To: 2009-09-17-23.59.59 

Date/Time Tourney Game Currency Buy-In ReBuys
AddOns Rake Place Entries TLB Points Prize Target ID Qualified 
7/6/2006 6:54:55 PM 26559464 NL Hold'em USD 10.00 0.00 1.00 26 107 0.00 0.00     
7/19/2006 8:34:20 PM 28152213 NL Hold'em   Freeroll 0.00 0.00 3380 7291 0.00 0.00 27706161   
7/27/2006 6:23:50 PM 27704005 NL Hold'em USD 10.00 0.00 1.00 56 117 0.00 0.00     
8/1/2006 8:38:46 PM 28841889 NL Hold'em USD 10 FPP 0.00 0.00 1280 7360 0.00 0.00 28686225   
8/2/2006 8:38:41 PM 28841892 NL Hold'em USD 10 FPP 0.00 0.00 3583 7501 0.00 0.00 28686225   
9/1/2006 8:14:49 PM 30629769 NL Hold'em   Freeroll 0.00 0.00 3863 9141 0.00 0.00 30261975   
9/4/2006 8:21:14 PM 31011959 NL Hold'em USD 10 FPP 0.00 0.00 6393 6631 0.00 0.00 30576802

How do you do this, is this the only way to check your rebuys/addons ?

Quote

12-23-2009 , 10:55 PM

#48

astrodon

enthusiast

Join Date: Nov 2004 Posts: 82

[QUOTE]Install AutoHotKey.
http://www.autohotkey.com/download//QUOTE]

Probably the most obstinate utility I have ever crossed in 27 years of computer experience.

Quote

12-24-2009 , 12:16 PM

#49

astrodon

enthusiast

Join Date: Nov 2004 Posts: 82

Quote:

Originally Posted by Palsh

If I may,

Code:

SELECT tourney_holdem_summary.tourney_no as "tourney_no"
FROM tourney_holdem_summary WHERE
  ((SELECT sum(val_finish)
  FROM tourney_holdem_results thr WHERE
    thr.id_tourney = tourney_holdem_summary.id_tourney) = 0)
  AND tourney_holdem_summary.id_site in (100)
ORDER BY tourney_no DESC;

restricts the results to tourneys from PokerStars where no result has yet been entered. It puts the most recent ones (those with the highest tourney_no) on top.
I'm not 100% sure if id_site 100 is always PS, if it does not work do a

Code:

select * from lookup_sites;

and use id found there as id_site.

Regards
Palsh

My son often comes to visit and he is a poker player as well. So consequently I wind up with downloaded files that PT3 reads. If you use the script to bring all tourneys you will get no player stats because you were not involved in the tourney. I edited the SQL to get just your stuff.

Code:

SELECT ths.tourney_no
FROM tourney_holdem_summary ths WHERE
  ((SELECT sum(val_finish)
    FROM 
        tourney_holdem_results thr inner join
        player p on
        p.id_player = thr.id_player
    WHERE
        p.player_name = 'PutYourNameHere' 
    AND thr.id_tourney = ths.id_tourney) = 0)
    AND ths.id_site in (100)
ORDER BY ths.tourney_no DESC;

EDIT: Also, I am wondering if PS has a limit of automatically generated requests. If there are more than two tourney numbers in the list - PS will only return two files.

Last edited by astrodon; 12-24-2009 at 12:21 PM.

Quote

12-27-2009 , 01:49 PM

#50

pmania

centurion

Join Date: Feb 2008 Posts: 111

Could someone modify this script to ask for a txt file which has tournament numbers in it, like:

1
2
3

etc.

I know pokerstars only allows about 60 tourney request per hour.

Quote

Page 2 of 5

First

1 2 3 4 5

Last

Post Reply Subscribe

...

Page 2 of 5

First

1 2 3 4 5

Last