PDA

View Full Version : Merge Support - moving "party" hands to merge



cmc
01-02-2010, 04:01 PM
Good afternoon,

Thank you very much for adding support for the Merge Network.
I had previously purchased the Merge Converter that converts hands to Party Poker format. I downloaded the latest HEM beta (1.10 Beta 6) and the imports seem to work well now, so I don't need the Merge Converter I purchased.

My problem is that I have a couple months of history in Party Poker format and I don't have the originals from the merge site (Carbon). I tried emailing their support and they will not send my old histories (the software only allows for saving of up to 30 days).

Is there any way I can convert my Party history to the Merge network?

Thank you!
cmc

fozzy71
01-03-2010, 01:44 AM
I have forwarded this thread to the developer.

netsrak
01-03-2010, 06:23 AM
Does this help?


"Hi, you first need to open pgadmin from Start Menu - Postgresql and then double click on the server name in the list and it will ask you for your password. Most likely it is postgrespass unless you used a different one.

Open the Query window by clicking on the icon that looks like a pencil and a piece of paper. In the window that opens replace anything in there with:

update players set site_id = 18 where site_id = 0;
update pokerhands set site_id = 18 where site_id = 0;
update pokerhands_hero set site_id = 18 where site_id = 0;
update tourneydata set site_id = 18 where site_id = 0;
update tourneyplayerdata set site_id = 18 where site_id = 0;


Then press F5 to run it. Launch HM and all your Boss players and hands that were converted to Party should be back to Boss. The problem with doing this if you already imported real Boss hands is you'll have duplicate players in the players table which will probably cause other problems.

Roy"

cmc
01-03-2010, 05:01 PM
Yes, thank you!
Note that for Merge, the site_id = 19.

To avoid having duplicate players, I did the following and it seemed to work well:

1. Purge all Merge hands from the database
2. Export Hands
3. Create new Database
4. Import hands
5. Run the SQL command provided (using the correct site_id).

Thanks again.

netsrak
01-04-2010, 05:56 AM
Thanks for the feedback

antzTPK
01-17-2010, 01:03 AM
Hi there i followed your link here from the PKR thread. im trying to get the hands i converted from pkr into pokerstars format back to pkr format, ive read all the above and have followed the instructions upto where i have to enter ....

update players set site_id = 18 where site_id = 0;
update pokerhands set site_id = 18 where site_id = 0;
update pokerhands_hero set site_id = 18 where site_id = 0;
update tourneydata set site_id = 18 where site_id = 0;
update tourneyplayerdata set site_id = 18 where site_id = 0;

what codes should i use to do this correctly

Thanks in advance antz

netsrak
01-17-2010, 07:21 AM
You find the values in the table "pokersites".

Stars is 2
Merge is 19


0;"Party";"PP"
1;"Full Tilt";"FT"
2;"Stars";"PS"
3;"Prima";"PRM"
4;"IPoker";"IPK"
5;"Absolute";"ABS"
6;"Crypto";"CRY"
7;"Bodog";"BDG"
8;"Ultimate Bet";"UB"
9;"On Game";"ONG"
10;"Everest";"EVT"
12;"Pacific";"PAC"
14;"Betfair";"BTF"
15;"Dracula";"DRC"
16;"Entraction";"ENT"
17;"Cake Poker";"CAK"
18;"Boss";"BOS"
19;"Merge";"MER"
20;"PKR";"PKR"

antzTPK
01-17-2010, 01:31 PM
ok thanks for the above
one quick question, will this action affect my pokerstars hh's for games ive playd on pokerstars under a different alias than on pkr. im guessing it should not !

Thanks for yurr time antz

netsrak
01-18-2010, 06:55 AM
Yes it will because the statements don't differ between different players.

If you have hands from both sited this will not work. I think the easiest it to create a new database and reimport all your hands.

antzTPK
01-18-2010, 05:12 PM
ok thank you, il create a new database and giv it a go, see how i get on and il let yu know how i get on. Cheers man

antzTPK
01-18-2010, 07:10 PM
Everything went smoothly
thanks once again for yurr help

raller
01-19-2010, 06:26 AM
I can confirm that this works. Great job!

GrindUnumb
01-23-2010, 06:57 PM
I tried these commands, and it converted my Party Poker (Merge) database back to MER according to the Sessions and Reports tab. However when I tried to export all those hands then re-import them into a new DB, they imported as Party again.

Is there a way that after I convert the Party hands in the DB back to Merge(Carbon), they can be exported as Merge(Carbon) hands?

netsrak
01-24-2010, 06:45 AM
Which HM version are you using?

GrindUnumb
01-24-2010, 02:39 PM
which hm version are you using?

1.10

netsrak
01-24-2010, 03:07 PM
Please zip and mail some of the exported files with a link to this thread to support@holdemmanager.net. But i'm not sure whether we can fix it.

bas0r
01-28-2010, 01:34 PM
ERROR: duplicate key value violates unique constraint "uniqueserial"

********** Error **********

ERROR: duplicate key value violates unique constraint "uniqueserial"
SQL state: 23505


-------
i tryed to convert players from PP into BOS
what does that error code mean?

netsrak
01-29-2010, 05:44 AM
Where do you get this message from? Are you sure its related to your update statements?

Please post the statements.

bas0r
01-29-2010, 08:35 AM
Where do you get this message from? Are you sure its related to your update statements?

Please post the statements.

i tryed the following in the sql query thing

update players set site_id = 18 where site_id = 0;
update pokerhands set site_id = 18 where site_id = 0;
update pokerhands_hero set site_id = 18 where site_id = 0;
update tourneydata set site_id = 18 where site_id = 0;
update tourneyplayerdata set site_id = 18 where site_id = 0;

--

to convert the duplicate players from PP to BOS.

netsrak
01-29-2010, 10:48 AM
Please run the separate lines individually one after the other.

For which do you get the error message?

bas0r
01-29-2010, 10:14 PM
Please run the separate lines individually one after the other.

For which do you get the error message?



i tried the lines separatly and the 2nd line produced an error, but i dont mind because the player transformation worked!