Cato Troubles

Shorty · 07-14-2003, 07:10 PM

One of the leagues players birthday was accidentally changed - I was changing his country to a more unique place and accidentally clicked on his name. The date got messed up as I just guessed at his month/day while keeping the same ago. No big deal.

Well Cato saw the change in birthdays and made a new player in the reference for him and now that I found his real birthday, it looks like this.

PLAYER STATS
1984
1985
1986
1987
1989
1990... etc

Meanwhile, a new player page with the same name has one line: 1988. Is there any file I can edit which will make Cato read this year making him the same player?

koohead · 07-14-2003, 07:18 PM

you probably could open up the access database and merge the data manually

Shorty · 07-14-2003, 07:33 PM

...which csv would that be

koohead · 07-14-2003, 07:35 PM

no, I'm talking about the .mdb file...the database that the utility compiles all of the csv data into

Shorty · 07-14-2003, 07:36 PM

aha!

Shorty · 07-14-2003, 07:41 PM

Ok, so if I change brownjoe616 to brownjoe804 like the rest, I should achieve what I desire, correct?

vvvvv

sharpmath · 07-14-2003, 09:00 PM

Sorry to sound ignorant, but what did you use to open up the MDB file? I assumed it was Excel, but it doesn't seem to take for me...?

sharpmath · 07-14-2003, 09:07 PM

ah. access. I get it now. thanks.

sharpmath · 07-14-2003, 09:32 PM

... so the only way, then, to fix the fact that OOTP History thinks Walter Johnson gave up 354 ER in 1903 for a 9.00+ ERA in hs first year as a pro with the Bronchos, when really it was 98 ER and he had a 2.73 ERA, is that right? Because I don't have Access, but if it's the only thing that will help me out here, im more than happy to buy it. I just want to make sure first.

koohead · 07-14-2003, 11:07 PM

Shorty: My guess would be Yes..of course, I've never tried anything like this myself, so...make a backup

sharpmath: actually, you would be able to edit the CSV file for pitching stats, since most likely that file is where the incorrect data is coming from. You would just need Excel for that.

sharpmath · 07-15-2003, 12:58 AM

Oh, alright, Ill give that a shot!
Thanks very much.

07-14-2003, 07:10 PM	#1
Shorty All Star Reserve Join Date: Jan 2002 Location: Cincinnati, Ohio Posts: 992	Cato Troubles One of the leagues players birthday was accidentally changed - I was changing his country to a more unique place and accidentally clicked on his name. The date got messed up as I just guessed at his month/day while keeping the same ago. No big deal. Well Cato saw the change in birthdays and made a new player in the reference for him and now that I found his real birthday, it looks like this. PLAYER STATS 1984 1985 1986 1987 1989 1990... etc Meanwhile, a new player page with the same name has one line: 1988. Is there any file I can edit which will make Cato read this year making him the same player? __________________ Here we go Redlegs here we go!

07-14-2003, 07:18 PM	#2
koohead Hall Of Famer Join Date: Dec 2001 Location: Phoenix, AZ Posts: 3,230	you probably could open up the access database and merge the data manually __________________ GM - New Jersey Bears of the NPBL;

07-14-2003, 07:33 PM	#3
Shorty All Star Reserve Join Date: Jan 2002 Location: Cincinnati, Ohio Posts: 992	...which csv would that be __________________ Here we go Redlegs here we go!

07-14-2003, 07:35 PM	#4
koohead Hall Of Famer Join Date: Dec 2001 Location: Phoenix, AZ Posts: 3,230	no, I'm talking about the .mdb file...the database that the utility compiles all of the csv data into __________________ GM - New Jersey Bears of the NPBL;

07-14-2003, 07:36 PM	#5
Shorty All Star Reserve Join Date: Jan 2002 Location: Cincinnati, Ohio Posts: 992	aha! __________________ Here we go Redlegs here we go!

07-14-2003, 07:41 PM	#6
Shorty All Star Reserve Join Date: Jan 2002 Location: Cincinnati, Ohio Posts: 992	Ok, so if I change brownjoe616 to brownjoe804 like the rest, I should achieve what I desire, correct? vvvvv __________________ Here we go Redlegs here we go!

07-14-2003, 09:00 PM	#7
sharpmath Minors (Single A) Join Date: Jun 2003 Location: Calgary, AB Posts: 69	Sorry to sound ignorant, but what did you use to open up the MDB file? I assumed it was Excel, but it doesn't seem to take for me...? __________________ this night has opened my eyes and I will never be the same. I'm not happy and I'm not sad.

07-14-2003, 09:07 PM	#8
sharpmath Minors (Single A) Join Date: Jun 2003 Location: Calgary, AB Posts: 69	ah. access. I get it now. thanks. __________________ this night has opened my eyes and I will never be the same. I'm not happy and I'm not sad.

07-14-2003, 09:32 PM	#9
sharpmath Minors (Single A) Join Date: Jun 2003 Location: Calgary, AB Posts: 69	... so the only way, then, to fix the fact that OOTP History thinks Walter Johnson gave up 354 ER in 1903 for a 9.00+ ERA in hs first year as a pro with the Bronchos, when really it was 98 ER and he had a 2.73 ERA, is that right? Because I don't have Access, but if it's the only thing that will help me out here, im more than happy to buy it. I just want to make sure first. __________________ this night has opened my eyes and I will never be the same. I'm not happy and I'm not sad.

07-14-2003, 11:07 PM	#10
koohead Hall Of Famer Join Date: Dec 2001 Location: Phoenix, AZ Posts: 3,230	Shorty: My guess would be Yes..of course, I've never tried anything like this myself, so...make a backup sharpmath: actually, you would be able to edit the CSV file for pitching stats, since most likely that file is where the incorrect data is coming from. You would just need Excel for that. __________________ GM - New Jersey Bears of the NPBL;

07-15-2003, 12:58 AM	#11
sharpmath Minors (Single A) Join Date: Jun 2003 Location: Calgary, AB Posts: 69	Oh, alright, Ill give that a shot! Thanks very much. __________________ this night has opened my eyes and I will never be the same. I'm not happy and I'm not sad.