Spritze DB's for OOTP11 - Page 37

The Game · 05-28-2015, 10:28 PM

Quote:

Originally Posted by skyballer455

Thanks, but don't want it to happen entirely. Perhaps I need to edit the database?

If you dont want the Fed league uncheck Expand Automatically before you get to that season and turn it back on after 1915 or January of 1916 and you should be good to go. Have not tried this on 16.

froghair · 05-29-2015, 01:38 PM

My most recent download from dropbox includes a Master CSV file with 28,000 players. I thought this db had upwards of 110k. Is there something I am not doing correctly?

Spritze · 05-29-2015, 02:24 PM

Quote:

Originally Posted by froghair

My most recent download from dropbox includes a Master CSV file with 28,000 players. I thought this db had upwards of 110k. Is there something I am not doing correctly?

Thou hast been overcome by wrong thinking. 28,000 is correct.

froghair · 05-29-2015, 04:28 PM

Thankest thou.

geoffmatt17 · 06-02-2015, 11:14 AM

Hi - I'm trying to remove players I don't want (Korean and Japanese) from my Master.csv. I think I was able to locate them all properly. I deleted them off of the Master.csv. Then, I removed the ODB files from the stats folder. Then, I try to start a new historical game, and I tell the game to point to the edited Master.csv. Then, OOTP shuts down as the database is being loaded (prior to 0%). What am I doing wrong? I've read (mainly throughout this thread) that if you make changes to the database, you need to delete the ODB files. Thanks in advance for the help!

Gambo · 06-02-2015, 02:27 PM

If you mess up removing players (delete a line improperly) it could cause issues. I've always just removed the playerid from the 1st? column and it won't import them. Keeping the db in shape is important.

Also, another issue is that the Db is big. If your computer doesn't have the muscle it may not be able to do it. The odb is actually a compressed file to access the data quickly.

Generally though speed issues don't pop up immediately. It's likely a structure or missing file issue.

Gambo · 06-02-2015, 02:45 PM

I could pretty easily convert this into the Gambo version but I don't know if I'll have time anytime soon.

If anybody is interested And familiar with using excel I can give them a walkthrough and the file with the actual team/organization assignments for historical MLB from 1901-2011?

If you know what you're doing it can all be done on a few hours.

If you are wondering my version is the SAME AS SPRITZES except I have it so players import when they were signed/drafted with the right organization, and have it so you can still have real league history/prior statistics when importing.

It's more styles for divergent replays and what ifs.

geoffmatt17 · 06-02-2015, 03:14 PM

Quote:

Originally Posted by Gambo

If you mess up removing players (delete a line improperly) it could cause issues. I've always just removed the playerid from the 1st? column and it won't import them. Keeping the db in shape is important.

This is great insight, I appreciate it. The playerid column is now the 2nd column I believe, LahmanID is the first. I will retrace my steps, leave the lines, but remove the playerid's. Will this automatically update the odb file? If not, how do I make sure that happens?

Quote:

Originally Posted by Gambo

I could pretty easily convert this into the Gambo version but I don't know if I'll have time anytime soon.

If anybody is interested And familiar with using excel I can give them a walkthrough and the file with the actual team/organization assignments for historical MLB from 1901-2011?

If you know what you're doing it can all be done on a few hours.

If you are wondering my version is the SAME AS SPRITZES except I have it so players import when they were signed/drafted with the right organization, and have it so you can still have real league history/prior statistics when importing.

It's more styles for divergent replays and what ifs.

I really like the style of your set up, it fits the way I'm trying to play very well. I'd be quite happy to see a Gambo update!

skyballer455 · 06-07-2015, 04:00 PM

I think there may be something wrong with the database. Here is the draft pool for the 1901 season:

I thought the database was supposed to generate 18 year old rookies, but here their ages are all over the place. And yes, i have the databse set to Spritze's.

Help!

Spritze · 06-07-2015, 06:31 PM

Well, just looking at your screenshot, the first player, Joe Tinker was 18 in 1898 and is 21 in 1901. This would seem to be correct. If you start your league in 1898 he will be 18. If you start in 1911 he will be 31. Your first inaugural import will have players of many different ages. Subsequent drafts will be 17-18-19 year olds depending on birthdates.

The obvious reason for this is obvious if you give it a little computational time of the organic variety.

I use Mr. Miyagi's Brain On - Brain Off mantra personally.

skyballer455 · 06-07-2015, 08:12 PM

Quote:

Originally Posted by Spritze

Well, just looking at your screenshot, the first player, Joe Tinker was 18 in 1898 and is 21 in 1901. This would seem to be correct. If you start your league in 1898 he will be 18. If you start in 1911 he will be 31. Your first inaugural import will have players of many different ages. Subsequent drafts will be 17-18-19 year olds depending on birthdates.

The obvious reason for this is obvious if you give it a little computational time of the organic variety.

I use Mr. Miyagi's Brain On - Brain Off mantra personally.

Thanks for clearing that up!

Spritze · 06-11-2015, 12:13 AM

Just added *** 2009-2014 to the database

Plan to add KBO 2009-2014 if I can at least find out who played what position.

The Game · 06-11-2015, 08:12 AM

Quote:

Originally Posted by Spritze

Just added *** 2009-2014 to the database

Plan to add KBO 2009-2014 if I can at least find out who played what position.

Which link is the most up-to-date?

Spritze · 06-11-2015, 10:05 AM

The last one but it doesn't have the new Japanese or Korean data yet. Still looking for position data for Korea.

Bigrod · 06-12-2015, 04:03 PM

Quote:

Originally Posted by Spritze

The last one but it doesn't have the new Japanese or Korean data yet. Still looking for position data for Korea.

Check with the guy in this post
http://www.ootpdevelopments.com/boar...ml#post3864692
He's Korean and knows the KBO.

Spritze · 06-13-2015, 10:16 AM

Thanks....Initial contact has been initiated.

Spritze · 06-19-2015, 03:50 PM

I have not yet heard back from Mr. Korea........

Since I do have batting and pitching info for Korean players perhaps I could either leave fielding out altogether (OOTP will make everyone a first baseman).

I suppose I could even guess based on batting record and roster information. Pitchers of course are handled.

Another possibility is to leave Korea out altogether.

I plan to use the OOTP 16 Korean standard league to glean whatever fielding info it contains for 2014/2015 as well. I have exported the Korean and the Japanese rosters, the I'll match positions and then the rating within the position. Since I have Japanese actual fielding data for everyone I'll use that to create Korean fielding. This will take care of about half the Korean fielding issue.

Japan (2009-2014) has been updated and added to the database.

MarkInCincy · 06-19-2015, 07:17 PM

Quote:

Originally Posted by Spritze

I have not yet heard back from Mr. Korea........

Since I do have batting and pitching info for Korean players perhaps I could either leave fielding out altogether (OOTP will make everyone a first baseman).

I suppose I could even guess based on batting record and roster information. Pitchers of course are handled.

Another possibility is to leave Korea out altogether.

I plan to use the OOTP 16 Korean standard league to glean whatever fielding info it contains for 2014/2015 as well. I have exported the Korean and the Japanese rosters, the I'll match positions and then the rating within the position. Since I have Japanese actual fielding data for everyone I'll use that to create Korean fielding. This will take care of about half the Korean fielding issue.

Japan (2009-2014) has been updated and added to the database.

Rather than make them all 1B's, if you can't find fielding info or figure it out, maybe just select a random Japanese player for those Korean guys and give them the same fielding ratings (or lower/bump them by a random pct??). Might be better than making them all 1B.

Just a thought

Spritze · 06-20-2015, 11:02 AM

I figured out a way to match the Korean OOTP fielding ratings to the Japanese OOTP fielding ratings to generate fake but logical fielding stats for the Koreans by year and position and even secondary positions.

Then I used those matches to roll back as many Korean players as I could each year to 2009. That is about 2,600 player years.

Doing this by hand would have taken a year or two but the computer processed it all in 3 or 4 seconds. It took a couple of hours to write the program but wowzers that is pretty spiffy.

I need to clean up the Korean players that did not have matches and I'll be done.

There will be a new Spritze download sometime in the next week or two. The changes will be the additional Japanese and Korean players and changes to the MLE formulas for all players.

The Game · 06-21-2015, 02:53 AM

Quote:

Originally Posted by Spritze

I figured out a way to match the Korean OOTP fielding ratings to the Japanese OOTP fielding ratings to generate fake but logical fielding stats for the Koreans by year and position and even secondary positions.

Then I used those matches to roll back as many Korean players as I could each year to 2009. That is about 2,600 player years.

Doing this by hand would have taken a year or two but the computer processed it all in 3 or 4 seconds. It took a couple of hours to write the program but wowzers that is pretty spiffy.

I need to clean up the Korean players that did not have matches and I'll be done.

There will be a new Spritze download sometime in the next week or two. The changes will be the additional Japanese and Korean players and changes to the MLE formulas for all players.

Feel like sharing that program? Would love to add my EBL players to your DB and have some killer RD leagues.

06-02-2015, 11:14 AM	#725
geoffmatt17 Major Leagues Join Date: Oct 2012 Location: Pennsylvania Posts: 305	Editing Master.csv Hi - I'm trying to remove players I don't want (Korean and Japanese) from my Master.csv. I think I was able to locate them all properly. I deleted them off of the Master.csv. Then, I removed the ODB files from the stats folder. Then, I try to start a new historical game, and I tell the game to point to the edited Master.csv. Then, OOTP shuts down as the database is being loaded (prior to 0%). What am I doing wrong? I've read (mainly throughout this thread) that if you make changes to the database, you need to delete the ODB files. Thanks in advance for the help! __________________ United Baseball Association - San Francisco Spartans (Commish) FOD - Miami Mutiny PBF - Port Moresby Wigmen SABR - Tampa Bay Rays FCB - Chicago White Sox FSL - Oklahoma City Red Hawks

06-02-2015, 02:27 PM	#726
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	If you mess up removing players (delete a line improperly) it could cause issues. I've always just removed the playerid from the 1st? column and it won't import them. Keeping the db in shape is important. Also, another issue is that the Db is big. If your computer doesn't have the muscle it may not be able to do it. The odb is actually a compressed file to access the data quickly. Generally though speed issues don't pop up immediately. It's likely a structure or missing file issue. __________________ *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-02-2015, 02:45 PM	#727
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	I could pretty easily convert this into the Gambo version but I don't know if I'll have time anytime soon. If anybody is interested And familiar with using excel I can give them a walkthrough and the file with the actual team/organization assignments for historical MLB from 1901-2011? If you know what you're doing it can all be done on a few hours. If you are wondering my version is the SAME AS SPRITZES except I have it so players import when they were signed/drafted with the right organization, and have it so you can still have real league history/prior statistics when importing. It's more styles for divergent replays and what ifs. __________________ *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-07-2015, 06:31 PM	#730
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Well, just looking at your screenshot, the first player, Joe Tinker was 18 in 1898 and is 21 in 1901. This would seem to be correct. If you start your league in 1898 he will be 18. If you start in 1911 he will be 31. Your first inaugural import will have players of many different ages. Subsequent drafts will be 17-18-19 year olds depending on birthdates. The obvious reason for this is obvious if you give it a little computational time of the organic variety. I use Mr. Miyagi's Brain On - Brain Off mantra personally. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

06-11-2015, 12:13 AM	#732
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Just added *** 2009-2014 to the database Plan to add KBO 2009-2014 if I can at least find out who played what position. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

05-29-2015, 01:38 PM	#722
froghair Minors (Single A) Join Date: Mar 2015 Location: Rocky River, Ohio Posts: 67	My most recent download from dropbox includes a Master CSV file with 28,000 players. I thought this db had upwards of 110k. Is there something I am not doing correctly?

05-29-2015, 04:28 PM	#724
froghair Minors (Single A) Join Date: Mar 2015 Location: Rocky River, Ohio Posts: 67	Thankest thou.

06-07-2015, 04:00 PM	#729
skyballer455 All Star Reserve Join Date: Jul 2014 Posts: 701	I think there may be something wrong with the database. Here is the draft pool for the 1901 season: I thought the database was supposed to generate 18 year old rookies, but here their ages are all over the place. And yes, i have the databse set to Spritze's. Help!

06-11-2015, 10:05 AM	#734
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The last one but it doesn't have the new Japanese or Korean data yet. Still looking for position data for Korea. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

06-13-2015, 10:16 AM	#736
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Thanks....Initial contact has been initiated. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

06-19-2015, 03:50 PM	#737
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Squid Pro Quo I have not yet heard back from Mr. Korea........ Since I do have batting and pitching info for Korean players perhaps I could either leave fielding out altogether (OOTP will make everyone a first baseman). I suppose I could even guess based on batting record and roster information. Pitchers of course are handled. Another possibility is to leave Korea out altogether. I plan to use the OOTP 16 Korean standard league to glean whatever fielding info it contains for 2014/2015 as well. I have exported the Korean and the Japanese rosters, the I'll match positions and then the rating within the position. Since I have Japanese actual fielding data for everyone I'll use that to create Korean fielding. This will take care of about half the Korean fielding issue. Japan (2009-2014) has been updated and added to the database. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 06-19-2015 at 04:17 PM.

06-20-2015, 11:02 AM	#739
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	I figured out a way to match the Korean OOTP fielding ratings to the Japanese OOTP fielding ratings to generate fake but logical fielding stats for the Koreans by year and position and even secondary positions. Then I used those matches to roll back as many Korean players as I could each year to 2009. That is about 2,600 player years. Doing this by hand would have taken a year or two but the computer processed it all in 3 or 4 seconds. It took a couple of hours to write the program but wowzers that is pretty spiffy. I need to clean up the Korean players that did not have matches and I'll be done. There will be a new Spritze download sometime in the next week or two. The changes will be the additional Japanese and Korean players and changes to the MLE formulas for all players. __________________ It's madness, madness, I tell you! For the love of God, don't do it!