PDA

View Full Version : Importing HH's For Only One Player?



PeaceFr0g
04-26-2010, 03:49 PM
I was using two separate databases (both in HEM) for two different poker sites. I'd like to import my FT hands into my main database. I do NOT want to merge the entire FT database however. Or...

Is there a way to make a copy of a database and then rename it, retaining them both under separate names? Thanks.

_Loki_
04-26-2010, 05:11 PM
Mr Mojo Risin'

You can't directly merge DB's, but to end up with one DB as you described I would do this:

The DB that you're exporting FROM (DB FT):
I would purge all observed hands in DB FT first
FAQ - Hold'em Manager Poker Tracking Software :: Observed Hand History Configuration (http://faq.holdemmanager.com/questions/196/Observed+Hand+History+Configuration)

Then I would export what was left in FT DB to a folder I made on the desktop:
FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)

Then I would import the HH's in the desktop folder into the other DB
(see above link)

Then I would delete (drop) the DB FT via PGadminIII
Then I would vacuum/reindex the new DB
Then I would defrag my HDD (turn off postgreSQL service first)

I haven't got time to post links for the last bits at the moment
MAKE SURE you take backup precautions before doing any of this :)

PeaceFr0g
04-26-2010, 08:00 PM
Thanks a ton Loki,

I think I made it more complicated than it needs to be. I just want to copy a database, re-name it, and use the one I re-named (while keeping the old one for when I play on FT). Is that any easier? I don't see how to copy a DB. Thanks.

_Loki_
04-26-2010, 08:30 PM
It isn't possible to rename a DB I was told on this forum
I don't believe you can copy a DB & rename it, but I don't know for sure - I can't imagine how to do this, but then I'm not a DB person :)

Is the main problem for you the time involved to export/import the HH's or is it more complicated than that ? I don't understand what you want to achieve in the end. I THINK you're saying that you want:

DB1: FT HH's only
DB2: FT HH's + anothersiteHH's

Or

DB1: FT HH's only
DB2: anothersiteHH's only

Or something else again ?

PeaceFr0g
04-27-2010, 12:57 AM
I guess I'm trying to do something like you would with a word document:

You have a document saved as "Letter". Now you open "Letter" and add to it, but save it as "New Letter". You now have two files. "Letter" and "New Letter". You can continue adding to "New Letter", but can also add to "Letter" without disturbing "New Letter".

So I'd like DB1 to remain as it is, but also create a DB2 that has a starting point of all of DB1's hands. Now I can use DB2 or DB1, without disturbing the other.

I'm sure I'm making it more complicated than it needs to be. I've been playing different game formats, and testing out slightly different styles. What I'm trying to do might sound silly, but it's how my brain works.

There must be a way to export all hands from DB1 to a file, create a DB2, and import from the file into DB2, while still retaining DB1. If you can spell out how to do that, great. If not, I can probably figure it out somehow, it will just take me forever and I probably will just end up not doing it! -lol. Thanks again Loki.

netsrak
04-27-2010, 03:31 AM
The only way is to export/import hands from DB1 to DB2:

FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)

_Loki_
04-27-2010, 12:23 PM
.. export all hands from DB1 to a file, create a DB2, and import from the file into DB2, while still retaining DB1...

Export from FT DB to a folder on the desktop:
FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)
The 'export' doesn't remove HH's from the FT DB - it copies them
(I don't like the word 'export' here, but it's the term that's used - an export in my mind is a cut/paste, but actually an export is a copy/paste in postgreSQL - crappy jargon)

Then import the HH's in the desktop folder into the other NEW DB

Then I would vacuum/reindex both DB's
Then I would defrag my HDD (turn off postgreSQL service first)

MAKE SURE you take backup precautions before doing any of this

PeaceFr0g
04-27-2010, 12:43 PM
Thanks Loki,

Done. I just exported the hands to a folder, created a new DB and imported them into that. Worked like a charm. All's good. As long as I got your ear, can I ask you another question without starting a new thread?

I'd like to know how I'm doing vs. players of varying vpip and other stats. I can't figure out how to sort players by vpip. For instance, if I want to see my results vs. the top 10 highest vpips in my DB, how do I do that? Or how do I even know who the top 10 highest vpips are? Surely, there must be a way without having to pull up each player individually. I would think it would be under 'vs. player' tab, but there's no vpip tab to sort by. Thanks.

_Loki_
04-27-2010, 01:13 PM
Glad it worked :)

I walked 47 miles on barbed-wire,
Got a cobra-snake for a necktie.
I built a house by the roadside,
Made of rattlesnake hide.

Got a brand new chimney up on top,
Made out of human skulls.

Tombstone head and a graveyard mind,
I'm just 22 and I don't mind dying.
Rode around the town with a rattlesnake whip,

The night is dark, the sky was blue,
Down the alley the ice wagon flew.
Hit a bump, somebody screamed,
You should'a heard just what I seen.

FROM MY POV THE 'PLAYERS' SIDEBAR IS THE BEE'S KNEES

Players Sidebar (Window): HM BLURB - "The Players Window is a great way to analyze individual players. Click Run Report and the Main View populates with players and stats. Click a player’s name and the Player Analysis window populates with the selected players stats. The Player Analysis window color codes player's stats based on if they are higher or lower than the average"

The below will give you what you need

FAQ - Hold'em Manager Poker Tracking Software :: Players Window Introduction (http://faq.holdemmanager.com/questions/184/Players+Window+Introduction)
FAQ - Hold'em Manager Poker Tracking Software :: Players Window Filters (http://faq.holdemmanager.com/questions/185/Players+Window+Filters)
FAQ - Hold'em Manager Poker Tracking Software :: Players Window Main View (http://faq.holdemmanager.com/questions/186/Players+Window+Main+View)
FAQ - Hold'em Manager Poker Tracking Software :: Players Window Player Analysis (http://faq.holdemmanager.com/questions/187/Players+Window+Player+Analysis)
FAQ - Hold'em Manager Poker Tracking Software :: Players Window Results Analysis (http://faq.holdemmanager.com/questions/188/Players+Window+Results+Analysis)

If you get stuck - shout out