CSV Import Upgrades

ken_admin  3/14/2016 12:09 PM

I've updated the import process in an attempt to make it intelligent enough to input most CSV formats.  If you gets errors saying players were not matched, I will get a message myself, and then add these players (so try again soon after).

oscarsf  3/14/2016 2:16 PM

Thanks Ken

Importing the projections from FanGraphs took about two minutes. I'm set for my draft. Thanks for your service!

Hopeful_Cubsfan  3/14/2016 3:22 PM

Getting a weird error while trying to import my pitcher projections. I did get the hitter ones to work just fine.

Could not find column for field earned_runs,er

ken_admin  3/14/2016 3:24 PM

For pitchers, we do expect an earned runs allowed stat.  Does your file not have this?

ken_admin  3/14/2016 3:36 PM

Actually, it may work for you now.  I have updated the code to convert ERA and Innings into projected Earned Runs.

Hopeful_Cubsfan  3/14/2016 3:39 PM

Thanks for the quick response. What I'm seeing now is this.

Could not find column for field era

slimdagreat  3/14/2016 4:06 PM

I'm getting this message when I try to upload projections

A system error has occurred. The administrator has been alerted. We apoligize for the inconvenience.

ken_admin  3/14/2016 4:16 PM

@Hopeful_Cubsfan - Can you email me your CSV file: kslight@baseballmonster.com

ken_admin  3/14/2016 4:17 PM

@slimdagreat  - I have updated the site if you can try one more time.

slimdagreat  3/14/2016 4:22 PM

first I got 

could not find team_name 

tried again and got same system error message

ken_admin  3/14/2016 7:53 PM

Does your CSV have a column for the player's team? If so, what is the heading?

Hopeful_Cubsfan  3/15/2016 12:09 AM

Whatever you did fixed it. Thank you very much.

slimdagreat  3/15/2016 8:33 AM

@kslight 

I think i figured out what the issue was. When I copied and pasted the column headers it put a space in so the column was  base_on_bal ls

That threw the file off. whatever you fixed coupled with me fixing that got it to work.

Thanks again

LGLP86  3/23/2016 12:18 PM

I have this error now.

Import Errors

Line 2: Could not match player, please fill in the player_id in your csv. CHC,TEAM,CHC,,,162,103,59,51,480,162,1448,1336,612,564,142,447,1346,51,0.286,20,1.23,3.80,3.50,3.77,4.22,8.9,3.0,6.4,0.9,239,69,28,104,11,41,18,13,0,0,99

Line 4: Could not match player, please fill in the player_id in your csv. LAD,TEAM,LAD,,,162,92,70,46,575,162,1448,1373,619,570,144,412,1334,51,0.292,15,1.23,3.85,3.55,3.85,4.13,9.0,2.7,6.3,0.9,229,61,27,112,11,41,24,12,0,0,98

Line 6: Could not match player, please fill in the player_id in your csv. HOU,TEAM,HOU,,,162,91,71,45,580,162,1447,1359,660,608,167,447,1247,51,0.281,27,1.25,4.10,3.78,4.02,4.11,8.8,2.8,6.4,0.9,230,21,27,89,13,43,20,11,0,0,94

Line 8: Could not match player, please fill in the player_id in your csv. WAS,TEAM,WAS,,,162,89,73,45,556,162,1447,1363,635,585,152,427,1321,48,0.288,23,1.24,3.95,3.64,3.90,4.26,9.0,2.8,6.3,1.0,207,46,24,107,10,43,21,10,0,0,97

Line 10: Could not match player, please fill in the player_id in your csv. NYM,TEAM,NYM,,,162,88,74,45,574,162,1447,1320,615,566,146,444,1343,46,0.283,21,1.22,3.82,3.52,3.73,4.26,9.0,3.0,6.4,1.0,236,66,27,71,12,40,20,12,0,0,99

Line 12: Could not match player, please fill in the player_id in your csv. BOS,TEAM,BOS,,,162,88,74,44,580,162,1446,1420,675,622,169,444,1272,52,0.293,25,1.29,4.20,3.87,4.26,4.03,9.0,2.8,6.5,0.9,234,22,26,99,13,44,22,11,0,0,92

Line 14: Could not match player, please fill in the player_id in your csv. CWS,TEAM,CWS,,,162,88,74,44,554,162,1446,1353,659,607,160,475,1256,52,0.282,22,1.26,4.10,3.78,4.03,4.12,9.0,3.0,6.6,0.9,245,37,28,106,12,42,20,12,0,0,94

Line 16: Could not match player, please fill in the player_id in your csv. SFG,TEAM,SFG,,,162,87,75,43,604,162,1448,1310,633,583,156,433,1279,48,0.276,23,1.20,3.93,3.62,3.73,4.41,9.0,2.9,6.1,1.0,210,48,24,83,11,42,18,11,0,0,97

Line 18: Could not match player, please fill in the player_id in your csv. TOR,TEAM,TOR,,,162,86,76,43,572,162,1446,1411,717,661,178,454,1190,50,0.286,25,1.29,4.47,4.11,4.32,4.29,9.0,2.9,6.1,1.0,187,-20,21,52,12,44,18,13,0,0,88

Line 20: Could not match player, please fill in the player_id in your csv. PIT,TEAM,PIT,,,162,85,77,42,567,162,1448,1394,675,622,145,480,1244,53,0.291,22,1.29,4.19,3.86,4.10,4.50,9.2,3.2,5.9,0.9,174,6,20,68,12,44,18,14,0,0,92

Line 22: Could not match player, please fill in the player_id in your csv. SEA,TEAM,SEA,,,162,85,77,43,582,162,1447,1353,683,629,172,448,1225,52,0.278,24,1.24,4.25,3.91,4.03,4.21,9.0,2.8,6.4,1.0,220,14,25,96,11,45,20,11,0,0,92

Line 24: Could not match player, please fill in the player_id in your csv. CLE,TEAM,CLE,,,162,85,77,42,578,162,1447,1393,665,612,175,438,1339,50,0.291,30,1.27,4.14,3.81,4.16,3.98,9.0,2.7,6.9,1.0,241,32,28,142,12,44,20,10,0,0,93

Line 26: Could not match player, please fill in the player_id in your csv. TBY,TEAM,TBY,,,162,84,78,42,503,162,1447,1356,672,619,173,473,1286,49,0.282,31,1.26,4.18,3.85,4.09,4.18,9.0,3.0,6.6,1.0,234,25,26,84,13,47,18,12,0,0,93

Line 28: Could not match player, please fill in the player_id in your csv. ARI,TEAM,ARI,,,162,83,79,42,603,162,1447,1415,690,636,158,493,1239,50,0.292,12,1.32,4.29,3.95,4.28,4.56,9.1,3.3,5.8,1.0,149,-9,17,51,10,39,21,13,0,0,91

Line 30: Could not match player, please fill in the player_id in your csv. OAK,TEAM,OAK,,,162,83,79,42,543,162,1447,1384,678,625,151,471,1163,53,0.284,20,1.28,4.22,3.89,4.09,4.17,9.0,3.0,6.0,0.9,221,19,25,60,13,41,22,13,0,0,92

Line 32: Could not match player, please fill in the player_id in your csv. NYY,TEAM,NYY,,,162,83,79,41,585,162,1446,1392,681,628,171,471,1288,51,0.289,17,1.29,4.24,3.91,4.23,4.14,9.1,2.9,6.7,1.0,227,15,26,83,10,40,20,11,0,0,92

Line 34: Could not match player, please fill in the player_id in your csv. LAA,TEAM,LAA,,,162,82,80,41,624,162,1445,1364,691,637,169,476,1205,47,0.280,16,1.27,4.30,3.97,4.12,4.29,9.0,3.0,6.2,1.0,212,6,24,62,12,41,21,14,0,0,91

Line 36: Could not match player, please fill in the player_id in your csv. TEX,TEAM,TEX,,,162,81,81,41,636,162,1447,1460,726,668,173,484,1244,50,0.297,9,1.34,4.51,4.16,4.53,4.20,9.1,3.0,6.4,1.0,176,-29,20,50,12,39,26,15,0,0,87

Line 38: Could not match player, please fill in the player_id in your csv. STL,TEAM,STL,,,162,80,82,40,664,162,1448,1406,672,619,148,454,1236,50,0.292,7,1.28,4.18,3.85,4.10,4.44,9.1,3.0,5.8,1.0,168,8,19,50,8,36,24,11,0,0,93

Line 40: Could not match player, please fill in the player_id in your csv. DET,TEAM,DET,,,162,80,82,40,598,162,1447,1459,738,680,171,464,1157,48,0.293,15,1.33,4.59,4.23,4.47,4.32,9.1,2.9,5.9,1.0,170,-41,19,57,10,39,21,12,0,0,86

Line 42: Could not match player, please fill in the player_id in your csv. MIN,TEAM,MIN,,,162,79,83,40,568,162,1447,1476,732,674,176,419,1148,48,0.294,23,1.31,4.55,4.19,4.47,4.23,9.0,2.6,5.7,1.0,173,-35,19,55,12,43,18,13,0,0,87

Line 44: Could not match player, please fill in the player_id in your csv. MIA,TEAM,MIA,,,162,78,84,39,572,162,1449,1394,685,631,153,509,1227,48,0.288,20,1.31,4.26,3.92,4.21,4.60,9.1,3.4,5.8,1.0,163,-5,19,58,12,43,19,14,0,0,91

Line 46: Could not match player, please fill in the player_id in your csv. BAL,TEAM,BAL,,,162,76,86,38,592,162,1445,1435,719,662,172,498,1209,52,0.292,21,1.34,4.48,4.12,4.48,4.29,9.1,3.1,6.2,1.0,188,-22,21,57,11,44,19,13,0,0,88

Line 48: Could not match player, please fill in the player_id in your csv. COL,TEAM,COL,,,162,71,91,35,681,162,1448,1555,763,703,177,504,1215,52,0.310,24,1.42,4.74,4.37,4.98,4.70,9.3,3.3,5.6,1.0,75,-82,9,32,14,45,21,13,0,0,83

Line 50: Could not match player, please fill in the player_id in your csv. KCR,TEAM,KCR,,,162,71,91,35,566,162,1445,1401,720,663,179,499,1194,49,0.284,20,1.31,4.48,4.13,4.39,4.40,9.1,3.1,6.1,1.0,195,-23,22,61,12,42,22,12,0,0,88

Line 52: Could not match player, please fill in the player_id in your csv. CIN,TEAM,CIN,,,162,69,93,34,571,162,1448,1432,739,681,179,539,1307,47,0.294,25,1.36,4.60,4.23,4.56,4.80,9.4,3.6,6.2,1.1,103,-59,11,30,14,44,16,16,0,0,86

Line 54: Could not match player, please fill in the player_id in your csv. SDP,TEAM,SDP,,,162,69,93,34,605,162,1448,1362,656,604,148,494,1326,49,0.289,29,1.28,4.07,3.75,4.00,4.41,9.2,3.4,6.4,1.0,187,25,21,66,13,47,19,13,0,0,94

Line 56: Could not match player, please fill in the player_id in your csv. MIL,TEAM,MIL,,,162,69,93,34,595,162,1447,1485,739,681,164,514,1229,52,0.302,26,1.38,4.60,4.23,4.64,4.67,9.3,3.4,5.7,1.0,101,-58,11,37,13,46,20,13,0,0,86

Line 58: Could not match player, please fill in the player_id in your csv. PHI,TEAM,PHI,,,162,63,99,32,606,162,1448,1472,745,686,172,472,1195,47,0.297,25,1.34,4.63,4.27,4.54,4.74,9.2,3.1,5.6,1.1,91,-64,10,30,13,46,18,15,0,0,85

Line 60: Could not match player, please fill in the player_id in your csv. ATL,TEAM,ATL,,,162,62,100,31,659,162,1448,1475,752,693,169,489,1182,49,0.297,18,1.36,4.67,4.31,4.58,4.77,9.3,3.3,5.6,1.0,79,-71,9,29,13,44,20,16,0,0,85

Line 206: Could not match player, please fill in the player_id in your csv. De_La_Rosa,Jorge,COL,NL,35,Sta,8,11,0,29,29,166.7,170,87,80,20,68,136,57,0.296,-13,1.43,4.70,4.33,4.85,4.89,9.1,3.8,5.4,1.0,12,-7,1.2,37,6,42,22,13,Omar_Olivares,Paul_Maholm,Wade_Miley,Vicente_Padilla,DELAROSA19810405A,15

Line 214: Could not match player, please fill in the player_id in your csv. Iglesias,Raciel,CIN,NL,26,Sta,8,10,0,23,23,158.0,148,76,70,20,48,148,54,0.284,-17,1.24,4.34,4.00,4.09,4.52,9.1,2.9,6.5,1.1,17,0,1.9,40,1,32,22,8,Richie_Lewis,Jimmy_Serrano,Greg_Harris,Paul_Wilmet,IGLESIAScubaR01,13

Line 304: Could not match player, please fill in the player_id in your csv. De_La_Rosa,Rubby,ARI,NL,27,Sta,6,7,0,21,21,118.3,124,65,60,16,39,94,55,0.299,-4,1.38,4.92,4.53,4.87,4.91,9.6,3.2,5.3,1.1,5,-8,0.5,28,8,51,14,12,Ray_Washburn,Eli_Grba,Darrell_Akerfelds,Dillon_Gee,DELAROSA19890301A,10

Line 416: Could not match player, please fill in the player_id in your csv. Oh,Seunghwan,STL,NL,33,Rel,5,3,4,73,0,70.7,62,26,24,7,19,66,45,0.275,-11,1.14,3.31,3.05,3.36,3.93,8.4,2.4,6.3,0.9,13,5,1.6,50,9,36,39,5,Kiyoshi_Toyoda,Kiyoshi_Toyoda,Luis_Aquino,Lee_Gronkiewicz,OHkoreaSH01,0

Line 686: Could not match player, please fill in the player_id in your csv. Layne,Tommy,BOS,AL,31,Rel,3,2,0,44,0,47.3,42,20,18,4,21,42,60,0.278,-1,1.34,3.81,3.51,4.02,4.15,8.9,4.0,6.7,0.8,5,1,0.5,35,25,45,28,12,Dave_Rucker,Hal_Woodeshick,Gary_Lavelle,J.P._Howell,LAYNE19841102A,0

Line 850: Could not match player, please fill in the player_id in your csv. De_Fratus,Justin,SEA,AL,28,Rel,2,3,0,35,0,43.3,43,23,21,5,16,33,45,0.289,-2,1.36,4.84,4.45,4.45,4.78,9.3,3.2,5.4,1.0,2,-2,0.3,19,12,43,22,19,Carlos_Fisher,Jose_Capellan,Micah_Owings,Aaron_Heilman,DEFRATUS19871021A,0

Line 1060: Could not match player, please fill in the player_id in your csv. Gonzalez,Chi_Chi,TEX,AL,24,Sta,1,2,0,5,5,26.7,30,16,15,3,10,15,55,0.302,-2,1.51,5.54,5.10,5.43,4.91,9.1,3.5,3.9,0.9,1,-2,0.1,8,10,40,22,16,Jason_Scobie,Tom_Edens,Roger_Bailey,Mitch_Zwolensky,GONZALEZ19920115B,2

Line 1112: Could not match player, please fill in the player_id in your csv. Musgrove,Joseph,HOU,AL,23,Sta,1,1,0,3,3,18.7,20,10,9,3,4,13,49,0.290,-1,1.24,4.88,4.50,4.47,4.26,8.8,1.9,5.4,1.1,2,0,0.2,19,8,56,20,8,Christian_Binford,Kris_Wilson,Eric_Moody,Justin_Reid,MUSGROVE19921204A,2

ken_admin  3/23/2016 12:30 PM

I believe the import worked, but the CSV contains summary lines for each MLB team which don't match.  Under Projections, you should see all of the players.

LGLP86  3/23/2016 12:46 PM

The import worked except for the players stated below.

How can I fix it?

Lucas Giolito is missing for players in the pool, probably because he is a minor pitcher.

ken_admin  3/23/2016 1:07 PM

A few of the lines at the bottom are players that did not match, but the first set of lines is actually a total for each team and not individual players.

LGLP86  3/23/2016 1:30 PM

Ok so now I see this. How do I fix that?

Import Errors

Line 146: Could not match player, please fill in the player_id in your csv. De_La_Rosa,Jorge,COL,NL,35,Sta,8,11,0,29,29,166.7,170,87,80,20,68,136,57,0.296,-13,1.43,4.7,4.33,4.85,4.89,9.1,3.8,5.4,1,12,-7,1.2,37,6,42,22,13,Omar_Olivares,Paul_Maholm,Wade_Miley,Vicente_Padilla,DELAROSA19810405A,15

Line 154: Could not match player, please fill in the player_id in your csv. Iglesias,Raciel,CIN,NL,26,Sta,8,10,0,23,23,158,148,76,70,20,48,148,54,0.284,-17,1.24,4.34,4,4.09,4.52,9.1,2.9,6.5,1.1,17,0,1.9,40,1,32,22,8,Richie_Lewis,Jimmy_Serrano,Greg_Harris,Paul_Wilmet,IGLESIAScubaR01,13

Line 244: Could not match player, please fill in the player_id in your csv. De_La_Rosa,Rubby,ARI,NL,27,Sta,6,7,0,21,21,118.3,124,65,60,16,39,94,55,0.299,-4,1.38,4.92,4.53,4.87,4.91,9.6,3.2,5.3,1.1,5,-8,0.5,28,8,51,14,12,Ray_Washburn,Eli_Grba,Darrell_Akerfelds,Dillon_Gee,DELAROSA19890301A,10

Line 356: Could not match player, please fill in the player_id in your csv. Oh,Seunghwan,STL,NL,33,Rel,5,3,4,73,0,70.7,62,26,24,7,19,66,45,0.275,-11,1.14,3.31,3.05,3.36,3.93,8.4,2.4,6.3,0.9,13,5,1.6,50,9,36,39,5,Kiyoshi_Toyoda,Kiyoshi_Toyoda,Luis_Aquino,Lee_Gronkiewicz,OHkoreaSH01,0

Line 626: Could not match player, please fill in the player_id in your csv. Layne,Tommy,BOS,AL,31,Rel,3,2,0,44,0,47.3,42,20,18,4,21,42,60,0.278,-1,1.34,3.81,3.51,4.02,4.15,8.9,4,6.7,0.8,5,1,0.5,35,25,45,28,12,Dave_Rucker,Hal_Woodeshick,Gary_Lavelle,J.P._Howell,LAYNE19841102A,0

Line 790: Could not match player, please fill in the player_id in your csv. De_Fratus,Justin,SEA,AL,28,Rel,2,3,0,35,0,43.3,43,23,21,5,16,33,45,0.289,-2,1.36,4.84,4.45,4.45,4.78,9.3,3.2,5.4,1,2,-2,0.3,19,12,43,22,19,Carlos_Fisher,Jose_Capellan,Micah_Owings,Aaron_Heilman,DEFRATUS19871021A,0

Line 1000: Could not match player, please fill in the player_id in your csv. Gonzalez,Chi_Chi,TEX,AL,24,Sta,1,2,0,5,5,26.7,30,16,15,3,10,15,55,0.302,-2,1.51,5.54,5.1,5.43,4.91,9.1,3.5,3.9,0.9,1,-2,0.1,8,10,40,22,16,Jason_Scobie,Tom_Edens,Roger_Bailey,Mitch_Zwolensky,GONZALEZ19920115B,2

Line 1052: Could not match player, please fill in the player_id in your csv. Musgrove,Joseph,HOU,AL,23,Sta,1,1,0,3,3,18.7,20,10,9,3,4,13,49,0.29,-1,1.24,4.88,4.5,4.47,4.26,8.8,1.9,5.4,1.1,2,0,0.2,19,8,56,20,8,Christian_Binford,Kris_Wilson,Eric_Moody,Justin_Reid,MUSGROVE19921204A,2

slimdagreat  3/24/2016 8:45 AM

LGLP86 (3 posts)  Yesterday 1:30 PM

Ok so now I see this. How do I fix that?

Import Errors

Line 146: Could not match player, please fill in the player_id in your csv. De_La_Rosa,Jorge,COL,NL,35,Sta,8,11,0,29,29,166.7,170,87,80,20,68,136,57,0.296,-13,1.43,4.7,4.33,4.85,4.89,9.1,3.8,5.4,1,12,-7,1.2,37,6,42,22,13,Omar_Olivares,Paul_Maholm,Wade_Miley,Vicente_Padilla,DELAROSA19810405A,15

Line 154: Could not match player, please fill in the player_id in your csv. Iglesias,Raciel,CIN,NL,26,Sta,8,10,0,23,23,158,148,76,70,20,48,148,54,0.284,-17,1.24,4.34,4,4.09,4.52,9.1,2.9,6.5,1.1,17,0,1.9,40,1,32,22,8,Richie_Lewis,Jimmy_Serrano,Greg_Harris,Paul_Wilmet,IGLESIAScubaR01,13

Line 244: Could not match player, please fill in the player_id in your csv. De_La_Rosa,Rubby,ARI,NL,27,Sta,6,7,0,21,21,118.3,124,65,60,16,39,94,55,0.299,-4,1.38,4.92,4.53,4.87,4.91,9.6,3.2,5.3,1.1,5,-8,0.5,28,8,51,14,12,Ray_Washburn,Eli_Grba,Darrell_Akerfelds,Dillon_Gee,DELAROSA19890301A,10

Line 356: Could not match player, please fill in the player_id in your csv. Oh,Seunghwan,STL,NL,33,Rel,5,3,4,73,0,70.7,62,26,24,7,19,66,45,0.275,-11,1.14,3.31,3.05,3.36,3.93,8.4,2.4,6.3,0.9,13,5,1.6,50,9,36,39,5,Kiyoshi_Toyoda,Kiyoshi_Toyoda,Luis_Aquino,Lee_Gronkiewicz,OHkoreaSH01,0

Line 626: Could not match player, please fill in the player_id in your csv. Layne,Tommy,BOS,AL,31,Rel,3,2,0,44,0,47.3,42,20,18,4,21,42,60,0.278,-1,1.34,3.81,3.51,4.02,4.15,8.9,4,6.7,0.8,5,1,0.5,35,25,45,28,12,Dave_Rucker,Hal_Woodeshick,Gary_Lavelle,J.P._Howell,LAYNE19841102A,0

Line 790: Could not match player, please fill in the player_id in your csv. De_Fratus,Justin,SEA,AL,28,Rel,2,3,0,35,0,43.3,43,23,21,5,16,33,45,0.289,-2,1.36,4.84,4.45,4.45,4.78,9.3,3.2,5.4,1,2,-2,0.3,19,12,43,22,19,Carlos_Fisher,Jose_Capellan,Micah_Owings,Aaron_Heilman,DEFRATUS19871021A,0

Line 1000: Could not match player, please fill in the player_id in your csv. Gonzalez,Chi_Chi,TEX,AL,24,Sta,1,2,0,5,5,26.7,30,16,15,3,10,15,55,0.302,-2,1.51,5.54,5.1,5.43,4.91,9.1,3.5,3.9,0.9,1,-2,0.1,8,10,40,22,16,Jason_Scobie,Tom_Edens,Roger_Bailey,Mitch_Zwolensky,GONZALEZ19920115B,2

Line 1052: Could not match player, please fill in the player_id in your csv. Musgrove,Joseph,HOU,AL,23,Sta,1,1,0,3,3,18.7,20,10,9,3,4,13,49,0.29,-1,1.24,4.88,4.5,4.47,4.26,8.8,1.9,5.4,1.1,2,0,0.2,19,8,56,20,8,Christian_Binford,Kris_Wilson,Eric_Moody,Justin_Reid,MUSGROVE19921204A,2

Its because your export file has some of the names in the wrong format.

De La Rosa in BBM's database is De La Rosa, you have it as De_La_Rosa

 Iglesias,Raciel? is misspelled, it should be Rasiel Iglesias

Tommy Layne is Tom Layne

What I did was I downloaded the Player ID CSV file and just copied and pasted the id numbers of hte guys with weird names (ex. Rubby De La Rosa is one for example) then I reuploaded it

LGLP86  3/30/2016 9:39 PM

Hi Ken,

Can you help me import the csv files from http://www.fantasypros.com/mlb/projections/hitters.php

Only hitters.

Thank you.

LGLP86