Quote:
Originally Posted by Spritze
I think where I am lost are the last two columns. I can't tell which is the change from and which is the change To These are both MLB id's? Do I change anything in the MiLB master? It has a MLB bbref ID in it. The MLB master has a MiLB id in it as well.
Sorry but I am still lost. Just need a little more explanation. We have 2 ID's in each master and I still don't know what to do with each of them.
MLB Master MLB PlayerID MiLB bbrefID
MiLB Master MLB PlayerID MiLB bbref ID
|
Column F (BBrefMLBid) of the spreadsheet is from column AG of the MilBMaster.csv file, Column G (playerID) from the spreadsheet is from column B the Master.csv file. I'm not exactly sure what the mechanism is for OOTP to match a player's major and minor league stats, but I think either one of the BBrefMLBid, or the lahmanid (col. AC) in the MilBMaster.csv file has to match the playedID in the master.csv file for one player to have both his major and minor league stats, and not be split into two players, one with just majors the other with just minors. As the master.csv file is more structured, I would change the appropriate column in the MilBMaster.csv file. I can't really try this myself as it seems the imports are based on the historical.odb file, which can't be changed.
Hope my intuition is right here and this works. I used to like messing around with the spreadsheets in the stats folder for a custom league, but can't seem to do that anymore with the last couple of versions. Thanks for reading this long message.