View Single Post
Old 02-05-2022, 06:35 PM   #209
ra24mpa
Minors (Triple A)
 
Join Date: Jun 2014
Location: STL
Posts: 238
Historical DB ID fixes

These are mostly from a historical league beginning in the year 2000 with maybe a couple from 1996. I haven't had a chance to go through every player yet, but I wanted to make sure this had a chance to be corrected before beta-testing begins. And I apologize for how terrible I have this formatted below, but it's still an improvement over how I have this in my notes.

Mark Clark clarkma01 is missing his milb pitching stats, but...

Phil Clark clarkph02 clark-003phi imports with Mark Clark's clarkma01 clark-004mar milb pitching stats

Jose Rodriguez rodrig019jos should be linked with rodrijo04
According to bbref, there is no rodrijo02, which is why the Jose Rodriguez who starts in the stl cardinals system and who made it to the show in 2000 has no MLB stats attached in the historical stats tab.
The other Jose Rodriguez rodrijo04 rodrig003mig has JR's MLB stats plus the one line of MiLB stats from 1994 of an Oakland farmhand named Miguel Rodriguez.

There are two Ramon Ortizes (same person) created during league creation in 2000, ortiz-001dio is linked with ortizra01 who doesn't exist in the Baseball Reference database, and therefore doesn't have any MLB stats attached to him, and ortizra02 (the one who should be linked with ortiz-001dio) is linked to a Cleveland farmhand from the late 1980s who never made it out of rookie league (ortiz-002ram).

There are two Jeff Williams created during 2000 setup:
willije01 willia003jef
african australian
This (willije01) should be Jerome Williams and linked to willia003jer

willije02 willia003jer
australian
this one willije02 should have willia003jef linked to it
Basically, flip the two milb ids.

Jacque Jones jonesja05 jones-006jac has Jason Jones' milb id jones-001jas which stops the latter from being created during league setup.

George Williams willige03 should have milb id willia003geo, but imported with Jeff Williams' willia004jef id.

Roberto Rivera riverro01 rivera004rob has the milb stats for rivera005rob included in addition to his own for some reason.

Dan Smith smithda07 smith-006dan imported with milb id smith-001rod for some reason.

Taylor Smith smith-001nie and Nestor Smith smith-001nes have their statlines mixed up. One's a pitcher, the other an outfielder, but each has the others year 2000 statline for some reason.

Jeff Wallace wallaje01 should have milb id wallac001jef but imported with wallac003jef

Scott Baker bakersc02 baker-001tim has Brett Baker's milb id baker-001bre

Chris Warren warren001chr and warren001aar have their respective 2000 stat lines messed up

Ricky Gutierrez gutier002ric is accidentally combined with gutieri01 who should have gutier001ric as his minors id. As such, the other one, who should be part of the 1996 rosters, is not in the game.
ra24mpa is offline   Reply With Quote