Thread: Inaugural Draft
View Single Post
Old 06-05-2018, 08:39 PM   #3
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,872
column B in the MLB and MiLB .csv files has the player IDs. You could easily cut and paste the entire column in theory - but i've never tried to do more than a year at a time, so i am not certain. The issue i see is getting the correct year for the players to import (in the coma space years .... ", 1932"). Those years are in column AA (i think it's that in 19 now ... used to be column Z in 18.) Without that, it won't work, but also the ages of the players would be all over the place if you didn't use the real years of the players career. If you were setting up a 2015 year as when you were to play, without specifying you wanted the 1924 Babe Ruth, or the 1895 Cy Young, or a 1961 Roger Maris many players could come in at over 100 yrs old. Not ideal i suspect.

The solution is to scroll over to the AA column after each player to get his debut year (from that point you could pick his best year to enter if you knew it.). That's a LOT of work, but it's the only solution i know. also be aware if you do this, it may take a long time to import that many players, so be patient.
Good luck and let us know how this works, or doesn't.
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
"Hello darkness, my old Friend ...." - Paul Simon
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.

Last edited by mitchkenn; 06-05-2018 at 09:21 PM.
mitchkenn is offline   Reply With Quote