Spritze DB's for OOTP11 - Page 21

Spritze · 11-18-2011, 08:34 AM

Put it in the Stats folder.

You can delete the dups of course, in game.

Germaniac · 11-18-2011, 09:00 AM

Thanks a lot

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

Spritze · 11-25-2011, 01:46 PM

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 · 11-28-2011, 12:48 AM

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 · 12-10-2011, 12:18 PM

Quote:

Originally Posted by Spritze

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

Done and uploaded to the ftp site.

thehef · 12-21-2011, 04:33 AM

Quote:

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 · 12-21-2011, 12:23 PM

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 (http://www.ootpdevelopments.com/boar...nsactions.html), 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 · 12-21-2011, 01:16 PM

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 · 12-21-2011, 01:21 PM

Quote:

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 · 12-21-2011, 01:25 PM

Quote:

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 · 12-21-2011, 08:43 PM

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 · 12-24-2011, 03:09 PM

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 · 12-29-2011, 05:36 AM

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 · 12-29-2011, 11:00 AM

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 · 12-29-2011, 11:04 AM

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

Are they the latest?

thehef · 12-29-2011, 12:32 PM

Quote:

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 · 12-29-2011, 01:44 PM

Quote:

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 · 12-29-2011, 01:49 PM

Quote:

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 · 01-21-2012, 05:45 PM

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 · 01-26-2012, 10:17 AM

Quote:

Originally Posted by Spritze

Here Be Read Me.

1889 = 19th century btw

11-18-2011, 08:34 AM	#401
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Put it in the Stats folder. You can delete the dups of course, in game. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

11-18-2011, 09:00 AM	#402
Germaniac Hall Of Famer Join Date: Apr 2011 Location: Frankenthal, Germany Posts: 3,086	Thanks a lot I'll try it as soon as I get home after work __________________ I'm going to have to meet my Maker some day. And if He asks me why I didn't let this boy play, and I say it's because he's black, that might not be a satisfactory answer. Happy Chandler, 1947

11-25-2011, 01:46 PM	#403
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Spritze Random DB's available 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. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

11-28-2011, 12:48 AM	#404
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	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. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-21-2011, 01:16 PM	#408
Bristolduke All Star Starter Join Date: May 2006 Posts: 1,420	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. __________________ Commish of the Home Nations Baseball Association Commish of the Baseball Association League Commish of the League of WAR Commish of the On-Line Dynasty League SIMBL2 - Westbury Cannons Great Lakes Baseball - Toledo Neptunes World Baseball - Guantanamo Marines OMLB - Cincinnati Reds

12-21-2011, 12:23 PM	#407
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,361	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 (http://www.ootpdevelopments.com/boar...nsactions.html), 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

12-21-2011, 08:43 PM	#411
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	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. __________________ *Give me league evolution with historical imports!!!* OOTP MODS: Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack available at... http://www.ootpmods.com

12-24-2011, 03:09 PM	#412
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,361	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

12-29-2011, 05:36 AM	#413
soxman Minors (Triple A) Join Date: Dec 2001 Location: Christchurch, England Posts: 283	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

12-29-2011, 11:00 AM	#414
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	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. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-29-2011, 11:04 AM	#415
soxman Minors (Triple A) Join Date: Dec 2001 Location: Christchurch, England Posts: 283	I'm using the databases that are dated from July on Padresfan's site. Are they the latest?

01-21-2012, 05:45 PM	#419
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	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. __________________ It's madness, madness, I tell you! For the love of God, don't do it!