2009 Sean Lahman Database is now available - Page 3

Markus Heinsohn · 01-21-2010, 06:02 AM

Quote:

Originally Posted by The Real MD

Oh, there will be one...it's called OOTP 11.

Right.

We do not know what changes get done to the database from year to year, so we cannot provide updates in an easy way.

OOTP 11 will work properly with the 5.7 version of the Lahman DB.

KennyV17 · 01-21-2010, 08:23 AM

Quote:

Originally Posted by Markus Heinsohn

Actually, the stats do not get imported other than the initial import of the player... so in this case, the game will not use the 2009 stats.

Thank you Markus for clarifying this.

I have two follow up questions:

1 - Does this mean that when you create a fictional historical league, technically the league has an "artificial shelf life" that expires once you reached whatever is the last year that is in the database you used?

So for example if you used the 2008 version of the database, and you decide to begin simming starting with the 1995 season, you could play 13 seasons before it runs out of data. And if that's correct, then what does the game do?

2 - If the stats only come in during the initial import, what exactly does the "Historical Progressing Options" do? Specifically the "Recalc player ratings based on real stats after each year"?

Kenny V

FigMan · 01-27-2010, 01:46 PM

Can someone please tell me which column G_batting is in the batting.csv? I don't have anything on this pc that will allow me to open the Access database (too large). It doesn't seem to be the 3rd or 4th column, more likely the 6th or 7th.
They seem to have forgotten a ReadMe.Txt file this year, so this may be the first surprise I bump into. Can someone also tell me what this new column is that I'll be deleting?
Thanks!

KennyV17 · 01-27-2010, 03:13 PM

Figman,

I was able to to modify the .CSV file of the database (removing Column G) using a borrowed version of Excel 2007. If your interested, PM me and I'll e-mail it to you

Maybe I can find a place online so you can download it.

Kenny V

Bluenoser · 01-27-2010, 03:19 PM

Quote:

Originally Posted by KennyV17

1 - Does this mean that when you create a fictional historical league, technically the league has an "artificial shelf life" that expires once you reached whatever is the last year that is in the database you used?

So for example if you used the 2008 version of the database, and you decide to begin simming starting with the 1995 season, you could play 13 seasons before it runs out of data. And if that's correct, then what does the game do?

Kenny V

Not following you on this one. If it's a "Fictional" historical league, why are you even using the DB?

FigMan · 01-27-2010, 04:15 PM

Thanks, Kenny. I can have a neighbor delete the column for me. I thought G_batting was the column name. I see from your post that it's the position. Column g, i.e., the 7th column. Correct me if I'm wrong. Thanks again! I'll post here if I have any more problems. I use his database in a java web app I wrote for personal use and each year the data is a bit different, and I need to make some changes. Usually there's a Readme.txt file included, not this year (yet?).

FigMan · 01-27-2010, 04:20 PM

I'm still curious what that column is, maybe it's something I want to include in what I'm doing..

KennyV17 · 01-27-2010, 07:23 PM

Quote:

Originally Posted by BruceM

Not following you on this one. If it's a "Fictional" historical league, why are you even using the DB?

The league is fictional meaning the teams and leagues are made up, but all the players involved are from MLB. There are no fictional players involved.

Kenny V

KennyV17 · 01-27-2010, 07:25 PM

Quote:

Originally Posted by FigMan

I'm still curious what that column is, maybe it's something I want to include in what I'm doing..

From the look of the numbers, it appears that it's an exact replica of what is in the column next to it. It holds the 'G' stats indicating how many games the players appeared in. Not sure why it was duplicated.

Kenny V

FigMan · 01-27-2010, 10:08 PM

That's what I thought too. I paged through it using TextPad and didn't see anything. My friend checked for me in Access (he was going to delete the 7th column for me) and found 12,093 rows having different values in those 2 columns (out of 92,706 rows). I'm assuming it's something new and that the other columns are the same as last year.. In the past the files had header records showing the layout.

kagnew35 · 02-16-2010, 02:06 AM

Can one of the more experienced members just set this up properly and provide a link to it?

trendon · 02-16-2010, 03:14 AM

Can I be the first clown to ask ... what is the benefit of this over the stock OOTP historical seasons?

Spritze · 02-16-2010, 09:29 AM

the batting.csv has two new fields

G_Batting = games where a player had a plate appearance
G_old = sorta self explanatory

G_old is the last column in the batting.csv

The new Fielding.csv has 4 or 5 new columns as well and one (ZR) has moved to the last column with the new ones inserted ahead of it.

KennyV17 · 02-16-2010, 09:43 PM

Quote:

Originally Posted by kagnew35

Can one of the more experienced members just set this up properly and provide a link to it?

This is the database that I corrected and currently using. Haven't run into any problems yet.

RapidShare: 1-CLICK Web hosting - Easy Filehosting

KennyV17 · 02-16-2010, 09:48 PM

Quote:

Originally Posted by trendon

Can I be the first clown to ask ... what is the benefit of this over the stock OOTP historical seasons?

Well, depending on what version of OOTP you purchased, you will only have historical seasons up to a certain year. So if you are using OOTP 9, the historical database that was provided only went up to 2007 IIRC.

However, as I understand how most people play OOTP, having the latest year of stats probably doesn't make much of a difference.

02-16-2010, 02:06 AM	#51 (permalink)
kagnew35 All Star Starter Join Date: Dec 2005 Location: Las Vegas, Nev Posts: 1,967 Thanks: 184 Thanked 58x in 14 posts	Can one of the more experienced members just set this up properly and provide a link to it? __________________ Elder Statesman of the Board http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

01-27-2010, 01:46 PM	#43 (permalink)
FigMan Bat Boy Join Date: Jan 2010 Posts: 4 Thanks: 0 Thanked 0x in 0 posts	Can someone please tell me which column G_batting is in the batting.csv? I don't have anything on this pc that will allow me to open the Access database (too large). It doesn't seem to be the 3rd or 4th column, more likely the 6th or 7th. They seem to have forgotten a ReadMe.Txt file this year, so this may be the first surprise I bump into. Can someone also tell me what this new column is that I'll be deleting? Thanks!

01-27-2010, 03:13 PM	#44 (permalink)
KennyV17 Minors (Single A) Join Date: Jan 2007 Location: Syracuse, NY Posts: 77 Thanks: 2 Thanked 4x in 2 posts	Figman, I was able to to modify the .CSV file of the database (removing Column G) using a borrowed version of Excel 2007. If your interested, PM me and I'll e-mail it to you Maybe I can find a place online so you can download it. Kenny V

01-27-2010, 04:15 PM	#46 (permalink)
FigMan Bat Boy Join Date: Jan 2010 Posts: 4 Thanks: 0 Thanked 0x in 0 posts	Thanks, Kenny. I can have a neighbor delete the column for me. I thought G_batting was the column name. I see from your post that it's the position. Column g, i.e., the 7th column. Correct me if I'm wrong. Thanks again! I'll post here if I have any more problems. I use his database in a java web app I wrote for personal use and each year the data is a bit different, and I need to make some changes. Usually there's a Readme.txt file included, not this year (yet?).

01-27-2010, 04:20 PM	#47 (permalink)
FigMan Bat Boy Join Date: Jan 2010 Posts: 4 Thanks: 0 Thanked 0x in 0 posts	I'm still curious what that column is, maybe it's something I want to include in what I'm doing..

01-27-2010, 10:08 PM	#50 (permalink)
FigMan Bat Boy Join Date: Jan 2010 Posts: 4 Thanks: 0 Thanked 0x in 0 posts	That's what I thought too. I paged through it using TextPad and didn't see anything. My friend checked for me in Access (he was going to delete the 7th column for me) and found 12,093 rows having different values in those 2 columns (out of 92,706 rows). I'm assuming it's something new and that the other columns are the same as last year.. In the past the files had header records showing the layout.

02-16-2010, 03:14 AM	#52 (permalink)
trendon Minors (Single A) Join Date: Jul 2009 Posts: 66 Thanks: 21 Thanked 9x in 2 posts	Can I be the first clown to ask ... what is the benefit of this over the stock OOTP historical seasons?

02-16-2010, 09:29 AM	#53 (permalink)
Spritze Hall Of Famer Join Date: Dec 2001 Location: Redmond Wa and Cape Coast Ghana Posts: 2,946 Thanks: 16 Thanked 344x in 242 posts	the batting.csv has two new fields G_Batting = games where a player had a plate appearance G_old = sorta self explanatory G_old is the last column in the batting.csv The new Fielding.csv has 4 or 5 new columns as well and one (ZR) has moved to the last column with the new ones inserted ahead of it.