Cato Recognizing Wrong Year - Page 2

kbensel · 04-05-2004, 05:57 PM

Operation Shutdown said: "Finally figured this little bugger out. For some odd reason, the exporter really screwed up the gamenr column when it exported the schedule_game.csv file. No idea how or why that happened, maybe it had something to do with a manual schedule being created. Basically, there were a bunch of duplicate entries in there, and it seemed to start off with the number of the last previous regular season game. I would've found it sooner if I had thought more about what the actual message error was saying, I could have just went into the games table and found what the primary key was in that table (which is a combo of the date and gamenr combined) and then figured out from that what was causing the problem. Anyway, to fix it, I just opened the csv file in Excel and filled down 1, 2, etc until the last regular season game. I figured the somewhat weird way it numbered the playoffs and stuck that in as well."

I'm getting the same error that Operation Shutdown got (shown below), but I'm not sure it's for the same reason.

"Run-time error '-2147467259 (80004005)'

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

I am using a fresh install of History Website Creator v.5.3.3. When I click "Import Stats" it gets all the way through "Updating Fields..." and then chokes on "Copying... Pre-Sim Data." The league is actually in its 8th season but this is the first time we're using Cato's program.

I have looked at the schedule_game.csv file and it looks normal, with no duplicate entries. The All-Star game shows up as game # 5000, but other than that the games are numbered sequentially through the end of the season, and then you get the strange (but systematic) numbering of games for the postseason.

Any ideas?

Thanks,
Kevin

ZouDave · 04-05-2004, 06:25 PM

Hey kbensel,

Did you run the career_exporter as well? If this is the first time using Cato but your league has other stats, it may want to look for the files that hold all the previous stats (it will consider them non-simmed or pre-simmed stats). Not sure this is the case, but hoping maybe I'm right.

See ya

ZD

kbensel · 04-05-2004, 07:30 PM

ZouDave,

Yes, I did. I ran all 3 of the batch files (exporter, career_exporter, and park). And I saw the status bar say that it was processing bat_career.csv and pit_career.csv and it finished those fine.

I'm not quite sure what "copying... pre-sim data" means. What exactly is it copying? And where is it copying it to? I assume to the database, but I don't really know.

Maybe knowing the answer to those questions would help solve this problem.

Thanks for your input.

jcato · 04-06-2004, 10:42 AM

Sounds like it doesn't like something in the either the bat_career.csv or pitch_career.csv. When it says "Importing Data...bat_career" it is reading the CSV file and storing the data in a temporary table. Later, when it says "Copying Data..." it is moving the data over to the permanent table. It must be trying to put something in that table that that table doesn't like. (Wow, can you actually use 'that' in 3 out of 4 words?!?")

Fill out a support ticket at www.equalnicity.com and attach your data files (the CSV files and the 3 HTML files). I should be able to figure out what's happening.

Operation Shutdown · 04-06-2004, 07:17 PM

A quick thing that you can check, and what I finally did to figure out my problem, is to open the database in Access, if you have it, and then go to the pre-sim data table (it may not be called that in the database but it is likely some sort of career stats table). Look in the design view and find out which column of data is the primary key/index, you'll know this as there will be a picture of a little key next to it. Then you can either open up whatever csv file it was in Excel or search through that table in Access to find out where the duplicate value is at. From that, you may be able to figure out why the value is a duplicate, then again, you might not.

04-05-2004, 06:25 PM	#22
ZouDave Major Leagues Join Date: Dec 2002 Location: Kansas City, MO Posts: 313	Hey kbensel, Did you run the career_exporter as well? If this is the first time using Cato but your league has other stats, it may want to look for the files that hold all the previous stats (it will consider them non-simmed or pre-simmed stats). Not sure this is the case, but hoping maybe I'm right. See ya ZD __________________ ZD

04-06-2004, 07:17 PM	#25
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	A quick thing that you can check, and what I finally did to figure out my problem, is to open the database in Access, if you have it, and then go to the pre-sim data table (it may not be called that in the database but it is likely some sort of career stats table). Look in the design view and find out which column of data is the primary key/index, you'll know this as there will be a picture of a little key next to it. Then you can either open up whatever csv file it was in Excel or search through that table in Access to find out where the duplicate value is at. From that, you may be able to figure out why the value is a duplicate, then again, you might not. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

04-05-2004, 05:57 PM	#21
kbensel Minors (Single A) Join Date: Jul 2002 Posts: 68	Operation Shutdown said: "Finally figured this little bugger out. For some odd reason, the exporter really screwed up the gamenr column when it exported the schedule_game.csv file. No idea how or why that happened, maybe it had something to do with a manual schedule being created. Basically, there were a bunch of duplicate entries in there, and it seemed to start off with the number of the last previous regular season game. I would've found it sooner if I had thought more about what the actual message error was saying, I could have just went into the games table and found what the primary key was in that table (which is a combo of the date and gamenr combined) and then figured out from that what was causing the problem. Anyway, to fix it, I just opened the csv file in Excel and filled down 1, 2, etc until the last regular season game. I figured the somewhat weird way it numbered the playoffs and stuck that in as well." I'm getting the same error that Operation Shutdown got (shown below), but I'm not sure it's for the same reason. "Run-time error '-2147467259 (80004005)' The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again." I am using a fresh install of History Website Creator v.5.3.3. When I click "Import Stats" it gets all the way through "Updating Fields..." and then chokes on "Copying... Pre-Sim Data." The league is actually in its 8th season but this is the first time we're using Cato's program. I have looked at the schedule_game.csv file and it looks normal, with no duplicate entries. The All-Star game shows up as game # 5000, but other than that the games are numbered sequentially through the end of the season, and then you get the strange (but systematic) numbering of games for the postseason. Any ideas? Thanks, Kevin

04-05-2004, 07:30 PM	#23
kbensel Minors (Single A) Join Date: Jul 2002 Posts: 68	ZouDave, Yes, I did. I ran all 3 of the batch files (exporter, career_exporter, and park). And I saw the status bar say that it was processing bat_career.csv and pit_career.csv and it finished those fine. I'm not quite sure what "copying... pre-sim data" means. What exactly is it copying? And where is it copying it to? I assume to the database, but I don't really know. Maybe knowing the answer to those questions would help solve this problem. Thanks for your input.

04-06-2004, 10:42 AM	#24
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	Sounds like it doesn't like something in the either the bat_career.csv or pitch_career.csv. When it says "Importing Data...bat_career" it is reading the CSV file and storing the data in a temporary table. Later, when it says "Copying Data..." it is moving the data over to the permanent table. It must be trying to put something in that table that that table doesn't like. (Wow, can you actually use 'that' in 3 out of 4 words?!?") Fill out a support ticket at www.equalnicity.com and attach your data files (the CSV files and the 3 HTML files). I should be able to figure out what's happening.