Quote:
Originally Posted by quillenl
Info below as requested, but please remember I stopped using these because of severe service time issues with this method.
https://www.dropbox.com/s/tb9wjjcirp...aster.csv?dl=0
https://www.dropbox.com/scl/fi/7qtez...4cha3it7qrk28n
Links above. Last messed with last summer so sent the master files. Had begun breaking up first by year, but stopped (it's easy) so linked the entire file.
First should be entire database after cleanup, second is a list of 60000 I'd worked down to make a more enjoyable random debut database. 60K players will get you 100 years worth of 20 round drafts for a 30 team league which is sufficient to me for 4 levels of minors.
For the first file (entire database). You can filter by the year you want to import (second column), then copy the first 2 rows into a csv file. Import that into your league's draft pool and you now have a full draft pool of everyone who debuted that year.
The second file all major league players and only those from the minor league who debuted in the minors at a relatively young age... and mostly after around 1960. That got the list of total players down to 59K for me. It isn't any good for year by year historical recreations but is great for random debut leagues where a smaller draft is desired (I am not a fan of 60 round drafts. The random debut is set by filtering by the 3rd column I added which consists of numbers 1 through 100. Each number provides 590 players for a draft pool.
First file sounds more like what you were looking for. Filter by year and copy to a csv file. First column is reference id and second is debut year. It's just a copy paste from this file into the one for import. If you have not used the import tool to import entire drafts before then that is a different conversation. |
Thanks for posting this.
I am going to give this a go and see what comes from trying it out
Just curious what is the service time issue that comes with using the files?