Spritze DB's for OOTP11

[actionjackson]

Originally Posted by Spritze

All outfielders are fixed, found a few in every year 2009-2014. Lahman info and format had changed which does not bother the fielding.csv but highly bothers the neutering process.

While researching these I found that some players are missing a stint or two....Austin Jackson has his time with Seattle but no Detroit as an example. I corrected the blank stints in Lahman but I am of the opinion something else is afoot as well.

Thank you sir. Aside from the post above, which I was in the middle of when you posted, I shall cease and desist, unless you need me to continue to root them out.

[actionjackson]

The following players seem to have the problem back in 2008 i.e. it may be a long standing issue with these players individually:

Engel Beltre (beltren01)
Nick Buss (bussni01)
Todd Cunningham (cunnito01)
Jermaine Curtis (curtije01)
Jake Elmore (elmorja01)
Logan Forsythe (forsylo01)
Freddy Galvis (galvifr01)
Evan Gattis (gattiev01)
Sean Halton (haltose01)
Jeff Kobernus (koberje01)
Brock Peterson (peterbr02)
Josh Prince (princjo01)
Derrick Robinson (robinde02) (lots of innings played, just blank PO, A, E, DP)
Yangervis Solarte (solarya01)
Steve Susdorf (susdost01) (more than one inning per game, but blank PO, A, E, DP)
Danny Valencia (valenda01)
Jemile Weeks (weeksje01)

[Spritze]

I found 365 missing Batting stints from 1871-2014, For Pitchers 233 missing stints. 578 Missing Fielding Stints. I'll get those cleaned up.


Then I'll look at your latest list of oddballs.

[Spritze]

Originally Posted by actionjackson

The following players seem to have the problem back in 2008 i.e. it may be a long standing issue with these players individually:

Engel Beltre (beltren01)
Nick Buss (bussni01)
Todd Cunningham (cunnito01)
Jermaine Curtis (curtije01)
Jake Elmore (elmorja01)
Logan Forsythe (forsylo01)
Freddy Galvis (galvifr01)
Evan Gattis (gattiev01)
Sean Halton (haltose01)
Jeff Kobernus (koberje01)
Brock Peterson (peterbr02)
Josh Prince (princjo01)
Derrick Robinson (robinde02) (lots of innings played, just blank PO, A, E, DP)
Yangervis Solarte (solarya01)
Steve Susdorf (susdost01) (more than one inning per game, but blank PO, A, E, DP)
Danny Valencia (valenda01)
Jemile Weeks (weeksje01)

Done.....AFAIK..... won't know for sure until I rerun the neuts but they look OK now that the missing Lahman info was filled in.

[actionjackson]

Originally Posted by Spritze

Done.....AFAIK..... won't know for sure until I rerun the neuts but they look OK now that the missing Lahman info was filled in.

FYI, word to the wise, this problem begins in 2002, innocently with Brock Peterson (peterbr02). I went all the way back to 1995 and found no blank spots from there until Mr. Peterson in 2002. He has 99.0 innings played (297 IPOuts) in 33 GP in RF and draws blanks in the PO, A, E, and DP columns. Hopefully, it's just a more recent phenomenon, although I refuse to assume that, on the grounds that I know what that makes you and me. If this is already covered by your multiple corrections lemme know.

[Spritze]

I went back to 1871 on all the corrections looking for more of the same type. Probably didn't find them all but this is a good start. Found 63 in all of the various types that caused your list.

[actionjackson]

Just in case you haven't found them (as these are infielders and most of the previous problems were with outfielders):

Stephen Drew 2B (drewst01) 2002-2005, 2014
Chase Headley 1B (headlch01) 2003-2006, 2014
Danny Valencia 1B (valenda01) 2003-2009, 2014
Gordon Beckham 3B (beckhgo01) 2014
Jemile Weeks SS, RF/CF (weeksje01) 2006-2010, 2013, 2014
Greg Dobbs 1B (dobbsgr01) 2014
Enrique Hernandez 3B (hernaen02) 2014
Travis Ishikawa LF (not an infielder, but hasn't been mentioned before) (ishiktr01) 2014
Jayson Nix RF (same as Ishikawa) (nixja01) 2014
Jordan Pacheco 3B (pachejo01) 2014

That's all I've got for now. Thank you for your patience, persistence, and understanding Sir Spritze.

[Spritze]

Question thing.... As a few people have figured out the Spritze database sticks players in the team organization they are most associated with. Ruth starts out as a Yankee for example. That is because Ruth started playing for an unaffiliated team (Baltimore) who had the right to sell his contract to any major or minor league team who would meet their price. So a historically accurate Ruth has a less than 6% chance of ever being signed by either the Red Sox or Yankees. Hence the artificial push to get him Yankeed. Players could also be artificially pushed to their first affiliated organization (Red Sox) in this case or left as available to anyone and start playing for the Independant teams who held their reserve clause contract. I don't know if OOTP is robust enough yet to let major league teams purchase ccntracts from unaffiliated minor league teams as all minor league teams were independent.

The reason Ruth starts out as a Yankee in the database is simply my preference. I am wondering if a change might be in order.

Newest DB, also on Wiki
https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

[actionjackson]

Originally Posted by Spritze

Question thing.... As a few people have figured out the Spritze database sticks players in the team organization they are most associated with. Ruth starts out as a Yankee for example. That is because Ruth started playing for an unaffiliated team (Baltimore) who had the right to sell his contract to any major or minor league team who would meet their price. So a historically accurate Ruth has a less than 6% chance of ever being signed by either the Red Sox or Yankees. Hence the artificial push to get him Yankeed. Players could also be artificially pushed to their first affiliated organization (Red Sox) in this case or left as available to anyone and start playing for the Independant teams who held their reserve clause contract. I don't know if OOTP is robust enough yet to let major league teams purchase ccntracts from unaffiliated minor league teams as all minor league teams were independent.

The reason Ruth starts out as a Yankee in the database is simply my preference. I am wondering if a change might be in order.

Newest DB, also on Wiki
https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

I usually play random debut, so I do an inaugural draft off the top anyway. I think either the team the player is most associated with or the team he started his career with makes equal sense and I have no preference either way. Truth be told, with the amount of work you put into this database, I think it should be your preference.

[MarkInCincy]

99.9% of my solo's are either RD or real yrs with inaugural draft, maybe once or twice I started with players on their historical teams so like Mr Jackson I say do what you want

[RANGER11JP]

I would say to leave Ruth as a Yankee since most of his fame is associated with them. We have the tools to move him.

How easy or difficult is it for someone NOT as skilled as you change the DB to tweak certain favorites? Just curious.

[Spritze]

Originally Posted by RANGER11JP

How easy or difficult is it for someone NOT as skilled as you change the DB to tweak certain favorites?

Depends on the twerk.

The db output is just a set of OOTP compiled (the ODB file) interlocking Comma Separated Value tables/spreadsheets. Those are available in the stats folder and can be edited pretty darn easily using whatever tool you are most comfortable tooling around with.

The database creation process itself requires a set of 4 interlinked 1.3 gb MS-Access databases and one macro so long it has to be split into 5 parts to be run otherwise all my system resources get used up by it. Dang resources.

[MarkInCincy]

Originally Posted by Spritze

Depends on the twerk.

The db output is just a set of OOTP compiled (the ODB file) interlocking Comma Separated Value tables/spreadsheets. Those are available in the stats folder and can be edited pretty darn easily using whatever tool you are most comfortable tooling around with.

The database creation process itself requires a set of 4 interlinked 1.3 gb MS-Access databases and one macro so long it has to be split into 5 parts to be run otherwise all my system resources get used up by it. Dang resources.

I think I know the answer but are the Access db's and macro available 'somewhere' ?

I have given up doing any mods to the csv's as without getting into an odb and using the csv's in game makes it run painstakingly slow at best

[Spritze]

The game compiles the ODB file not the database.

I produce the CSV's only, same as you would, then OOTP16 compiles them itsownself. The compiler is a secret squirrel thing.

If you have an FTP Site that does not mind huge files I can certainly share the Access files.

[MarkInCincy]

Originally Posted by Spritze

The game compiles the ODB file not the database.

I produce the CSV's only, same as you would, then OOTP16 compiles them itsownself. The compiler is a secret squirrel thing.

If you have an FTP Site that does not mind huge files I can certainly share the Access files.

I hate squirrels, they are evil.

I never knew that the game does the odb compiling, which is why with any mods to csv's I always renamed the odb's to something else and pointed game to master.csv instead of the odb. I 'think' I read that somewhere on the forums here that you had to do that with any modded csv's. This is wonderful info to know, I owe you a beer or two or five

I really don't need the Access db's (thank God... I abhor Access) if the game is compiling the odbs but thanks for the offer. I would have to slit my wrists if I had to try and do anything with 4 Access db's of that size, did it once with similar sized one in migrating/importing it to a 'real' db.

....

[Spritze]

Originally Posted by MarkInCincy

I 'think' I read that somewhere on the forums here that you had to do that with any modded csv's.

Yes, you still need to do that.

[RANGER11JP]

If my feeble mind recalls, isn't there some scenario when we want to remove the OBD files from the rest? At the moment I can not recall as to why.

[Spritze]

When you have made a change to a CSV file.

The change does not take effect unless/until the ODB has been removed or renamed. ODB takes precedence over CSV.

[RANGER11JP]

Originally Posted by Spritze

Does not work until 1871 at the earliest is my sincere belief. Most options don't work well if at all until then.

Sorry to bring this up again, I may just be this dense. I started a fictional league in 1860. I did not check the box for importing historical rookies until just before the end of the 1870 season. Since you have most of those players going to IND teams, I checked around and found Cap Anson and others signing with teams through opening day.etc. This time I did not get random debuts as all were from that era, but quite a few never made the league because I found their debut in the MASTER.CSV as pre 1871. Al Spalding is an example.

What am I doing wrong or is there something I can do to import the early achievers that you have worked on in the years you have determined?

I may not have the latest update, so I don't know if that might behave differently.

[Spritze]

I do not believe random kicks until 1871 via an inaugural draft. Since you started in 1860 and have no inaugural draft available you are in unexplored territory.

Just like if you had started in 1960 since you did not import historical rookies fot a decade those classes have been skipped. You would need to import those Rookies by hand.

You could sort the Master.csv by debut year for the list of the skipped.