Spritze DB's for OOTP11

[Spritze]

Put it in the Stats folder.

You can delete the dups of course, in game.

[Germaniac]

Thanks a lot

I'll try it as soon as I get home after work

[Spritze]

Randon db for OOTP12 available. PM me for the ftp link.

I made 20 different ones but only put up one. If it plays OK I'll put up the rest.

I used the posted instructions and it was really easy to roll them out.

I do note that while these db's are based on neutered stats, due to the huge difference in errors and passed balls through the years (1871-2010) 19th century players get screwed fieldingwise.

If the majority think it advisable I might neutralize those two fielding stats before running the randomizer.

Pitching and Batting are both neutered to the std 750 run environment.

[Spritze]

A second Random DB is Up on the FTP site. It is another full set 1871-2010 and beyond.

Is there a clamoring for a 1901-2010 and beyond version? It would have all the usual suspects available just with the first 30 years chopped off.

How about a 1951-1960 version. That would compress all the players to a single decade.

A Spritze HS Random db is what I plan on next though.

[Spritze]

Originally Posted by Spritze

A Spritze HS Random db is what I plan on next though.

Done and uploaded to the ftp site.

[thehef]

The Gambo and Spritze db's include quite a few Negro League players and they do have stats associated with them... Either view the master.csv to get a players ID and import them into your league or just use either of our databases.

In looking at one of the Gambo/Spritze db's, I find that 7,355 records in the Master.csv file have a Null value in the playerid field (these all appear to be non-major leaguers). So, 1) I don't see how they could be imported into OOTP without a playerid, and 2) I don't see how they could be linked to records in the various batting, pitching, fielding files.

Can anyone explain? Thanks

[thehef]

To partially answer my own question above, it appears that a difference between db's is that Gambo/Spritze db w/ Transactions for OOTP12 has the Negro and Minor League players among the 7,355 records with a NULL playerid field, whereas the Gambo/Spritze db for OOTP12 has mostly only Asians (and coaches & managers) with NULL playerid values.

Not exactly sure why this is, but it appears that if you want additional players (negros & minor leaguers), and want professional rather than high school debuts, then Gambo/Spritze db for OOTP12 is the way to go... I think...

Relating this to another thread (modded db's & historical transactions), I am thinking of taking the in-game neutered csv files (I believe those are the ones that include a "2" in the filename), and adding some players from Gambo/Spritze db for OOTP12 in order to have some extra players (imported as FA's) to fill out some independent teams, whereas my Major Leagues would sail right along using historical transactions.

I trust that Spritze and/or some other experts in the field (or on the couch) will let me know if I am on the right track for doing this... Thanks

[Bristolduke]

The largest difference, (I believe), is that Spritze HS creates every historical player to start at age 18, which alters what year they arrive. He is not adding HS players per se. The Gambo/Spritze does exclude the Asians and some minor leaguers, that Spritze includes in teh HS DB.

Remember, if you alter the *2 files then you must delete the database.odb file for the changes to take affect. I'm guessing (haven't tested this myself), that if you create a league with your newly created .csv files and select the historical transactions options, that it will still work even though the database.odb is not present.

In which case, you would get the result you are desiring - historical transactions for all but the negro league players.

[Spritze]

Originally Posted by Bristolduke

I'm guessing (haven't tested this myself), that if you create a league with your newly created .csv files and select the historical transactions options, that it will still work even though the database.odb is not present.

In which case, you would get the result you are desiring - historical transactions for all but the negro league players.

Yes, this is how it rolls.

[Spritze]

Originally Posted by thehef

Not exactly sure why this is, but it appears that if you want additional players (negros & minor leaguers), and want professional rather than high school debuts, then Gambo/Spritze db for OOTP12 is the way to go... I think...

This is a trueism. Gambo did the professional debuts for selected players. I does the debuts out of high school for everyone plus the high school drop outs plus the pregnant girlfriend scenarios. All me.

[Gambo]

Yep they are essentially the same database except mine uses professional debuts, real organizations as of opening day for each year and trims out most of the asians. (I pretty much stick to American leagues).

The asians that are included are those who played in the Majors or minors, those not from Asian countries and the top ~50 historically.

[thehef]

For the project I describe a few (5) posts above, what, if anything, would be required of the non-2.csv files (batting.csv, pitching.csv, fielding.csv, etc.)? If using Neutered stats, does the game at any point still reference the non-neutered files for anything (maybe for the Real Life Stats panel or something)?

Thanks

[soxman]

I'm trying to do a historical replay starting in 1901.

I've used both the Gambo/Spritze DB for OOTP12 and the Spritze High School DB but the problem I'm finding is that Lou Gehrig never seems to get imported.

Could anyone advise a solution?

Many Thanks

[Spritze]

Make sure you have the latest Spritze HS database. "Somebody" put quote marks and commas in birth/death city names and nicknames. Putting commas in a Comma Separated Values Files is a bit of a sticky wicket. The latest version has those removed. Only effects a very few players (less than 30), Gehrig is one of them.

[soxman]

I'm using the databases that are dated from July on Padresfan's site.

Are they the latest?

[thehef]

Originally Posted by thehef

For the project I describe (9) posts above, what, if anything, would be required of the non-2.csv files (batting.csv, pitching.csv, fielding.csv, etc.)? If using Neutered stats, does the game at any point still reference the non-neutered files for anything (maybe for the Real Life Stats panel or something)?

Just bumping my post from above...

[Spritze]

Originally Posted by soxman

I'm using the databases that are dated from July on Padresfan's site.

Are they the latest?

I don't know. PM me and I'll give you access to my ftp site. Them is for sure the latest.

[Spritze]

Originally Posted by thehef

For the project I describe a few (5) posts above, what, if anything, would be required of the non-2.csv files (batting.csv, pitching.csv, fielding.csv, etc.)? If using Neutered stats, does the game at any point still reference the non-neutered files for anything (maybe for the Real Life Stats panel or something)?

Thanks

The games does use both the regular and the neutered files even if you choose to base things neuterally.

I don't know the specifics (because it does not effect my database). I believe GAMBO does because it does affect his.

[Spritze]

New Random DB on the FTP Site

Compresses all players to debut between 1951 and 1970.

You wind up with a bunch of all star teams basically. Use an inaugural draft and make sure you have a lot of $$$. It is a 48 - team major league. 3 Divisions each. Just change the teams.csv if you don't like that.

[hfield007]

Originally Posted by Spritze

Here Be Read Me.

1889 = 19th century btw