Spritze database still rules

[sprague]

Been playing since ootp 12, not as long as some here but long enough


I was trying out the new historical game that comes with the game and just still find it dissapointing because you are stuck with history exactly as it was played. I can't add minors, delete minors, move all the teams to 1 subleague, expand etc.
The player work has been great


Then I put in the spritze db...and the historical fun was back again. Yes the fielding ratings aren't as good as the new db, and sometimes a minor league player (esp pitchers) can be way over rated compared to a MLB player...but that just requires a few edits

The fact I can set up leagues and use the players that come in each year any way I want makes spritze still the hands down database winner for historical play


thanks again for all the work you put into it over the years...still a great way to play

[Rain King]

It has been a long time since I have used this database. Can you remind me how it is different than the one the game provides?

[treymancini]

You are allowed to do all that in historical though?

[Bluenoser]

Originally Posted by sprague

Been playing since ootp 12, not as long as some here but long enough


I was trying out the new historical game that comes with the game and just still find it dissapointing because you are stuck with history exactly as it was played. I can't add minors, delete minors, move all the teams to 1 subleague, expand etc.
The player work has been great


Then I put in the spritze db...and the historical fun was back again. Yes the fielding ratings aren't as good as the new db, and sometimes a minor league player (esp pitchers) can be way over rated compared to a MLB player...but that just requires a few edits

The fact I can set up leagues and use the players that come in each year any way I want makes spritze still the hands down database winner for historical play


thanks again for all the work you put into it over the years...still a great way to play

Put yourself in Commish mode and you can do all those things. Doesn't have to be spritze DB to edit league structure.

[David Watts]

Originally Posted by Bluenoser

Put yourself in Commish mode and you can do all those things. Doesn't have to be spritze DB to edit league structure.

I don't think you can. If you want to play historical using historical minors I'm almost 100% sure you're required to have the box for historical expansion checked as well This makes changing league structure impossible, as once the first season comes to an end, OOTP is going to delete any changes you made and reset the league to fit the historical setup.

[Bluenoser]

Originally Posted by David Watts

I don't think you can. If you want to play historical using historical minors I'm almost 100% sure you're required to have the box for historical expansion checked as well This makes changing league structure impossible, as once the first season comes to an end, OOTP is going to delete any changes you made and reset the league to fit the historical setup.

Ok, I get that. But changing which DB you use shouldn't enable/disable the ability to edit those features should it?

[sprague]

Right what David said, If you want to play with the database and get the whole gamit of minor league and negro players you are stuck with the structure of all the leagues exactly as it is,

You can't even change the team names...make any revisions and the next season it will all revert back to real history.
It is for that reason (even though the stats db that comes with the game is great) I want to have the option to mold my league as I want- I don't like so many minor leagues in the 1940's and 50's, I would like to have no subleagues, expand many times as more players become available.


With the spritze db it is just like the normal "non minors" db that lets you do what you want with the game structure.
There was a thread here long ago called "free the minor league database." I really hope that can happen one day, but until then, spritze still fires up and plays on ootp21...
By 1900 my MLB has 20 teams and a minor league and negro players are about to begin appearing

[Bluenoser]

Originally Posted by David Watts

I don't think you can. If you want to play historical using historical minors I'm almost 100% sure you're required to have the box for historical expansion checked as well This makes changing league structure impossible, as once the first season comes to an end, OOTP is going to delete any changes you made and reset the league to fit the historical setup.

My understanding is he wants to edit the minors, so that's not using historical minors, that's fictional.

I started an historical league and have no problem changing those options. I am also able to edit league structure.

Automatic expansion can be disabled, as can real minors. This doesn't require one to use spritze db.

[Bluenoser]

Originally Posted by sprague

Right what David said, If you want to play with the database and get the whole gamit of minor league and negro players you are stuck with the structure of all the leagues exactly as it is,

You can't even change the team names...make any revisions and the next season it will all revert back to real history.
It is for that reason (even though the stats db that comes with the game is great) I want to have the option to mold my league as I want- I don't like so many minor leagues in the 1940's and 50's, I would like to have no subleagues, expand many times as more players become available.


With the spritze db it is just like the normal "non minors" db that lets you do what you want with the game structure.
There was a thread here long ago called "free the minor league database." I really hope that can happen one day, but until then, spritze still fires up and plays on ootp21...
By 1900 my MLB has 20 teams and a minor league and negro players are about to begin appearing

Right, but what you're doing isn't an historical league, it's fictional historical. That can be done with either db.

[David Watts]

Originally Posted by Bluenoser

My understanding is he wants to edit the minors, so that's not using historical minors, that's fictional.

I started an historical league and have no problem changing those options. I am also able to edit league structure.

Automatic expansion can be disabled, as can real minors. This doesn't require one to use spritze db.

Sure you can create a a straight up historical league and edit to your hearts content. But, take a look at the historical league you created. Is there a single player available that didn't play in the MLB the year you created? The OP wants access to minor league players and Negro League players. Right now, the only way to gain that access is to use the Historical Minors feature/DB. In the past, folks would use the Spritze DB, because players made their debuts at a younger age than their MLB debut year which is used by the OOTP db. For example, if you used Spritze's db, Dale Murphy might import in 1974 at the age of 18, while the OOTP db will have him debut in 1976 at the age of 20.

[BaseballMan]

I cant speak about minor leagues but as far as the majors,
my leagues follow the real mlb expansion with rookies going to the correct teams.
I don't know if i would even bother with minors before 1903. Its hard enough to get accurate data on the major leagues of the time.

[Bluenoser]

Originally Posted by David Watts

Sure you can create a a straight up historical league and edit to your hearts content. But, take a look at the historical league you created. Is there a single player available that didn't play in the MLB the year you created? The OP wants access to minor league players and Negro League players. Right now, the only way to gain that access is to use the Historical Minors feature/DB. In the past, folks would use the Spritze DB, because players made their debuts at a younger age than their MLB debut year which is used by the OOTP db. For example, if you used Spritze's db, Dale Murphy might import in 1974 at the age of 18, while the OOTP db will have him debut in 1976 at the age of 20.

I get what you're saying. However, what the OP said, according to his initial post, was that he wants to add minors, delete minors, move teams, and expand.

Those are the things I'm referring to.

[David Watts]

Originally Posted by Bluenoser

I get what you're saying. However, what the OP said, according to his initial post, was that he wants to add minors, delete minors, move teams, and expand.

Those are the things I'm referring to.

I can't disagree with what you just said. I think I may have just understood where he was coming from without him having to actually say "historical minors."

[sprague]

David and Blue are both correct


I want to be able to use the historical minors database- have access to ALL the players both minor and major
But use them in a fictional set up if I wanted to. Change minors, majors, edit team names, add teams etc.
I can only do that and get the total package of players with Spritze DB, hence the reason I made the thread to say that for me it still rules-
But if the historical minors DB is allowed to be open- we can follow real history or make our own set up, then I would have to redo a thread and then claim the DB with the game moves to #1

[quillenl]

Originally Posted by sprague

David and Blue are both correct


I want to be able to use the historical minors database- have access to ALL the players both minor and major
But use them in a fictional set up if I wanted to. Change minors, majors, edit team names, add teams etc.
I can only do that and get the total package of players with Spritze DB, hence the reason I made the thread to say that for me it still rules-
But if the historical minors DB is allowed to be open- we can follow real history or make our own set up, then I would have to redo a thread and then claim the DB with the game moves to #1

You can do this via importing players from the minor league database, but it takes a bit of extra work (a lot) and still has some irritating bugginess despite Markus doing a lot to try and improve it just after 21's release.

I set up an Excel database so I can easily import players by year of their debut. You can set up your minors however you want doing it that way. Was an issue doing this in previous versions as players would import as fragile across the board. While the fragile issue was resolved there continues to be problems with service time on import so I gave up on it. It's doable though if you come across Spritze database issues that are game-breaking to you (I did but don't even remember what it was right now beyond having to do with new fields added in OOTP XX or 19).

[sprague]

Originally Posted by quillenl

You can do this via importing players from the minor league database, but it takes a bit of extra work (a lot) and still has some irritating bugginess despite Markus doing a lot to try and improve it just after 21's release.

I set up an Excel database so I can easily import players by year of their debut. You can set up your minors however you want doing it that way. Was an issue doing this in previous versions as players would import as fragile across the board. While the fragile issue was resolved there continues to be problems with service time on import so I gave up on it. It's doable though if you come across Spritze database issues that are game-breaking to you (I did but don't even remember what it was right now beyond having to do with new fields added in OOTP XX or 19).

Do you have excel files for every year of player entry from the database?
If so would you be willing to share them, I would love to try them out if I could have my own league but bring in all the draft eligible players each year

[quillenl]

Info below as requested, but please remember I stopped using these because of severe service time issues with this method.

https://www.dropbox.com/s/tb9wjjcirp...aster.csv?dl=0

https://www.dropbox.com/scl/fi/7qtez...4cha3it7qrk28n

Links above. Last messed with last summer so sent the master files. Had begun breaking up first by year, but stopped (it's easy) so linked the entire file.

First should be entire database after cleanup, second is a list of 60000 I'd worked down to make a more enjoyable random debut database. 60K players will get you 100 years worth of 20 round drafts for a 30 team league which is sufficient to me for 4 levels of minors.

For the first file (entire database). You can filter by the year you want to import (second column), then copy the first 2 rows into a csv file. Import that into your league's draft pool and you now have a full draft pool of everyone who debuted that year.

The second file all major league players and only those from the minor league who debuted in the minors at a relatively young age... and mostly after around 1960. That got the list of total players down to 59K for me. It isn't any good for year by year historical recreations but is great for random debut leagues where a smaller draft is desired (I am not a fan of 60 round drafts. The random debut is set by filtering by the 3rd column I added which consists of numbers 1 through 100. Each number provides 590 players for a draft pool.

First file sounds more like what you were looking for. Filter by year and copy to a csv file. First column is reference id and second is debut year. It's just a copy paste from this file into the one for import. If you have not used the import tool to import entire drafts before then that is a different conversation.

[sprague]

Originally Posted by quillenl

Info below as requested, but please remember I stopped using these because of severe service time issues with this method.

https://www.dropbox.com/s/tb9wjjcirp...aster.csv?dl=0

https://www.dropbox.com/scl/fi/7qtez...4cha3it7qrk28n

Links above. Last messed with last summer so sent the master files. Had begun breaking up first by year, but stopped (it's easy) so linked the entire file.

First should be entire database after cleanup, second is a list of 60000 I'd worked down to make a more enjoyable random debut database. 60K players will get you 100 years worth of 20 round drafts for a 30 team league which is sufficient to me for 4 levels of minors.

For the first file (entire database). You can filter by the year you want to import (second column), then copy the first 2 rows into a csv file. Import that into your league's draft pool and you now have a full draft pool of everyone who debuted that year.

The second file all major league players and only those from the minor league who debuted in the minors at a relatively young age... and mostly after around 1960. That got the list of total players down to 59K for me. It isn't any good for year by year historical recreations but is great for random debut leagues where a smaller draft is desired (I am not a fan of 60 round drafts. The random debut is set by filtering by the 3rd column I added which consists of numbers 1 through 100. Each number provides 590 players for a draft pool.

First file sounds more like what you were looking for. Filter by year and copy to a csv file. First column is reference id and second is debut year. It's just a copy paste from this file into the one for import. If you have not used the import tool to import entire drafts before then that is a different conversation.

Thanks for posting this.
I am going to give this a go and see what comes from trying it out


Just curious what is the service time issue that comes with using the files?

[quillenl]

Some players were generating with like 20 years of service time. This makes them eligible for free agency almost immediately depending on where your draft is relative to Free Agency. Beyond just being annoying, the AI couldn't handle it and was allowing top prospects to walk right off the bat.

My thought when I saw this was that it was related to the players real life data in the minor league database and the year the game was set. So a player who played in the 1920s would show up with decades of service time when my league was set in the 70s. Figured it should not be an issue if I just had players debut the year they should have, or much earlier (like set game year to 1850 for my league) but never tested it since I was only interested in random debut and something new had caught my attention and time.

Been a bit, and this is from memory. Worked on this with intention of starting an Online League with Real Minor League players and random debut drafts and forgot about it till your post so I am sure I am missing an important bit somewhere

[wbcfan]

Ok I'm still pretty new, but want to play histrorical league and have access to foreign players in the KBO, Cuban League, *** and was told this would allow it. I have no idea what it is and how would I go about loading it up? I'm on ootp 21. Thanks.