Catobase database edit ???

Danny Reaves · 07-12-2004, 09:21 PM

I made a dumb mistake while running catobase at the end of the year. I accidentally changed one of my team abbreviations and didn't catch it until I had already imported stats and created the html. I did not back up the database before proceeding. Now I have a team that is represented by two abbreviations with the old one carrying all the history but the lastest season.
Can I edit the database to merge the info back together? If so, how?

chrisj · 07-12-2004, 09:44 PM

I'd have to play around to tell you exactly what to do...

BUT... I think you'd just have to open the database in Access, and change all the team abrvs to what you'd like. It'd be a lot of work, but should work.

OR... if it's just the last season that is messed up, the latest version of Catobase includes an option to delete the last season that has been added. Simply delete the info, and import everything once again.

Hope that helps!

gordyhulten · 07-12-2004, 10:32 PM

I think you can simply open up CatoBase, use Edit --> Team Info to change the team abbreviations year by year.

Danny Reaves · 07-12-2004, 11:43 PM

I haven't updated from 6.0.0. yet, so I will try that first.

jcato · 07-13-2004, 09:18 AM

You can't use Edit/Team Info to change the abbreviations. I would recommend using a newer version and deleting and reimporting the season. But, you could do it manually. Either way, I would certainly do it on a backup copy first.

To do it manually, you would need to look in each table (except the cj_* tables) and change the abbreviation, if it's in there. I think the only special case is the Teams table. In this one, you would need to delete the row with the bad abbreviation and change the LastYear value of the row with the correct abbreviation.

Danny Reaves · 07-13-2004, 11:14 AM

I updated to 6.1.2 and then deleted the season and reran cato and it worked fine. Thanks for the help.

07-12-2004, 09:21 PM	#1
Danny Reaves Bat Boy Join Date: Jul 2003 Posts: 14	Catobase database edit ??? I made a dumb mistake while running catobase at the end of the year. I accidentally changed one of my team abbreviations and didn't catch it until I had already imported stats and created the html. I did not back up the database before proceeding. Now I have a team that is represented by two abbreviations with the old one carrying all the history but the lastest season. Can I edit the database to merge the info back together? If so, how?

07-12-2004, 09:44 PM	#2
chrisj All Star Reserve Join Date: Feb 2002 Location: Edmonton, Alberta (but still wishing I was in Halifax, Nova Scotia, Canada) Posts: 834	I'd have to play around to tell you exactly what to do... BUT... I think you'd just have to open the database in Access, and change all the team abrvs to what you'd like. It'd be a lot of work, but should work. OR... if it's just the last season that is messed up, the latest version of Catobase includes an option to delete the last season that has been added. Simply delete the info, and import everything once again. Hope that helps! __________________ Canadian Baseball League -- Commissioner -- Calgary GM

07-12-2004, 10:32 PM	#3
gordyhulten All Star Starter Join Date: Jan 2003 Location: Champaign, IL Posts: 1,175	I think you can simply open up CatoBase, use Edit --> Team Info to change the team abbreviations year by year. __________________ Gordy Hulten Owner / General Manager Red Willow Roadrunners -- Kennel Series Champions: 1951, 1959, 1964, 1965, 1972, 1975, 1980, 1982, 1983 Dog Days Baseball - "The World's Best Online OOTP League" Creator inactive: Republican League - OOTP 2009 Dynasty inactive: Republican League Dynasty - Version 2.0 inactive: Republican League Dynasty

07-12-2004, 11:43 PM	#4
Danny Reaves Bat Boy Join Date: Jul 2003 Posts: 14	I haven't updated from 6.0.0. yet, so I will try that first.

07-13-2004, 09:18 AM	#5
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	You can't use Edit/Team Info to change the abbreviations. I would recommend using a newer version and deleting and reimporting the season. But, you could do it manually. Either way, I would certainly do it on a backup copy first. To do it manually, you would need to look in each table (except the cj_* tables) and change the abbreviation, if it's in there. I think the only special case is the Teams table. In this one, you would need to delete the row with the bad abbreviation and change the LastYear value of the row with the correct abbreviation.

07-13-2004, 11:14 AM	#6
Danny Reaves Bat Boy Join Date: Jul 2003 Posts: 14	I updated to 6.1.2 and then deleted the season and reran cato and it worked fine. Thanks for the help.