Catobase question

Jeremy Weimer · 01-25-2005, 08:42 PM

Alright, I noticed for some reason after 1907 each teams draft logs aren't showing up at all. The years after 1907 are listed but for each round it's just blank where the players name should be. Anyone have any idea what could have happened?

SandMan · 01-25-2005, 09:48 PM

The import stats from CATOBASE did not properly interpret the tags in the DRAFTLOG.html file in the LEAGUE_NEWS_BOX folder in your league. If you don't have a backup of the season you cannot fix this easily.

You may be able to if your Almanac saves all 3 options. If your almanac folder has a draftlog file in it for the season you need check out the tags in the source code. Look at the file through a browser and see if it is correct, if not view the source and make sure that the tags match the previous years tags. I believe the tag is a 6 for the round and a 1 for the players selected. Correct the tag and this should fix the problem. You will need to back out in CATO to 1906 and rerun the import. IMPORTANT: Keep a copy of the MDB file incase of problems. You run a risk of messing up the history files when you go back then go back forward, unless you have each season saved. You can use the CSV files you already have for the stats by moving them to your CATOBASE\DATA folder from the CATOBASE|DATA|YEAR folder and unchecking the option in CATO to use the exporter. This will use the data you moved into the data folder. You will need to do this for each year until you get to the last season you have processed.

Another option and not as difficult. It may be easier to just get the copy of each teams draft choices from the teams history file and manually entering them into the MDB table. You will need ACCESS to do this. You will probably only have 10 per team so this should be easy. Then the next time pages are created this should be corrected. One not on modifying the DRAFT table in the DATABASE - the player ID field needs to be populated with the ID from the MASTER table and not the P# from the game and also make sure that you do not misspell any information in the name of team.

Jeremy Weimer · 01-25-2005, 11:09 PM

I was with you until you started the second paragraph.

SandMan · 01-25-2005, 11:30 PM

Quote:

Originally Posted by Jeremy Weimer

I was with you until you started the second paragraph.

Well I guess to put it simply, unless you have programming experience or probably a lot of time with ACCESS or EXCEL you are pretty much screwed once you go to the next season without saving the files.

Jeremy Weimer · 01-25-2005, 11:52 PM

Jeremy Weimer · 01-26-2005, 12:49 AM

Is there anyway someone can fix this problem for me? Please?

gmo · 01-26-2005, 12:56 AM

Do you have histories on the player pages, and if so, do players' draft notes show up there even though the info does not show up on the team draft pages?

Jeremy Weimer · 01-26-2005, 01:02 AM

It seems that the history section isn't showing up on player pages in Cato for players that were drafted in 1907 and after. All the players before that do though. Could it have anything to do with the fact that I reset my league in 1907 because of the crash I had with it? I was simming in June and it had a run time error and messed up all the stats. So I reset the league to the start of 1907 and went through and deleted out all mention of 1907 in player histories except the draft mentions.

Jeremy Weimer · 01-26-2005, 01:03 AM

The player histories show up fine in the game though. All the players drafted after 1907 have player histories in the game and such.

SandMan · 01-26-2005, 02:49 AM

Quote:

Originally Posted by Jeremy Weimer

It seems that the history section isn't showing up on player pages in Cato for players that were drafted in 1907 and after. All the players before that do though. Could it have anything to do with the fact that I reset my league in 1907 because of the crash I had with it? I was simming in June and it had a run time error and messed up all the stats. So I reset the league to the start of 1907 and went through and deleted out all mention of 1907 in player histories except the draft mentions.

That is it. When you hit reset without doing a release draft all, the players remain on the same teams, but the reset deletes all the files in the league_new_box folder including the draftlog.txt file. At this point you have no references to the draft in the file and the game assumes that the players are and have been assigned to their current teams. with no draft taking place.

You still may have the draft picks listed in the team history. Check that out and see if the draft for 1907 appears in your teams history. I would think that it may not because of the reset......but if the information is there you can still manually add it to the CATOBASE manually.......

Jeremy Weimer · 01-26-2005, 03:13 PM

What about years after 1907 though? Does resetting my league like that subsequently ruin the draft logs for every season afterwards as well? Because 1907 is the only season I reset but every season after that the draft logs are blank in Catobase.

SandMan · 01-26-2005, 03:25 PM

Quote:

Originally Posted by Jeremy Weimer

What about years after 1907 though? Does resetting my league like that subsequently ruin the draft logs for every season afterwards as well? Because 1907 is the only season I reset but every season after that the draft logs are blank in Catobase.

I am not sure if it does. Look at your current season and see if the draftlog.txt file is okay. If it is check out the DRAFT table in CATOBASE. I would try to test it out by copying the current league and CATOBASE, adding manually the players from one teams draft from their histories into CATO from the previous season, sim out the current season, run cato at end of year, proceed as usual and then check out the html files to see if the current years data is in the html. This one stumps me.....

Bobble · 01-26-2005, 03:31 PM

Quote:

Originally Posted by Jeremy Weimer

I was with you until you started the second paragraph.

I was with him until the start of the second word.

Jeremy Weimer · 01-26-2005, 03:33 PM

Where do I find the draftlog.txt for the current season? In the OOTP6 league folder or in the Catobase folder or what? I'm not sure what to look for. And what should I be looking for as far as to whether it's okay or not?

Jeremy Weimer · 01-26-2005, 03:34 PM

Quote:

Originally Posted by Bobble

I was with him until the start of the second word.

Poor Bobble.

SandMan · 01-26-2005, 04:18 PM

Quote:

Originally Posted by Jeremy Weimer

Where do I find the draftlog.txt for the current season? In the OOTP6 league folder or in the Catobase folder or what? I'm not sure what to look for. And what should I be looking for as far as to whether it's okay or not?

The draftlog.txt file is in the LEAGUE_NEWS_BOX folder in your league folder, the DRAFT table is in CATOBASE and should be current upto the previous season. The draftlog.txt file will have a 6 tag followed by the round and each player drafted will have a 1 tag in from of their record. If the current draftlog looks good and the DRAFT table stops after the 1906 season then I would do the following.

Do a search in the LEAGUE_NEWS_BOX\PLAYERS folder and search for the following for each team:

by TEAMCITY in YEAR..

This will give you the draft choices, just replace the year for the years you are missing and do each city. If you do a search on just the "in year" you may get other records that you don't need. Then you will need to just manually add the players to the DRAFT Table in CATO BASE.

Hopefully the next time you run catobase the program will be able to update the DRAFT table from the current draftlog.txt file.

Jeremy Weimer · 01-26-2005, 05:20 PM

I checked the current draft log and it looks fine to me. So how do I go about manually adding in the rookies in Catobase to each corresponding year? I have no idea how to do that.

SandMan · 01-26-2005, 05:39 PM

Quote:

Originally Posted by Jeremy Weimer

I checked the current draft log and it looks fine to me. So how do I go about manually adding in the rookies in Catobase to each corresponding year? I have no idea how to do that.

1. Check the DRAFT table in CATOBASE ans see which draft year is the last group to be in the table. It should be in your case 1906. If records appear after that date they may be corrupt so check for any bad records, but I suspect that the records stopped in 1906.

2. Using the Windows Search Folders program, search the LEAGE_NEWS_BOX\PLAYERS folder for the "by XXXX in YYYY" with the XXXX being 1 teams city location and XXXX being in your case 1907. Do this for each team. This will bring you a list of all the players drafted for the year.

3. Write down the p#, if you had a 10 player draft this should only be 10 players per team. Read the history to see which round they were selected and what the pick number is. If the pick is not available I would just look at the previous years standings and write the teams down from worst to first and use that as my guide for the draft. May be off by a team or two but not by much.

4. Export from the league setup main screen the CSV Rosters to get the rosters for each team with the P#. Some of the players may no longer be on team that drafted them but that is not important - just search the CSV roster export by P# and should find the player.

5. Open the DRAFT table in ACCESS and enter the players information using the format from the previous seasons already loaded into the table. To get the player id in the last field go to the Master table for the players and get the CATO Assigned ID Important not to use the P#. This ID is to link to the pages when the page is built.

6. You will need to do this for the 1907 season and all seasons that you played except for the current, which has a good draftlog.txt file and should process after the missing seasons are added to the CATOBASE.

That should do it. BTW, I have not had the pleasure of doing this but I have been spending a great deal of time with CATOBASE and the export files to see how they work. I hope this helps.....

Next time the pages are recreated this should work.

Jeremy Weimer · 01-26-2005, 10:07 PM

Well I was with you until you got to the part about Access. I don't have Access on this computer and have no interest in purchasing Office just so I can use it to fix Catobase. So that kinda screws everything up.

SandMan · 01-26-2005, 10:12 PM

Without ACCESS, CATOBASE is difficult to repair when you proceed to the next season - always good to backup your league and cato mdb file after each season...

01-25-2005, 08:42 PM	#1
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	Catobase question Alright, I noticed for some reason after 1907 each teams draft logs aren't showing up at all. The years after 1907 are listed but for each round it's just blank where the players name should be. Anyone have any idea what could have happened?

01-25-2005, 09:48 PM	#2
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	The import stats from CATOBASE did not properly interpret the tags in the DRAFTLOG.html file in the LEAGUE_NEWS_BOX folder in your league. If you don't have a backup of the season you cannot fix this easily. You may be able to if your Almanac saves all 3 options. If your almanac folder has a draftlog file in it for the season you need check out the tags in the source code. Look at the file through a browser and see if it is correct, if not view the source and make sure that the tags match the previous years tags. I believe the tag is a 6 for the round and a 1 for the players selected. Correct the tag and this should fix the problem. You will need to back out in CATO to 1906 and rerun the import. IMPORTANT: Keep a copy of the MDB file incase of problems. You run a risk of messing up the history files when you go back then go back forward, unless you have each season saved. You can use the CSV files you already have for the stats by moving them to your CATOBASE\DATA folder from the CATOBASE\|DATA\|YEAR folder and unchecking the option in CATO to use the exporter. This will use the data you moved into the data folder. You will need to do this for each year until you get to the last season you have processed. Another option and not as difficult. It may be easier to just get the copy of each teams draft choices from the teams history file and manually entering them into the MDB table. You will need ACCESS to do this. You will probably only have 10 per team so this should be easy. Then the next time pages are created this should be corrected. One not on modifying the DRAFT table in the DATABASE - the player ID field needs to be populated with the ID from the MASTER table and not the P# from the game and also make sure that you do not misspell any information in the name of team. Last edited by SandMan; 01-25-2005 at 09:51 PM.

01-25-2005, 11:09 PM	#3
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	I was with you until you started the second paragraph.

01-25-2005, 11:52 PM	#5
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411

01-26-2005, 12:49 AM	#6
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	Is there anyway someone can fix this problem for me? Please?

01-26-2005, 12:56 AM	#7
gmo Hall Of Famer Join Date: May 2002 Location: Longmont, CO Posts: 3,420	Do you have histories on the player pages, and if so, do players' draft notes show up there even though the info does not show up on the team draft pages?

01-26-2005, 01:02 AM	#8
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	It seems that the history section isn't showing up on player pages in Cato for players that were drafted in 1907 and after. All the players before that do though. Could it have anything to do with the fact that I reset my league in 1907 because of the crash I had with it? I was simming in June and it had a run time error and messed up all the stats. So I reset the league to the start of 1907 and went through and deleted out all mention of 1907 in player histories except the draft mentions.

01-26-2005, 01:03 AM	#9
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	The player histories show up fine in the game though. All the players drafted after 1907 have player histories in the game and such.

01-26-2005, 03:13 PM	#11
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	What about years after 1907 though? Does resetting my league like that subsequently ruin the draft logs for every season afterwards as well? Because 1907 is the only season I reset but every season after that the draft logs are blank in Catobase.

01-26-2005, 03:33 PM	#14
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	Where do I find the draftlog.txt for the current season? In the OOTP6 league folder or in the Catobase folder or what? I'm not sure what to look for. And what should I be looking for as far as to whether it's okay or not?

01-26-2005, 05:20 PM	#17
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	I checked the current draft log and it looks fine to me. So how do I go about manually adding in the rookies in Catobase to each corresponding year? I have no idea how to do that.

01-26-2005, 10:07 PM	#19
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	Well I was with you until you got to the part about Access. I don't have Access on this computer and have no interest in purchasing Office just so I can use it to fix Catobase. So that kinda screws everything up.

01-26-2005, 10:12 PM	#20
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Without ACCESS, CATOBASE is difficult to repair when you proceed to the next season - always good to backup your league and cato mdb file after each season...