PDA

View Full Version : Import File(s) error from 888/Pacific



drunkson
07-19-2011, 11:07 AM
Hi,
I'm just started to use HEM and want to import a lot of hand histories exported from PT3, but I get import errors.

There are 10.000 hands in each file, and I get 10.000 errors.

1. Why do I get the errors?
2. Where can I see error codes?
3. What to do with the logfiles after an import? Delete or leave them?

I see several error logfiles
C:\Program Files (x86)\RVG Software\Holdem Manager\SQLErrors.txt
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Import Errors\ImportErrors.txt
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Logs\ImportTraceError.log
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Logs\SQLErrors.txt
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Logs\2011-07-19ImportErrors.txt
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Logs\Pacific2011-07-19ImportErrors.txt

It's not all my files that won't import, but most of them.

drunkson
07-20-2011, 02:37 AM
I'm running the newest version 1.11.07a.

I tried to import to a new database, but with same result.

netsrak
07-20-2011, 04:05 AM
We don't support the PT3 export format for all sites.

You should import the original handhistory files from the PT3 subfolder processed or you can try to convert the PT3 database to Holdemmanager. This is under File->Import PT3 database

drunkson
07-20-2011, 11:47 PM
I created a new database in HEM and tried to import my PT3 database.

I choose the PT3 installation directory "C:\Program Files (x86)\PokerTracker 3" and then I get the folowing error:

ERROR: 42P01: relation "holdem_hand_summary" does not exists.

My PT3 processed files isn't in the default directory, but on another drive.

HEM version: 1.11.07a
PT3 version: 3.11.2 beta
PostgreSQL: 8.3

netsrak
07-21-2011, 05:17 AM
Did you choose the PT3 postgresql database in the first column of the import function?
Please add a screenshot of your selections and the error.

drunkson
07-21-2011, 08:15 AM
Thanks for your help, this was just what I did wrong. I chose the wrong database :(

drunkson
07-21-2011, 10:29 AM
But unfortunately it didn't finished.

It imported 600K hands out of 700K and then I got this error:
ERROR: 22P05: character 0x81 of encoding "WIN1252" has no equivalent in "UTF8".
16291

Patvs
07-21-2011, 08:58 PM
Delete the postgres user:

click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.

Install SQL 8.4.8 (or 9.0.4 ) to port 5433 (from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org))
Create a new database (UTF8) and reimport the hands.

Your issue seems to be caused the old postgres 8.3 user is in WIN1252 encoding, while you created a UTF8 HoldemManager database.......



---


You can also opt to just create a new ASCI HoldemManager database (non-UTF8) then reimport the hands.

drunkson
07-22-2011, 01:59 AM
Ok, thanks. I will try this after I'm back from holiday.

I think I will do the following:
1. Backup my PT3 database
2. Upgrade PostgreSQL to 9.0.4 (port 5490)
3. Restore my PT3 database to the new PostgreSQL
4. Create a new HEM database (UTF8)
5. Reimport the hands using the menues in HEM

drunkson
07-22-2011, 10:07 AM
Ok, I changed my mind and tried before my holiday ;-)

1. Backup my PT3 database
No, problem

2. Upgrade PostgreSQL to 9.0.4 (port 5490)
No, problem

3. Restore my PT3 database to the new PostgreSQL
Took a while to find out how to connect to the new PostgreSQL version, but I managed

4. Create a new HEM database (UTF8)
No, problems

5. Reimport the hands using the menues in HEM
Last time I tried, the import took several hours, but this time the cash hands imported in a few seconds (700K hands), but the tournaments took awhile (3K tournaments)
I think it was the export and not the import which took the time.

Everything looked nice, until I opened HEM. There were no cash hands at all (that's why it was so quick)

Patvs
07-22-2011, 11:54 AM
Move the hands to a different folder. Then reimport them again into a new empty database.

drunkson
07-22-2011, 01:40 PM
I can't move them to a different folder, because most of the hands I only have in PT3.

I tried to import the HH's i do have, and they are ok, but for some reason all my NL10 hands are gone (It's NL10 I play the most).

All other hands are there, NL4, NL20, NL50, FL-tables.

I played a few NL10 hands at £-tables, and they are there.

I did a clear of all filters, but still it wont work.

If I move a HH to another folder and do a re-import HEM says all hands are dublicates, so somehow they are in HEM, but I can't see them in the reports.

Patvs
07-22-2011, 08:31 PM
clear filters (even though it appears no filters are selected)

drunkson
07-23-2011, 09:48 AM
I tried every thing now, and I gave up.

I'm just sticking with what I have, and will continue from there.

Thanks for trying to help me.

Patvs
07-23-2011, 10:27 AM
set the date formatting of your computer to M/d/yyyy (and not to European default d/M/yyyy)
and regional settings English (United States)

Then reimport the hands into a new database.
Import them from the PT3 "Processed Hands" folder + your HoldemManager archive folder.

drunkson
07-23-2011, 11:47 AM
I'm sorry but I don't have more time to experiement. I'm going on vacation;-)

I have most of my hands restored now.

I made a new DB and imported from my HH's. Some of the HH's vere very big (10K hands) and I got this error
ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

After I split the HH's to smaller parts, most of the hands were imported, and now I see the NL10 too.

But you might have a point with the regional settings. I live in DK and have DK settings, even though I try to keep my poker related things in English.

But for now, I'm sattisfied. Thank you.