Cato newbie - Page 2

locust9 · 06-01-2003, 04:52 PM

ugh, yeah, I'm in about the same situation. On top of that, I noticed that the total minors roster are really producing some strange stats. Andruw jones hits .196? Maybe when he was 14, but not at 30. I don't mind journeymen minor leaguers making late career surges, there are plenty of recent examples of that, but the massive fluctuation in some of these seasons has to be seen to be believed. I saw told helton go from a 62 homer season to SEVENTEEN the next season. Ok, I traded for him, and he was on colorado, but even so, the guy was 31 when i got him, so it wasn't age. He dropped 100 points in avg, and 45 hrs? Shea isn't that much of a pitcher's park - hell - JUPITER isn't.

/loc

Killebrew · 06-01-2003, 05:15 PM

Here is one "error in line ## of a CSV file" that I was able to fix, it's a longshot but maybe it applies to some issues others are having with that error:

The CSV data is stored between the comma's and inside double quotes. If any of your data has a double quote in it then OOTP History will give you that "... line in CSV file" error. For example, a team name like the Boston "i" Dotters will cause the program to error out. Double quotes can occur easily in player nicknames in the players CSV file (like Doug "Lefty" Hodge) but I really can't think of many reasons to see them in the non player data. Unexpected comma's would also cause these kinds of errors so those are two things to look for when a OOTP History error points you to a specific line of a CSV file. So far whenever I have had that error I was able to find the problem on that line, edit it and rerun the program with no errors.

Tip: Using a more powerful text editor than Notepad makes finding a specific line in a CSV file very easy. Ultra-Edit is a great program for this and I think it has a free trial period. I'm sure there are others as well but they make CSV trouble shooting easy.

locust9 · 06-01-2003, 06:40 PM

yeah, but this 'invalid use of null' error is perplexing. I have no idea what the hell is causing it.

ARRRGH.

loc

Killebrew · 06-01-2003, 10:23 PM

Quote:

Originally posted by locust9
yeah, but this 'invalid use of null' error is perplexing. I have no idea what the hell is causing it.

ARRRGH.

loc

This is likely not helpful, but I got an Error 94 invalid use of Null when OOTP History was expecting required field information - in my case team name. For some reason the import from the OOTP5 html pages for one season skipped the city name. It was easy to find, but initially I assumed the error was much more serious and I was going through the MDB file table by table hoping to recognize an error. I'd suggest for the null error that you trouble shoot all the most obvious and simple things first. Check the options and make sure you have your league name in there (no quotes or commas!) and all your award names. May as well confirm the paths and settings too while you are there. Next go through the teams (via OOTP history) year by year and look for empty fields - that's how I solved my error 94 invalid use of null problem anyway.

locust9 · 06-02-2003, 04:36 AM

actually, it was helpful. You solved my problem.

.

It appears the problem was something as stupid as me not changing my league name in the OOTP history options to my actual leaguename (okfinally). I think it was set at okfinally.lg. Argh.

The long and short of the solution is : CHECK THE PATHS AND NAMES IN OPTIONS. Even if you are absolutely sure you did everything right, odds are you missed something. Now it's time to go process 90 years of history.

tx to everyone
loc

locust9 · 06-02-2003, 09:42 AM

well -

it ALMOST works. I have a single season here, but when i simmed the next season, i only see the next season - the career stats aren't cumulative. Any idea what I could have missed? What I can see, so far, is brilliant. I can't wait to get the thing working completely...

tx
loc

SteveBsFan · 06-18-2003, 12:24 PM

Just want to bump this to see if anyone figured out the 'line 2' problem. I am getting the same thing. Used exporter 5, started importing, and got the word wrap - line 2 error.

Thanks!

koohead · 06-18-2003, 12:28 PM

SteveB: I got the same error you got when I downloaded the exporter from CommishJoe's site. That version of the exporter is specific to BOSI. On Cato's site, there is a link for Exporter5. Make sure you are using that. That was the solution for me.

A.J. Holz · 06-18-2003, 12:42 PM

Quote:

Originally posted by koohead
SteveB: I got the same error you got when I downloaded the exporter from CommishJoe's site. That version of the exporter is specific to BOSI. On Cato's site, there is a link for Exporter5. Make sure you are using that. That was the solution for me.

You bet. The Exporter available from the BOSI site does NOT work with OOTP History 5.3.0. This is because CommishJoe made a small change to the exporter to support some new BOSI features and OOTP History 5.3.0 was not changed to recognize the new format of .CSV files.

When using the CSV Exporter, make sure you are using the one that is linked to off of the OOTP History pages, located at

http://www.jcato.net/downloads/history/exporter5.zip

SteveBsFan · 06-18-2003, 12:59 PM

Cool, seems to be working now. I got through the line 2 bug, now importing. Thanks!

SteveBsFan · 06-18-2003, 02:17 PM

I seem to have the same problem as locust now, it only generates reports for the current season, not any of the past ones. Anyone know how to import past stats?

A.J. Holz · 06-18-2003, 02:22 PM

You should be able to use the Career Exporter to accomplish this. You will probably have to start over, but look at the instructions here:

http://www.jcato.net/downloads/history/readme5.html

Go to the section called "Importing Data," it's under step 4.

SteveBsFan · 06-18-2003, 02:28 PM

Nice, thanks.. Is there an option that allows you to alter the appearance of the html files? Thanks!

SteveBsFan · 06-18-2003, 02:29 PM

nm I think I found it, with the css

SteveBsFan · 06-18-2003, 03:14 PM

another quick question, is cato the utility that creates pages like this..

http://www.aba.ootp-leagues.com/History/ABA/index.htm

or is that another utility? Thanks!

koohead · 06-18-2003, 04:07 PM

yup...that's pretty much it. Either that is an earlier version of Cato, or it may be the Wallman utility (Ryan W) that is a similar history version.
The latest Cato will have additional things such as manager pages, win shares, and various career leaderboards

A.J. Holz · 06-18-2003, 04:21 PM

Yeah, that's the Cato history page, with a cascading style sheet edited to change the colors and layout. Wallman's utility, which worked with OOTP4, made pages that looked like baseball-reference.com.

SteveBsFan · 06-18-2003, 04:24 PM

Cool, now my only problem is that I don't think the commish saved the past league info. I can't find it in the 'in game almanac', and the pages for past gold glove winners, etc is blank, so I am not sure if I can even have a history with that league. Is there any way to import history into the game itself?

Scott Vibert · 06-18-2003, 06:19 PM

Cato's utility will work even if you don't have the award winners listed. You can add the award winners to the Game files by editing the corresponding text files in teh league_news_box directory.

A.J. Holz · 06-18-2003, 06:20 PM

Not that I know of. If the Almanac isn't there, and you don't have backups of the league files (most people normally back them up at the point where the "proceed to next season" button is waiting to be pressed), then the most you'll be able to get for that league would be the current year PLUS historical statistics for each player. You wouldn't be able to import any Award winners or postseason results for any previous years.

06-18-2003, 12:28 PM	#28
koohead Hall Of Famer Join Date: Dec 2001 Location: Phoenix, AZ Posts: 3,233	SteveB: I got the same error you got when I downloaded the exporter from CommishJoe's site. That version of the exporter is specific to BOSI. On Cato's site, there is a link for Exporter5. Make sure you are using that. That was the solution for me. __________________ GM - New Jersey Bears of the NPBL;

06-18-2003, 02:22 PM	#32
A.J. Holz All Star Reserve Join Date: Apr 2002 Location: Atlanta, GA Posts: 650	You should be able to use the Career Exporter to accomplish this. You will probably have to start over, but look at the instructions here: http://www.jcato.net/downloads/history/readme5.html Go to the section called "Importing Data," it's under step 4. __________________ 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

06-18-2003, 04:07 PM	#36
koohead Hall Of Famer Join Date: Dec 2001 Location: Phoenix, AZ Posts: 3,233	yup...that's pretty much it. Either that is an earlier version of Cato, or it may be the Wallman utility (Ryan W) that is a similar history version. The latest Cato will have additional things such as manager pages, win shares, and various career leaderboards __________________ GM - New Jersey Bears of the NPBL;

06-18-2003, 04:21 PM	#37
A.J. Holz All Star Reserve Join Date: Apr 2002 Location: Atlanta, GA Posts: 650	Yeah, that's the Cato history page, with a cascading style sheet edited to change the colors and layout. Wallman's utility, which worked with OOTP4, made pages that looked like baseball-reference.com. __________________ 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

06-18-2003, 06:20 PM	#40
A.J. Holz All Star Reserve Join Date: Apr 2002 Location: Atlanta, GA Posts: 650	Not that I know of. If the Almanac isn't there, and you don't have backups of the league files (most people normally back them up at the point where the "proceed to next season" button is waiting to be pressed), then the most you'll be able to get for that league would be the current year PLUS historical statistics for each player. You wouldn't be able to import any Award winners or postseason results for any previous years. __________________ 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

06-01-2003, 04:52 PM	#21
locust9 Minors (Rookie Ball) Join Date: Mar 2002 Posts: 36	ugh, yeah, I'm in about the same situation. On top of that, I noticed that the total minors roster are really producing some strange stats. Andruw jones hits .196? Maybe when he was 14, but not at 30. I don't mind journeymen minor leaguers making late career surges, there are plenty of recent examples of that, but the massive fluctuation in some of these seasons has to be seen to be believed. I saw told helton go from a 62 homer season to SEVENTEEN the next season. Ok, I traded for him, and he was on colorado, but even so, the guy was 31 when i got him, so it wasn't age. He dropped 100 points in avg, and 45 hrs? Shea isn't that much of a pitcher's park - hell - JUPITER isn't. /loc

06-01-2003, 05:15 PM	#22
Killebrew Hall Of Famer Join Date: Dec 2001 Posts: 3,326	Here is one "error in line ## of a CSV file" that I was able to fix, it's a longshot but maybe it applies to some issues others are having with that error: The CSV data is stored between the comma's and inside double quotes. If any of your data has a double quote in it then OOTP History will give you that "... line in CSV file" error. For example, a team name like the Boston "i" Dotters will cause the program to error out. Double quotes can occur easily in player nicknames in the players CSV file (like Doug "Lefty" Hodge) but I really can't think of many reasons to see them in the non player data. Unexpected comma's would also cause these kinds of errors so those are two things to look for when a OOTP History error points you to a specific line of a CSV file. So far whenever I have had that error I was able to find the problem on that line, edit it and rerun the program with no errors. Tip: Using a more powerful text editor than Notepad makes finding a specific line in a CSV file very easy. Ultra-Edit is a great program for this and I think it has a free trial period. I'm sure there are others as well but they make CSV trouble shooting easy.

06-01-2003, 06:40 PM	#23
locust9 Minors (Rookie Ball) Join Date: Mar 2002 Posts: 36	yeah, but this 'invalid use of null' error is perplexing. I have no idea what the hell is causing it. ARRRGH. loc

06-02-2003, 04:36 AM	#25
locust9 Minors (Rookie Ball) Join Date: Mar 2002 Posts: 36	actually, it was helpful. You solved my problem. . It appears the problem was something as stupid as me not changing my league name in the OOTP history options to my actual leaguename (okfinally). I think it was set at okfinally.lg. Argh. The long and short of the solution is : CHECK THE PATHS AND NAMES IN OPTIONS. Even if you are absolutely sure you did everything right, odds are you missed something. Now it's time to go process 90 years of history. tx to everyone loc

06-02-2003, 09:42 AM	#26
locust9 Minors (Rookie Ball) Join Date: Mar 2002 Posts: 36	well - it ALMOST works. I have a single season here, but when i simmed the next season, i only see the next season - the career stats aren't cumulative. Any idea what I could have missed? What I can see, so far, is brilliant. I can't wait to get the thing working completely... tx loc

06-18-2003, 12:24 PM	#27
SteveBsFan Minors (Single A) Join Date: Jan 2003 Posts: 69	Just want to bump this to see if anyone figured out the 'line 2' problem. I am getting the same thing. Used exporter 5, started importing, and got the word wrap - line 2 error. Thanks!

06-18-2003, 12:59 PM	#30
SteveBsFan Minors (Single A) Join Date: Jan 2003 Posts: 69	Cool, seems to be working now. I got through the line 2 bug, now importing. Thanks!

06-18-2003, 02:17 PM	#31
SteveBsFan Minors (Single A) Join Date: Jan 2003 Posts: 69	I seem to have the same problem as locust now, it only generates reports for the current season, not any of the past ones. Anyone know how to import past stats?

06-18-2003, 02:28 PM	#33
SteveBsFan Minors (Single A) Join Date: Jan 2003 Posts: 69	Nice, thanks.. Is there an option that allows you to alter the appearance of the html files? Thanks!

06-18-2003, 02:29 PM	#34
SteveBsFan Minors (Single A) Join Date: Jan 2003 Posts: 69	nm I think I found it, with the css

06-18-2003, 03:14 PM	#35
SteveBsFan Minors (Single A) Join Date: Jan 2003 Posts: 69	another quick question, is cato the utility that creates pages like this.. http://www.aba.ootp-leagues.com/History/ABA/index.htm or is that another utility? Thanks!

06-18-2003, 04:24 PM	#38
SteveBsFan Minors (Single A) Join Date: Jan 2003 Posts: 69	Cool, now my only problem is that I don't think the commish saved the past league info. I can't find it in the 'in game almanac', and the pages for past gold glove winners, etc is blank, so I am not sure if I can even have a history with that league. Is there any way to import history into the game itself?

06-18-2003, 06:19 PM	#39
Scott Vibert Hall Of Famer Join Date: Dec 2001 Location: My Computer Posts: 8,254	Cato's utility will work even if you don't have the award winners listed. You can add the award winners to the Game files by editing the corresponding text files in teh league_news_box directory.