Manually Adding Seasons to Catobase

bulldog55 · 11-01-2004, 02:13 PM

I run a league at BBSC that has a file for every year but its first. Obviously this throws off our league's Catobase.

But I had an idea today. I have the almanac for the first season. If I took the data files from the second season and manually edited them to match up with the almanac for the first season, and saved them in a 2003 folder, you think I could fool Catobase into thinking it generated that? Or does it need to actually go through the process of generating the files?

Or would it be so much work that it wouldn't even matter whether Catobase could handle it?

eriqjaffe · 11-01-2004, 02:18 PM

Since Catobase is a two-step process (generate .mdb files, generage .html files from the .mdb files), you should be able to manually add data to the .mdb file and run CatoBase.

I think.

But it probably would be a lot of work.

bulldog55 · 11-01-2004, 02:21 PM

So would I just be editing the database in Access? Would I have to edit the csv files into the 2003 folder? Or are those just a means of getting the information into the mdb?

DaveHorn · 11-01-2004, 04:24 PM

You've got two options.

You could recreate the CSVs by hand for that year and then import them and let Cato do all the database work. But that would mean you would have to start CATO over since you need to do the years sequentially (or at least I think you do, never tried doing it out of sequence). You'd also be editing the CSV text files instead which to me seems much more difficult then editing the tables in Access.

You other option, as I just alluded, is to just edit the tables in Access. Once your done, you can simply regen the HTML and you are good to go. But I imagine getting all that data into Cato will be no small task. Good luck!

11-01-2004, 02:13 PM	#1
bulldog55 Hall Of Famer Join Date: Sep 2002 Location: California's Canada Warnings: 17 Posts: 2,479	Manually Adding Seasons to Catobase I run a league at BBSC that has a file for every year but its first. Obviously this throws off our league's Catobase. But I had an idea today. I have the almanac for the first season. If I took the data files from the second season and manually edited them to match up with the almanac for the first season, and saved them in a 2003 folder, you think I could fool Catobase into thinking it generated that? Or does it need to actually go through the process of generating the files? Or would it be so much work that it wouldn't even matter whether Catobase could handle it? __________________ Commissioner, Trans-Continental Base Ball Association Owner/GM, Los Angeles Electrics (TCBA), Beaverton Rangers (OTBL), Portland Mavericks (Union League), and Los Angeles Superbas (Century League) Being smart, don't always make you popular.

11-01-2004, 02:18 PM	#2
eriqjaffe Hall Of Famer Join Date: May 2003 Location: Under The Christmas Fish Posts: 7,697	Since Catobase is a two-step process (generate .mdb files, generage .html files from the .mdb files), you should be able to manually add data to the .mdb file and run CatoBase. I think. But it probably would be a lot of work. __________________

11-01-2004, 02:21 PM	#3
bulldog55 Hall Of Famer Join Date: Sep 2002 Location: California's Canada Warnings: 17 Posts: 2,479	So would I just be editing the database in Access? Would I have to edit the csv files into the 2003 folder? Or are those just a means of getting the information into the mdb? __________________ Commissioner, Trans-Continental Base Ball Association Owner/GM, Los Angeles Electrics (TCBA), Beaverton Rangers (OTBL), Portland Mavericks (Union League), and Los Angeles Superbas (Century League) Being smart, don't always make you popular.

11-01-2004, 04:24 PM	#4
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	You've got two options. You could recreate the CSVs by hand for that year and then import them and let Cato do all the database work. But that would mean you would have to start CATO over since you need to do the years sequentially (or at least I think you do, never tried doing it out of sequence). You'd also be editing the CSV text files instead which to me seems much more difficult then editing the tables in Access. You other option, as I just alluded, is to just edit the tables in Access. Once your done, you can simply regen the HTML and you are good to go. But I imagine getting all that data into Cato will be no small task. Good luck! __________________ Dave HFTC Commish