Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 05-28-2015, 10:28 PM   #721
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by skyballer455 View Post
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.
__________________
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"


The Game is offline   Reply With Quote
Old 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?
froghair is offline   Reply With Quote
Old 05-29-2015, 02:24 PM   #723
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by froghair View Post
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.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-29-2015, 04:28 PM   #724
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
Thankest thou.
froghair is offline   Reply With Quote
Old 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!
geoffmatt17 is offline   Reply With Quote
Old 06-02-2015, 02:27 PM   #726
Gambo
Hall Of Famer
 
Gambo's Avatar
 
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
Gambo is offline   Reply With Quote
Old 06-02-2015, 02:45 PM   #727
Gambo
Hall Of Famer
 
Gambo's Avatar
 
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
Gambo is offline   Reply With Quote
Old 06-02-2015, 03:14 PM   #728
geoffmatt17
Major Leagues
 
Join Date: Oct 2012
Location: Pennsylvania
Posts: 305
Quote:
Originally Posted by Gambo View Post
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 View Post
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!
geoffmatt17 is offline   Reply With Quote
Old 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!
skyballer455 is offline   Reply With Quote
Old 06-07-2015, 06:31 PM   #730
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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!
Spritze is offline   Reply With Quote
Old 06-07-2015, 08:12 PM   #731
skyballer455
All Star Reserve
 
Join Date: Jul 2014
Posts: 701
Quote:
Originally Posted by Spritze View Post
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!
skyballer455 is offline   Reply With Quote
Old 06-11-2015, 12:13 AM   #732
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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!
Spritze is offline   Reply With Quote
Old 06-11-2015, 08:12 AM   #733
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by Spritze View Post
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?
__________________
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"


The Game is offline   Reply With Quote
Old 06-11-2015, 10:05 AM   #734
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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!
Spritze is offline   Reply With Quote
Old 06-12-2015, 04:03 PM   #735
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 3,075
Quote:
Originally Posted by Spritze View Post
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.
Bigrod is offline   Reply With Quote
Old 06-13-2015, 10:16 AM   #736
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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!
Spritze is offline   Reply With Quote
Old 06-19-2015, 03:50 PM   #737
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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.
Spritze is offline   Reply With Quote
Old 06-19-2015, 07:17 PM   #738
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
Quote:
Originally Posted by Spritze View Post
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
__________________
"A baseball fan has the digestive apparatus of a billy goat. He can, and does, devour any set of statistics with insatiable appetite and then nuzzles hungrily for more." - Sportswriter Arthur Daley
"Who says there's an unemployment problem in this country? Just take the five percent unemployed and give them a baseball stat to follow." - Outfielder Andy Van Slyke
MarkInCincy is offline   Reply With Quote
Old 06-20-2015, 11:02 AM   #739
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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!
Spritze is offline   Reply With Quote
Old 06-21-2015, 02:53 AM   #740
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by Spritze View Post
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.
__________________
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"


The Game is offline   Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:56 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments