OOTP Developments Forums - View Single Post

Comedian2004 · 05-02-2007, 06:16 PM

I crossed the line today. I took a unique angle to the database approach. Why design the database by hand when I can do it programmingly?

I have written some software that changes the Lahman database.

The plan is to have the program design the new database on factors that you change in my program. That will be further down the line, but in the meantime, I am going to release some databases to see how they work.

The first, what I did was load in the original database. The new database is JUST written with players that played anytime between 1990 and 1999. It basically changes all the years for the players to 1999. When you import the league in, you end up getting ALL of the players that played in the 1990s.

I have not figured out this thing completely yet, but this 1st version does create a league. While most of the players are on correct teams, I have not figured out yet why some players are not on a certain team. They may be on Boston instead of Detroit, when they played for both teams in the 1990s. That's ok, as I think the general idea for this would be for a fantasy draft league.

So, here is what you do to use this database. Download the zip file and unzip it to a folder like c:/1990s

Open up OOTP and create a new league. Pull the players from THIS database and use 1999 as the import year.

I would suggest:

Use the CAREER STATS for this type of league.
DO NOT import entire history.
DO NOT adjust players stats on each year
DO NOT use AUTO league expansion
Enter 1999 as the year to base the league on

Once the league is imported, release all players to free agency and have a fantasy draft. This would be a 1990s best of fantasy league.

Please help me out by examining the league and seeing if you can see how the teams are being filled.

I also want to modify it so that every one is 20 years old at import time, but I am having some problems with the master.csv file, as I think there is actually some bad data in the original Lahman database. The fields get out of whack for certain players.

You can download the database at: www.planetootp.com/AU1990s.zip - The file is just under 6 meg in size.

I will make one for each decade eventually. I also plan on making one for HOF players only and also one for every single player that ever played (with a min. number of at bats or IP). Could you imagion a fantasy draft with every player that ever played in the league?

I also envision a BEST TEAM type database. So, the league would consist of all the greatest players that ever played with DETROIT being on Detroit.

This program could open all sort of database possibilities.

If any of the current database creators would like to give me a hand in writing this program, please let me know.

05-02-2007, 06:16 PM	#1 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,398	Experimental Database I crossed the line today. I took a unique angle to the database approach. Why design the database by hand when I can do it programmingly? I have written some software that changes the Lahman database. The plan is to have the program design the new database on factors that you change in my program. That will be further down the line, but in the meantime, I am going to release some databases to see how they work. The first, what I did was load in the original database. The new database is JUST written with players that played anytime between 1990 and 1999. It basically changes all the years for the players to 1999. When you import the league in, you end up getting ALL of the players that played in the 1990s. I have not figured out this thing completely yet, but this 1st version does create a league. While most of the players are on correct teams, I have not figured out yet why some players are not on a certain team. They may be on Boston instead of Detroit, when they played for both teams in the 1990s. That's ok, as I think the general idea for this would be for a fantasy draft league. So, here is what you do to use this database. Download the zip file and unzip it to a folder like c:/1990s Open up OOTP and create a new league. Pull the players from THIS database and use 1999 as the import year. I would suggest: Use the CAREER STATS for this type of league. DO NOT import entire history. DO NOT adjust players stats on each year DO NOT use AUTO league expansion Enter 1999 as the year to base the league on Once the league is imported, release all players to free agency and have a fantasy draft. This would be a 1990s best of fantasy league. Please help me out by examining the league and seeing if you can see how the teams are being filled. I also want to modify it so that every one is 20 years old at import time, but I am having some problems with the master.csv file, as I think there is actually some bad data in the original Lahman database. The fields get out of whack for certain players. You can download the database at: www.planetootp.com/AU1990s.zip - The file is just under 6 meg in size. I will make one for each decade eventually. I also plan on making one for HOF players only and also one for every single player that ever played (with a min. number of at bats or IP). Could you imagion a fantasy draft with every player that ever played in the league? I also envision a BEST TEAM type database. So, the league would consist of all the greatest players that ever played with DETROIT being on Detroit. This program could open all sort of database possibilities. If any of the current database creators would like to give me a hand in writing this program, please let me know. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!