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.