Spritze DB's for OOTP11 - Page 17

PadresFan · 07-04-2011, 11:10 PM

Just got back from a great 24 hour getaway... Will post in an hour or so...

Al

Lee · 07-04-2011, 11:19 PM

Great news, really looking forward to this, thanks for all the work guys.

Gambo · 07-06-2011, 09:53 AM

I'm finishing up the my versions of this database so they should be available for the weekend.

Sparrow · 07-06-2011, 10:54 AM

Thanks for all you both do. I am yet to use one of these databases but plan to this year.

My questions are (with excitement, curiosity, and plenty of patience) will a real debut no asians come out for OOTP 12 (including career minor leaguers)? And, are Ichiro, Dice-K, etc. included in the no asians database?

Thanks again.

Gambo · 07-06-2011, 11:40 AM

I will have two versions of the database. The 1st will be my standard with players debuting when they made their professional debut in the correct organizations, correct organizations upon import, career minor leaguers and the top ~50 historical japanese players. Dice-K, Ichiro etc will import when they made their foreign debut.

The second version is a tweaked database that works with real transactions turned on, this includes all major leaguers and a good portion of the minor leaguers (the minor leaguers had to be in a MLB organization at some point). Players will import either when they joined their 1st MLB organizations (minors or majors). For players who were drafted or signed during the season, they will import as Free Agents at the beginning of the year and the transaction database will add them to their teams as the season progresses. For example David Clyde will import in 1973 as a Free Agent and in June go to the Rangers. This will also implement the work around for players importing to the correct teams or as a Free Agent as of opening day for the import year. (The real stats will look weird as an additional team is added in some cases). So players who were signed in May will import as Free Agents on opening day.

Both these databases need to use the neutralized stats option and the 2nd version will also function fine without real transactions used. The 2nd version is closest to the "No asians" version Spritze creates.

I will be sending the 1st version to Padres site shortly and hope to finish the 2nd version sometime today also.

*The Gambo/Spritze database uses the same data as the Spritze DB.

Spritze · 07-06-2011, 11:51 AM

Quote:

Originally Posted by Sparrow

And, are Ichiro, Dice-K, etc. included in the no asians database?

Thanks again.

Yup

AESP_pres · 07-06-2011, 01:07 PM

Quote:

Originally Posted by Gambo

The second version is a tweaked database that works with real transactions turned on, this includes all major leaguers and a good portion of the minor leaguers (the minor leaguers had to be in a MLB organization at some point).

Does it means that you have created more minor league players who never reach the major league this year? By exemple guy like Tim Barker who was trade for Tim Wallach in 92 or Mario Brito who was part of the Tim Raines / Ivan Calderon trade in 90.

Gambo · 07-06-2011, 01:37 PM

Yes and no. The database only contains the guys who Spritze has already done MLB equivalencies for. But if they were already in Spritze's database I tried to get them to match in the transaction database.

Tim Barker is not in it. BUT Mario Brito is as Spritze did him for his time in Foreign leagues. So his transactions are there.

mikecos23 · 07-06-2011, 02:04 PM

Ahhh my favorite time of the year, when the various Spritze and Gambo databases are complete and I can start using OOTP for historical play again - much appreciation to both of you for all your hard work!

diamondreplays · 07-07-2011, 09:34 AM

Rookie Question: What is the difference between this database of players and that which ships with the game? Never mind...just read the first page of this thread. Re-phrase: For those gamers playing historical replays with RL lineups and transactions, is this database more precise than that which ships with the game?

Spritze · 07-07-2011, 09:59 AM

I think not. Make no difference to a strictly Major League replay.

Gambo · 07-07-2011, 01:16 PM

Actually, a little bit more. The historical transaction file has a few updates that are not in the version that ships with the game. There are VERY few and likely you would not notice them unless you are playing in the deadball era.

I am working on an update,with the help of M's Rule, (this has part of these) that has some enhancements such as specific dates for players leaving and returning from the military, players who died during the season leaving the team on the correct dates, removal lines for those who don't wan't to play with retire according to history and hopefully we will get in league suspensions (only for instances off the field such as drugs, gambling).

DXMachina · 07-08-2011, 07:59 PM

First, thanks to both of you for all the work on these databases. They're really great. However, I did come a piece of corrupt data. I was setting up a historical league starting in 1961 using the new Gambo-Spritze DB (without transactions), and the game was telling me that one of the players was named Allegheny County" Bob (with the quote mark included. I took a look at the master.csv file, and the player should be Bob Purkey. Somehow the phrase 'Allegheny County"' wound up in the first name field, and 'Bob' is in the last name field. I don't know if any of the other data for Purkey is off. A lot of the numbers don't seem to match the Lahman version of the file, but I attributed that to neutralizing the stats.

I checked some other versions of both the Gambo-Spritze and the Spritze databases for OotP12, and they all contain bad data. It's no big deal to fix once I figured out who it was supposed to be, but I figured it was best to let you know.

Thanks again for the hard work.

Spritze · 07-08-2011, 08:45 PM

Thanks, FYI search for quote marks/commas and you'll find all the name errors. There should be no quotes in the base master.csv that comes from the new OOTP guy who changed the names and other base info but he has included a few which is the root cause of your (and our) troubles.

inuyashabr1986 · 07-08-2011, 09:41 PM

I'm a little new to this game, how do I load this file to start a new game with it?

DXMachina · 07-09-2011, 10:21 AM

Quote:

FYI search for quote marks/commas and you'll find all the name errors.

I found six of them in the DB I'm using: Lou Gehrig (!), Harry Little, Bob Purkey, John Simmons, Joe Tepsic, and George Ulrich. I removed the historical database.odb and restarted the league using just the edited csvs. I now see the usefulness of the odbs. The initial load takes forever with the csvs.

Spritze · 07-09-2011, 11:55 AM

PM me and I'll give you a link to the corrected commaless db on my work ftp site

If you are using Gambos contact him for the similar update

inuyashabr1986 · 07-09-2011, 12:13 PM

i try to play with Gambo / Spritze w/ Transactions for OOTP 12, but i cant load this db, how i do that??

Spritze · 07-09-2011, 01:12 PM

The easy way is to put the files in your stats folder after unzippering of course.

Then just create a new game.

inuyashabr1986 · 07-09-2011, 01:58 PM

Thank you Spritze

07-06-2011, 09:53 AM	#323
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	I'm finishing up the my versions of this database so they should be available for the weekend. __________________ *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

07-06-2011, 11:40 AM	#325
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	I will have two versions of the database. The 1st will be my standard with players debuting when they made their professional debut in the correct organizations, correct organizations upon import, career minor leaguers and the top ~50 historical japanese players. Dice-K, Ichiro etc will import when they made their foreign debut. The second version is a tweaked database that works with real transactions turned on, this includes all major leaguers and a good portion of the minor leaguers (the minor leaguers had to be in a MLB organization at some point). Players will import either when they joined their 1st MLB organizations (minors or majors). For players who were drafted or signed during the season, they will import as Free Agents at the beginning of the year and the transaction database will add them to their teams as the season progresses. For example David Clyde will import in 1973 as a Free Agent and in June go to the Rangers. This will also implement the work around for players importing to the correct teams or as a Free Agent as of opening day for the import year. (The real stats will look weird as an additional team is added in some cases). So players who were signed in May will import as Free Agents on opening day. Both these databases need to use the neutralized stats option and the 2nd version will also function fine without real transactions used. The 2nd version is closest to the "No asians" version Spritze creates. I will be sending the 1st version to Padres site shortly and hope to finish the 2nd version sometime today also. The Gambo/Spritze database uses the same data as the Spritze DB. __________________ 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

07-06-2011, 01:37 PM	#328
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	Yes and no. The database only contains the guys who Spritze has already done MLB equivalencies for. But if they were already in Spritze's database I tried to get them to match in the transaction database. Tim Barker is not in it. BUT Mario Brito is as Spritze did him for his time in Foreign leagues. So his transactions are there. __________________ *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

07-07-2011, 09:34 AM	#330
diamondreplays Bat Boy Join Date: Jun 2011 Location: Atlanta Posts: 15	Rookie Question: What is the difference between this database of players and that which ships with the game? Never mind...just read the first page of this thread. Re-phrase: For those gamers playing historical replays with RL lineups and transactions, is this database more precise than that which ships with the game? __________________ A Second Time through the Order Follow Me on Twitter Last edited by diamondreplays; 07-07-2011 at 09:38 AM.

07-07-2011, 01:16 PM	#332
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	Actually, a little bit more. The historical transaction file has a few updates that are not in the version that ships with the game. There are VERY few and likely you would not notice them unless you are playing in the deadball era. I am working on an update,with the help of M's Rule, (this has part of these) that has some enhancements such as specific dates for players leaving and returning from the military, players who died during the season leaving the team on the correct dates, removal lines for those who don't wan't to play with retire according to history and hopefully we will get in league suspensions (only for instances off the field such as drugs, gambling). __________________ *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

07-04-2011, 11:10 PM	#321
PadresFan All Star Starter Join Date: Dec 2001 Location: Carlsbad, CA Posts: 1,151	Just got back from a great 24 hour getaway... Will post in an hour or so... Al

07-04-2011, 11:19 PM	#322
Lee Global Moderator Join Date: Dec 2001 Location: The Scorched Desert Posts: 4,652	Great news, really looking forward to this, thanks for all the work guys.

07-06-2011, 10:54 AM	#324
Sparrow All Star Reserve Join Date: Feb 2009 Posts: 803	Thanks for all you both do. I am yet to use one of these databases but plan to this year. My questions are (with excitement, curiosity, and plenty of patience) will a real debut no asians come out for OOTP 12 (including career minor leaguers)? And, are Ichiro, Dice-K, etc. included in the no asians database? Thanks again.

07-06-2011, 02:04 PM	#329
mikecos23 Minors (Double A) Join Date: Apr 2010 Location: Reading, PA, USA Posts: 117	Ahhh my favorite time of the year, when the various Spritze and Gambo databases are complete and I can start using OOTP for historical play again - much appreciation to both of you for all your hard work!

07-07-2011, 09:59 AM	#331
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	I think not. Make no difference to a strictly Major League replay.

07-08-2011, 07:59 PM	#333
DXMachina Bat Boy Join Date: Jun 2011 Posts: 3	First, thanks to both of you for all the work on these databases. They're really great. However, I did come a piece of corrupt data. I was setting up a historical league starting in 1961 using the new Gambo-Spritze DB (without transactions), and the game was telling me that one of the players was named Allegheny County" Bob (with the quote mark included. I took a look at the master.csv file, and the player should be Bob Purkey. Somehow the phrase 'Allegheny County"' wound up in the first name field, and 'Bob' is in the last name field. I don't know if any of the other data for Purkey is off. A lot of the numbers don't seem to match the Lahman version of the file, but I attributed that to neutralizing the stats. I checked some other versions of both the Gambo-Spritze and the Spritze databases for OotP12, and they all contain bad data. It's no big deal to fix once I figured out who it was supposed to be, but I figured it was best to let you know. Thanks again for the hard work.

07-08-2011, 08:45 PM	#334
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Thanks, FYI search for quote marks/commas and you'll find all the name errors. There should be no quotes in the base master.csv that comes from the new OOTP guy who changed the names and other base info but he has included a few which is the root cause of your (and our) troubles. Last edited by Spritze; 07-09-2011 at 12:38 AM.

07-08-2011, 09:41 PM	#335
inuyashabr1986 Bat Boy Join Date: Jun 2011 Posts: 14	I'm a little new to this game, how do I load this file to start a new game with it?

07-09-2011, 11:55 AM	#337
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	PM me and I'll give you a link to the corrected commaless db on my work ftp site If you are using Gambos contact him for the similar update Last edited by Spritze; 07-09-2011 at 11:56 AM.

07-09-2011, 12:13 PM	#338
inuyashabr1986 Bat Boy Join Date: Jun 2011 Posts: 14	i try to play with Gambo / Spritze w/ Transactions for OOTP 12, but i cant load this db, how i do that??

07-09-2011, 01:12 PM	#339
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The easy way is to put the files in your stats folder after unzippering of course. Then just create a new game.

07-09-2011, 01:58 PM	#340
inuyashabr1986 Bat Boy Join Date: Jun 2011 Posts: 14	Thank you Spritze