Import File(s) error from 888/Pacific

[drunkson]

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]

I'm running the newest version 1.11.07a.

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

[netsrak]

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]

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]

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]

Thanks for your help, this was just what I did wrong. I chose the wrong database

[drunkson]

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".
Attachment 16291

[Patvs]

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)
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]

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]

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)