Career Fielding Averages file for Lahman DB 5.0 now available.

Ankit · 03-10-2003, 11:51 PM

I know a lot of you have been dissatisfied with the way OOTP 5 assigns fielding ratings to players that are imported from Lahman DB 5.0.

I have created a new fielding.csv file which has the career average fielding data for each player. So now, when you import Jimmy Foxx as a rookie, he won't import as a C, but will have ratings for both 1B and 3B. His fielding percentage will be his lifetime career average at that positions as will his other information (Games, Putouts, Assists, Errors, Double Plays, etc.). Some of you may be familiar with my work in this regard as I had put out a similar file for Lahman DB 4.5. This is no different.

I would like to thank Jeff Cato for providing me with SQL queries when I did this for the 4.5 version. Without those queries, this update would not have been possible. I simply had to tweak some things to fit the new DB format. Anyways, thank you very much Jeff.

As for the file (about 665 kb), download it here: http://www.ap4e.com/CareerAvgFielding.zip

There is only the csv file, overwrite the original one and you are good to go. Give me some feed back on this and spread the word, as quite a few people would like this but may or may not understand what I explained above.

Hope you guys find it as useful as I do...

Dargone · 03-10-2003, 11:55 PM

Awesome! Thank you Ankit, this is much sooner than I thought. Just in time for my replay league

doubles · 03-11-2003, 12:11 AM

Great news, thanks for your work Ankit. Much appreciated

Steve Kuffrey · 03-11-2003, 12:26 AM

I may have to start a historical league if this keeps up. Thanks for your hard work.

Carlton · 03-11-2003, 12:32 AM

thanks Ankit, we always appreciate your work

Carlton · 03-11-2003, 12:40 AM

do we overwrite the FIELDING.CSV file?

Carlton · 03-11-2003, 12:41 AM

sorry hit reply too soon

because there is a fieldingOF.csv in version 5.0

Kane182 · 03-11-2003, 01:45 AM

bump...Looking for the answer as well

darkhorse · 03-11-2003, 05:17 AM

Thanks for your work, Ankit. I imported the 1985 season and while there are fewer errors, I still see fielding percentages that are incorrect and range factors that don't jibe with the data. Jose Canseco importing as an A range RF with a fielding percentage .012 higher than his career numbers.

Another weird thing I noticed was Larry Parrish importing with the correct positions, 3B and RF, yet the game had him playing at 2B, a position he wasn't rated for. The Rangers had 2B on their ML roster, so that wasn't the problem.

Again, thanks for your fine work. I hope the OOTP5 Lahman import is improved with the two updates Markus has planned for the game.

Ankit · 03-11-2003, 07:57 AM

Quote:

Originally posted by Carlton
do we overwrite the FIELDING.CSV file?

Yes, overwrite the FIELDING.CSV file.

Ankit · 03-11-2003, 08:02 AM

Quote:

Originally posted by darkhorse
Thanks for your work, Ankit. I imported the 1985 season and while there are fewer errors, I still see fielding percentages that are incorrect and range factors that don't jibe with the data. Jose Canseco importing as an A range RF with a fielding percentage .012 higher than his career numbers.

Another weird thing I noticed was Larry Parrish importing with the correct positions, 3B and RF, yet the game had him playing at 2B, a position he wasn't rated for. The Rangers had 2B on their ML roster, so that wasn't the problem.

Again, thanks for your fine work. I hope the OOTP5 Lahman import is improved with the two updates Markus has planned for the game.

The reason the fielding percentages are different is due to rounding and averaging of the other numbers. I will try to correct this today and put up a new one if possible. Range is assigned randomly by the game, import him again, and he will get another range rating... As for Larry Parrish playing at 2B, thats up to the CPU manager, nothing I can fix with the file, obviously.

rwd59 · 03-11-2003, 09:34 AM

I have seen a number of people who are listed for a position that they have no fielding ratings for. This is something new to V5 as I never had that happen in V4. Steve, Markus, any idea why?

Vida Blue · 03-11-2003, 09:45 AM

Thanks Ankit! Your hard work is always appreciated.

bernstde4 · 03-11-2003, 09:49 AM

thanks Ankit, this is great... now I can import the players at their real positions!

darkhorse · 03-11-2003, 10:09 AM

Quote:

Originally posted by rwd59
I have seen a number of people who are listed for a position that they have no fielding ratings for. This is something new to V5 as I never had that happen in V4. Steve, Markus, any idea why?

Aye, that is why I mentioned it to Ankit. It was the first time I had ever seen a team in OOTP place a player in a position they weren't rated for when there was another player on the roster who was rated there.

Didn't know others had seen this phenomenon.

darkhorse · 03-11-2003, 10:16 AM

Quote:

Originally posted by Ankit
The reason the fielding percentages are different is due to rounding and averaging of the other numbers. I will try to correct this today and put up a new one if possible. Range is assigned randomly by the game, import him again, and he will get another range rating... As for Larry Parrish playing at 2B, thats up to the CPU manager, nothing I can fix with the file, obviously.

I've seen a a pretty decent percentage of players import with a range factor that would approximate their career data at baseballreference. But as you mention, I've also seen some players have fluctuations with seperate imports.

If range factors are assigned totally random, that is a dismaying thought. I'd have hoped for much more with the Lahman defensive import with OOTP5.

JimiP · 03-11-2003, 10:40 AM

This is a beautiful thing, exactly wehat i believed was needed.
I cannot thank you enuf for this - and hope the Reds do well in BOS this year !

chef

Larry_Rinker · 03-11-2003, 12:37 PM

..

Yes, great fix. Haven't checked it yet but here's hoping Omar Vizquel's fielding rating is improved from the "D" it is in the current Lehman.

We are entirely biased here in Cleveland but, watching him day in and day out for the last 9 years or so, he really is the greatest fielding shortstop in the history of the game of baseball.

LR

..

Bluenoser · 03-11-2003, 02:49 PM

Any chance this thread can be moved to the "MOD" forum before it gets buried on this forum?

hamonrye · 03-13-2003, 04:54 AM

i'm using the evaluation version of winzip wizard. after i unzipped the ankit download, i now have a careeravgfielding file, a fielding file and a fieldingof file within my stats folder. i haven't tried it yet to see if it works, but it doesn't appear to have overwritten anything, just created a new listing within the folder. does the file need to have the same name as what it's overwriting, or does it recognize the data? i don't know much about this kind of thing, as you may be able to tell.

i would appreciate any feedback as to how exactly this is supposed to be done. i would love to use the database ankit created to get accurate historical fielding.

03-10-2003, 11:51 PM	#1
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	Career Fielding Averages file for Lahman DB 5.0 now available. I know a lot of you have been dissatisfied with the way OOTP 5 assigns fielding ratings to players that are imported from Lahman DB 5.0. I have created a new fielding.csv file which has the career average fielding data for each player. So now, when you import Jimmy Foxx as a rookie, he won't import as a C, but will have ratings for both 1B and 3B. His fielding percentage will be his lifetime career average at that positions as will his other information (Games, Putouts, Assists, Errors, Double Plays, etc.). Some of you may be familiar with my work in this regard as I had put out a similar file for Lahman DB 4.5. This is no different. I would like to thank Jeff Cato for providing me with SQL queries when I did this for the 4.5 version. Without those queries, this update would not have been possible. I simply had to tweak some things to fit the new DB format. Anyways, thank you very much Jeff. As for the file (about 665 kb), download it here: http://www.ap4e.com/CareerAvgFielding.zip There is only the csv file, overwrite the original one and you are good to go. Give me some feed back on this and spread the word, as quite a few people would like this but may or may not understand what I explained above. Hope you guys find it as useful as I do... __________________

03-10-2003, 11:55 PM	#2
Dargone Hall Of Famer Join Date: Feb 2002 Location: Interwebs Posts: 2,862	Awesome! Thank you Ankit, this is much sooner than I thought. Just in time for my replay league __________________ I was never one to patiently pick up broken fragments and glue them together again and tell myself that the mended whole was as good as new. What is broken is broken -- and I'd rather remember it as it was at its best than mend it and see the broken places as long as I lived.-Margaret Mitchell

03-11-2003, 12:26 AM	#4
Steve Kuffrey Administrator Join Date: Jul 1999 Location: S.E. TN - Georgia born and raised Posts: 17,035	I may have to start a historical league if this keeps up. Thanks for your hard work. __________________ Steve Kuffrey DABS Atlanta Braves - 2008 Eastern Division Champ *DBLC Atlanta Braves - 2011, 2014 East Division Champ, 2012, 2013 NL Wildcard Baseball Maelstrom-Montreal Expos-2013 Tourney winner, 2014 WC Team Sparky's League - Tampa Bay D'Rays Epicenter Baseball League - Astros 2014 The CBL Rewind - Phillies '95

03-11-2003, 12:32 AM	#5
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	thanks Ankit, we always appreciate your work __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

03-11-2003, 12:40 AM	#6
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	do we overwrite the FIELDING.CSV file? __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

03-11-2003, 12:11 AM	#3
doubles Major Leagues Join Date: Dec 2001 Posts: 485	Great news, thanks for your work Ankit. Much appreciated

03-11-2003, 12:41 AM	#7
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	sorry hit reply too soon because there is a fieldingOF.csv in version 5.0 __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

03-11-2003, 01:45 AM	#8
Kane182 Minors (Triple A) Join Date: Feb 2003 Location: Quincy, MA Posts: 230	bump...Looking for the answer as well

03-11-2003, 05:17 AM	#9
darkhorse Hall Of Famer Join Date: May 2002 Location: fort worth, tx Posts: 10,850	Thanks for your work, Ankit. I imported the 1985 season and while there are fewer errors, I still see fielding percentages that are incorrect and range factors that don't jibe with the data. Jose Canseco importing as an A range RF with a fielding percentage .012 higher than his career numbers. Another weird thing I noticed was Larry Parrish importing with the correct positions, 3B and RF, yet the game had him playing at 2B, a position he wasn't rated for. The Rangers had 2B on their ML roster, so that wasn't the problem. Again, thanks for your fine work. I hope the OOTP5 Lahman import is improved with the two updates Markus has planned for the game. __________________ "The Human Torch was denied a bank loan."

03-11-2003, 09:34 AM	#12
rwd59 All Star Reserve Join Date: Dec 2001 Location: LA (Lower Alabama) Posts: 964	Steve,Markus? I have seen a number of people who are listed for a position that they have no fielding ratings for. This is something new to V5 as I never had that happen in V4. Steve, Markus, any idea why?

03-11-2003, 09:45 AM	#13
Vida Blue Major Leagues Join Date: Dec 2001 Location: Greater Reich of Ontario Posts: 324	Thanks Ankit! Your hard work is always appreciated. __________________ "The only way I'm going to get a Gold Glove is with a can of spray paint." - Reggie Jackson

03-11-2003, 09:49 AM	#14
bernstde4 Minors (Rookie Ball) Join Date: Jul 2002 Posts: 37	thanks Ankit, this is great... now I can import the players at their real positions!

03-11-2003, 10:40 AM	#17
JimiP Minors (Triple A) Join Date: Dec 2001 Location: Lowcountry SC Posts: 226	Thanks Ankit ! This is a beautiful thing, exactly wehat i believed was needed. I cannot thank you enuf for this - and hope the Reds do well in BOS this year ! chef __________________ Love, Peace & Chicken Grease, chef jimiP

03-11-2003, 12:37 PM	#18
Larry_Rinker Bat Boy Join Date: Jan 2002 Posts: 4	.. Yes, great fix. Haven't checked it yet but here's hoping Omar Vizquel's fielding rating is improved from the "D" it is in the current Lehman. We are entirely biased here in Cleveland but, watching him day in and day out for the last 9 years or so, he really is the greatest fielding shortstop in the history of the game of baseball. LR ..

03-11-2003, 02:49 PM	#19
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: In The Moment Posts: 14,481	Any chance this thread can be moved to the "MOD" forum before it gets buried on this forum?

03-13-2003, 04:54 AM	#20
hamonrye Major Leagues Join Date: Sep 2002 Posts: 335	i'm using the evaluation version of winzip wizard. after i unzipped the ankit download, i now have a careeravgfielding file, a fielding file and a fieldingof file within my stats folder. i haven't tried it yet to see if it works, but it doesn't appear to have overwritten anything, just created a new listing within the folder. does the file need to have the same name as what it's overwriting, or does it recognize the data? i don't know much about this kind of thing, as you may be able to tell. i would appreciate any feedback as to how exactly this is supposed to be done. i would love to use the database ankit created to get accurate historical fielding.