|
||||
|
![]() |
#741 |
OOTP Historical Czar
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! |
![]() |
![]() |
![]() |
#742 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
|
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" ![]() |
![]() |
![]() |
![]() |
#743 |
Hall Of Famer
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
|
You're the best Spritze!
![]() |
![]() |
![]() |
![]() |
#744 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
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! |
![]() |
![]() |
![]() |
#745 |
OOTP Historical Czar
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. |
![]() |
![]() |
![]() |
#746 |
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 |
![]() |
![]() |
![]() |
#747 |
OOTP Historical Czar
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! |
![]() |
![]() |
![]() |
#748 | |
All Star Starter
Join Date: Jun 2002
Posts: 1,363
|
Quote:
![]()
__________________
BASEBALL, HOCKEY AND BOXING FAN |
|
![]() |
![]() |
![]() |
#749 |
OOTP Historical Czar
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! |
![]() |
![]() |
![]() |
#750 |
All Star Starter
Join Date: Jun 2002
Posts: 1,363
|
Yes, so can I change something to get those players to go to the team designated BS1?
__________________
BASEBALL, HOCKEY AND BOXING FAN |
![]() |
![]() |
![]() |
#751 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Quote:
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! |
|
![]() |
![]() |
![]() |
#752 | |
All Star Starter
Join Date: Jun 2002
Posts: 1,363
|
Quote:
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. |
|
![]() |
![]() |
![]() |
#753 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Quote:
Someday things in OOTP pre-1901 may change?
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
|
![]() |
![]() |
![]() |
#754 |
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 |
![]() |
![]() |
![]() |
#755 |
All Star Reserve
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
|
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
|
![]() |
![]() |
![]() |
#756 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
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! |
![]() |
![]() |
![]() |
#757 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Quote:
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! |
|
![]() |
![]() |
![]() |
#758 | |
All Star Starter
Join Date: Jun 2002
Posts: 1,363
|
Quote:
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 |
|
![]() |
![]() |
![]() |
#759 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
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! |
![]() |
![]() |
![]() |
#760 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
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! |
![]() |
![]() |
![]() |
Bookmarks |
|
|