Probably a dumb CatoBase question....

metsgeek · 01-27-2005, 09:08 PM

I'm a newbie at this. It took me forever to even figure out how to generate the .csv files for the stat import.

I clicked on "Import Stats" and got an error that said:

Quote:

There is a problem importing around line 82 in the file \players.csv.

The most likely cause is an invalid character in the HomeState or Nickname fields.

Open this file in Notepad and uncheck WordWrap. Examine the above line and surrounding lines for any unusual characters and import again.

I found a number of weird characters that occur in OOTP when the nickname or hometown is too long. I went through the file and edited out every one of them, saved it, then went back and tried to import again.

Same Result

I reopened the file and none of my edits had stuck. The weird characters were still there.

I tried again and the file still wouldn't edit.

I tried to edit it in Excel. Same damn problem

Perhaps this is a Notepad issue, but I can't figure out why I can't edit it. It seems like such a simple fix.

Please help.

Operation Shutdown · 01-27-2005, 09:25 PM

Try editing them in OOTP and then re-running the exporters. I never had any luck editing the csv files and getting them to work.

Mike D · 01-27-2005, 09:36 PM

Quote:

Originally Posted by Operation Shutdown

Try editing them in OOTP and then re-running the exporters. I never had any luck editing the csv files and getting them to work.

I'm having problems with Cato also. I'm at work now, so I can exactly go through with it now, but if someone who reads this thread can hit me up on AIM later tonight, I'd appreciate the help. The username is mdxbox.

jazzrack · 01-27-2005, 09:45 PM

Quote:

Originally Posted by Operation Shutdown

Try editing them in OOTP and then re-running the exporters. I never had any luck editing the csv files and getting them to work.

yep, find the player in the .csv file then go into ootp and edit the player, then re-export. only way i have ever fixed it.

Jeremy Weimer · 01-27-2005, 09:49 PM

Yeah, like the others have said you have to do the nickname editting in OOTP then save it and re-do Catobase. For some reason it doesn't save if you do it in the CSV file. I had the same problem when I started using Catobase.

gcsii99 · 01-27-2005, 09:52 PM

if you edit the .csv file with notepad, word, etc and then run the import again you will simply copy over the file. Instead after you run make the changes, go to the options menu in Catobase and uncheck "run exporter...", then hit import stats. This will make catobase use the .csv files that are already created (and edited) instead of re-running exporter. Of course, the only long-term solution is to edit the name/hometown/nickname in OOTP, otherwise you end up making the .csv corrections every year

metsgeek · 01-28-2005, 12:52 AM

UGH! I wanted to avoid that. Hopefully, the next version of OOTP will have space for about 10 more characters for Names, Nicknames and Hometowns.

Operation Shutdown · 01-28-2005, 12:23 PM

Quote:

Originally Posted by metsgeek

UGH! I wanted to avoid that. Hopefully, the next version of OOTP will have space for about 10 more characters for Names, Nicknames and Hometowns.

Well if you edit it in OOTP, then the next season when you run CATObase again, you won't have to go back through and re-edit all of the csv files again.

01-27-2005, 09:25 PM	#2
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	Try editing them in OOTP and then re-running the exporters. I never had any luck editing the csv files and getting them to work. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

01-27-2005, 09:52 PM	#6
gcsii99 Minors (Triple A) Join Date: Nov 2002 Location: Acworth, GA Posts: 220	if you edit the .csv file with notepad, word, etc and then run the import again you will simply copy over the file. Instead after you run make the changes, go to the options menu in Catobase and uncheck "run exporter...", then hit import stats. This will make catobase use the .csv files that are already created (and edited) instead of re-running exporter. Of course, the only long-term solution is to edit the name/hometown/nickname in OOTP, otherwise you end up making the .csv corrections every year __________________ Be still Taggert...My mind is a raging torrent, flooded with rivulets of thought, cascading into a waterfall of creative alternatives.

01-28-2005, 12:52 AM	#7
metsgeek Hall Of Famer Join Date: Dec 2002 Location: Norwood, MA Posts: 5,450	UGH! I wanted to avoid that. Hopefully, the next version of OOTP will have space for about 10 more characters for Names, Nicknames and Hometowns. __________________ Commissioner - PBRL - Just finished 2009 109 seasons and still running strong!!!

01-27-2005, 09:49 PM	#5
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Minneapolis, MN Posts: 3,411	Yeah, like the others have said you have to do the nickname editting in OOTP then save it and re-do Catobase. For some reason it doesn't save if you do it in the CSV file. I had the same problem when I started using Catobase.