Manual Import Guide for too many hands

General discussion of PokerTracker 3.

Moderator: Moderators

Manual Import Guide for too many hands

Postby ozora tsubasa » Fri Jan 25, 2008 2:29 am

I just finished importing 15k hands and during the import I ran into a few files crashing PT3 beta1 during the import. Here's a little guide if you're planning to import handhistories from a folder containing many files:

I ran into a few handhistory files crashing PT when importing 5k files. If this happens, look at the file number from import window when the crash happens. Then sort the files in your handhistory folder w.r.t filename. The first X many files are already imported according to the number you see at crash time. You can move these away to another folder. Either the last file of that batch or the X+1st file is the problem one. Try finding which one by importing these files individually and reproducing the error. Send the problem file to PT people by submitting a support ticket. Then import your handhistory folder once again with the remaining handhistory files.

Sometimes the number you see on the import statistics during the crash lags behind a few files of the actual number of the file which causes the crash. Like here it shows 15 files were imported, but in reality it could have been any 14+X within a reasonable range: [imgh79]http://www.karidegiliz.biz/publicpoker/2p2r17.jpg[/imgh79]

To locate the file which caused the crash, another way is to look at the last filename displayed in import status window:
[url=http://www.karidegiliz.biz/publicpoker/2p2r18.jpgh79][imgh79]http://www.karidegiliz.biz/publicpoker/2p2r18.jpg[/imgh79][/urlh79]

But sometimes the filename isn't shown there, or the PT window freezes etc.
In that case you can go to your PokerTracker 3 folder and open the PokerTracker.log file. Go to the last few lines:

[quoteh79]2008/00/25 01:08:09.352: [00001316][PostgresConnection (Error)] Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: duplicate key violates unique constraint "hhs-unique_hand_no" CONTEXT: COPY holdem_hand_summary, line 1: "1679277 300 1 42 [bh79]4448953210[/bh79] 2007/12/09 23:27:58 2008/01/25 01:08:09 6 4 0 0 8.00 0.40 0.07 0 254 4 1..." )[/quoteh79]

4448953210 is the hand number of a hand from the problem file. To locate this file, you can search your handhistory folder for the file containing the text "4448953210", and you have your file :)
[imgh79]http://www.karidegiliz.biz/publicpoker/2p214.jpg[/imgh79]

If the handhistory file has an extension other than .txt, windows search some might overlook that file during search. (eg. .tmp files). You can use [url=http://sourceforge.net/projects/renameit/h79]Renameit[/urlh79] to rename the extensions of all your HH files to .txt.
ozora tsubasa
 
Posts: 28
Joined: Thu Jan 24, 2008 8:32 pm

Re: Manual Import Guide for too many hands

Postby ozora tsubasa » Fri Jan 25, 2008 3:13 am

[quote="ozora tsubasa"4fm]I just finished importing 15k hands and during the import I ran into a few files crashing PT3 beta1 during the import. Here's a little guide if you're planning to import handhistories from a folder containing many files:[/quote4fm]

15k files, not 15k hands.
ozora tsubasa
 
Posts: 28
Joined: Thu Jan 24, 2008 8:32 pm


Return to General [Read Only]

Who is online

Users browsing this forum: Amazonbot and 10 guests

cron