Holdemanager import

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Holdemanager import

Postby rewket » Wed Apr 30, 2008 12:47 pm

Is it possible to import hands from Holdem manager to PT3? i really hate holdem manager and want to move my database to pt3.
I tried to import all my saved HH but for some reason PT3 is missing my downswing from the end of this month which skews the resulsts.


tried to search but it said i cannot use the search function
rewket
 
Posts: 4
Joined: Thu Mar 13, 2008 3:04 pm

Re: Holdemanager import

Postby APerfect10 » Wed Apr 30, 2008 1:12 pm

What site are you playing on? Is it possible that the hand histories for this 'downswing' are simply not there?

To be honest, I am not very familiar with HM but I suspect there should be a way to export your hand histories to the hard drive. It would not surprise me though if there was not. In that case do the following:

(Credit to _dave_ for providing this)
Open a command prompt on the computer running postgresql (Start -> Run -> "cmd" [Enter]), type (or copy/paste) the line below.

Change the database name "HM_DB1" to your Holdem Manager database name and change the txt file names at the end if you like.

Code: Select all
psql -A -t -d "HM_DB1" -U postgres -c "select handhistory from handhistories;" -o hm_hh.txt

it should chug for a while and make some big text files which you can manually import into PokerTracker 3. (It may be wise to do this on a new database so that all of the duplicates do not slow down the import process).

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4463
Joined: Sat Dec 08, 2007 6:03 pm

Re: Holdemanager import

Postby Rtttzzz » Wed Aug 17, 2011 5:22 am

bump. i'm having some issues to import from HEM to the latest version of PT3. speaking of raw hands and they're totally different when exported from HEM than from PT3.
surprisingly, it's importing MTT hands but not any single cash game. any help? thanks.
Rtttzzz
 
Posts: 10
Joined: Wed Oct 07, 2009 7:12 am

Re: Holdemanager import

Postby kraada » Wed Aug 17, 2011 8:27 am

What site is this for? Do you have (or can you get) the original hand histories?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Holdemanager import

Postby Rtttzzz » Mon Sep 12, 2011 8:10 pm

kraada wrote:What site is this for? Do you have (or can you get) the original hand histories?

ongame, latest client (java). original hh is hard/impossible to get, only the ones exported from hem in "raw" format. somehow PT3 seriously owns hem when HH exporting is in question.
Rtttzzz
 
Posts: 10
Joined: Wed Oct 07, 2009 7:12 am

Re: Holdemanager import

Postby WhiteRider » Tue Sep 13, 2011 3:45 am

Hands written by the current OnGame software are in plain text so should be exactly the same after the import, but neither PT3 or HEM deletes any hand history files, they are just moved after import so unless you deleted them yourself you should still have them.
If they were imported by HEM they will have been moved to C:\HMArchive by default.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 13 guests

cron
highfalutin