6.5B and cato ok? - Page 5

jdettbarn · 10-12-2005, 10:56 PM

I've made all the ltrans fixes that have been mentioned on the boards and everything goes fine until near the end of the HTML generation. I keep getting the "Error 3021: Either BOF or EOF is True..." error when Cato gets to generating the Team Positional Charts (Atlanta is the first team.)

I opened up the Access database and 2018 didn't import into the TeamPosChart table like every other year and Atlanta has an extra entry with 0 for the Year.

Any ideas how this might of happened? I'm stumped.

The JOBL has run 17 seasons with Catobase and no errors until this season. I'll have some mighty sad owners if I can't get this fixed. (Including me!)

Any help is greatly appreciated.

SandMan · 10-13-2005, 01:03 AM

I have seen this on a few occasions. Just delete the record, but make sure it is not for a valid year, check all the years of the league and make sure atlanta has them all. If not just delete the last seasons from the catobase program menu, rerun with the option set to do all years and recalculate winshares. This will work.

jdettbarn · 10-13-2005, 10:18 AM

Thanks Sandman. I'll give it a shot tonight!

SandMan · 10-14-2005, 02:17 PM

Quote:

Originally Posted by jdettbarn

Thanks Sandman. I'll give it a shot tonight!

Just remember to do one season at a time using the CSV files and not importing with the exporter....

If your first bad season was the last season it is easy. Delete the season from the catobase menu and rerun the import and export, but if it goes back further you must delete all seasons to that point, then load one at a time the csv files from the year folder to the data folder and rerun the import with the use exporter option set to no...

jdettbarn · 10-14-2005, 05:16 PM

Thanks for the tips. I tried this last night, but with no luck.

It is the most recent season (2018), so that is good. I deleted it through the Catobase menu and re-ran import/export process through the Catobase. I still get the same error, however, when I get to the HTML generation of the Team Positional Charts. I checked the Access DB again and same deal: ATL entries with 0 for the year. They (the entries with 0) are definitely the 2018 ATL team too (players match). I also checked every other year and all others are present.

What CSV files does the Team Position table pull from? I wonder if there is a problem with those files...

Maybe I could try opening the league in 6.12 and running Catobase from that file to see if that helps.

Worst case I guess I could hand enter all team positional charts, then try running the HTML...

Thanks again, Sandman... you've at least given me and the league hope that this can be fixed!

endgame · 10-14-2005, 05:40 PM

Quote:

Originally Posted by jdettbarn

It is the most recent season (2018), so that is good. I deleted it through the Catobase menu and re-ran import/export process through the Catobase.

Not an identical issue, but when I last had to delete the most recent season for a re-run it took a couple of extra steps because the most recent season was NOT the last season in the database pulldown.

In other words I wanted to delete the 2004 season, but when I went to delete it from Catobase pulldown I noticed that 2005, 2006, 2007, etc.. were in there as well. Once I deleted all seasons beyond and including the most recent, all went well. Still don't know why they were there, but they were. It may not help, but it will at least be one thing to rule out.

jdettbarn · 10-18-2005, 11:15 PM

A little update on my error:

Checked the Fielding table... Found a bunch of current season players with 0 for the year. Deleted them and re-imported. All teams/players imported into this table seemingly correctly.

Then checked TeamPost Chart after making the above change. All teams are there now. Everything looks (seemingly) OK.

Also checked the FldStarters table... here is where the weirdness happens. All teams in the FL (team ids 1-8) were imported correctly. The rest of the teams (9-16) did not import for 2018. Team ID 9 is ATL, which just happens to be where the HTML generation sticks during the Team Positional Charts. So it seems like something happened with ATL during the fielding import.

And I still get the same error during HTML generation... Now I'm not sure why the Team Positional Charts don't generate now that the table is finally (seemingly) correct. But the whole FldStarters thing has me confused too.

Any ideas would be greatly appreciated... for now, I guess I'll be checking out the fielding CSVs, specifically ATL.

nestajones · 10-22-2005, 08:23 PM

Quote:

Originally Posted by Comedian2004

www.sim2005.com/newCatoFix.zip

Unzip it to the C:\Program Files\Out of the Park Developments\OOTP 6.5\1940.lg\LEAGUE_NEWS_BOX folder and run it.

It will do the search and replace and add a blank line after the trade.

It will save it as ltrans.txt.

The original alltrans.txt file is untouched, you may delete it if desired.

If you feel skirmish, or want to be extra careful, make a copy of the original ltrans.txt file.

NOTE FOR ALL CATO FILE USERS: When you are testing this, make sure that the alltrans.txt file was created by the NEW patch and not the old. Just installing the new patch does not replace the funky trans file. I am not actually sure when that is saved, when you save a league? I don't know.

I downloaded the fix, unzipped it to league_news_box folder, and ran it. When I try running it I get an error message: C:\windows\microsoft.NET\framework\v1.1.4322\mscor wksdll could not be loaded.

No clue what that means. Does that mean the fix did not work? what now?

Comedian2004 · 10-22-2005, 08:37 PM

You need to download and install the Microsoft NET framework. See the docs in my Sig for the link.

Quote:

Originally Posted by nestajones

I downloaded the fix, unzipped it to league_news_box folder, and ran it. When I try running it I get an error message: C:\windows\microsoft.NET\framework\v1.1.4322\mscor wksdll could not be loaded.

No clue what that means. Does that mean the fix did not work? what now?

SandMan · 10-22-2005, 08:39 PM

Quote:

Originally Posted by jdettbarn

A little update on my error:

Checked the Fielding table... Found a bunch of current season players with 0 for the year. Deleted them and re-imported. All teams/players imported into this table seemingly correctly.

Then checked TeamPost Chart after making the above change. All teams are there now. Everything looks (seemingly) OK.

Also checked the FldStarters table... here is where the weirdness happens. All teams in the FL (team ids 1-8) were imported correctly. The rest of the teams (9-16) did not import for 2018. Team ID 9 is ATL, which just happens to be where the HTML generation sticks during the Team Positional Charts. So it seems like something happened with ATL during the fielding import.

And I still get the same error during HTML generation... Now I'm not sure why the Team Positional Charts don't generate now that the table is finally (seemingly) correct. But the whole FldStarters thing has me confused too.

Any ideas would be greatly appreciated... for now, I guess I'll be checking out the fielding CSVs, specifically ATL.

Atlanta was the first team in the other league processed so my guess would be that once the 0 year records are deleted from the table and all tables that have 0 year records it should process from the csvs all right. Just make sure that you don't re-run the import with the exporter option on.. Turn this off and copy the csvs from the 2018 folder into the data folder. Then from the menu delete the 2018 season and rerun the import with the exporter option off..... if this fails again then do the same process but look at the csv files within excel. Look specifically at the Atlanta records first...

Hope this helps...

Maximus · 11-06-2005, 02:01 AM

Quote:

Originally Posted by Comedian2004

Catofix is still available.

www.sim2005.com/catofix.zip

Unzip the exe file into the .lg/LEAGUE_NEWS_BOX folder.

Run it and it will create a file called lalltrans2.txt, leaving the originally untouched.

Move the original out of that folder and rename this one.

I have run it in the correct folder but I do not get a file named lalltrans2.txt. It still says lalltrans.txt. Is there something I am doing wrong?

Maximus · 11-06-2005, 03:08 AM

One more question. By changing all of the =r's to =p's will that make all of the players who had =r's in the game not retired anymore?

sdf4977 · 11-06-2005, 01:32 PM

That's what I wanted to know too.

SandMan · 11-06-2005, 05:02 PM

Quote:

Originally Posted by Maximus

One more question. By changing all of the =r's to =p's will that make all of the players who had =r's in the game not retired anymore?

No they will still retire, it is just that the catobase will see them by their id and process then. It does not have any affect on the game itself.

kq76 · 11-07-2005, 08:49 AM

Quote:

Originally Posted by BruceM

What's happening with the rxxx is that players are retiring mid season and then turning around and signing with another team. There is no player release line from when the player retires and that has to be added or his stats will only show for the one team and not both. Retired players should not go directly to the FA pool when they retire.

From:

Quote:

Originally Posted by BruceM

I didn't find any problems though with retired players signing with another team, so that seems to be working fine.

I get the sense that this might still be a problem, it just might be that your test season didn't have any cases of a retired player signing with a number team that season. So, if it is still a problem, then if I read that top quote of yours correctly, you would have to go into lalltrans.txt and after every retirement line you would have to add a line that would indicate that that same player was released like:

Quote:

1 Anansi: Released P <a href=p608.html>Rafiki Siham</a>.

Quote:

Originally Posted by BruceM

There needs to be a hard line break after each trade transaction.

Could you clarify what you mean by this, please? Do you mean:

-just make sure the next line after a trade is on it's own line,
-there is a < br > tag after the last line in a trade,
-there is a < p > tag after the last line in a trade, or
-something else?

(I added the spaces in the tags for them to show up in my post.)

Thanks, Bruce, and everyone else for flushing out these problems for the rest of us.

BTW, for those doing this on their own I'd suggest first making a copy of your ltrans.txt and renaming it something like ltrans-original.txt (and just in case you save it prematurely with the changes, do the same with lalltrans.txt to ltrans-original.txt). Then do your changes to lalltrans.txt and save it as ltrans.txt. If you do what the others said you might get the same result, but I think it's less likely to make a mistake you can't easily recover from this way and you'll be able to keep the original ltrans.txt.

Garlon · 11-08-2005, 01:47 PM

Jdettbarn,

I had the exact same problem as you do with Catobase...it came after 17 seasons, during the positional charts, and with ATL as well. Let me know if you figure out how to fix it.

Bluenoser · 11-08-2005, 02:13 PM

Quote:

Originally Posted by kq76

From:

I get the sense that this might still be a problem, it just might be that your test season didn't have any cases of a retired player signing with a number team that season. So, if it is still a problem, then if I read that top quote of yours correctly, you would have to go into lalltrans.txt and after every retirement line you would have to add a line that would indicate that that same player was released like:

Could you clarify what you mean by this, please? Do you mean:

-just make sure the next line after a trade is on it's own line,
-there is a < br > tag after the last line in a trade,
-there is a < p > tag after the last line in a trade, or
-something else?

(I added the spaces in the tags for them to show up in my post.)

Thanks, Bruce, and everyone else for flushing out these problems for the rest of us.

BTW, for those doing this on their own I'd suggest first making a copy of your ltrans.txt and renaming it something like ltrans-original.txt (and just in case you save it prematurely with the changes, do the same with lalltrans.txt to ltrans-original.txt). Then do your changes to lalltrans.txt and save it as ltrans.txt. If you do what the others said you might get the same result, but I think it's less likely to make a mistake you can't easily recover from this way and you'll be able to keep the original ltrans.txt.

What I mean by a Hard Line Break is at the end of each trade transaction, press the "Enter" key once. This will create a blank line after each trade transaction.
As for the retired players signing with another team, I've yet to see it with 6.5b, so I'm inclined to believe Markus fixed the problem. However that is only my experience with my own leagues. If you are finding that it is still occuring, then it probably should be looked at again by Markus.

Maximus · 11-08-2005, 06:22 PM

Quote:

Originally Posted by Maximus

I have run it in the correct folder but I do not get a file named lalltrans2.txt. It still says lalltrans.txt. Is there something I am doing wrong?

bump for the above issue.

Garlon · 11-08-2005, 06:52 PM

Maximus,

I could not get that program to do anything either.

battists · 11-11-2005, 10:37 PM

Another glutton for punishment here.

I can't figure out what the "Data Directory" in the Catobase options refers to, and what is supposed to be in there. First it told me league.csv wasn't there, so I ran Commish joe's exporter and dumped the results in there. Now it's telling me lnews* isn't there either.

Any suggestions?

10-12-2005, 10:56 PM	#81
jdettbarn All Star Reserve Join Date: Mar 2002 Location: Buffalo, NY Posts: 635	I've made all the ltrans fixes that have been mentioned on the boards and everything goes fine until near the end of the HTML generation. I keep getting the "Error 3021: Either BOF or EOF is True..." error when Cato gets to generating the Team Positional Charts (Atlanta is the first team.) I opened up the Access database and 2018 didn't import into the TeamPosChart table like every other year and Atlanta has an extra entry with 0 for the Year. Any ideas how this might of happened? I'm stumped. The JOBL has run 17 seasons with Catobase and no errors until this season. I'll have some mighty sad owners if I can't get this fixed. (Including me!) Any help is greatly appreciated. __________________ NPBL Idaho Spuds GM Former Federal Baseball League and JOBL Commish (2002 - 2011) Last edited by jdettbarn; 10-12-2005 at 10:58 PM.

10-13-2005, 10:18 AM	#83
jdettbarn All Star Reserve Join Date: Mar 2002 Location: Buffalo, NY Posts: 635	Thanks Sandman. I'll give it a shot tonight! __________________ NPBL Idaho Spuds GM Former Federal Baseball League and JOBL Commish (2002 - 2011)

10-14-2005, 05:16 PM	#85
jdettbarn All Star Reserve Join Date: Mar 2002 Location: Buffalo, NY Posts: 635	Thanks for the tips. I tried this last night, but with no luck. It is the most recent season (2018), so that is good. I deleted it through the Catobase menu and re-ran import/export process through the Catobase. I still get the same error, however, when I get to the HTML generation of the Team Positional Charts. I checked the Access DB again and same deal: ATL entries with 0 for the year. They (the entries with 0) are definitely the 2018 ATL team too (players match). I also checked every other year and all others are present. What CSV files does the Team Position table pull from? I wonder if there is a problem with those files... Maybe I could try opening the league in 6.12 and running Catobase from that file to see if that helps. Worst case I guess I could hand enter all team positional charts, then try running the HTML... Thanks again, Sandman... you've at least given me and the league hope that this can be fixed! __________________ NPBL Idaho Spuds GM Former Federal Baseball League and JOBL Commish (2002 - 2011)

10-18-2005, 11:15 PM	#87
jdettbarn All Star Reserve Join Date: Mar 2002 Location: Buffalo, NY Posts: 635	A little update on my error: Checked the Fielding table... Found a bunch of current season players with 0 for the year. Deleted them and re-imported. All teams/players imported into this table seemingly correctly. Then checked TeamPost Chart after making the above change. All teams are there now. Everything looks (seemingly) OK. Also checked the FldStarters table... here is where the weirdness happens. All teams in the FL (team ids 1-8) were imported correctly. The rest of the teams (9-16) did not import for 2018. Team ID 9 is ATL, which just happens to be where the HTML generation sticks during the Team Positional Charts. So it seems like something happened with ATL during the fielding import. And I still get the same error during HTML generation... Now I'm not sure why the Team Positional Charts don't generate now that the table is finally (seemingly) correct. But the whole FldStarters thing has me confused too. Any ideas would be greatly appreciated... for now, I guess I'll be checking out the fielding CSVs, specifically ATL. __________________ NPBL Idaho Spuds GM Former Federal Baseball League and JOBL Commish (2002 - 2011)

10-13-2005, 01:03 AM	#82
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	I have seen this on a few occasions. Just delete the record, but make sure it is not for a valid year, check all the years of the league and make sure atlanta has them all. If not just delete the last seasons from the catobase program menu, rerun with the option set to do all years and recalculate winshares. This will work.

11-06-2005, 03:08 AM	#92
Maximus Major Leagues Join Date: Nov 2004 Posts: 417	One more question. By changing all of the =r's to =p's will that make all of the players who had =r's in the game not retired anymore?

11-06-2005, 01:32 PM	#93
sdf4977 Minors (Rookie Ball) Join Date: Dec 2004 Posts: 46	That's what I wanted to know too.

11-08-2005, 01:47 PM	#96
Garlon Hall Of Famer Join Date: Jun 2004 Posts: 4,268	Jdettbarn, I had the exact same problem as you do with Catobase...it came after 17 seasons, during the positional charts, and with ATL as well. Let me know if you figure out how to fix it.

11-08-2005, 06:52 PM	#99
Garlon Hall Of Famer Join Date: Jun 2004 Posts: 4,268	Maximus, I could not get that program to do anything either.

11-11-2005, 10:37 PM	#100
battists Hall Of Famer Join Date: Jul 2004 Posts: 18,506	Another glutton for punishment here. I can't figure out what the "Data Directory" in the Catobase options refers to, and what is supposed to be in there. First it told me league.csv wasn't there, so I ran Commish joe's exporter and dumped the results in there. Now it's telling me lnews* isn't there either. Any suggestions?