Exporting from access to Postgre

[asantu]

This went to the wrong folder on the first try - sorry.

Pat - I am getting an error when exporting files from an access DB for importing into a Postgre DB. First 3500 hands go fine then get an error screen of "Error Updating Sessions, Error updating sessions table in function of_SessionPart2, 7 - SQLSTATE = 22003, ERROR: smallint out of range; error while executing query". I'm running 2.17.03j on a Vista 64bit machine with UAC turned off. Thanks for any help.

[ptrack pat]

When exactly do you get this error?
How are you importing the files that you exported?
How many files are you trying to import?
Is there more detail to the error message, like the actual SQL statement that shows the data it's trying to insert into this table?

[asantu]

I created the data with Export Hand Histories to Files... using 300 hands per file from an exisitng access DB. Exports without a hitch. I then use Import Hand Histories from the file menu and grab the 20 files I just created. During the second to last file import the status line of the import screen says Status: Updating session information, part two... Then spashes the error screen of the first post. The error message info seems to be

Error updating the sessions table in function of_SessionPart2.
7 - SQLSTATE = 22003
ERROR: smallint out of range;
Error while executing the query

When I try and grab the last two files indiviually the same error pops up. I have exported them again with the same results. It just lists the offending file it is trying to import. I converted PA hands to party then imported them. It has been working fine until I tried to convert to Postgre using your export function.

[ptrack pat]

Please use the online support system to create a ticket for this problem and attach one of the files that you get this error with...here is a link to the support system...
http://www.pokertracker.com/support/?cat_id=4