Player Database question(s)

SandMan · 01-25-2005, 09:37 AM

I am thinking of making a fictional database of rookies to add to the current historical database I am using giving me a larger rookie class. I have a few questions though.

1. If I add only a rookie record to the database will this player not develop correctly? In other words does OOTP look at the whole career when importing a rookie from a database like Lahman's and creating the players ratings.

2. Does anyone have a utility to convert CommishJoes exporter CSV files into the lahman format? Not a big deal since I can put the records into Excel, move the columns to another table in correct order.

Why am I doing this? I would like to have a league with historical players but with more teams than the early years of MLB had. So I need to create more players and the players created by filling minors are not really ready to play at the major league level.

How am I doing this? I would like create a test league with 40 teams, have an initial draft of 15-20 players, delete all free agents, fill AAA twice (moving 1 group to AA). Then I would let the AI control all teams, Sim a season and export the stats, giving me about1500 or so players. I would then delete the records of players over the age of 30, giving me a rookie class. I then just take these player put them in the correct format (lahman's) and add these records to the database I am using. If I need more players to add to each season I would just redo the process, creating multiple test leagues to get my rookie class.

To get different years I would just need to edit the birth year and year of the record to reflect the players age at that season. If I wanted a player to start in 1942 and his age in my test league was 22. I would just change the birth year to 1922. Sounds simple enough to do.....Using Access and Excel.

To those that have created databases to use in the game, does this sound doable? or practical?

Ankit · 01-25-2005, 01:14 PM

OOTP does look at more than the initial year when assigning talent ratings. One season will not be enough. I recommend 4 or 5 seasons. It sounds practical but very complicated. It will definitely require a lot of time.

SandMan · 01-25-2005, 05:08 PM

Thanks for the information Ankit. I may still try this because once I have about 130+ seasons worth of rookies I could reuse this many times and use the originator to change the name once I have the players imported into the game so that I would not get to familiar with certain potential star players.

Again thanks....

01-25-2005, 09:37 AM	#1
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Player Database question(s) I am thinking of making a fictional database of rookies to add to the current historical database I am using giving me a larger rookie class. I have a few questions though. 1. If I add only a rookie record to the database will this player not develop correctly? In other words does OOTP look at the whole career when importing a rookie from a database like Lahman's and creating the players ratings. 2. Does anyone have a utility to convert CommishJoes exporter CSV files into the lahman format? Not a big deal since I can put the records into Excel, move the columns to another table in correct order. Why am I doing this? I would like to have a league with historical players but with more teams than the early years of MLB had. So I need to create more players and the players created by filling minors are not really ready to play at the major league level. How am I doing this? I would like create a test league with 40 teams, have an initial draft of 15-20 players, delete all free agents, fill AAA twice (moving 1 group to AA). Then I would let the AI control all teams, Sim a season and export the stats, giving me about1500 or so players. I would then delete the records of players over the age of 30, giving me a rookie class. I then just take these player put them in the correct format (lahman's) and add these records to the database I am using. If I need more players to add to each season I would just redo the process, creating multiple test leagues to get my rookie class. To get different years I would just need to edit the birth year and year of the record to reflect the players age at that season. If I wanted a player to start in 1942 and his age in my test league was 22. I would just change the birth year to 1922. Sounds simple enough to do.....Using Access and Excel. To those that have created databases to use in the game, does this sound doable? or practical?

01-25-2005, 01:14 PM	#2
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	OOTP does look at more than the initial year when assigning talent ratings. One season will not be enough. I recommend 4 or 5 seasons. It sounds practical but very complicated. It will definitely require a lot of time. __________________

01-25-2005, 05:08 PM	#3
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Thanks for the information Ankit. I may still try this because once I have about 130+ seasons worth of rookies I could reuse this many times and use the originator to change the name once I have the players imported into the game so that I would not get to familiar with certain potential star players. Again thanks....