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 06-21-2015, 10:28 AM   #741
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Yes, I can share the Spritze database creator. It uses 4 interconnected 1.5 gb Access databases. You would need to append/load the tables with your EBL players and then process the data.
__________________
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, 03:06 PM   #742
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
Yes, I can share the Spritze database creator. It uses 4 interconnected 1.5 gb Access databases. You would need to append/load the tables with your EBL players and then process the data.
Hopefully I can figure out how to do it this time around. Last time, which was a few years ago, I was lost trying to do it.
__________________
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-21-2015, 05:53 PM   #743
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
You're the best Spritze!
actionjackson is offline   Reply With Quote
Old 06-22-2015, 12:49 AM   #744
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by The Game View Post
Hopefully I can figure out how to do it this time around. Last time, which was a few years ago, I was lost trying to do it.
First thing to accomplish is to get your data/stats into the standard Lahman format. Master, batting, pitching, fielding, teams.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-27-2015, 12:45 PM   #745
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
KBO Update

I found Position information for 83% of the position players and 100% of the pitchers.

Next step is to see what positions may be missing per team and year and to guess from there. If a team has no SS in a certain year for instance but every other position has a regular then the player who was a regular but has no known position must have been the shortstop.

Just found many of the missing.....The 3 sources I used have different spellings for the same Korean fellas. Computers don't handle sound alikes well, they are far more literal than that. I'll do my best to match these peoples by changing their spellings to match each other.

730 double "players" caused by alternate spellings. These will be reduced by half when the spellings are made to match. More than likely there are even more that I may not find but this is the best I can do at the moment.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 06-27-2015 at 11:53 PM.
Spritze is offline   Reply With Quote
Old 06-28-2015, 06:48 PM   #746
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Hello Spritze,

I am running an experiment with your HS DB. It is going quite well. The fictional league started in 1850 and your players which you adjusted debuts for have done so. I read that you have certain players that along the way you have designated to go to a particular team, and I am good with that. But I have some questions, as always.

What team codes are you then using for the debut team? I looked in the Batting2.csv file and found most players with the IND designation. I saw a few BSN designates, but am not sure what set (LAHMAN, OOTP, BR) of TEAM ID's that is from.

Depending on your answer, where would I go to make changes to the DB to possibly alter some of the debut teams, if I am using earlier TEAM ID's
which do not follow the pre-1901 OOTP fiction?

Thank you for your help and your great work.

JP
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 06-28-2015, 06:57 PM   #747
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Teams = Lahman

IND = Player never played in the Majors and all the other teams he played on were Independent ones.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-28-2015, 07:42 PM   #748
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
Teams = Lahman

IND = Player never played in the Majors and all the other teams he played on were Independent ones.
What I guess is confusing me is there is no BSN TEAM ID in 1871, at least the LAHMAN teams.csv which I am looking at.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 06-28-2015, 07:54 PM   #749
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The Boston Red Stockings of 1871 eventually became known as the Boston Braves.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-28-2015, 10:01 PM   #750
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
The Boston Red Stockings of 1871 eventually became known as the Boston Braves.
Yes, so can I change something to get those players to go to the team designated BS1?
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 06-28-2015, 11:06 PM   #751
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
Yes, so can I change something to get those players to go to the team designated BS1?
No.

OOTP ignores all team designations until 1901. Doesn't matter what you make it, nothing happens.

This is part of a possibly misguided OOTP design decision.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-28-2015, 11:37 PM   #752
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
No.

OOTP ignores all team designations until 1901. Doesn't matter what you make it, nothing happens.

This is part of a possibly misguided OOTP design decision.
I see. So just out of curiosity, what or where is the designation that it honors after 1901?

If that is the case, why would you designated any players to BSN or CH1 etc, before 1901?
__________________
BASEBALL, HOCKEY AND BOXING FAN

Last edited by RANGER11JP; 06-28-2015 at 11:45 PM.
RANGER11JP is offline   Reply With Quote
Old 06-28-2015, 11:59 PM   #753
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
I see. So just out of curiosity, what or where is the designation that it honors after 1901?

If that is the case, why would you designated any players to BSN or CH1 etc, before 1901?
Same place.

Someday things in OOTP pre-1901 may change?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-29-2015, 12:20 AM   #754
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Just so I am clear on this. It is the Batting2.csv and the "stint" column and the corresponding year?

Sorry to be such a donkey on this. Thank you for your patience.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 06-29-2015, 06:06 AM   #755
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
Quote:
Originally Posted by Spritze View Post
Same place.

Someday things in OOTP pre-1901 may change?
I have been hoping, crossing my fingers, praying, sacrificing chickens/goats,etc since OOTP3 that this happens and I REFUSE to give up on it.
...
Someday our time will come..........
__________________
"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-29-2015, 07:55 AM   #756
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
Just so I am clear on this. It is the Batting2.csv and the "stint" column and the corresponding year?
According to Gambo some of the basic player info comes from the batting.csv, some from the batting2.csv, I do not actually know what comes from where. Yours is probably a good guess but I do not know for sure.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-29-2015, 08:09 AM   #757
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by MarkInCincy View Post
I have been hoping, crossing my fingers, praying, sacrificing chickens/goats,etc since OOTP3 that this happens and I REFUSE to give up on it.
...
Someday our time will come..........
Over the years all the challenges that kept this from happening have been addressed but it has just never been implemented for pre-1901 leagues.

The challenges were
1) must have two sub-leagues (not one, not three)
2) must have an even number of teams in each sub-league

OOTP now works with the above for leagues other than the pre-1901 major leagues. If this was added to the 19th century.......then

the only things left are the auto-release of players from defunct/contracted teams in a league into the free agent pool and true two-way 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-30-2015, 01:45 AM   #758
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
According to Gambo some of the basic player info comes from the batting.csv, some from the batting2.csv, I do not actually know what comes from where. Yours is probably a good guess but I do not know for sure.
Doesn't your description of the DB say that you picked certain teams for multi team players to import to? So what designates that?

Meanwhile I have changed some of my TEAM ID's to correspond to what I think is your designator, such as BSN, although that was not the pre-1876 team id for the Boston team.

We need to campaign OOTP to give this a bit more attention in the future.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 06-30-2015, 11:58 AM   #759
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
Doesn't your description of the DB say that you picked certain teams for multi team players to import to? So what designates that?
The major league organization a player spent the most time (majors and minors) in.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-30-2015, 12:08 PM   #760
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
such as BSN, although that was not the pre-1876 team id for the Boston team.
The designator only changed because the Boston team moved from the LA (pre-1871),NA (pre-1876) to the NL (since then). Using the same designator for them simply keeps all the team records together and available and the player rosters consistant. It is a workaround for now.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze 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 10:40 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