Catobase 5.3.2 Now Available

jcato · 04-01-2004, 10:45 AM

EDIT: This version contains an error that will affect most everyone. I've removed it and a fixed version will be available soon. Sorry for the trouble!

------

Check the list below for all the changes.

Important Note
For existing databases, if you used the Career Exporter to import pre-sim player seasons, they will be deleted the first time you use this version. To get them back in, simply run the Career Exporter again the next time you import a season. The pre-sim seasons will then be added back into the database.

Enhancements and Fixes

Fixed error that caused program to only copy photos and logos with BMP extension regardless of what the user entered in the Options screen.
Fixed error when calculating fielding Win Shares that would cause a divide by zero error for a particularly poor defensive team.
Fixed error that prevented some years in bat_career.csv and pitch_career.csv from not importing into the database. The team field was causing many previous seasons to not get imported. Small catch, though. The career files only get imported once, even if the career CSV files are created each season. This improves the speed of the import since there is no reason to reimport the same data every season. It also means that this improvement will not happen for existing databases. To work around this, the first time you open an existing database with this version, it will delete all the career (pre-sim years) records. To get them back, create the career CSV files for the next season you import. It will only import the seasons before the first simmed season.
Fixed error that occured if a player history item was longer than 255 characters.
Improved reading of player histories. Should now get each item more realiably.
Added message box to inform user of how many All-Stars are imported.
Added a check at the beginning of the import process to prevent importing the same year twice and to prevent importing if the season isn't over.
Added better handling of Free Agents. Now, if the program cannot figure out the team, a screen will pop up allowing the user to select the correct team from a dropdown box.
Improved the HOF screen to show stats from both pre-sim years and simmed years. The totals now reflect both as well.

ZouDave · 04-01-2004, 11:02 AM

awesome! Can't wait to get home and check this out!

THANK YOU SO MUCH, CATO!

jblaze03fuel · 04-01-2004, 08:43 PM

What ever happened with CATO & OOTP6?

treedom · 04-01-2004, 09:03 PM

Right on! Thanks.

ZouDave · 04-01-2004, 09:33 PM

I'm getting an error I'm wondering if you can help me on:

During the CREATE HTML process, towards the end during the Team Summary, Chicago (A) White Sox, 1992 - Player Salaries, I get the following error:

Error 3001: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another, has occurred.

Any ideas on that one?

jcato · 04-02-2004, 09:15 AM

Some one else had the same problem and it turned out to be an apostrophe in the team name. I wasn't able to find a way around it, so team names cannot have an apostrophe. If there's no apostrophe, then I would need the files to figure it out.

The best way to fix it is to change the name in OOTP5, recreate the HTML and CSV files, and start a new database.

You could also edit the database if you have Access 2000 or higher. You would need to edit TeamName in the TeamInfo table and TeamFrom and TeamTo in the Trades table.

ZouDave · 04-02-2004, 11:11 AM

Definitely shouldn't be an apostrophe. I'm using just the major league team names as this is a historical replay. Now, there is a parantheses because it's Chicago (A), but is there a reason it would have a problem with that name this late into the creation process? It would have hit the Chicago (A) field numerous times before this step, I would think.

And as a FYI, I went back to v5.3.1 and did not have the problem. Not sure if that means anything or not.

I'll be happy to send you any files that you'll need, if you can tell me what you need. I'll be able to send them to you this evening after work.

Thanks for your support, Cato.

jcato · 04-02-2004, 11:32 AM

Don't worry about sending the files, I made a mistake. After trying to solve to apostrophe problem, I didn't change 1 line back to the way it was. So, now it will crash if a team name has a space in it.

I'll have this fixed in a bit. Sorry about this!

Scott Vibert · 04-02-2004, 12:28 PM

Thanks Jeff for all your work on this utility.

Three things I'm wondering if they'll be possible to do.

#1.) I've noticed that on occaision some free agents (especially pitchers in a DH league) will not get assigned to teams, will this version correct that? (If it doesn't I'll continue to use my work around, which is to edit the .csv files to assign the teams out prior to the import)

#2.) Sometimes you'll get a Free Agent who is released and then resigns with a different team. To my knowledge currently the program doesn't split his stats, they all go to the final team he played for. I've gotten around this by editing the ltrans.htm file to put in dummy trades in these cases, but would it be possible to have the program do this automatically? (Hopefully without actually ending up with this listed in the trades list)

#3.) Some leagues induct Managers/Owners into the Hall of Fame, would it be possible to edit the utility to allow for this to be done and for them to show up on the Hall of Fame Page?

Thanks again for all your work on the utility, it's easily my favorite OOTP add on.

ZouDave · 04-02-2004, 01:39 PM

You're the man, Cato! Thanks again for all of your support!

jcato · 04-02-2004, 01:42 PM

Fixed version is now available, see this post for details.

Scott,
1. The only FAs I've seen that didn't get assigned teams were ones who's last game was a playoff game. I adjusted for this by making a dialog that pops up to allow the user to assign a team to a FA when the program can't figure it out. If you have a case where this is not happening and the FA is still not being assigned, please enter a support ticket and attach the data files and I'll see what is happening.

2. Yeah, this has been mentioned before, but I forgot about it. Right now, it only splits stats for traded players, but I'll look into a way to do it for FAs, too.

3. I'll look into this, too.

Thanks!

Scott Vibert · 04-02-2004, 02:54 PM

Thanks Jeff... I'll have to go back and see if I've got one of those cases handy and still have unaltered data files.

04-01-2004, 09:03 PM	#4
treedom Hall Of Famer Join Date: May 2002 Location: Transylvania Posts: 2,900	Right on! Thanks. __________________ A rake and a roustabout.

04-01-2004, 09:33 PM	#5
ZouDave Major Leagues Join Date: Dec 2002 Location: Kansas City, MO Posts: 313	I'm getting an error I'm wondering if you can help me on: During the CREATE HTML process, towards the end during the Team Summary, Chicago (A) White Sox, 1992 - Player Salaries, I get the following error: Error 3001: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another, has occurred. Any ideas on that one? __________________ ZD

04-02-2004, 11:11 AM	#7
ZouDave Major Leagues Join Date: Dec 2002 Location: Kansas City, MO Posts: 313	Definitely shouldn't be an apostrophe. I'm using just the major league team names as this is a historical replay. Now, there is a parantheses because it's Chicago (A), but is there a reason it would have a problem with that name this late into the creation process? It would have hit the Chicago (A) field numerous times before this step, I would think. And as a FYI, I went back to v5.3.1 and did not have the problem. Not sure if that means anything or not. I'll be happy to send you any files that you'll need, if you can tell me what you need. I'll be able to send them to you this evening after work. Thanks for your support, Cato. __________________ ZD

04-02-2004, 01:39 PM	#10
ZouDave Major Leagues Join Date: Dec 2002 Location: Kansas City, MO Posts: 313	You're the man, Cato! Thanks again for all of your support! __________________ ZD

04-01-2004, 10:45 AM	#1
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	Catobase 5.3.2 Now Available EDIT: This version contains an error that will affect most everyone. I've removed it and a fixed version will be available soon. Sorry for the trouble! ------ Check the list below for all the changes. Important Note For existing databases, if you used the Career Exporter to import pre-sim player seasons, they will be deleted the first time you use this version. To get them back in, simply run the Career Exporter again the next time you import a season. The pre-sim seasons will then be added back into the database. Enhancements and Fixes Fixed error that caused program to only copy photos and logos with BMP extension regardless of what the user entered in the Options screen. Fixed error when calculating fielding Win Shares that would cause a divide by zero error for a particularly poor defensive team. Fixed error that prevented some years in bat_career.csv and pitch_career.csv from not importing into the database. The team field was causing many previous seasons to not get imported. Small catch, though. The career files only get imported once, even if the career CSV files are created each season. This improves the speed of the import since there is no reason to reimport the same data every season. It also means that this improvement will not happen for existing databases. To work around this, the first time you open an existing database with this version, it will delete all the career (pre-sim years) records. To get them back, create the career CSV files for the next season you import. It will only import the seasons before the first simmed season. Fixed error that occured if a player history item was longer than 255 characters. Improved reading of player histories. Should now get each item more realiably. Added message box to inform user of how many All-Stars are imported. Added a check at the beginning of the import process to prevent importing the same year twice and to prevent importing if the season isn't over. Added better handling of Free Agents. Now, if the program cannot figure out the team, a screen will pop up allowing the user to select the correct team from a dropdown box. Improved the HOF screen to show stats from both pre-sim years and simmed years. The totals now reflect both as well. Last edited by jcato; 04-02-2004 at 12:01 PM.

04-01-2004, 11:02 AM	#2
ZouDave Major Leagues Join Date: Dec 2002 Location: Kansas City, MO Posts: 313	awesome! Can't wait to get home and check this out! THANK YOU SO MUCH, CATO! __________________ ZD

04-01-2004, 08:43 PM	#3
jblaze03fuel All Star Reserve Join Date: Apr 2002 Posts: 920	What ever happened with CATO & OOTP6?

04-02-2004, 09:15 AM	#6
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	Some one else had the same problem and it turned out to be an apostrophe in the team name. I wasn't able to find a way around it, so team names cannot have an apostrophe. If there's no apostrophe, then I would need the files to figure it out. The best way to fix it is to change the name in OOTP5, recreate the HTML and CSV files, and start a new database. You could also edit the database if you have Access 2000 or higher. You would need to edit TeamName in the TeamInfo table and TeamFrom and TeamTo in the Trades table.

04-02-2004, 11:32 AM	#8
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	Don't worry about sending the files, I made a mistake. After trying to solve to apostrophe problem, I didn't change 1 line back to the way it was. So, now it will crash if a team name has a space in it. I'll have this fixed in a bit. Sorry about this!

04-02-2004, 12:28 PM	#9
Scott Vibert Hall Of Famer Join Date: Dec 2001 Location: My Computer Posts: 8,249	Thanks Jeff for all your work on this utility. Three things I'm wondering if they'll be possible to do. #1.) I've noticed that on occaision some free agents (especially pitchers in a DH league) will not get assigned to teams, will this version correct that? (If it doesn't I'll continue to use my work around, which is to edit the .csv files to assign the teams out prior to the import) #2.) Sometimes you'll get a Free Agent who is released and then resigns with a different team. To my knowledge currently the program doesn't split his stats, they all go to the final team he played for. I've gotten around this by editing the ltrans.htm file to put in dummy trades in these cases, but would it be possible to have the program do this automatically? (Hopefully without actually ending up with this listed in the trades list) #3.) Some leagues induct Managers/Owners into the Hall of Fame, would it be possible to edit the utility to allow for this to be done and for them to show up on the Hall of Fame Page? Thanks again for all your work on the utility, it's easily my favorite OOTP add on.

04-02-2004, 01:42 PM	#11
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	Fixed version is now available, see this post for details. Scott, 1. The only FAs I've seen that didn't get assigned teams were ones who's last game was a playoff game. I adjusted for this by making a dialog that pops up to allow the user to assign a team to a FA when the program can't figure it out. If you have a case where this is not happening and the FA is still not being assigned, please enter a support ticket and attach the data files and I'll see what is happening. 2. Yeah, this has been mentioned before, but I forgot about it. Right now, it only splits stats for traded players, but I'll look into a way to do it for FAs, too. 3. I'll look into this, too. Thanks!

04-02-2004, 02:54 PM	#12
Scott Vibert Hall Of Famer Join Date: Dec 2001 Location: My Computer Posts: 8,249	Thanks Jeff... I'll have to go back and see if I've got one of those cases handy and still have unaltered data files.