***Updated on the Corrected Lahman 4.5 Database***

[Scott Vibert]

Well, I've sent Sean an email to check...

Unfortunately by the letter of the law, posting the database or any of the files of the database at any other site for distribution is in violation of the liscence agreement you accept by downloading and using the database.

Here are the lines from the Read Me file within the Lahman Database.
</font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">
It may not be re-distributed without permission. Any commercial use, or other dissemination of the database in part or in whole is prohibited.
</font><hr /></blockquote><font size="2" face="Verdana, Arial">

[grismosw]

Simple ask for permission

[Scott Vibert]

</font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by grismosw:
<strong>Simple ask for permission </strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">Already been done... just need a response.

[Scott Vibert]

I believe the latest corrected version is now available at Warren's site... it's probably worth checking out if you've been waiting for it.

<a href="http://www.tresclub.com/downloads/downloads.htm" target="_blank">http://www.tresclub.com/downloads/downloads.htm</a>

<small>[ 05-05-2002, 05:23 PM: Message edited by: ScottVib ]</small>

[BasicGuy]

Scott I tried your fixed database and tried importing 1994. I still am haveing pitchers with unbelivable stats. Roger Clemens had nearly 300 wins In 94 and was avg over 30 wins a season looking at his history.

Did I use your improved database wrong? Any help would be greatly appreciated.

[Malleus Dei]

Is there a corrected 4.5 veriosn with the positional data fixed available yet?

[IatricSB]

Scott had sent me his editted files and I was going to use the weekend to work on getting some edited versions done. However, I got wrapped up in some BoS League work and didn't get it done. First evening I get some time I plan on finishing it unless someone else beats me to it.

[Scott Vibert]

Malleus, the version I sent IatricSB should be available at Tresclub's site.

<a href="http://www.tresclub.com/downloads/downloads.htm" target="_blank">http://www.tresclub.com/downloads/downloads.htm</a>

Basic Guy, I'll take a look at that season tonight and specifically look out for Roger Clemens.. I know I had no such errors when I tested it, make sure you are importing a version 4.5 database. Also check the file, there should be two readme files, one is the standard Lahman Readme and the other would be the Readme I included... if the date on that ReadMe says April 30th than you should have the latest.

[Malleus Dei]

Thanks, guys. My own roster work is on hold until there's a solid data base to work from.

Thanks to both of you for your good work.

[Scott Vibert]

Basic Guy, I just imported the database and had no issues with that season:

Clemens showed up with 1994 stats of:

9-7 in 24 starts 2.84 ERA

his other stats appear accurate as well.

Are you sure you had the most recent version of my revised database?

[BasicGuy]

Scott to make sure I redownloaded this file

<a href="http://www.tresclub.com/downloads/revdb45.zip" target="_blank">http://www.tresclub.com/downloads/revdb45.zip</a>

and tried to import the 1994 season and a lot of the pitchers seem to get double stats. I'm useing 4.0c which Is the last release of OOTP 4.

I also made sure It stated version 4.5 when Importing. And this download has the two readmes you mentioned. Is there any chance you sent him the wrong database files ziped with the readmes?

[Scott Vibert]

</font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by BasicGuy:
<strong>
I also made sure It stated version 4.5 when Importing. And this download has the two readmes you mentioned. Is there any chance you sent him the wrong database files ziped with the readmes?</strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">I don't think so the readmes only exist on my computer in my Stats folder and the dates on the files looked right to me.... Anyone else having problems with the statistics? What folder to you have the .csv files in? I'll try it again over the weekend (can't get to it tonight)...

I have my database in C:\Stats for the folder and have no older versions of the database on my machine (that I know off)... if the pitchers are getting double stats it would be a sign that the TOT field was still in the file for that season, I don't see it (in fact TOT doesn't exist in the Pitching.csv file according to a quick search), but do the pitchers with the statistical problems have TOT listed as one of their teams? If they do then somehow you are reading a different version of the pitching.csv file to get the stats than came in the revised Database... the date on the file should be 4/29 about 11:55pm...

What are the dates in the file that you have downloaded? Did you overwrite all the old files with the new stuff?

[blmeanie]

Here's what I'd suggest:

using my computer or windows explorer, search for pitching.csv on all hard drives and delete all instances. Then re-extract from the zip file to the folder you want it in.

Try again.

[BasicGuy]

Scott I do have 3 database folders I use....I have Stats(which is the one I use to import rookies each season and Is a V4 database),Stats4(which Is the version 4 one I use to start a league the first season), And Stats45(which Is your fixed version).

I checked the dates and there correct. Tonight I will delete the other 2 dirs and move yours to just plain stats dir and try agian.

Thanks for all the help......Its more than likely my fault

[BasicGuy]

Ok I deleted the other versions and left only the version I downloaded from the above link. And still have the problem. I cant figure out what I'm doing wrong(I relize Its more than likely my fault <img border="0" title="" alt="[Wink]" src="wink.gif" /> ).

Here's Roger Clemens Career stats from importing the 1994 season.

CAREER STATS :

YEAR ERA W L S G CG SHO IP ER BB K TEAMS
1984 4.33 21 9 0 4 5 1 133.0 64 29 126 BOS
1985 3.31 15 7 0 5 3 1 98.0 36 37 74 BOS
1986 2.48 33 24 0 4 10 1 254.0 70 67 238 BOS
1987 2.97 36 20 0 9 18 7 282.0 93 83 256 BOS
1988 2.93 35 18 0 12 14 8 264.0 86 62 291 BOS
1989 3.13 35 17 0 11 8 3 253.0 88 93 230 BOS
1990 1.93 31 21 0 6 7 4 228.0 49 54 209 BOS
1991 2.62 35 18 0 10 13 4 271.0 79 65 241 BOS
1992 2.40 32 18 0 11 11 5 247.0 66 62 208 BOS
1993 4.45 29 11 0 14 2 1 192.0 95 67 160 BOS

Total ERA : 2.94
Total Wins : 302
Total Losses: 163
Total Saves : 0
Total SHO : 35
Total CG : 91
Total K's : 2033
Total BB's : 619

And there are others that are off like this too. Any help into what I could of did to make this happen?

[BasicGuy]

Had to post this as I got a kick out of the top 25 career win leaders

WINS TOP 25
1) Rich Gossage * 966-121
2) Jeff Reardon * 869-72
3) Lee Smith * 850-67
4) Charlie Hough * 837-211
5) Dennis Eckersley * 804-183
6) Jesse Orosco * 714-66
7) Dave Righetti * 688-79
8) Larry Andersen * 670-39
9) Craig Lefferts * 666-57
10) Steve Bedrosian * 657-75
11) Rick Honeycutt * 640-101
12) Greg a. Harris * 620-69
13) Roger Mcdowell * 586-62
14) Mark Davis * 585-51
15) Danny Darwin * 585-138
16) Mitch Williams * 567-43
17) John Franco * 566-62
18) Dennis Martinez * 558-208
19) Tom Henke * 553-37
20) Paul Assenmacher * 531-41
21) Rob Murphy * 530-27
22) Jay Howell * 528-54
23) Jack Morris * 526-244
24) Mark Eichhorn * 496-41
25) Jim Gott * 492-49

Now thats a lot of wins

[Malleus Dei]

Basic:

Delete yuor c:\stats directory.

Unzip the revised 4.5 into c:\stats. When asked if you want to create it, say yes.

Now import a pitcher, specifying c:\stats as the directory.

If THAT doesn't work, then you are cursed and there is no helping you.

[AngelinOF]

I was able to recreate your problem by stating version 4.5 was 4.0 when it asked. Any pitcher I imported had his games show up as his wins. Double check to make sure that when the game asks what version you are using that you click the 4.5 tab.

Also on note of the revised database, not a big deal but, Johnny Vander Meer imports with a blank orgin he was born in Prospect Park, New Jersey I do believe.

<small>[ 05-10-2002, 04:49 AM: Message edited by: AngelinOF ]</small>

[BasicGuy]

Ok this Is really strange I deleted my C:\stats folder and redownloaded the database and extracted It to that folder agian.

In the game when you create a new league the game automaticly sets It self for version 4.5 unless you change It......but to be safe I clicked through all the options till It stated 4.5 agian.

And still the same thing.......Now I've done enough Software tech support to know its more than likely my fault.....but where????

I checked to make sure I have the right files.....right dir.....I make sure its set to the correct dir in the game, And that Its set to the right database version in the game.

I'm not saying its OOTP or the databases fault as that seems imposible but what other user error could I have done.

I'll try reinstalling OOTP4 maybe some how OOTP got corupt and even though I'm telling it version 4.5 it still thinks its version 4.0

[Malleus Dei]

Basic, time for an exorcism!