Spritze/Garlon DB - Page 5

rasnell · 01-15-2008, 03:36 AM

garlon/spritz: any reason why this won't run on OOTP 08? Causes a crash. Also no readme instructions. I tried 2 ways: 1) Just exactly as you created it; and 2) copying all Lahman files into a folder, then copying your files into the same folder and allowing it to overwrite. Neither way works in 08.

Tips?

Will it work in OOTP 07? Instructions?

Spritze · 01-15-2008, 04:29 PM

I use way two (2) and it works for me in both versions. (at least it worked once in a row)

So I don't have any good ideas what might be goofy in your setup. I don't have any bad ideas either.

Sorry.
The Idea Man who has no ideas

rasnell · 01-15-2008, 07:30 PM

I'll try again and see what happens.

Bristolduke · 01-15-2008, 07:47 PM

Make sure you have the other Lahman CSV files included. SO you have the Spritze/GArlon Master, batting, fielding, fieldingOF and Pitcher and the rest of the Lahman files. I think the main one the game needs is the teams.csv, but I include them all.

Bristolduke · 01-16-2008, 09:54 AM

Spritze/Garlon,

I noticed an anomoly on Bob Watson

Watson batted once in 1966 (ph only so no position data)
he played in 6 games(14 AB) in 1967 and played 3 games at 1B
1968 he played 45 games(140 AB) and played 40 in LF none at 1B

You have the fielding data correct but your batting data shows
1966 75 games 249 AB (this is a real problem with no fielding data)
1967 76 games 251 AB
1968 78 ganes 251 AB

Seems inconsistent.

Thanks

swampdragon · 01-16-2008, 01:14 PM

Quote:

Originally Posted by Spritze

I use way two (2) and it works for me in both versions. (at least it worked once in a row)

So I don't have any good ideas what might be goofy in your setup. I don't have any bad ideas either.

Sorry.
The Idea Man who has no ideas

That works for me as well. There are some things that can improve the db. I've mentioned the fielding.csv file earlier. Also, the nickname field in the master file has to be edited for every player. If that's not done, you get errors in the play-by-play when the game looks for a nickname.

Spritze · 01-16-2008, 07:03 PM

Bristolduke: That is not an anomoly. It is the way Mr. Garlon insisted it should be. In Version 2 I am going to adjust this. It bugs me too. Fielding should track with games played. 250ab's or so are the minimum allowed in this db so games/innings in the field should flow along with that.

swampdragon: Nicknames seem to work for me in PBP. Is it due to the length of some? I have yet to notice any challenges in names of the nick. They can be removed but I'd like to try to save them if possible. Any ideas?

swampdragon · 01-16-2008, 09:03 PM

Quote:

Originally Posted by Spritze

Bristolduke: That is not an anomoly. It is the way Mr. Garlon insisted it should be. In Version 2 I am going to adjust this. It bugs me too. Fielding should track with games played. 250ab's or so are the minimum allowed in this db so games/innings in the field should flow along with that.

swampdragon: Nicknames seem to work for me in PBP. Is it due to the length of some? I have yet to notice any challenges in names of the nick. They can be removed but I'd like to try to save them if possible. Any ideas?

The nickname fields in my download have all been cleared and replaced with a single space. The players come up on the player screen with ' ' between their first and last names, even the ones that had nicknames in Lahman.

rasnell · 01-17-2008, 05:06 AM

Got it working. Must have done something wrong in creating the new folder, copying Lahman, then overwriting with Garlon. Everything fine now. Thanks.

tkirch · 01-23-2008, 06:25 PM

I notice that when I import some strarting pitchers lose their ENDURANCE down to 8. Any reason for this?

Spritze · 01-24-2008, 12:41 PM

This is by design as that is how Mr. Garlon wanted it.

In the next version this will not be so.

Aytumious · 02-03-2008, 01:14 PM

I'm not sure why exactly, but I imported a 1997 season and the Braves only have 23 players in their entire organization.

They have only 8 pitchers:

Maddux
Smoltz
Glavine
Neagle
Bielecki
Wohlers
Wade
Clontz

Any ideas why this is the case?

http://www.baseball-reference.com/teams/ATL/1997.shtml

Embree, Byrd, Millwood, Fox, etc. don't exist anywhere in the universe.

Other teams seem fine, though they only have 26-30 players. I setup the DB by extracting Lahman first then copying your DB over the that.

Spritze · 02-04-2008, 06:52 PM

The db edits sorta halt in 1997 so it probably has something to do with that. This is another thing that will be changed with the next version. I am going all the way to the current Lahman rather than stopping a decade early. I think Mr. G wanted to halt there due to some of the weirder edits he wanted made but most of those I have dropped and I have not seen any challenges like this using the latest Lahman up through last year -2007.

Hopefully Version 2 will be out by March. I have made the necessary changes based on what has been reported here. If any other problems crop up please note them in this thread.

Thankee

Aytumious · 02-05-2008, 09:25 AM

Quote:

Originally Posted by Spritze

The db edits sorta halt in 1997 so it probably has something to do with that. This is another thing that will be changed with the next version. I am going all the way to the current Lahman rather than stopping a decade early. I think Mr. G wanted to halt there due to some of the weirder edits he wanted made but most of those I have dropped and I have not seen any challenges like this using the latest Lahman up through last year -2007.

Hopefully Version 2 will be out by March. I have made the necessary changes based on what has been reported here. If any other problems crop up please note them in this thread.

Thankee

Thanks.

I have a question. I'd prefer to use your set because of the normalizing you've done, but I may start a franchise with the Gambo set while I wait for your update. Is it possible to take the defensive files that you've created and copy those over what is in the Gambo set? I'd much prefer your setup. I'm guessing it would be fine, with the only potential problem being that Gambo is setup to add players when they were originally signed as opposed to when they made their debut.

If it is possible, which files would I use?

Edit:
Actually, it looks like your FieldingOF file only goes to 1995. Correct?

Spritze · 02-05-2008, 12:22 PM

Just copy over the fielding and fieldingof files. Howsomeever if you do this you will have years with no fielding data at all since the db's have different starting points.

Debuts are controlled by the master so that should be okey-dokey as well.

Spritze · 02-08-2008, 07:21 PM

Just finished version 2 build1 of the db for OOTP8/2007. I forgot to take it home with me this weekend but once I am back at work I'll get it posted.
Fixed all the issues mentioned here and added 2007 Major league data.

kagnew35 · 02-11-2008, 07:57 PM

Spritz, where are you?

Spritze · 02-12-2008, 12:48 PM

I am sitting in a chair at a desk programming manufacturing equipment so digital art files can be used to create printing plates so the boxes around products you buy can look pretty when you recycle them.

Where are you?

greendiver · 02-12-2008, 01:36 PM

Quote:

Originally Posted by swampdragon

The nickname fields in my download have all been cleared and replaced with a single space. The players come up on the player screen with ' ' between their first and last names, even the ones that had nicknames in Lahman.

Baseball is right around the corner, so I fired up OOTP with the Spritze/garlon database to set up a league and ran into the problem above. Didn't see a reply to this issue. Were the nicknames removed by design, or will they be back in the pending version 2

Spritze · 02-12-2008, 01:42 PM

Yes they will be back.

01-15-2008, 03:36 AM	#81
rasnell Hall Of Famer Join Date: Jan 2003 Location: Frankfort, Kentucky Posts: 3,739	garlon/spritz: any reason why this won't run on OOTP 08? Causes a crash. Also no readme instructions. I tried 2 ways: 1) Just exactly as you created it; and 2) copying all Lahman files into a folder, then copying your files into the same folder and allowing it to overwrite. Neither way works in 08. Tips? Will it work in OOTP 07? Instructions? __________________ Charlie Root won more games for the Cubs than any pitcher (201), yet was remembered for one pitch to Babe Ruth. Find out more about the 1929 World Series in my book, "Root for the Cubs: Charlie Root and the 1929 Chicago Cubs." See the web site at www.rootforthecubs.com. The book is at http://www.amazon.com/Root-Cubs-Char...t+for+the+cubs. Beta tester, OOTP 2007-2023 and iOOTP 2011-2014.

01-15-2008, 04:29 PM	#82
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Iwfm I use way two (2) and it works for me in both versions. (at least it worked once in a row) So I don't have any good ideas what might be goofy in your setup. I don't have any bad ideas either. Sorry. The Idea Man who has no ideas

01-15-2008, 07:30 PM	#83
rasnell Hall Of Famer Join Date: Jan 2003 Location: Frankfort, Kentucky Posts: 3,739	I'll try again and see what happens. __________________ Charlie Root won more games for the Cubs than any pitcher (201), yet was remembered for one pitch to Babe Ruth. Find out more about the 1929 World Series in my book, "Root for the Cubs: Charlie Root and the 1929 Chicago Cubs." See the web site at www.rootforthecubs.com. The book is at http://www.amazon.com/Root-Cubs-Char...t+for+the+cubs. Beta tester, OOTP 2007-2023 and iOOTP 2011-2014.

01-17-2008, 05:06 AM	#89
rasnell Hall Of Famer Join Date: Jan 2003 Location: Frankfort, Kentucky Posts: 3,739	Got it working. Must have done something wrong in creating the new folder, copying Lahman, then overwriting with Garlon. Everything fine now. Thanks. __________________ Charlie Root won more games for the Cubs than any pitcher (201), yet was remembered for one pitch to Babe Ruth. Find out more about the 1929 World Series in my book, "Root for the Cubs: Charlie Root and the 1929 Chicago Cubs." See the web site at www.rootforthecubs.com. The book is at http://www.amazon.com/Root-Cubs-Char...t+for+the+cubs. Beta tester, OOTP 2007-2023 and iOOTP 2011-2014.

02-11-2008, 07:57 PM	#97
kagnew35 All Star Starter Join Date: Dec 2005 Location: Las Vegas, Nev Posts: 1,965	Spritz, where are you? __________________ Elder Statesman of the Board http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room

01-15-2008, 07:47 PM	#84
Bristolduke All Star Starter Join Date: May 2006 Posts: 1,404	Make sure you have the other Lahman CSV files included. SO you have the Spritze/GArlon Master, batting, fielding, fieldingOF and Pitcher and the rest of the Lahman files. I think the main one the game needs is the teams.csv, but I include them all.

01-16-2008, 09:54 AM	#85
Bristolduke All Star Starter Join Date: May 2006 Posts: 1,404	Spritze/Garlon, I noticed an anomoly on Bob Watson Watson batted once in 1966 (ph only so no position data) he played in 6 games(14 AB) in 1967 and played 3 games at 1B 1968 he played 45 games(140 AB) and played 40 in LF none at 1B You have the fielding data correct but your batting data shows 1966 75 games 249 AB (this is a real problem with no fielding data) 1967 76 games 251 AB 1968 78 ganes 251 AB Seems inconsistent. Thanks

01-16-2008, 07:03 PM	#87
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Bristolduke: That is not an anomoly. It is the way Mr. Garlon insisted it should be. In Version 2 I am going to adjust this. It bugs me too. Fielding should track with games played. 250ab's or so are the minimum allowed in this db so games/innings in the field should flow along with that. swampdragon: Nicknames seem to work for me in PBP. Is it due to the length of some? I have yet to notice any challenges in names of the nick. They can be removed but I'd like to try to save them if possible. Any ideas?

01-23-2008, 06:25 PM	#90
tkirch Minors (Double A) Join Date: Jul 2002 Posts: 196	I notice that when I import some strarting pitchers lose their ENDURANCE down to 8. Any reason for this?

01-24-2008, 12:41 PM	#91
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	This is by design as that is how Mr. Garlon wanted it. In the next version this will not be so.

02-03-2008, 01:14 PM	#92
Aytumious Minors (Triple A) Join Date: Dec 2006 Posts: 268	I'm not sure why exactly, but I imported a 1997 season and the Braves only have 23 players in their entire organization. They have only 8 pitchers: Maddux Smoltz Glavine Neagle Bielecki Wohlers Wade Clontz Any ideas why this is the case? http://www.baseball-reference.com/teams/ATL/1997.shtml Embree, Byrd, Millwood, Fox, etc. don't exist anywhere in the universe. Other teams seem fine, though they only have 26-30 players. I setup the DB by extracting Lahman first then copying your DB over the that.

02-04-2008, 06:52 PM	#93
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	The db edits sorta halt in 1997 so it probably has something to do with that. This is another thing that will be changed with the next version. I am going all the way to the current Lahman rather than stopping a decade early. I think Mr. G wanted to halt there due to some of the weirder edits he wanted made but most of those I have dropped and I have not seen any challenges like this using the latest Lahman up through last year -2007. Hopefully Version 2 will be out by March. I have made the necessary changes based on what has been reported here. If any other problems crop up please note them in this thread. Thankee

02-05-2008, 12:22 PM	#95
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Just copy over the fielding and fieldingof files. Howsomeever if you do this you will have years with no fielding data at all since the db's have different starting points. Debuts are controlled by the master so that should be okey-dokey as well.

02-08-2008, 07:21 PM	#96
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Just finished version 2 build1 of the db for OOTP8/2007. I forgot to take it home with me this weekend but once I am back at work I'll get it posted. Fixed all the issues mentioned here and added 2007 Major league data.

02-12-2008, 12:48 PM	#98
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	I took most of Monday off I am sitting in a chair at a desk programming manufacturing equipment so digital art files can be used to create printing plates so the boxes around products you buy can look pretty when you recycle them. Where are you?

02-12-2008, 01:42 PM	#100
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Yes they will be back.