CatoBase 6.1.2 Update

jcato · 07-05-2004, 11:06 AM

Okay, let's try this one out. I think this will fix most of the problems everyone's been having. As always, you can get it here.

- Fixed error that would make the team field blank and crash the program.
- CatoBase should now work independent of the user's date format.
- Improved the importing of transactions from the ltrans.txt (or ltrans.html) file.

Cowboys3356 · 07-05-2004, 11:25 AM

If we already have a the 6.1.1 version running do we need to redo all of our saved seasons or will this update work with previous saved seasons?

PotatoPeeler · 07-05-2004, 12:14 PM

I looked around and could not find any instructions for CatoBase. Could someone point me in the right direction?

Thanks.

Edit: Nevermind... I found it.

The next question is... I have a league that is 10 years old. Is there anything special I need to do to get all the years imported?

jcato · 07-05-2004, 09:19 PM

Quote:

Originally Posted by Cowboys3356

If we already have a the 6.1.1 version running do we need to redo all of our saved seasons or will this update work with previous saved seasons?

No, you do not have to redo the seasons. The fixes in this update primarily affect the importing of the stats.

PP, to get all the pages, you have to run CatoBase at the end of each season. If you start using it in the middle of a career league, the previous simmed seasons will only show on the player pages as 'pre-sim' years.

kq76 · 07-05-2004, 09:46 PM

If it's not too difficult, could you make it so that it will work with leagues with years before 1800? Thanks.

chrisj · 07-05-2004, 10:00 PM

hm... I'm getting a weird error.

While importing pitch_career.csv, it tells me: "Type Mismatch". I click on "OK", and then I get a message saying: "The following team abbreviations are new from last year. However, they exist for earlier years. This is probably not correct. You can change them now or not."

It then lists every team abbreviation... but none have actually changed from one year to another. I click on okay, and it appears to go on fine...

Until I get to the "Ratings Data" section where another error occurs. Run-time error '-214767259 (80004005)':

The changes you requested to the table were not successful becasue 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"

PotatoPeeler · 07-05-2004, 10:30 PM

Quote:

Originally Posted by jcato

PP, to get all the pages, you have to run CatoBase at the end of each season. If you start using it in the middle of a career league, the previous simmed seasons will only show on the player pages as 'pre-sim' years.

Okay. Thanks for the help!

kq76 · 07-05-2004, 10:44 PM

Quote:

Originally Posted by chrisj

It then lists every team abbreviation... but none have actually changed from one year to another.

I have no idea if this is relevant, but what about Sandspit / Dawson City?

chrisj · 07-05-2004, 10:49 PM

Quote:

Originally Posted by kq76

I have no idea if this is relevant, but what about Sandspit / Dawson City?

I thought it might have had something to do with that, so I checked and double checked... but the move doesn't appear to have had anything to do with it.

Still trying different things out... but nothing has seemed to work out yet. I think I might have to wait to see if Cato has any suggestions.

Edit: Support ticket has been sent.

Brian Corleone · 07-06-2004, 02:37 AM

I noticed a new feature (I think) under the options for CatoBase 6.1.2. Under the Output tab, there is an option called "Salary Only". It is unchecked by default. What does this option do when checked?

gmo · 07-06-2004, 02:42 AM

Quote:

Originally Posted by Brian Corleone

I noticed a new feature (I think) under the options for CatoBase 6.1.2. Under the Output tab, there is an option called "Salary Only". It is unchecked by default. What does this option do when checked?

Not sure since I didn't use the option, but I believe when unchecked it displays in the resulting player HTML pages the ratings and salary. Thus when checked salary would be shown but not ratings.

Ben E Lou · 07-06-2004, 05:43 AM

Quote:

Originally Posted by chrisj

hm... I'm getting a weird error.

While importing pitch_career.csv, it tells me: "Type Mismatch". I click on "OK", and then I get a message saying: "The following team abbreviations are new from last year. However, they exist for earlier years. This is probably not correct. You can change them now or not."

It then lists every team abbreviation... but none have actually changed from one year to another. I click on okay, and it appears to go on fine...

Until I get to the "Ratings Data" section where another error occurs. Run-time error '-214767259 (80004005)':

The changes you requested to the table were not successful becasue 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"

That is *exactly* what has been happening to me. It happened with 6.1.1 as well.

Cowboys3356 · 07-06-2004, 10:39 AM

I was having a couple of problems and needed some help with Catobase. I am running the newest version 6.1.2

While importing stats I got an error saying that a Batting.field could not be zero. I checked the player it referenced and the guy did have a .000 batting average for the season. This happened while creating player batting fields I believe. Now the fact the player in question had a .000 batting avg for the season didn't cause the crash did it? There are lots of players especially pitchers with that kind of batting avg. Also when I tried to restart and reimport the stats it crashed saying that season was already in the Database which of course it isn't.

Hope you guys have some ideas!

Doc

Cowboys3356 · 07-06-2004, 10:51 AM

Ok I figured out how to get past the "Season already in database error" and when I reran the database it worked without any errors. Not sure why it worked the second time but I am not complaining!

gmo · 07-07-2004, 07:02 PM

Quote:

Originally Posted by jcato

- Improved the importing of transactions from the ltrans.txt (or ltrans.html) file.

Just rebuilt a database with the update. Quickly noticed a player who had been waived after the last regular season was now listed with the team he played for all season rather than the one that picked him up as had been the case before. Unfortunately it still isn't 100% perfect, but I'm very impressed with how much improvement has been made over the last handful of updates to placing players with the correct teams for the correct periods of time. This seems like a very difficult thing to program, and I just want to give more kudos to Jeff for doing as well with this as he has and continuing to strive to make it better.

07-05-2004, 11:06 AM	#1
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	CatoBase 6.1.2 Update Okay, let's try this one out. I think this will fix most of the problems everyone's been having. As always, you can get it here. - Fixed error that would make the team field blank and crash the program. - CatoBase should now work independent of the user's date format. - Improved the importing of transactions from the ltrans.txt (or ltrans.html) file.

07-05-2004, 12:14 PM	#3
PotatoPeeler Hall Of Famer Join Date: Aug 2002 Location: Rapid City, SD Posts: 3,639	I looked around and could not find any instructions for CatoBase. Could someone point me in the right direction? Thanks. Edit: Nevermind... I found it. The next question is... I have a league that is 10 years old. Is there anything special I need to do to get all the years imported? __________________ 培傑西 I have never taken a lesson on how to talk on TV in my life. - Tim McCarver Guns have only two enemies; rust and liberals. The world is a comedy to those that think; a tragedy to those that feel. Last edited by PotatoPeeler; 07-05-2004 at 12:19 PM.

07-05-2004, 09:46 PM	#5
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	If it's not too difficult, could you make it so that it will work with leagues with years before 1800? Thanks. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080)

07-05-2004, 10:00 PM	#6
chrisj All Star Reserve Join Date: Feb 2002 Location: Edmonton, Alberta (but still wishing I was in Halifax, Nova Scotia, Canada) Posts: 834	hm... I'm getting a weird error. While importing pitch_career.csv, it tells me: "Type Mismatch". I click on "OK", and then I get a message saying: "The following team abbreviations are new from last year. However, they exist for earlier years. This is probably not correct. You can change them now or not." It then lists every team abbreviation... but none have actually changed from one year to another. I click on okay, and it appears to go on fine... Until I get to the "Ratings Data" section where another error occurs. Run-time error '-214767259 (80004005)': The changes you requested to the table were not successful becasue 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" __________________ Canadian Baseball League -- Commissioner -- Calgary GM Last edited by chrisj; 07-05-2004 at 10:09 PM.

07-05-2004, 11:25 AM	#2
Cowboys3356 All Star Starter Join Date: Sep 2003 Posts: 1,571	If we already have a the 6.1.1 version running do we need to redo all of our saved seasons or will this update work with previous saved seasons?

07-06-2004, 02:37 AM	#10
Brian Corleone Bat Boy Join Date: May 2004 Posts: 16	I noticed a new feature (I think) under the options for CatoBase 6.1.2. Under the Output tab, there is an option called "Salary Only". It is unchecked by default. What does this option do when checked?

07-06-2004, 10:39 AM	#13
Cowboys3356 All Star Starter Join Date: Sep 2003 Posts: 1,571	I was having a couple of problems and needed some help with Catobase. I am running the newest version 6.1.2 While importing stats I got an error saying that a Batting.field could not be zero. I checked the player it referenced and the guy did have a .000 batting average for the season. This happened while creating player batting fields I believe. Now the fact the player in question had a .000 batting avg for the season didn't cause the crash did it? There are lots of players especially pitchers with that kind of batting avg. Also when I tried to restart and reimport the stats it crashed saying that season was already in the Database which of course it isn't. Hope you guys have some ideas! Doc

07-06-2004, 10:51 AM	#14
Cowboys3356 All Star Starter Join Date: Sep 2003 Posts: 1,571	Ok I figured out how to get past the "Season already in database error" and when I reran the database it worked without any errors. Not sure why it worked the second time but I am not complaining!