View Single Post
Old 06-25-2022, 02:29 PM   #113
weeqat
Minors (Rookie Ball)
 
Join Date: Jan 2020
Posts: 27
Importing Negro League players by CSV - unpredictable results

Not sure if this is a database issue per se, but it relates to csv player import so I'll post here. I've got a list of 206 Negro League players which seems to import into different test leagues that I've set up with hugely different results. In some import scenarios all of the pitchers will come in as 20-20 RPs, because they only have a 40-grade fastball and no other pitches. Other times, they will import with a full arsenal of pitches and starter stamina, etc. Same list, same import year, nothing changes. Here are some of the variables that I've tried to isolate, but I can't seem to find a consistent process.

2 leagues are set up, both custom/fictional, but with the same 28 real teams created. In one, I set up a random debut league, deleted all the players and then imported full majors and minors systems for all those specific teams (eg 1969 Orioles, 2004 Red Sox) via csv. In the other, I deleted all the minor league levels and imported the same teams (which gave me 30-50 "real" players spread between active roster and reserve pool). I then added minor league levels and imported all of the "missing" players from the above-mentioned lists.

(As a side note, the first setup method above created some EXTREMELY weird, low ratings for a lot of players - very good teams might have their whole real life bullpen filled with 20-30 POT players. This was using normalized stats so I'm not sure what happened there. The 2nd league was set up in order to fix this specific problem, and seemed to have provided a better range of ratings).

Back to the NeL import. First phase was to import about 1200 different player-years in order to find the ones that the game "liked" best. I used normalized stats, with adjust/weaken set to 200/40 for hitters and 30/10 for pitchers (this will be consistent for all import attempts). I narrowed this down to 206 players.

First league: I first imported the list into the FA pool with the above settings, and all of the pitchers were 20/20, with a single pitch. I deleted them and then, in the same game session, I imported them into the draft pool instead - and I got solid ratings and results.

In the second league, I imported them into the draft pool but had the 20/20 issue. I deleted them and then tried importing them into the FA pool instead, and the results were good this time!

If I try to import any of the players singly, using their id and year, they come in as 20/20. Hitters are generally better but their ratings are often much lower than I get when importing the entire list.

I'm curious for any insight as to why there is so much variation in what seems to be an easily repeatable process? It seems like there is some underlying coding error causing this.
weeqat is offline   Reply With Quote