Two Plus Two Newer Archives

Two Plus Two Newer Archives (http://archives1.twoplustwo.com/index.php)
-   Software (http://archives1.twoplustwo.com/forumdisplay.php?f=47)
-   -   Moving selctions of hands in PT to new PT DB (http://archives1.twoplustwo.com/showthread.php?t=486487)

JackAll 08-26-2007 01:58 AM

Moving selctions of hands in PT to new PT DB
 
I want to take all my hands from 4 months ago using only 3 specific limits and put them in a new db for performance sake.

Can anyone give me a quick guide to this please?


Assume something like this:


"file"
=> "Maintain database names ..."
=> Add
=> <creates a new db?>


Then maybe

"utilities"
=> Export Hand Histories To File"


Than maybe select the new db as the default and unselect others

Then import those hh's?





Does this sound right at all?

matt42s 08-26-2007 02:30 AM

Re: Moving selctions of hands in PT to new PT DB
 
That'll do it.

JackAll 08-26-2007 05:56 AM

Re: Moving selctions of hands in PT to new PT DB
 
Hmm ... after creating the second postgres database (see image below), when i open up ring game stats, it shows all the hands from the first postgres db before i imported any.

Anyone got any ideas why this is?

http://img329.imageshack.us/img329/2...eenshotmh3.png

HighSteaks 08-26-2007 06:16 AM

Re: Moving selctions of hands in PT to new PT DB
 
You have to give the second one a different name when you are promted to name it in the conversion process- both of them are called PTPGSQL1 in your picture, you must have let it do it by default I guess- name the next one PTPGSQL2 or similar. Once you sort all of that out you can delete the one you duplicated also.

Example

http://img521.imageshack.us/img521/4489/jrtrjtrjvx9.png

JackAll 08-26-2007 06:43 AM

Re: Moving selctions of hands in PT to new PT DB
 
God, I suck at computers.

When I select something on that area, it only gives these options (see pic below).

Do I need to go somewhere else to create a new postgres db first? Like some command prompt and do something?

http://img525.imageshack.us/img525/7...enshot2ky5.jpg

HighSteaks 08-26-2007 07:12 AM

Re: Moving selctions of hands in PT to new PT DB
 
You have to convert databases from Access to Postgres. So make an new access database using "create a new empty access database"- Poker Tracker will give that a name automatically much like your "My first" up the very top- will be ptrack2.mbd or similar. Import this batch of hands into it that you are wanting to make this new database from and then that will be converted using the top three funtions you see under "utilities" on the main page. I'll keep my eye out lol (know how you feel- was hopeless also)

matt42s 08-26-2007 07:12 AM

Re: Moving selctions of hands in PT to new PT DB
 
You need to create a new access database and then convert it to postgres. There is no way to create a new, blank postgres database in PT.

JackAll 08-27-2007 12:40 AM

Re: Moving selctions of hands in PT to new PT DB
 
Ahhh. Thanks for the info.


I moved it all into a new access db. Took hours to import that 250k hands [img]/images/graemlins/frown.gif[/img]

I originally changed it to postgres becasue i started datamining on FTP and the db size was too big for an Access db. Since then I decided to keep on at my current site where I don't need to datamine. So I think I should be ok with the Access db for the time being.

Will covert it later if I need to.


Thanks you very much for the help!


All times are GMT -4. The time now is 08:38 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.