cato

[Maria Nieves]

Just started a 1903 sim. Finished WS. Exported my site files and began importing via Cato's newest version.


"There is a problem importing line 254 in the file \players.csv"

Can someone please lend me some advice so I can make the proper corrections???????????

Here is line 254:


254,"Sudhoff","Willie","Wee willie",R,R,"","USA,MO,ST. LOUIS" ,5,7,165,0,2,2,2,0,0,0,0,29,1,94,9,17,1874,1,0,0,0
,0,5,0,1,0,0,0,1,4,1060000,0,0,0,0,0,3,1,3,1,8,2,1
,3,1,8,2,1,3,1,8,1,1,1,1,10,2,7,10,10,2,7,10,1,6,1
0,1,8,10,0,0,0,0,0,0,0,0,0,0,0,893,1218,0,0,0,0,0,
49,4,0,0,0,1,0,0,0,0,0,0,0,2,2,2,1,8,8,5,14,7,7,0,
0,0,1,1,0,1,0,0,0,0,0,1,3,3,0,1,1,1,0,0,2,2,1,1,1,
10,0,10,Active,0,0,5,3,2,1,2,0,1,0,1,1,0,0,0,0,4,2
.5,7,7,5,0,0

[jcato]

The line number isn't always exact. Check the 2 or 3 lines before this one. More than likely there is a player whose nickname has a double quote at the end of it. Something like this:

253,"Hrabosky","Al","The mad hunger"",R,R,.....

This is common in historical leagues. In OOTP, nicknames have a 15 character limit. If an imported player's nickname is more than 15 characters, OOTP doesn't handle it very well. I'll see if I can't correct for this in the next version.

[Maria Nieves]

I'm sorry, unfortunately I'm still having difficulties. I opened player.csv in Excel and wiped out column D for nicknames. Then I saved it, but everytime I begin the import, the names are there again, and I'm still getting the error. BTW I suspect the error is caused by

253,"Strang","Sammy","The dixie thrusSR",S,R,"","USA,TN,CHATTANOOGA"

Am I editing the wrong file and do I need to redo a process?

[ZouDave]

here's what I normally do to fix these problems:

Find the player that is causing the problem...in this case, you've found it with Sammy Strange. Go back into OOTP and find Sammy Strange in the game. Edit out his nickname in the game. Either change it to be under 15 characters or just delete it altogether. This will fix the problem not only for this year, but all future years. If you just fix it in the file once, the next time you export the stuff to .csv it's just going to grab his nickname again.

Once you've edited the nickname out of the game, run the exporter batch again.

That should do it.

[Maria Nieves]

Yes! That did it! I appreciate the help. Thank you