Spritze's db for OOTP14 - Page 12

RMc · 05-04-2014, 10:43 PM

Exactly what do I have to download, and what files needs to be put where?

The files that are in the zip file are the only ones that need to be overwritten in the stats directory.

I did that, and it didn't work; read what I wrote on the previous page.

Carlton · 05-05-2014, 11:13 AM

I think I need Spritze's High School master file and just throw that into my OOTP 15 Stats folder

over writing Gambo's Master.csv but keeping all the other files from Gambo. Or will that cause hijinks in the Matrix?

Gambo · 05-05-2014, 01:56 PM

Quote:

Originally Posted by RMc

I've used Gambo/Spritze dbs in the past, but for the last few years I just can't seem to get them to work right.

This is what I've been doing:

1) Create historical game in 1871.
2) Once game is created, point game to your database.
3) Unfortunately, it still has the 115 "real" players, and not the 281 "1871ers" specified in your db.
4) "A-ha!" says I. "I'll just delete these guys and set the amateur draft for March 1, before the season starts!"
5) I do so and there's...37 players, who all debuted in 1872, not 1871.
6) What gives? How do I point the game to the Gambo/Spritze db (and not the one that comes with the game) so that the 1871ers load properly?
7) Help!

I think #2 is wrong. The database needs to be pointed to in the advanced options of the historical game creation prior to when players are created.

RMc · 05-05-2014, 05:18 PM

I think #2 is wrong.

You think? This is your database, right? What's the proper way to install it?

Gambo · 05-05-2014, 06:27 PM

If your #2 is wrong it has nothing to do with the database, it's the way the game is programmed to create a league and it's the same for everybody. You are just creating the league wrong.

You can have the database completely installed correctly but if you don't select the database when creating the historical league (step 1 in the wizard) it's going to use the one that comes with OOTP.

From what your describing it sounds like you are not selecting the database until after the league is fully created. You are only then changing the path to the new database. So essentially you are creating the league using the original and from that point on you would be using another database.

Gambo · 05-05-2014, 06:31 PM

Also, your issue with the amateur draft is again a game programming thing that is totally independent of whatever database you use. I.e. the way OOTP is programmed and designed.

The game sees it as 1871. The next draft you have whether you have it in March, June, or half past September will have 1872 players in it.

*If you import 1871 and change the game year to 1995. It's still going to import the guys from 1872 for the next draft.

RMc · 05-05-2014, 07:10 PM

...I'm kinda frustrated here. Here's what I've done so far:

I downloaded "Gambo/Spritze DB for OOTP 14 (Corrected)" from ootpmods.com. It contains six files: Pitching2.csv, Batting2.csv, Fielding2.csv, FieldingOF2.csv, Master.csv and historical_database.odb. I have put these files in the standard "stats" folder (after saving the originals elsewhere). Still, I get the "original" 115 players from the original files.

Spritze sez there are additional files that I need. Where are they?

Quote:

You can have the database completely installed correctly but if you don't select the database when creating the historical league (step 1 in the wizard) it's going to use the one that comes with OOTP.

OK, I didn't realize you have to hit "Show Advanced Options" to set the database before game creation. I pointed it at "historical_database.odb" in the stats file (yours, replaced the original). Still got 115 players. Then I tried again, pointed it at "master.csv". 115 players.

I know I must be doing something obviously wrong, but what?

Spritze · 05-05-2014, 08:10 PM

The Gambo db most likely does not have the extra 1871 players that the Spritze db does. Same for all the rest of the years I bet. Remember he mentions he deletes the players he does not want. Bet those are some of the ones you do want.

RMc · 05-05-2014, 09:19 PM

Quote:

The Gambo db most likely does not have the extra 1871 players that the Spritze db does.

The "Gambo/Spritze DB for OOTP 14 (Corrected)" database -- the one I downloaded -- has 241 players debuting in 1871, while the regular database has 115.

Gambo · 05-05-2014, 10:39 PM

I really could just look at the file to make sure but do all those guys who start in 1871 have a playerid in column "a" and or are you choosing neutralized stats?

Gambo · 05-05-2014, 10:46 PM

Quote:

Originally Posted by Spritze

The Gambo db most likely does not have the extra 1871 players that the Spritze db does. Same for all the rest of the years I bet. Remember he mentions he deletes the players he does not want. Bet those are some of the ones you do want.

I should have all the American ball players but I know it is possible that spritze may have added other pcl or non mlb guys from that era after I did my latest update.

Though technically I've retired my version of the db I will likely do another update sometime after spritze releases his new one. It won't be as detail oriented as previous ones but will be an "update".

Since I'm not good as good at access as spritze I was a bit limited by my processor speed to do a quick full update. I should be able to bang one out now.

sharkmgs · 06-20-2014, 01:57 PM

Hi. I started a historical league with the Spritze db for OOTP 14. However, when I got to the first amateur draft, almost every pitcher (including Don Drysdale) has only one pitch (a low-rated fastball). I've not really seen the sim allow pitchers to develop additional pitches. Did I load the db wrong? Any suggestions would be very much appreciated.

I started the league fresh in 1953 and pointed to the "historical_database.odb" file. I tried to import Drysdale individually, and got the same result (a 4 stars middle reliever with only a 40 (20-80 scale) fastball. I'm not sure where I was supposed to put the files I downloaded from ootpmods, since I can't find instructions anywhere.

Spritze · 06-22-2014, 01:25 PM

The files go in the ootp15\stats folder for best results

Brick · 07-13-2014, 05:28 PM

Is the database updated through the 2013 season?

RANGER11JP · 08-15-2014, 02:52 AM

Quote:

Originally Posted by Spritze

you can use the included odb unless you want to change things by hand, then you would use the csv's.

Neutered is best.

Real, the Spritze db is College or Pro debut, Gambo is Pro debut.

What would you "change by hand"????

Thanks.

JP

The Game · 08-16-2014, 02:10 PM

Why are young players rated so badly? i do have various scouting on that might not show chase to be great but to be this bad, i just don;t get. i did have it set for real stats and just switched it to neutered.

Spritze · 08-16-2014, 04:48 PM

The ratings for Mr. Chase in the year shown are based on how he would play at age 18 in the Major leagues which was 2 years before his professional debut and 4 years before his major league debut. OOTP does not allow for minor league ratings. Everything is based on how a player would play in the ML at his age and skill level. The db leaves young players room to grow and get better (or worse) as time moves on. Doing otherwise would of course have all players debuting in the ML at a very young age.

Pinetarpress · 08-16-2014, 06:32 PM

Ok...so I have been editing minor league stats for real minor leaguers in the 1976 season...

Example: If a AA hitter had 100 H in 400 AB with 15 HR I would edit it by taking away 25 hits and 5 HR figuring that is what he would do at big league level,,,.are you saying that when I edit a player I should just keep his actual stats in there because it really doesn't matter how I edit him since he isn't in the big leagues?

This might be a confusing question so if you have a best practice for editing minor leaguer stats I would like to hear it

Spritze · 08-16-2014, 07:09 PM

If you do not make his stats into MLE's he may be overrated and appear in the big leagues way too soon.

I have a group of formulas that create MLE's based on a players age and MiLB level as well as the type of league.

Example: you have 2 players that hit .300 in the minors. One is 21 years old and the other is 32. One played in a pitcher dominated league (the 21 yr old) and one in a hitters paradise. The 32 year old played in AA and the 21 year old in AAA. Their MLE ratings will be hugely different as their stats under go adjustments.

Pinetarpress · 08-16-2014, 10:22 PM

I have my own MLE that I use....But, would love to see yours....do you have a link?

Thanks ahead of time ....

Btw as of right now I play every game and have actually edited in all the right players and stats for every minor leaguer in the 1976 season...

05-04-2014, 10:43 PM	#221
RMc All Star Starter Join Date: Jan 2004 Posts: 1,643	OK, now I'm really confused... Exactly what do I have to download, and what files needs to be put where? The files that are in the zip file are the only ones that need to be overwritten in the stats directory. I did that, and it didn't work; read what I wrote on the previous page. __________________ "We're all behind our baseball team..."

05-05-2014, 05:18 PM	#224
RMc All Star Starter Join Date: Jan 2004 Posts: 1,643	I think #2 is wrong. You think? This is your database, right? What's the proper way to install it? __________________ "We're all behind our baseball team..."

05-05-2014, 06:27 PM	#225
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	If your #2 is wrong it has nothing to do with the database, it's the way the game is programmed to create a league and it's the same for everybody. You are just creating the league wrong. You can have the database completely installed correctly but if you don't select the database when creating the historical league (step 1 in the wizard) it's going to use the one that comes with OOTP. From what your describing it sounds like you are not selecting the database until after the league is fully created. You are only then changing the path to the new database. So essentially you are creating the league using the original and from that point on you would be using another database. __________________ *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

05-05-2014, 06:31 PM	#226
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	Also, your issue with the amateur draft is again a game programming thing that is totally independent of whatever database you use. I.e. the way OOTP is programmed and designed. The game sees it as 1871. The next draft you have whether you have it in March, June, or half past September will have 1872 players in it. If you import 1871 and change the game year to 1995. It's still going to import the guys from 1872 for the next draft. __________________ 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

05-05-2014, 08:10 PM	#228
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The Gambo db most likely does not have the extra 1871 players that the Spritze db does. Same for all the rest of the years I bet. Remember he mentions he deletes the players he does not want. Bet those are some of the ones you do want. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

05-05-2014, 11:13 AM	#222
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	I think I need Spritze's High School master file and just throw that into my OOTP 15 Stats folder over writing Gambo's Master.csv but keeping all the other files from Gambo. Or will that cause hijinks in the Matrix?

05-05-2014, 10:39 PM	#230
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	I really could just look at the file to make sure but do all those guys who start in 1871 have a playerid in column "a" and or are you choosing neutralized stats? __________________ *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

06-20-2014, 01:57 PM	#232
sharkmgs Minors (Rookie Ball) Join Date: Oct 2009 Posts: 20	Hi. I started a historical league with the Spritze db for OOTP 14. However, when I got to the first amateur draft, almost every pitcher (including Don Drysdale) has only one pitch (a low-rated fastball). I've not really seen the sim allow pitchers to develop additional pitches. Did I load the db wrong? Any suggestions would be very much appreciated. I started the league fresh in 1953 and pointed to the "historical_database.odb" file. I tried to import Drysdale individually, and got the same result (a 4 stars middle reliever with only a 40 (20-80 scale) fastball. I'm not sure where I was supposed to put the files I downloaded from ootpmods, since I can't find instructions anywhere. Last edited by sharkmgs; 06-20-2014 at 02:12 PM.

06-22-2014, 01:25 PM	#233
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The files go in the ootp15\stats folder for best results __________________ It's madness, madness, I tell you! For the love of God, don't do it!

07-13-2014, 05:28 PM	#234
Brick Minors (Triple A) Join Date: Jul 2002 Location: A legend in my own mind Posts: 289	Is the database updated through the 2013 season? __________________ Big Sky Baseball League - San Bernardino Stallions Baseball Back to the Future - St. Louis Cardinals Washington Nationals Silver Screen Test

08-16-2014, 02:10 PM	#236
The Game Hall Of Famer Join Date: Feb 2012 Location: Inside The Game Posts: 30,937	Why are young players rated so badly? i do have various scouting on that might not show chase to be great but to be this bad, i just don;t get. i did have it set for real stats and just switched it to neutered. Attached Images __________________ Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong"

08-16-2014, 04:48 PM	#237
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The ratings for Mr. Chase in the year shown are based on how he would play at age 18 in the Major leagues which was 2 years before his professional debut and 4 years before his major league debut. OOTP does not allow for minor league ratings. Everything is based on how a player would play in the ML at his age and skill level. The db leaves young players room to grow and get better (or worse) as time moves on. Doing otherwise would of course have all players debuting in the ML at a very young age. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

08-16-2014, 06:32 PM	#238
Pinetarpress Major Leagues Join Date: Oct 2013 Posts: 423	Ok...so I have been editing minor league stats for real minor leaguers in the 1976 season... Example: If a AA hitter had 100 H in 400 AB with 15 HR I would edit it by taking away 25 hits and 5 HR figuring that is what he would do at big league level,,,.are you saying that when I edit a player I should just keep his actual stats in there because it really doesn't matter how I edit him since he isn't in the big leagues? This might be a confusing question so if you have a best practice for editing minor leaguer stats I would like to hear it

08-16-2014, 07:09 PM	#239
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	If you do not make his stats into MLE's he may be overrated and appear in the big leagues way too soon. I have a group of formulas that create MLE's based on a players age and MiLB level as well as the type of league. Example: you have 2 players that hit .300 in the minors. One is 21 years old and the other is 32. One played in a pitcher dominated league (the 21 yr old) and one in a hitters paradise. The 32 year old played in AA and the 21 year old in AAA. Their MLE ratings will be hugely different as their stats under go adjustments. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

08-16-2014, 10:22 PM	#240
Pinetarpress Major Leagues Join Date: Oct 2013 Posts: 423	Thanks I have my own MLE that I use....But, would love to see yours....do you have a link? Thanks ahead of time .... Btw as of right now I play every game and have actually edited in all the right players and stats for every minor leaguer in the 1976 season...