2005 Lahman, may be a new format

arod23 · 01-04-2006, 10:49 AM

As many of you have noted, the 2005 update to the Lahman DB (www.baseball1.com) has not been posted yet. Typically, it is posted in early November. The reason is that there are discussions taking place about changing the format.

Attention Markus:
If there are changes to the format, then the ability to do historical sims in the new version will obviously be impacted. In fact, the current version of OOTP won't work either. Even if one field is changed/moved in Lahman, importing will not work or at best contain major errors.

Fixing things like reordering, eliminating columns to correspond to OOTP import format is not that difficult and Garlon and I will volunteer to make an OOTP-compatible Lahman DB if neccessary. However, despite the 100s (are there 100s?) of custom DBs created by the community, my guess is that more users still import directly from Lahman (certainly those new to OOTP use it first). That means that the new version will not work "out of the box" for historical simmers without using a "mod DB".

Markus, I know you spoke with Sean Lahman when developing OOTP, so I think a new discussion is warranted.

kingpin1976 · 01-04-2006, 10:59 AM

I have a 2005 version already,it came out for Puresim.

arod23 · 01-04-2006, 11:08 AM

I am not speaking specifically about 2005 stats but the change in the general format of the importing DB, which could affect the ability to historically sim.

Malleus Dei · 01-04-2006, 07:35 PM

No big deal, we can always use the modified 2005 PureSim one, which we already have.

SeanLahman · 01-06-2006, 11:59 AM

arod wrote...
> As many of you have noted, the 2005 update to the Lahman DB
> (www.baseball1.com) has not been posted yet. Typically, it is posted
> in early November. The reason is that there are discussions taking
> place about changing the format.

Actually, the main reason for the delay is that I'm behind on the deadline for my new book.

The new version of the Lahman database will be available on the web tomorrow (Saturday January 7), and there will be no changes to the underlying database structure. Importing past seasons should be transparent.

Arod is correct that changes to the design are being discussed, and if those are implemented, I'll let Markus know ahead of time so that he can make the necessary changes to the importing code.

Thanks to the hundreds of you who've sent emails asking when the new database would be ready ;-) I appreciate your patience.

ctorg · 01-06-2006, 12:56 PM

Quote:

Originally Posted by SeanLahman

arod wrote...
> As many of you have noted, the 2005 update to the Lahman DB
> (www.baseball1.com) has not been posted yet. Typically, it is posted
> in early November. The reason is that there are discussions taking
> place about changing the format.

Actually, the main reason for the delay is that I'm behind on the deadline for my new book.

The new version of the Lahman database will be available on the web tomorrow (Saturday January 7), and there will be no changes to the underlying database structure. Importing past seasons should be transparent.

Arod is correct that changes to the design are being discussed, and if those are implemented, I'll let Markus know ahead of time so that he can make the necessary changes to the importing code.

Thanks to the hundreds of you who've sent emails asking when the new database would be ready ;-) I appreciate your patience.

Well, there you have it folks. Official word. Thanks!

arod23 · 01-06-2006, 01:12 PM

Excellent news!!

Thanks Sean

99Ballons · 01-06-2006, 07:04 PM

Sorry to post this here, but I can't find the "Troubleshooting Forum"

I'm running OOTP 6.5 and I just copied the Lahman Database to c:\stats like the screen says.

When I click 'Import League', the game crashes.

Does anyone know how to fix this?!?

rem · 01-06-2006, 07:24 PM

Thanks Sean!

Exodor · 01-07-2006, 06:28 PM

Just checked and the new database, including the 2005 season, is up at http://www.baseball1.com/

tim_uwrf · 01-07-2006, 07:09 PM

I seem to be getting a crash in OOTP5 (all previous versions worked in OOTP5) Is it because there are two Batting files and two Fielding files. Does that affect anything?

Malleus Dei · 01-07-2006, 11:37 PM

Quote:

Originally Posted by SeanLahman

I appreciate your patience.

What patience?

Malleus Dei · 01-07-2006, 11:37 PM

Quote:

Originally Posted by 99Ballons

Sorry to post this here, but I can't find the "Troubleshooting Forum"

http://www.ootpdevelopments.com/boar...splay.php?f=14

andymac · 01-07-2006, 11:44 PM

Quote:

Originally Posted by tim_uwrf

I seem to be getting a crash in OOTP5 (all previous versions worked in OOTP5) Is it because there are two Batting files and two Fielding files. Does that affect anything?

Yea, that would be it. Change whichever batting file you are wanting to use for the input to batting.csv and it should work.

Or you can combine the two using a text editor (like notepad) and that way you will only need the one file. The reason it is split up is because combined the file contains more rows than most spreadsheet applications can handle.

tim_uwrf · 01-08-2006, 01:21 AM

Gotcha. Thanks dude for the help.

SeanLahman · 01-08-2006, 02:11 PM

Quote:

Originally Posted by tim_uwrf

I seem to be getting a crash in OOTP5 (all previous versions worked in OOTP5) Is it because there are two Batting files and two Fielding files. Does that affect anything?

That's my fault guys. I added the split files for batting and fielding this year for the folks who want to use the data in a spreadsheet. I didn't mean to leave out the original batting and fielding tables. I've added them to the zip file, and if you download it again, you shouldn't have the problem.. You can also manually add the two files together, as andymac suggested.

tim_uwrf · 01-08-2006, 02:56 PM

Quote:

Originally Posted by SeanLahman

That's my fault guys. I added the split files for batting and fielding this year for the folks who want to use the data in a spreadsheet. I didn't mean to leave out the original batting and fielding tables. I've added them to the zip file, and if you download it again, you shouldn't have the problem.. You can also manually add the two files together, as andymac suggested.

Thanks Sean. Wasn't blaming you for anything. What you do is a great thing for baseball and OOTP is obviously not your target audience, although it is great to be able to put your database to use for OOTP.

adichiara · 01-08-2006, 10:48 PM

When will it be on excel?

andymac · 01-08-2006, 10:52 PM

Quote:

Originally Posted by adichiara

When will it be on excel?

You can open .csv files in excel.

adichiara · 01-08-2006, 11:18 PM

OK, is there any way to get it so you have player names instead of ids (regular season sheet)?

01-04-2006, 10:49 AM	#1
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 378	2005 Lahman, may be a new format As many of you have noted, the 2005 update to the Lahman DB (www.baseball1.com) has not been posted yet. Typically, it is posted in early November. The reason is that there are discussions taking place about changing the format. Attention Markus: If there are changes to the format, then the ability to do historical sims in the new version will obviously be impacted. In fact, the current version of OOTP won't work either. Even if one field is changed/moved in Lahman, importing will not work or at best contain major errors. Fixing things like reordering, eliminating columns to correspond to OOTP import format is not that difficult and Garlon and I will volunteer to make an OOTP-compatible Lahman DB if neccessary. However, despite the 100s (are there 100s?) of custom DBs created by the community, my guess is that more users still import directly from Lahman (certainly those new to OOTP use it first). That means that the new version will not work "out of the box" for historical simmers without using a "mod DB". Markus, I know you spoke with Sean Lahman when developing OOTP, so I think a new discussion is warranted.

01-06-2006, 11:59 AM	#5
SeanLahman Bat Boy Join Date: Jan 2003 Posts: 10	arod wrote... > As many of you have noted, the 2005 update to the Lahman DB > (www.baseball1.com) has not been posted yet. Typically, it is posted > in early November. The reason is that there are discussions taking > place about changing the format. Actually, the main reason for the delay is that I'm behind on the deadline for my new book. The new version of the Lahman database will be available on the web tomorrow (Saturday January 7), and there will be no changes to the underlying database structure. Importing past seasons should be transparent. Arod is correct that changes to the design are being discussed, and if those are implemented, I'll let Markus know ahead of time so that he can make the necessary changes to the importing code. Thanks to the hundreds of you who've sent emails asking when the new database would be ready ;-) I appreciate your patience. __________________ Sean Lahman http://baseball1.com http://footballproject.com

01-06-2006, 07:04 PM	#8
99Ballons Banned Join Date: Jan 2006 Location: Bristol, CT, USA Posts: 97	Another OOTP Crash Argh! Sorry to post this here, but I can't find the "Troubleshooting Forum" <!--StartFragment -->I'm running OOTP 6.5 and I just copied the Lahman Database to c:\stats like the screen says. When I click 'Import League', the game crashes. Does anyone know how to fix this?!?

01-06-2006, 07:24 PM	#9
rem Hall Of Famer Join Date: Jul 2003 Location: College Park, Md. Posts: 5,024	Thanks Sean! __________________ OTBA: Washington Filibusters CLBR: Minnesota Twins 2005 Winner of LL's Pick the Loser Contest! - 15-0

01-04-2006, 10:59 AM	#2
kingpin1976 Major Leagues Join Date: Oct 2003 Posts: 402	I have a 2005 version already,it came out for Puresim.

01-04-2006, 11:08 AM	#3
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 378	I am not speaking specifically about 2005 stats but the change in the general format of the importing DB, which could affect the ability to historically sim.

01-06-2006, 01:12 PM	#7
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 378	Excellent news!! Thanks Sean

01-07-2006, 06:28 PM	#10
Exodor Major Leagues Join Date: Apr 2005 Location: Portland, OR Posts: 481	Just checked and the new database, including the 2005 season, is up at http://www.baseball1.com/

01-07-2006, 07:09 PM	#11
tim_uwrf Hall Of Famer Join Date: Sep 2003 Location: Field of Dreams Posts: 1,998	I seem to be getting a crash in OOTP5 (all previous versions worked in OOTP5) Is it because there are two Batting files and two Fielding files. Does that affect anything?

01-08-2006, 01:21 AM	#15
tim_uwrf Hall Of Famer Join Date: Sep 2003 Location: Field of Dreams Posts: 1,998	Gotcha. Thanks dude for the help.

01-08-2006, 10:48 PM	#18
adichiara Minors (Double A) Join Date: Jun 2004 Posts: 121	When will it be on excel?

01-08-2006, 11:18 PM	#20
adichiara Minors (Double A) Join Date: Jun 2004 Posts: 121	OK, is there any way to get it so you have player names instead of ids (regular season sheet)?