|
Minors (Rookie Ball)
Join Date: Dec 2002
Location: Minneapolis, MN
Posts: 31
|
CSV dump problem: All Star Text in leagues.csv
It looks like the all_star_text0 and all_star_text1 fields are messed up in the CSV dumps. I just did a dump for a league based on the MAL quickstart in the middle of the year and saw the following occur in one of the league records:
Code:
22,"Texas League","TEX",206,0,0,0,"Texas League.png","","2006-4-6","2006-4-4","Outstanding Pitcher Award","Outstanding Hitter Award","Newcomer of the Year Award","Glove Wizard Award",0,0,0,0,0,0,0,"2006-6-15","2006-12-1","2006-9-1","2006-7-31","2008-6-20",-1,0,1,2,2006,2006,3,1,"",10,0,0,1,1,219,220,"texas_league_aa_c_2006.lsdl","","SP <C. Melancon:player#2608> (FRI), SP <D. Medell:p,"SP <B. Davis:player#1303> (SAN), SP <R. Pace:player,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,140,3,5,0,0,0,0,0,0,0,0,0,0,0,0,30000,0,0,0.0000,0,0,0,1,0,3000,500,300,500,750,200,2000,3.5000,0.3000,93,99,66,87,80,78,70,91,0,115,126,193,133,119,137,119,151,150,83,24.9953,167353,44522,8919,898,5451,16222,1850,31828,185425,0.2960,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,0.8000,0.7000,0.7500,0.8500,0.8500,0.9500,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,1.0000,2006
Note the content in the middle that starts out with "SP <" as well as the strange placement of what appears to be a closing quote and then what might be meant for the next field that might also be missing a closing quote. The proper parsing for this is ambiguous at best and when I look at the content in the world.dat file itself, there are two strings that are quite long. If the intention was to only include the first 50 characters of each of these fields, then this should be done with a closing quote for each field to make things parse correctly.
By the way, this was done with patch 1.0.3 applied.
|
Home | Webstore
09-19-2006, 01:45 AM
