Importing Plain Text Files PT3 & PTO

[chadsdavis]

Ok...
I let the import run after using the file splitter although shortyly after starting it the program went "Not Responding"....
I went to sleep....when I woke up there was a pop up window error "A problem has caused PTO to stop working".

Needless to say this is very frustrating after spending the money to buy a product that doesn't seem to want to work.

I would appreciate any help you could provide and please keep in mind I am not very savvy with all the quick "tech talk"...I really need things explained to me as I was a 10 year old.


Thanks in Advance
Chad


PS...I am very confused how the save exact file type that was comprised of Full Tilt HH's (Text in Notepad) went so smoothly and even when splitting these Stars HH's (Text in Notepad) into 300 hands per mini file PTO doesn't seem to want to import them.

[chadsdavis]

Well I have tried again to import these HH's only this time I am going into the split mini files and importing 10-15 at a time and this seems to be working.
I'll relay if this eventually solves my problem.

[ptrack mike]

OK, I'm surprised you had trouble after using the File Splitter. No one has every had trouble using it to do exactly what you are doing.

Did it really say this exactly?

"A problem has caused PTO to stop working"

If it happens again tell me exactly what it says - all messages.

[chadsdavis]

Yes it really said that.
I am having success importing them 10 "mini files" at a time. It is a little tedious but hey it is working!!!

I really need some help with the PostgreSQL info though. See reply a couple of spots up. I don't know what to enter in order to be able to use the functions that would Cluster, Vacuum, Analyze.

Thanks

[ptrack mike]

First, have you installed PostgreSQL on your computer? Then, have you converted your PTO Access database to PostgreSQL or are you importing all the hands into the Access database?

[chadsdavis]

First, have you installed PostgreSQL on your computer? Then, have you converted your PTO Access database to PostgreSQL or are you importing all the hands into the Access database?

Yeah I'm pretty sure when I downloaded PT3 (About a month before PTO) that I had to download PostgreSQL (I have a file folder named PostgreSQL)....
As far as importing goes.... On PT3 I just hit autoimport and it does it all.
On PTO I just click on the Site (Either Stars or TIlt-Only 2 I play) and click start timer.

As far as converting goes??? I'm new to all this so I appreciate anything you could do for me but please explain things to me as if I were a 10 year old because I am severly stupid when it comes to these programs.

Thanks
Chad

[ptrack mike]

OK, I'm not 100% sure how this will work since you already loaded PT3's PostgreSQL but we'll try. On the PTO menu open the Utilities > PostgreSQL Settings... window. Are the any settings there? If not click Add, then for Port use 5432 or 5433, Server = localhost, User Name = postgres, Password is the password you set up when you installed PT3, ODBC Entry to Use = PostgreSQL Unicode, and Encoding = UNICODE. Click OK. That is step 1. Are you able to do all that?

[chadsdavis]

OK, I'm not 100% sure how this will work since you already loaded PT3's PostgreSQL but we'll try. On the PTO menu open the Utilities > PostgreSQL Settings... window. Are the any settings there? If not click Add, then for Port use 5432 or 5433, Server = localhost, User Name = postgres, Password is the password you set up when you installed PT3, ODBC Entry to Use = PostgreSQL Unicode, and Encoding = UNICODE. Click OK. That is step 1. Are you able to do all that?

I can fill in everything (Guessing on password as I really don't remember) except for the ODBC Entry to Use Field.....It has a drop down box with no options in it and it won't let me type anything.

My database seems to be working fine but it is slow looking at the features as it seems it needs to be "cleaned up".

Thoughts???

[chadsdavis]

Mike what do you think?

Chad

[ptrack mike]

For the ODBC Entry issue see here:
viewtopic.php?f=29&t=5669

Use the Compact a Poker Database Option on the Utilities menu. If the Access database is a working well then you may want to just stick with that for awhile. You can always convert it later.