All Time Database

BridgeGoth · 05-02-2021, 05:09 PM

So this is a multi part question:

1: Is there a database that I can import into historical leagues that contain every player?
For example: When I do "Use random players from all eras instead of real rosters", those players and seasons have to come from some where, but where? And it it possible to compile it?

2: If this database does exist, would it also be possible to include every year from every player's career? For example, there would be 23 Greg Madduxes, one for each season of his career, with the strongest ones being when his age corresponded to the 1994 and 1995 seasons.

3: Assuming #1 and #2 are true or possible to be true: Would exporting a roster from every season I want to combine into a text file, then manually pasting each season's roster into the same text file and then import it into a new league, do the trick?
I tested this with just one season and I found two problems: First the old rosters weren't cleared, is there a way to clear the erase all the players in the league and start over with a new imported file? Secondly, I exported 1920 then imported it into 2021, and all the players were over 100 years old. I am not sure if that will cause a problem down the line, but it just looks silly if nothing else.

With that said, if this database is able to be build, I'd be happy to do it, assuming it isn't going to take hundreds of hours of labor. I think it would be really exciting to see every player from the history of the game in the same league.

Any help or suggestions anyone can give will be greatly apprecaited.

Thanks!

3fbrown · 05-02-2021, 09:20 PM

Unfortunately the big database file is not one you can easily edit. Which is too bad, because I have ways that I would love to tweak the file (and I did in the past when it was a regular CSV file). I have not heard about anyone "hacking" the database file, so at the very least it is unfortunately difficult, if not impossible.

Your plan could be implemented manually, but it would take a LONG time. I know importing players individually can be done such that they are whatever age you want them to be. (You put in the year you want to import them, so if you import Greg Maddux from 1995, he will be 30 or whatever age he was that year, even if your league is in 1901 or 2284.) I do not know if you can do that when importing an entire team/league, as I have not done that. Doing this manually will take a LONG time, I'm pretty sure it would be your dreaded hundreds of hours.

I can not guarantee this will work, it might be possible for you to get an old version of the game where the database file *was* just an ordinary CSV that you could easily edit. I know, as I did it back in the day. If that is possible, then as long as you were OK with OOTP8 or whatever old version, it may work. But that is only if such a version is available on the website, would work on whatever OS you have, and doesn't require a license.

Does anyone else know of a way to do this without extraordinary amounts of manual input?

BridgeGoth · 05-03-2021, 04:06 PM

My hope was that I could get a file in spreadsheet from that I could easily mass edit in Excel or a similar program, doesn't sound like that's going to be the case.

So what do you mean about 1995 Maddux always being 30? When imported the full 1920 rosters to 2021 they were all 120+ years old, what would be different? And how do I impliment what you were suggesting?

Elysian Fields · 05-03-2021, 07:32 PM

Quote:

Originally Posted by 3fbrown

Unfortunately the big database file is not one you can easily edit. Which is too bad, because I have ways that I would love to tweak the file (and I did in the past when it was a regular CSV file). I have not heard about anyone "hacking" the database file, so at the very least it is unfortunately difficult, if not impossible.

Your plan could be implemented manually, but it would take a LONG time. I know importing players individually can be done such that they are whatever age you want them to be. (You put in the year you want to import them, so if you import Greg Maddux from 1995, he will be 30 or whatever age he was that year, even if your league is in 1901 or 2284.) I do not know if you can do that when importing an entire team/league, as I have not done that. Doing this manually will take a LONG time, I'm pretty sure it would be your dreaded hundreds of hours.

I can not guarantee this will work, it might be possible for you to get an old version of the game where the database file *was* just an ordinary CSV that you could easily edit. I know, as I did it back in the day. If that is possible, then as long as you were OK with OOTP8 or whatever old version, it may work. But that is only if such a version is available on the website, would work on whatever OS you have, and doesn't require a license.

Does anyone else know of a way to do this without extraordinary amounts of manual input?

It takes some time, but what most people have done in the past is to create notepad files with lists of players you want to upload into the game. You have to do some research to create the lists one player at a time, but once that is done you can just upload the notepad file and it will read the .csv historical file and loads those players.

Most players use their Baseball Reference filing name, but a few are different and need to be looked at in the .csv file.

I wish you could upload everyone at once, that would be something.

pstrickert · 05-03-2021, 11:38 PM

I edited a Lahman file that includes everyone who played in the major leagues through 2020. This file now consists of the player ID, full name, debut season, and final season. Close to 20,000 players. I'll attach a zip file with .csv and .txt files. Presumably, you could use this data to create a text file to import into OOTP. You would need at a minimum the player ID and import year. If you don't specify a team abbreviation, the player goes into the Free Agent pool. The hard part would be creating separate entries for each season the player played (if that's what you wanted to do).

BridgeGoth · 05-04-2021, 04:19 PM

Thanks! I'll play around with this today and see what I can do

How will the game know which season to put the player in?

If i start in 2021 will Ty Cobb be 130 years old?

pstrickert · 05-04-2021, 05:25 PM

If you're importing a group of players via text file, you'll need to include a season for each one. How old was the player during that season? That's how old he'll be when you import him.

pstrickert · 05-04-2021, 05:27 PM

For example:

aaronha01,1956

Hank Aaron was 22 years old in 1956. He'll be 22 when you import him into the game.

BridgeGoth · 05-06-2021, 03:54 AM

Quote:

Originally Posted by pstrickert

For example:

aaronha01,1956

Hank Aaron was 22 years old in 1956. He'll be 22 when you import him into the game.

That sounds pretty straight forward, so will the following things be true?

A: Hank Aaron 1956 as written, will be 22 whether it's 1888 or 1988?

B: Hank Aaron 1956 will be rated based on his stats in 1956

C: Hank Aaron 1956 would be different from all Aarons

If all I have to do is designate a year, that's not hard at all.

I'd just have to put the year after the ID, rinse and repeat a whole hell of a lot of times?

pstrickert · 05-06-2021, 11:27 AM

A. Yes
B. Yes, if you choose to base ratings on import season (which is the default)
C. Yes

You can have a Hank Aaron for each of his 23 seasons, if you wish.

sprague · 05-06-2021, 12:00 PM

Quote:

Originally Posted by pstrickert

A. Yes
B. Yes, if you choose to base ratings on import season (which is the default)
C. Yes

You can have a Hank Aaron for each of his 23 seasons, if you wish.

I just had to tell you how great that database tool you made above is...right there is every player, their lehman id and their debut year.
This is an extremely helpful document.
Wanted to say thanks for making it, and for sharing it

BridgeGoth · 05-06-2021, 03:31 PM

This sound like a huge project, but one I might try to tackle, making a database of all seasons ever, or a database of the top players in their best seasons.

On my Twitch, I programmed over 2000 players into my FUNtoon chatbot, which it gives out randomly, so I could use more or less the same player list I think and it would come out good.

There is so much potential here, I just have to find the time, the energy, and hopefully the skills to not butcher this!

sgtpep · 09-22-2021, 09:34 PM

Quote:

Originally Posted by pstrickert

If you're importing a group of players via text file, you'll need to include a season for each one. How old was the player during that season? That's how old he'll be when you import him.

Is there any way to import a player's entire career? Looking to have players perform at their career average rather than an All-Star year.

05-04-2021, 04:19 PM	#6
BridgeGoth Minors (Rookie Ball) Join Date: Apr 2018 Posts: 43	Thanks! I'll play around with this today and see what I can do How will the game know which season to put the player in? If i start in 2021 will Ty Cobb be 130 years old? Last edited by BridgeGoth; 05-04-2021 at 04:22 PM.

05-02-2021, 05:09 PM	#1
BridgeGoth Minors (Rookie Ball) Join Date: Apr 2018 Posts: 43	All Time Database So this is a multi part question: 1: Is there a database that I can import into historical leagues that contain every player? For example: When I do "Use random players from all eras instead of real rosters", those players and seasons have to come from some where, but where? And it it possible to compile it? 2: If this database does exist, would it also be possible to include every year from every player's career? For example, there would be 23 Greg Madduxes, one for each season of his career, with the strongest ones being when his age corresponded to the 1994 and 1995 seasons. 3: Assuming #1 and #2 are true or possible to be true: Would exporting a roster from every season I want to combine into a text file, then manually pasting each season's roster into the same text file and then import it into a new league, do the trick? I tested this with just one season and I found two problems: First the old rosters weren't cleared, is there a way to clear the erase all the players in the league and start over with a new imported file? Secondly, I exported 1920 then imported it into 2021, and all the players were over 100 years old. I am not sure if that will cause a problem down the line, but it just looks silly if nothing else. With that said, if this database is able to be build, I'd be happy to do it, assuming it isn't going to take hundreds of hours of labor. I think it would be really exciting to see every player from the history of the game in the same league. Any help or suggestions anyone can give will be greatly apprecaited. Thanks!

05-02-2021, 09:20 PM	#2
3fbrown Major Leagues Join Date: May 2008 Posts: 414	Unfortunately the big database file is not one you can easily edit. Which is too bad, because I have ways that I would love to tweak the file (and I did in the past when it was a regular CSV file). I have not heard about anyone "hacking" the database file, so at the very least it is unfortunately difficult, if not impossible. Your plan could be implemented manually, but it would take a LONG time. I know importing players individually can be done such that they are whatever age you want them to be. (You put in the year you want to import them, so if you import Greg Maddux from 1995, he will be 30 or whatever age he was that year, even if your league is in 1901 or 2284.) I do not know if you can do that when importing an entire team/league, as I have not done that. Doing this manually will take a LONG time, I'm pretty sure it would be your dreaded hundreds of hours. I can not guarantee this will work, it might be possible for you to get an old version of the game where the database file was just an ordinary CSV that you could easily edit. I know, as I did it back in the day. If that is possible, then as long as you were OK with OOTP8 or whatever old version, it may work. But that is only if such a version is available on the website, would work on whatever OS you have, and doesn't require a license. Does anyone else know of a way to do this without extraordinary amounts of manual input?

05-03-2021, 04:06 PM	#3
BridgeGoth Minors (Rookie Ball) Join Date: Apr 2018 Posts: 43	My hope was that I could get a file in spreadsheet from that I could easily mass edit in Excel or a similar program, doesn't sound like that's going to be the case. So what do you mean about 1995 Maddux always being 30? When imported the full 1920 rosters to 2021 they were all 120+ years old, what would be different? And how do I impliment what you were suggesting?

05-04-2021, 05:25 PM	#7
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 16,466	If you're importing a group of players via text file, you'll need to include a season for each one. How old was the player during that season? That's how old he'll be when you import him.

05-04-2021, 05:27 PM	#8
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 16,466	For example: aaronha01,1956 Hank Aaron was 22 years old in 1956. He'll be 22 when you import him into the game.

05-06-2021, 11:27 AM	#10
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 16,466	A. Yes B. Yes, if you choose to base ratings on import season (which is the default) C. Yes You can have a Hank Aaron for each of his 23 seasons, if you wish.

05-06-2021, 03:31 PM	#12
BridgeGoth Minors (Rookie Ball) Join Date: Apr 2018 Posts: 43	This sound like a huge project, but one I might try to tackle, making a database of all seasons ever, or a database of the top players in their best seasons. On my Twitch, I programmed over 2000 players into my FUNtoon chatbot, which it gives out randomly, so I could use more or less the same player list I think and it would come out good. There is so much potential here, I just have to find the time, the energy, and hopefully the skills to not butcher this!