Spritze DB's for OOTP11 - Page 38

Spritze · 06-21-2015, 10:28 AM

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.

The Game · 06-21-2015, 03:06 PM

Quote:

Originally Posted by Spritze

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.

actionjackson · 06-21-2015, 05:53 PM

You're the best Spritze!

Spritze · 06-22-2015, 12:49 AM

Quote:

Originally Posted by The Game

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.

Spritze · 06-27-2015, 12:45 PM

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.

RANGER11JP · 06-28-2015, 06:48 PM

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

Spritze · 06-28-2015, 06:57 PM

Teams = Lahman

IND = Player never played in the Majors and all the other teams he played on were Independent ones.

RANGER11JP · 06-28-2015, 07:42 PM

Quote:

Originally Posted by Spritze

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.

Spritze · 06-28-2015, 07:54 PM

The Boston Red Stockings of 1871 eventually became known as the Boston Braves.

RANGER11JP · 06-28-2015, 10:01 PM

Quote:

Originally Posted by Spritze

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?

Spritze · 06-28-2015, 11:06 PM

Quote:

Originally Posted by RANGER11JP

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.

RANGER11JP · 06-28-2015, 11:37 PM

Quote:

Originally Posted by Spritze

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?

Spritze · 06-28-2015, 11:59 PM

Quote:

Originally Posted by RANGER11JP

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?

RANGER11JP · 06-29-2015, 12:20 AM

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.

MarkInCincy · 06-29-2015, 06:06 AM

Quote:

Originally Posted by Spritze

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..........

Spritze · 06-29-2015, 07:55 AM

Quote:

Originally Posted by RANGER11JP

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.

Spritze · 06-29-2015, 08:09 AM

Quote:

Originally Posted by MarkInCincy

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.

RANGER11JP · 06-30-2015, 01:45 AM

Quote:

Originally Posted by Spritze

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.

Spritze · 06-30-2015, 11:58 AM

Quote:

Originally Posted by RANGER11JP

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.

Spritze · 06-30-2015, 12:08 PM

Quote:

Originally Posted by RANGER11JP

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.

06-21-2015, 10:28 AM	#741
Spritze 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!

06-27-2015, 12:45 PM	#745
Spritze 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.

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

06-28-2015, 06:57 PM	#747
Spritze 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!

06-28-2015, 07:54 PM	#749
Spritze 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!

06-21-2015, 05:53 PM	#743
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,163	You're the best Spritze!

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