SQL: to convert or not to convert

[Patrick del Poker Grande]

I completely missed this whole SQL thing when I went to New Orleans for 3 months and didn't play anything online during that time. There's too much chitter chatter to try to sift through it all to get back to the start of it. Can someone fill me in with a cliff's notes version of what's going on here? I've got the latest PT (2.08.00b). Do I need anything else? Is this something for the everyday user, or do I need to be some sort of SQL computer science super user trying to pull my own queries and whatnot to be doing this?

[smartalecc5]

No man, all you do is click convert to SQL in the utilities menu. I was worried about having to run prompts and all that weird SQL parlance. Thankfully, Pokertracker looks and runs the exact same way. The only differences are that database quries run faster (aka loading hands when you clikc the "ring picture") and the database can be bigger than 2gb.

Any thing I misseD?

[TheIrishThug]

[ QUOTE ]
Autohotkey script, self made, just record the import routine and loop. There might be of been an easier way to do it?

[/ QUOTE ]

so its not a pt function that combines the seberate db's? r u just exporting and re-importing the hands to the central db?

[illunious]

[ QUOTE ]
[ QUOTE ]
Autohotkey script, self made, just record the import routine and loop. There might be of been an easier way to do it?

[/ QUOTE ]

so its not a pt function that combines the seberate db's? r u just exporting and re-importing the hands to the central db?

[/ QUOTE ]

Correct, and non-auto-import only accepts like 30 files at a time (had 1800 with overlap - both my exported HHs and backed up HHs). Could of tried adding an auto import directory, figured it might not of worked though.

[Dudd]

[ QUOTE ]
[ QUOTE ]
Well, PokerGrapher doesn't work, that's it.

[/ QUOTE ]

I converted to PostgreSQL AND got PokerGrapher to work. See this thread, 5 posts down.

[/ QUOTE ]

Sorry, but for those of us who don't know a thing about SQL and databases in general, I don't know where to look once I get past the control panel.

[sthief09]

[ QUOTE ]
Autohotkey script, self made, just record the import routine and loop. There might be of been an easier way to do it?

[/ QUOTE ]



any chance you could post how tod o this? I'm sick of having multiple databases

[Luv2DriveTT]

[ QUOTE ]
[ QUOTE ]
Autohotkey script, self made, just record the import routine and loop. There might be of been an easier way to do it?

[/ QUOTE ]



any chance you could post how tod o this? I'm sick of having multiple databases

[/ QUOTE ]

I still use multiple databases for different games, I find it easier that way. One for short, one for full, one for NL full, and now I'm adding a data mined database to each. I don't autorate (shhhh.... secret) so its really just for convince and accuracy of stats while using Poker Ace.


To merge databases, you have to export a database to a folder on your desktop, switch databases, and then import the HH into the new master database. It's that easy.

TT [img]/images/graemlins/club.gif[/img]

[illunious]

[ QUOTE ]
[ QUOTE ]
Autohotkey script, self made, just record the import routine and loop. There might be of been an easier way to do it?

[/ QUOTE ]


any chance you could post how tod o this? I'm sick of having multiple databases

[/ QUOTE ]

You'll probably be lost unless you have some experience with macros. autohotkeys

Once you get comfortable with macros, stuff like this is real easy to do.

1. Export your HHs from secondary DBs, open PT and the manual import window, run AHK recorder and start recording
2. Go through the process of importing the files, this will need to be the same mouse/keyboard actions every time (I clicked import, selected the first 8 files, deleted, added a "Sleep, 3000", selected the next 8, clicked ok when it was done importing and looped)
3. Use your recording to make a .ahk file and add the loop.

This is what my script looked like I doubt it will work for anyone else because of different screen coordinates.

<font class="small">Code:</font><hr /><pre> Loop, 198
{
WinWait, ahk_class #32770,
IfWinNotActive, ahk_class #32770, , WinActivate, ahk_class #32770,
WinWaitActive, ahk_class #32770,
Send, {ENTER}
MouseClick, left, 276, 175
Sleep, 100
WinWait, Poker Tracker (Version 2.07.00h),
IfWinNotActive, Poker Tracker (Version 2.07.00h), , WinActivate, Poker Tracker (Version 2.07.00h),
WinWaitActive, Poker Tracker (Version 2.07.00h),
MouseClick, left, 250, 284
Sleep, 100

WinWait, Select File(s) To Import,
IfWinNotActive, Select File(s) To Import, , WinActivate, Select File(s) To Import,
WinWaitActive, Select File(s) To Import,
MouseClick, left, 17, 154
Sleep, 100
Send, {RIGHT}{SHIFTDOWN}{HOME}{SHIFTUP}{DEL}
Sleep, 3000
MouseClick, left, 17, 154
Sleep, 100
Send, {RIGHT}{SHIFTDOWN}{HOME}{SHIFTUP}
MouseClick, left, 361, 205
Sleep, 100



}</pre><hr />

[sthief09]

there's no way of doing if it you didn't save your HH's?

[TheIrishThug]

pt has an export hands option, that will over u if u didn't save the hands. also, u can use the auto import in pt to work around the limit on the number of files to load at once, it will also go into sub-directories.