Lost hands from pt3

[xxDRBxx1]

I just upgraded to PT4 from PT3 and I copied over my PT3 database. The results are close, but not exact as far as amount won, hands played, and possibly even statistics right down to the exact numbers. Also, it is paaaainfully slow.

Why would there be missing hands in the transfer in database?
Is there something in housekeeping I was supposed to immediately to make the speed faster.

Thanks in advance.

[WhiteRider]

Are the hands cash or tournament hands, or a mixture?
Which type are missing?
What site(s) do you play at?
Did you get any import errors when you did the conversion?
Roughly how many hands are there altogether?

[polk3]

I've been going through the same thing , and I can share some experiences.

* Missing hands tend to be because of import errors in PT4, i.e. hands that import fine in PT3 but are rejected by PT4.

* There was also a bug earlier where not all hands were exported from PT3, but I believe that has been corrected now.

* This affects both cash and tournament hands in both holdem and omaha

* There are errors in how PT4 handles penalty blind situations, or new players with no reported starting stack, or cases where the hand history file is incomplete etc. Tricky spots for a tracker to handle, but PT3 gets it right whereas PT4 doesn't. This seems to happen more on some sites than on others.

* It also appears to differ a bit between sites. Some are super solid, while some give more errors.

* There are also some cases where PT4 corrects issues from PT3. I've seen this sometimes with time zones and how session hands are summarized into totals for a session. In my case I also had errors in my PT3 db that had been caused by past import bugs in PT3, but since I hadn't done a reimport the errors remained in the db.

* Additionally, on some sites PT4 will report on invalid showdown hands in some spots where PT3 doesn't. Don't know if this actually has an impact on data content though.

I've reported on all these errors via support tickets. I think the devs are on it, though it seems to take a bit time. Your import could obv have other issues than I've seen.

There are also some other reasons why results could look different in PT4. Limit names may have changed, position names may have changed, bb/100 vs BB/100 changed, currency conversion changed, tournament descriptions changed etc. These are generally improvements, so they may cause difficulty in comparing but they are typically desired differences.

The import errors and the penalty blind (etc) errors are numerous enough in my case to be significant. If there were just some limited errors I don't know if I'd bother with it, but this impacts thousands of hands for me. For some sites I get differences in 5-10% of all cash sessions, though some of those differences may be small (say one or two blinds for a whole session).

[xxDRBxx1]

Thanks for the replies...
I play on Revolution and Bovada (obviously only Revolution matters), primarily cash.... I only care about the missing cash game hands.
The only problem getting the PT3 database over was it froze the first time and I had to abort and try again. It worked the second time as far as I can tell although I am no tech guru.
My database is rather large (~900,000 hands with a bit less than half being my own). Maybe around 1,500 players... mostly Bodog players when they allowed PT3 (not sure how to get rid of them now).

I'm not missing too many hands, just was wondering why I did not get every one. Thanks.

[kraada]

polk3,

Thanks for creating tickets for your situations. That goes a long way towards helping us make sure everything works 100% without problems. There are tons of different permutations of old hands and we only have access to so much data of our own, so every example that can concretely reproduce a problem is a big step towards getting a fix.

xxDRBxx1,

There was a problem which was fixed in our latest release where the very first hand wasn't getting converted. If you're only missing a handful of hands that one might have been part of your problem. If you have a chunk of hands, please try exporting those hands from PT3 and attaching them to a support ticket and we'll make sure to look into what is going on here for you.

[xxDRBxx1]

The problem is I have no idea what hands I am missing. Is there anything I could do (such as trying copying over of database again, waiting for update, etc) that I could do rather than go through close to a million hands to see which ones I don't have? Thanks again.

[kraada]

The easiest way is probably to compare reports in PT3 and PT4 - if you compare your sessions report in PT3 to any by sessions grouping in PT4 you can find quickly which sessions have problems, then export just those sessions from PT3 and reimport them into PT4. If there remain problems with those hands, then you can send us the exports for further investigation.

[polk3]

@xxDRBxx1:

If you have a limited number of sessions kraada's suggestion is indeed probably the easiest. If you know your way around SQL and databases and you have 900k hands to go through there's a way to automate the process. It does involve some non-beginner and non-standard PostgreSQL machinery though, and unless you have experience in that area it's not going to be the right place to start.

I'm currently trying to encapsulate the hand comparison in an app that makes it a lot easier. Will be happy to share when finished, though it's going to be another while before it's at a useful stage.

[xxDRBxx1]

Thanks for the help, although aside from going to Texas Holdem, my name, Sessions, Reports (in PT3)... I don't know what to do :/

[kraada]

Then in PT4 with your name selected look at the Summary report grouped by Sessions. Sort both by date and look at either number of hands or total amount won. You should be able to rule out many sessions quite quickly.

Once you've found what you want to export, follow this tutorial to export those sessions. Try importing them using Get Hands From Disk in PT4 - if they don't work, zip them up and attach them to a support ticket so that we can investigate why and get a fix together for you.