Cato Utility Problem with Career Stats

jupiter29 · 02-25-2004, 05:13 PM

I am having a problem with the Cato utility. I have searched the board and not been able to find a solution.

I am using OOTP 5 and am in 2005, which is approximately year 35 of my league. I want to bring all the career stats into OOTP History and then update year by year. I downloaded the History utility from www.cato.net/downloads and installed Version 4, then overwrote it with version 5.1 and then 5.3. I then downloaded the CommishJoe exporter from the Cato page and edited the batch files as necessary.

I ran the exporters on a directory containing a backup of the league, because that was the only way I seemed to be able to find the player.dat file. I seem to recall in OOTP4 that you used the online league setup and exported these files, but that doesn't seem to work now, so I may be missing something here.

When I run the exporter batch files, I get files with career stats for batting and pitching. When I open them up, I can see that there is more than one year for each player, so the data seems to be there. And when I run the history utility, the career files are processed.

However, when the whole process is finished and I got to look at the stats (the only easy way I know of is in the "Add Hall of Fame" page, but let me know if there is an easier way), only stats from 2005 are present. All the historical players from previous years are listed, whether or not they played in 2005, but they have no statistics.

Can anyone suggest any reason for this? I have tried re-downloading both the exporter and the history utility with no success. And I've set up the history utility a number of times. I can't absolutely swear that award names are exactly correct, but I have triple-checked the data directory settings. And, as I said, the files are being processed (I know because the names are in the HOF drop down), they are just not being assigned statistics.

I'm hoping I'm missing something obvious. Any help will be appreciated.

Carlton · 02-25-2004, 09:29 PM

you have to import each season starting from the 1st individually

jupiter29 · 02-26-2004, 12:33 PM

Carlton: I'm sorry, I'm not sure I understand what you are telling me. Are you saying that the History utility is incapable of importing the career files and adding earlier stats? That would be rather disappointing if it were true. More to the point, though, unless I am missing something obvious, it seems to directly contradict the readme that comes with the Cato utility. The readme says that the career_exporter can be run to add stats.

And that seems to me to make sense. The stats are all there in OOTP, and the career_exporter exported them. I can see the CSV files. It's just that when I import the stats into the History utility, it appears to load them but then just never updates the data.

Am I missing something?

Killebrew · 02-26-2004, 03:29 PM

About this issue, it seems like you are not able to successfully complete step #2:
2. With OOTP v5, create the league HTML pages. Player pages and boxscores are not necessary.

Is that correct? If so this will cause serious data problems and is the place to troubleshoot first. That is likely the reason you won't see this years stats in the HOF portion of the Cato History app. Please respond if I am misunderstanding and I can look at a later step that might be causing problems.

About your expectations of the career stats importer - I think you may be dissapointed in what this will generate in Cato History. I don't think it is used often, but the career stats import should work, it just will not provide you with all the breakdowns in Cato History. I believe all it does is provide the pre-cato year stats on the player pages. I'm not sure if it even does past team stats.

A.J. Holz · 02-26-2004, 04:26 PM

For an example of how pre-sim ("career") stats look in the Cato output, go to:

http://www.fibb.net/Cato/index.html

Years 2003 - 2005 are simmed, but the player pages have pre-2003 stats on them.

If you're not getting this result from your Cato output, something's wrong. My first suggestion would be to download the csv exporter from Cato's site and use that one, not the one from CommishJoe's site. CommishJoe keeps his exporter updated for certain BOSI features and some of the new data is not handled gracefully by the Cato utility. I don't recall it affecting career stats in particular, but it would be a place to start.

jupiter29 · 02-26-2004, 04:49 PM

Killebrew,

You are correct, I have no successfully completed step two. I did try to create the league HTML pages (through Online League Setup, or something similar to that), and they created just fine. But when I went to run the exporter on this folder, it was not able to find PLAYERS.DAT ... Since these are HTML pages, the closest I had was PLAYERS.HTML.

I searched my computer and found that PLAYERS.DAT was being created everytime I backed up the league, so I assumed (possibly incorrectly) that the exporter was meant to be run off of a backup of the league.

Could you walk me though the steps necessary to create the HTML files and the PLAYER.DAT file? Any help would be appreciated.

With regard to the career stats, I understand that not everything will come across. It is the current stats I am most interested in. I would like to have career stats for career leaderboards, comparisons of current HOFers and things of that sort, and I am hoping the utility will bring in enough information to make that possible.

jupiter29 · 02-26-2004, 04:54 PM

A.J., thank you for the link. It was quite helpful. These stats are definitely not coming through, and I am hoping Killebrew can help me figure out why. However from the looks of these, the career exporter may indeed not give me the information I am looking for. I see that the player stats include career stats, but I was really hoping that the career leaderboards and the ink tests and HOF Standards would as well, but that doesn't seem to be the case.

I guess I could do it year by year if I really had to. That's disappointing, though.

In any event, thank you for your help.

Killebrew · 02-26-2004, 07:13 PM

Quote:

Originally posted by jupiter29
Killebrew,

You are correct, I have no successfully completed step two. I did try to create the league HTML pages (through Online League Setup, or something similar to that), and they created just fine. But when I went to run the exporter on this folder, it was not able to find PLAYERS.DAT ... Since these are HTML pages, the closest I had was PLAYERS.HTML.

I searched my computer and found that PLAYERS.DAT was being created everytime I backed up the league, so I assumed (possibly incorrectly) that the exporter was meant to be run off of a backup of the league.

Could you walk me though the steps necessary to create the HTML files and the PLAYER.DAT file? Any help would be appreciated.

The html files that Cato History requires are output from the game itself. I am at work so I forget the exact menu names (someone please correct me if I am geting this wrong), but here are the steps:

1. Open OOTP and load the league that you want to use Cato History with. Important: This league should be at the end of the season you want to import into Cato History. That means the 'proceed to next year' button is there. If you have not saved a year end OOTP league file I'm afraid you can't use Cato History for that season

. It's a good idea top back up a league every season at the year end anyway, but the Cato History add-on requires this.

2. If all was okay in step 1 (hope so) then choose the "OPTIONS"--> ONLINE LEAGUE OPTIONS" menu (this is where having the game in front of me would help

) which gives you the chance to output the games stats in an html format like this. You need to specify where you want to save these html pages. I'd suggest creating a directory on your C:\ drive called "ootphtml" (without the quotes), then type that path (C:\ootphtml) in the games html output form. If the directory soes not exist I don't think the game creates it so make sure of your spelling and accuracy of the path. Note that you do not have to output the player pages for Cato History so it should not take too long for the game to generate these html pages.

3. Then continue on with step 3 of the Cato History intsructions.

Remember that cato History step #6 will require you to type in the ootp html path exactly as you specified. In the above example that I used it was C:\ootphtml.

UPDATE: The way you get to the OOTP Master Html Report within the game:
LEAGUE --> ONLINE LEAGUE SETUP --> MASTER HTML REPORT

jupiter29 · 02-27-2004, 10:40 AM

Okay, I think I am getting closer. I have saved the league at the end of each season, and I can go back and create the HTML pages. And I know how to point the history utility to those.

But, I believe, these html files are not where the exporter pulls it's data from. Where do I use the exporter? On the directory that I saved the league to? That's what I have been doing and it seems to work fine.

But the career stats are still not coming across completely. I created the HTML pages from Cato from my previous attempt and some career stats are there and some are not. So something went wrong. In any event though, the career stats are not really coming across in the way I am hoping for, so I may have to go back and do it year by year anyway. I just want to make sure I have the steps right.

My understanding now is that I create the HTML pages into one folder, run the exporter on the saved league folder (NOT the HTML) folder and then point Cato to both of these folders separately. Does that sound right to you?

Killebrew · 02-27-2004, 11:48 AM

Quote:

Originally posted by jupiter29
But, I believe, these html files are not where the exporter pulls it's data from. Where do I use the exporter? On the directory that I saved the league to? That's what I have been doing and it seems to work fine.

Yes - you are correct here. The path you type in the CommishJoe Exporter batch (*.BAT) files should point to the OOTP league directory of the year that you are importing into Cato's OOTP History. If there are career stats from years before that you want to import at this time then run the CommishJoe career stats export batch file at the point the Cato OOTP History instructions suggest.

Quote:

Originally posted by jupiter29
But the career stats are still not coming across completely. I created the HTML pages from Cato from my previous attempt and some career stats are there and some are not. So something went wrong. In any event though, the career stats are not really coming across in the way I am hoping for, so I may have to go back and do it year by year anyway. I just want to make sure I have the steps right.

I don't believe you can get the exact effect you want without doing this import year by year

. The reason is that lots of the Cato OOTP History info the app requires is not saved by the game after you proceed to the next year. A.J. Holz is right on with his link example of how these 'career stats' years look within the Cato History pages - there does not seem to be much mention of the previous years except on the player pages - see 1999 - 2002 on this page:
http://www.fibb.net/Cato/players/d/drewjd612.html

Quote:

Originally posted by jupiter29
My understanding now is that I create the HTML pages into one folder, run the exporter on the saved league folder (NOT the HTML) folder and then point Cato to both of these folders separately. Does that sound right to you?

That is absolutely right. In the options menu of Cato History you have 2 separate paths to input that guide the Cato app to look for the games html in one directory and the CommishJoe exporter (CSV files) files in another. You could put all these files in the same directory of course but for safeties sake I think it's good to separate them. When importing several years in one evening it is easy to forget whether you ran the exporter yet or not

.

Note: My explanations here are a little long winded in an effort to be very clear about each step, but by doing so I make some of the processes seem more complex than they really are. Just keep that in mind, it's not as complex as it might seem at first. Also note: Cato's readme instructions trump anything we write here - they are already thorough, but sometimes when you're stuck you need a few more of the details to continue.

jupiter29 · 02-27-2004, 01:34 PM

Killebrew (and everyone else), thanks for your help. I think I am ready to proceed on my own, with the Cato readme if need be. I still haven't figured out exactly what went wrong with my previous attempt at the career exporter (some came across, some did not), but maybe it had to do with the HTML files not being there. In any event, I think I will go the year by year route so that should not be a problem.

Somewhere along the line, I just had it in my head that the exporter ran off of the HTML output, and that wasn't working. I should have just regrouped and started fresh then, it would have been easier.

The really embarrassing thing is that I ran the utility with OOTP4 a few times. It's been awhile, but I must have faced and solved this same problem back then. Without asking for help. I'm getting dumber.

crackpott · 03-24-2004, 02:09 AM

...I solved my last problem. This one won't go away. I've read over the whole thread, and yes, I exported everything properly, the CSV files all have the player history and such. And I know I won't get cato stats, but it's still nice to have player history for the past years for career numbers. For some reason, it's just not coming out in the stats. Most players will only have 2009 and 2010 in their stats listed, others will have random years it seems dating back to the beginning. I have no idea what's causing this.

crackpott · 03-24-2004, 03:02 AM

for reference to what I mean, i posted a few player html files.

http://www.fbbl.net/abreubobby572.html
http://www.fbbl.net/andersryan166.html

Operation Shutdown · 03-24-2004, 03:17 PM

I've been getting the same problem as crackpott. It seems that Cato will import any stats prior to years that you have actually simmed, but won't import any career stats of OOTP simmed games.

crackpott · 03-24-2004, 03:37 PM

...at least I'm not alone.

jcato · 03-24-2004, 05:01 PM

Okay, a couple of things here.

First, the current version (5.3.1) seems to be chocking on alot of the entries in the bat_career.csv and pitch_career.csv files. The problem is the Teams field at the end of the line. I've updated the code and it seems to be doing a better job of getting the data now.

Second, the HOF screen doesn't show pre-sim stats, it only shows stats from simmed years. The player pages are the only place that shows the pre-sim seasons. I have changed this in the next version and the HOF screen will show both pre-sim and simmed seasons together. The career total will also include all seasons.

The catch to this is that if the career stats exist in the database, the import process skips the career files. To get around this, the first time an existing database is opened with the new version, the career (pre-sim seasons) stats will be deleted. The next season you import, you will need to run the career Exporter program to make the career files. It will then import the pre-sim seasons up to the first simmed season.

crackpott · 03-25-2004, 01:51 AM

Quote:

Originally posted by jcato
Okay, a couple of things here.

First, the current version (5.3.1) seems to be chocking on alot of the entries in the bat_career.csv and pitch_career.csv files. The problem is the Teams field at the end of the line. I've updated the code and it seems to be doing a better job of getting the data now.

Second, the HOF screen doesn't show pre-sim stats, it only shows stats from simmed years. The player pages are the only place that shows the pre-sim seasons. I have changed this in the next version and the HOF screen will show both pre-sim and simmed seasons together. The career total will also include all seasons.

The catch to this is that if the career stats exist in the database, the import process skips the career files. To get around this, the first time an existing database is opened with the new version, the career (pre-sim seasons) stats will be deleted. The next season you import, you will need to run the career Exporter program to make the career files. It will then import the pre-sim seasons up to the first simmed season.

...

I appreciate the help, Jeff, but can you dumb it down for me a little?

Perhaps a step by step list of what I need to do to fix the problem.

jcato · 03-25-2004, 09:27 AM

Okay, when you imported the 2011 season, the program tried to read in the career CSV files. For Ryan Anderson, it could only read seasons 2005, 2009, and 2010. His other season are probably in the CSV file, but my program was unable to properly add them to the database. This should be improved in the next version.

Since this is the first season you are using CatoBase, just wait for the next version, upgrade, and start with a new database. You should then have those missing years in the database.

02-25-2004, 05:13 PM	#1
jupiter29 Bat Boy Join Date: Feb 2004 Posts: 12	Cato Utility Problem with Career Stats I am having a problem with the Cato utility. I have searched the board and not been able to find a solution. I am using OOTP 5 and am in 2005, which is approximately year 35 of my league. I want to bring all the career stats into OOTP History and then update year by year. I downloaded the History utility from www.cato.net/downloads and installed Version 4, then overwrote it with version 5.1 and then 5.3. I then downloaded the CommishJoe exporter from the Cato page and edited the batch files as necessary. I ran the exporters on a directory containing a backup of the league, because that was the only way I seemed to be able to find the player.dat file. I seem to recall in OOTP4 that you used the online league setup and exported these files, but that doesn't seem to work now, so I may be missing something here. When I run the exporter batch files, I get files with career stats for batting and pitching. When I open them up, I can see that there is more than one year for each player, so the data seems to be there. And when I run the history utility, the career files are processed. However, when the whole process is finished and I got to look at the stats (the only easy way I know of is in the "Add Hall of Fame" page, but let me know if there is an easier way), only stats from 2005 are present. All the historical players from previous years are listed, whether or not they played in 2005, but they have no statistics. Can anyone suggest any reason for this? I have tried re-downloading both the exporter and the history utility with no success. And I've set up the history utility a number of times. I can't absolutely swear that award names are exactly correct, but I have triple-checked the data directory settings. And, as I said, the files are being processed (I know because the names are in the HOF drop down), they are just not being assigned statistics. I'm hoping I'm missing something obvious. Any help will be appreciated.

02-26-2004, 04:26 PM	#5
A.J. Holz All Star Reserve Join Date: Apr 2002 Location: Atlanta, GA Posts: 650	For an example of how pre-sim ("career") stats look in the Cato output, go to: http://www.fibb.net/Cato/index.html Years 2003 - 2005 are simmed, but the player pages have pre-2003 stats on them. If you're not getting this result from your Cato output, something's wrong. My first suggestion would be to download the csv exporter from Cato's site and use that one, not the one from CommishJoe's site. CommishJoe keeps his exporter updated for certain BOSI features and some of the new data is not handled gracefully by the Cato utility. I don't recall it affecting career stats in particular, but it would be a place to start. __________________ NABA - Tijuana Toros / Commish ORB - Oakland Athletics (former owner) MBBA - Seattle Storm JOBL - Grand Forks Varmints (former owner) FIBB - Chicago Fire TMBU - Tulsa Tomcats (former owner) ACL - Oakland A's (former owner) ACB - Rockville Superbas

03-24-2004, 02:09 AM	#12
crackpott Hall Of Famer Join Date: Dec 2001 Location: Toronto Posts: 2,961	...I solved my last problem. This one won't go away. I've read over the whole thread, and yes, I exported everything properly, the CSV files all have the player history and such. And I know I won't get cato stats, but it's still nice to have player history for the past years for career numbers. For some reason, it's just not coming out in the stats. Most players will only have 2009 and 2010 in their stats listed, others will have random years it seems dating back to the beginning. I have no idea what's causing this. __________________ Abandoned Planet - Check it out. The photos don't suck anymore.

03-24-2004, 03:02 AM	#13
crackpott Hall Of Famer Join Date: Dec 2001 Location: Toronto Posts: 2,961	for reference to what I mean, i posted a few player html files. http://www.fbbl.net/abreubobby572.html http://www.fbbl.net/andersryan166.html __________________ Abandoned Planet - Check it out. The photos don't suck anymore.

03-24-2004, 03:17 PM	#14
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	I've been getting the same problem as crackpott. It seems that Cato will import any stats prior to years that you have actually simmed, but won't import any career stats of OOTP simmed games. __________________ "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."

02-25-2004, 09:29 PM	#2
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	you have to import each season starting from the 1st individually __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!" Last edited by Carlton; 02-25-2004 at 11:26 PM.

02-26-2004, 12:33 PM	#3
jupiter29 Bat Boy Join Date: Feb 2004 Posts: 12	Carlton: I'm sorry, I'm not sure I understand what you are telling me. Are you saying that the History utility is incapable of importing the career files and adding earlier stats? That would be rather disappointing if it were true. More to the point, though, unless I am missing something obvious, it seems to directly contradict the readme that comes with the Cato utility. The readme says that the career_exporter can be run to add stats. And that seems to me to make sense. The stats are all there in OOTP, and the career_exporter exported them. I can see the CSV files. It's just that when I import the stats into the History utility, it appears to load them but then just never updates the data. Am I missing something?

02-26-2004, 03:29 PM	#4
Killebrew Hall Of Famer Join Date: Dec 2001 Posts: 3,326	About this issue, it seems like you are not able to successfully complete step #2: 2. With OOTP v5, create the league HTML pages. Player pages and boxscores are not necessary. Is that correct? If so this will cause serious data problems and is the place to troubleshoot first. That is likely the reason you won't see this years stats in the HOF portion of the Cato History app. Please respond if I am misunderstanding and I can look at a later step that might be causing problems. About your expectations of the career stats importer - I think you may be dissapointed in what this will generate in Cato History. I don't think it is used often, but the career stats import should work, it just will not provide you with all the breakdowns in Cato History. I believe all it does is provide the pre-cato year stats on the player pages. I'm not sure if it even does past team stats.

02-26-2004, 04:49 PM	#6
jupiter29 Bat Boy Join Date: Feb 2004 Posts: 12	Killebrew, You are correct, I have no successfully completed step two. I did try to create the league HTML pages (through Online League Setup, or something similar to that), and they created just fine. But when I went to run the exporter on this folder, it was not able to find PLAYERS.DAT ... Since these are HTML pages, the closest I had was PLAYERS.HTML. I searched my computer and found that PLAYERS.DAT was being created everytime I backed up the league, so I assumed (possibly incorrectly) that the exporter was meant to be run off of a backup of the league. Could you walk me though the steps necessary to create the HTML files and the PLAYER.DAT file? Any help would be appreciated. With regard to the career stats, I understand that not everything will come across. It is the current stats I am most interested in. I would like to have career stats for career leaderboards, comparisons of current HOFers and things of that sort, and I am hoping the utility will bring in enough information to make that possible.

02-26-2004, 04:54 PM	#7
jupiter29 Bat Boy Join Date: Feb 2004 Posts: 12	A.J., thank you for the link. It was quite helpful. These stats are definitely not coming through, and I am hoping Killebrew can help me figure out why. However from the looks of these, the career exporter may indeed not give me the information I am looking for. I see that the player stats include career stats, but I was really hoping that the career leaderboards and the ink tests and HOF Standards would as well, but that doesn't seem to be the case. I guess I could do it year by year if I really had to. That's disappointing, though. In any event, thank you for your help.

02-27-2004, 10:40 AM	#9
jupiter29 Bat Boy Join Date: Feb 2004 Posts: 12	Okay, I think I am getting closer. I have saved the league at the end of each season, and I can go back and create the HTML pages. And I know how to point the history utility to those. But, I believe, these html files are not where the exporter pulls it's data from. Where do I use the exporter? On the directory that I saved the league to? That's what I have been doing and it seems to work fine. But the career stats are still not coming across completely. I created the HTML pages from Cato from my previous attempt and some career stats are there and some are not. So something went wrong. In any event though, the career stats are not really coming across in the way I am hoping for, so I may have to go back and do it year by year anyway. I just want to make sure I have the steps right. My understanding now is that I create the HTML pages into one folder, run the exporter on the saved league folder (NOT the HTML) folder and then point Cato to both of these folders separately. Does that sound right to you?

02-27-2004, 01:34 PM	#11
jupiter29 Bat Boy Join Date: Feb 2004 Posts: 12	Killebrew (and everyone else), thanks for your help. I think I am ready to proceed on my own, with the Cato readme if need be. I still haven't figured out exactly what went wrong with my previous attempt at the career exporter (some came across, some did not), but maybe it had to do with the HTML files not being there. In any event, I think I will go the year by year route so that should not be a problem. Somewhere along the line, I just had it in my head that the exporter ran off of the HTML output, and that wasn't working. I should have just regrouped and started fresh then, it would have been easier. The really embarrassing thing is that I ran the utility with OOTP4 a few times. It's been awhile, but I must have faced and solved this same problem back then. Without asking for help. I'm getting dumber.

03-24-2004, 03:37 PM	#15
crackpott Hall Of Famer Join Date: Dec 2001 Location: Toronto Posts: 2,961	...at least I'm not alone. __________________ Abandoned Planet - Check it out. The photos don't suck anymore.

03-24-2004, 05:01 PM	#16
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	Okay, a couple of things here. First, the current version (5.3.1) seems to be chocking on alot of the entries in the bat_career.csv and pitch_career.csv files. The problem is the Teams field at the end of the line. I've updated the code and it seems to be doing a better job of getting the data now. Second, the HOF screen doesn't show pre-sim stats, it only shows stats from simmed years. The player pages are the only place that shows the pre-sim seasons. I have changed this in the next version and the HOF screen will show both pre-sim and simmed seasons together. The career total will also include all seasons. The catch to this is that if the career stats exist in the database, the import process skips the career files. To get around this, the first time an existing database is opened with the new version, the career (pre-sim seasons) stats will be deleted. The next season you import, you will need to run the career Exporter program to make the career files. It will then import the pre-sim seasons up to the first simmed season.

03-25-2004, 09:27 AM	#18
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	Okay, when you imported the 2011 season, the program tried to read in the career CSV files. For Ryan Anderson, it could only read seasons 2005, 2009, and 2010. His other season are probably in the CSV file, but my program was unable to properly add them to the database. This should be improved in the next version. Since this is the first season you are using CatoBase, just wait for the next version, upgrade, and start with a new database. You should then have those missing years in the database.