Hey, a Catobase problem! (Line 1 of players.csv)

[bulldog55]

What an exciting change of pace from all the other threads in here. I have a Catobase problem!

It's telling me there is a problem in line 1 of players.csv. I'll let everyone else look at it because I'm afraid I'm going to put a fist through my monitor if I look at this anymore.

PNum(0),LName,FName,NName,B,T,Hometown,HomeState,H eight Ft,Height In,Weight(10),Conspl,Pressure,Pull,Consistency,Tem per,Loyalty,Winner,Leader,Age,Pos(20),Number,Birth Month,Birth Day,Birth Year,Durability,Inj Length,Inj Nbr,DL Length,Inj Pct,Exp(30),Yrs Free Agent,Pitcher?,Free Agent?,Day To Day?,Cont Minor,Cont Major,Cont Yrs,Cont Salary,NCont Minor,NCont Major(40),NCont Yrs,NCont Salary,Mood,BRat OvContact,BRat OvPower,BRat OvGap,BRat OvEye,BRat OvKs,BRat RContact,BRat RPower(50),BRat RGap,BRat REye,BRat RKs,BRat LContact,BRat LPower,BRat LGap,BRat LEye,BRat LKs,BTal Contact,BTal Power,BTal Gap(60),BTal Eye,BTal Ks,PRat OvStuff,PRat OvControl,PRat Movement,PRat OvEndurance,PRat RStuff,PRat RControl,PRat RMovement(70),PRat LStuff,PRat LControl,PRat LMove,PTal Stuff,PTal Control,PTal Move,PT Complain?,Complain?,Wants Ext?,Wants Retire?(80),Promote?,Coach?,On Waiver?,Cleared Waiver?,On 40 Man?,Waiver Claim Team ID,Can Demand Trade?,Days on 40 Man,Days of Service,Waivers Left(90),Minor Level,Must Be Active?,Promoted Time,Demoted Time,GB Pct,Hold Run,WP,Balk,HP,Role(100),POM,BOM,POW,BOW,POY,BOY,P OG,Rec R,Rec H,Rec RBI(110),Rec HR,Rec BB,Rec SO,Rec LHS,Rec HA,Rec LS,Rec WS,Rec Long HR1,Rec Long HR2,Rec Long HR3(120),Stk HS,Stk LHS,Stk RBI,Stk LRBI,Stk HR,Stk LHR,Stk RS,Stk LRS,Stk WS,Stk LWS(130),Stk LS,Stk LLS,Stk HWS,Stk LHWS,Stk HLS,Stk LHLS,Stk AWS,Stk LAWS,Stk ALS,Stk LALS(140),Stk Saves,C Arm,OF Arm,IF Arm,PB,Team ID,Roster,Status,Pos Fatigue,Speed(150),Steal,Running,Bunt Hit,Bunt Sac,HP,FB,SI,SL,CH,KN(160),SP,CU,SC,Velocity,Stars ,Pro Years,MLB Years,Years on 40,Player Type,On 60 Day DL?(170)
1,Lantz,Andrew,,R,R,,USA,6,0,210,0,2,0,1,0,1,0,0,2 3,2,46,10,13,1880,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,1,2,3,2,1,1,1,3,2,1,1,2,3,2,1,7,8,6,4,4,1,1, 3,0,1,1,3,1,1,3,1,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,1,1,4,4,2,A,0,0,2,2,2,1,2,0,0,0,0,0,0,0,0,0,0,2. 5,0,0,0,0,0

[SandMan]

Is this the actual line. Did you edit this through Excel? Or view it and save through excel. It looks strange that none of the String fields like name have double quotes around them.....just curious if this may be a problem. All my player csv files look like this:


1,"Taylor","Russ","",L,L,"","Mobile AL",5,11,175,0,0,1,0,2,1,0,0,33,9,31,9,7,1970,1,0, 0,0,0,12,0,0,0,0,9,1,3,1310000,0,0,0,0,0,31,43,52, 20,32,33,44,53,21,34,33,41,48,17,28,4,5,5,3,4,6,1, 20,0,6,1,20,6,1,20,2,2,3,0,0,0,0,0,0,1,0,1,0,0,227 4,2147,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,2,6,2 ,0,0,5,0,0,0,420,374,371,0,5,0,3,0,3,0,3,0,0,0,0,0 ,0,0,0,0,0,0,0,0,1,2,2,0,6,Active,0,0,4,3,4,1,3,0, 0,0,0,0,0,0,0,0,0,2.0,13,12,13,0,0

[bulldog55]

I'd been doing it both in notepad and Excel, but it seems like I must have done it in Excel every time I tested it. That was exactly the problem. Thank you so much.

[Carlton]

Yea with player problems open it in notepad and take away the $$ in the long nickname spot. The write in the whole nickname and it should work

[Vris]

Okay, I'm confused.

Catobase is telling me I have a problem around line 1344, and that it might be an unusual character in the nickname or home state areas. Sure enough, in line 1345, there is an unusual character in the nickname field. So I delete the nickname and type in a new one. I go to input the stats again, and the same thing. So I open up Notepad and none of the changes I made saved, even though I specifically hit "save". I try it again, same thing. I open it in OpenOffice (as I don't have Excel), and my changes are there. What is going on?

[gmo]

Originally Posted by Vris

Okay, I'm confused.

Catobase is telling me I have a problem around line 1344, and that it might be an unusual character in the nickname or home state areas. Sure enough, in line 1345, there is an unusual character in the nickname field. So I delete the nickname and type in a new one. I go to input the stats again, and the same thing. So I open up Notepad and none of the changes I made saved, even though I specifically hit "save". I try it again, same thing. I open it in OpenOffice (as I don't have Excel), and my changes are there. What is going on?

Are you recreating the csv files in CatoBase each time you run it? If so, then any edits you make disappear when the program runs again as new files are made. In any case it is a good idea to edit the nickname (or whatever) in the game itself to permanently fix the problem.

[Jeremy Weimer]

Yeah, you have to use the in-game editor to make the changes stick. Otherwise everytime you run Catobase the txt file is jut going to be overwritten and it will keep having the error.

[Vris]

Yeah that was the next step. I was just wondering if I was doing anything wrong. Thanks guys!

Yup, that was it. Thanks again!