CatoBase name change question

gordyhulten · 04-26-2004, 02:49 PM

If I edit a player's name (from say "Joesph" to "Joseph" or "Odonoghue" to "O'Donoghue") will that cause problems when I use CatoBase later?

tim_uwrf · 04-26-2004, 03:19 PM

I would think it depends on whether CatoBase uses player ID or Player name. But I wouldn't know. So like you posed the question, you'll probably have to wait for Cato to come around.

tcblcommish · 04-26-2004, 05:13 PM

I am almost posittive that if you change a players name, he won't get stats from anymore seasons if you change it in the database.

gordyhulten · 04-26-2004, 05:36 PM

Quote:

Originally posted by tcblcommish
I am almost posittive that if you change a players name, he won't get stats from anymore seasons if you change it in the database.

I'm not sure what you mean.

Can I change a name as long as I change it in the database? Can I not change names at all?

jcato · 04-26-2004, 10:36 PM

If you already have a database with previous seasons, and this player is in it, and you change his name or birthdate, he will get a new playerid and you will, in effect, have 2 different players in the database.

Changing players' names after they are in the database is not recommended. However, you can probably get away with it, if you have Access 2000 or higher. This may (or may not) work:

Change the player's name in OOTP.
Import the season with the player's new name.
Find the 2 entires for the player in the Master table.
Copy the new playerid
Paste the new playerid in every table where the old playerid is.
Delete the record with the old playerid in the Master table.
Create the HTML pages.

Hopefully everything will work, right. Might want to try this on a backup version of the database!

04-26-2004, 02:49 PM	#1
gordyhulten All Star Starter Join Date: Jan 2003 Location: Champaign, IL Posts: 1,175	CatoBase name change question If I edit a player's name (from say "Joesph" to "Joseph" or "Odonoghue" to "O'Donoghue") will that cause problems when I use CatoBase later? __________________ 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

04-26-2004, 03:19 PM	#2
tim_uwrf Hall Of Famer Join Date: Sep 2003 Location: Field of Dreams Posts: 1,998	I would think it depends on whether CatoBase uses player ID or Player name. But I wouldn't know. So like you posed the question, you'll probably have to wait for Cato to come around.

04-26-2004, 05:13 PM	#3
tcblcommish Hall Of Famer Join Date: Mar 2002 Location: Canada Posts: 3,440	I am almost posittive that if you change a players name, he won't get stats from anymore seasons if you change it in the database.

04-26-2004, 10:36 PM	#5
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	If you already have a database with previous seasons, and this player is in it, and you change his name or birthdate, he will get a new playerid and you will, in effect, have 2 different players in the database. Changing players' names after they are in the database is not recommended. However, you can probably get away with it, if you have Access 2000 or higher. This may (or may not) work: Change the player's name in OOTP. Import the season with the player's new name. Find the 2 entires for the player in the Master table. Copy the new playerid Paste the new playerid in every table where the old playerid is. Delete the record with the old playerid in the Master table. Create the HTML pages. Hopefully everything will work, right. Might want to try this on a backup version of the database!