PT to Statking export?

[subq]

Has anyone tried to export sessions from PT to import into Statking somehow?

[TimM]

[ QUOTE ]
Has anyone tried to export sessions from PT to import into Statking somehow?

[/ QUOTE ]

I am curious too. I just downloaded the StatKing demo, but can't seem to find out what the demo limitations are.

I do some Perl programming, so I think if there is no direct way to export, it shouldn't be too hard for me to write some script to massage the PT output to get it into SK.

Of course, if someone has already done this, I wouldn't want to reinvent the wheel if I didn't have to.

[TimM]

Actually it looks easy. The only problem with PT's output is that it the time field is in minutes and Statking wants hours. The date portion imports fine even with the extra time field that PT puts out.

To do the export:

Filter your PT data as desired
Go to the session tab
Click the Start Time heading under Session Detail until the sessions are sorted date ascending
Click the "P" button next to Session Detail, then click Export
Uncheck all boxes except 1,3,5,7 and 8.
Export to a Comma Separated file

You can then open this file in notepad or excel and change the times from minutes to hours. Since I have 600 sessions so far, I will write some kind script to do it and post it here later.

[TimM]

Got my copy of StatKing today, and wrote a script to covert the PokerTracker sessions export format to something StatKing can import.

To use this script you will need to install a version of Perl on your system. I use ActivePerl:

http://www.activestate.com/Products/...?id=ActivePerl

Save the following lines to a text file and call it PTtoSK.pl:

<font class="small">Code:</font><hr /><pre>
# PTtoSK.pl ################################################## #################

%sites = ('PP' =&gt; 'Paradise Poker', 'PTY' =&gt; 'Party &amp; Affiliates',
'PS' =&gt; 'Poker Stars', 'UB' =&gt; 'Ultimate Bet',
'PRM' =&gt; 'Prima Network', 'ABS' =&gt; 'Absolute Poker');
open(INFILE, "in.csv") or die $!;
open(OUTFILE, "&gt;out.csv") or die $!;
while (&lt;INFILE&gt {
next if /^\D/;
@fields = split(/,/);
next if $fields &gt; 15;
$fields[2] = $sites{$fields[2]} if defined($sites{$fields[2]});
$fields[4] =~ s/\$//g;
$fields[6] /= 60;
print OUTFILE "$fields[0],$fields[2],$fields[4],$fields[6],$fields[7]\n";
}
close(OUTFILE);
close(INFILE);

################################################## #############################
</pre><hr />

To do the export:

<ul type="square"> [*]Filter your PT data as desired[*]Go to the session tab[*]Click the Start Time heading under Session Detail until the sessions are sorted date ascending[*]Click the "P" button next to Session Detail, then click Export[*]Do not uncheck any boxes, leave all defaults[*]Export to a Comma Separated file, call it in.csv, and save it to the same location as the PTtoSK.pl script[*]Run (double-click) the PTtoSK.pl script[*]The script will create an out.csv file, import this into StatKing[/list]
As usual there is no warranty, if you break your computer trying to do this, it's your responsibility.

[Luv2DriveTT]

This script is TRUELY fantastic. Would you consider making a script for Tournaments as well? [img]/images/graemlins/spade.gif[/img] [img]/images/graemlins/diamond.gif[/img] [img]/images/graemlins/heart.gif[/img] [img]/images/graemlins/club.gif[/img] [img]/images/graemlins/grin.gif[/img]

[TimM]

[ QUOTE ]
This script is TRUELY fantastic. Would you consider making a script for Tournaments as well? [img]/images/graemlins/spade.gif[/img] [img]/images/graemlins/diamond.gif[/img] [img]/images/graemlins/heart.gif[/img] [img]/images/graemlins/club.gif[/img] [img]/images/graemlins/grin.gif[/img]

[/ QUOTE ]

Sorry I missed this reply. I don't play tournaments much, so I'm not sure what would be needed here. Does SK even cover tournaments?

[Wahoo91]

WOW-
I just tried this out and was able to easily upload MANY MANY PT sessions that I had given up on ever getting into SK.

I can not thank you enough Tim this is f***in' AWESOME!

[img]/images/graemlins/grin.gif[/img] [img]/images/graemlins/grin.gif[/img] [img]/images/graemlins/grin.gif[/img]

[Wahoo91]

Tim-
I asked this in another tread but it was pretty buried; who are the two people in your avatar?

[TimM]

I wish I knew:

http://www.allposters.com/gallery.as...mp;item=333735

[Wahoo91]

http://www.allposters.com/gallery.as...mp;item=333735

How many times is it appropriate to say WOW in one thread?