Catobase Problem: Help Please

Jeremy Weimer · 01-17-2005, 11:41 PM

Alright, I started a solo league in 1901 using the Lahman database. I played out the season and figured it would be cool to use Catobase to keep a running history of my league. So I setup Catobase and all that and then ran it. I hit "Import Stats" to begin the process and it starts doing it's business then a window pops up saying:

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

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

Open this file in Notepad and uncheck word wrap (under Edit).
Examine the above line and surrounding lines for any unusual characters and import again."

I know that's pretty self explainatory, but how do I go about fixing this? I opened up the file in Notepad like it said and looked at line 100 and the others around it and didn't really notice anything unfamiliar compared to other lines. So how do I know what to look for and remove? Any help is appreciated on fixing this problem.

magnet · 01-17-2005, 11:51 PM

Quote:

Originally Posted by Jeremy Weimer

Alright, I started a solo league in 1901 using the Lahman database. I played out the season and figured it would be cool to use Catobase to keep a running history of my league. So I setup Catobase and all that and then ran it. I hit "Import Stats" to begin the process and it starts doing it's business then a window pops up saying:

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

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

Open this file in Notepad and uncheck word wrap (under Edit).
Examine the above line and surrounding lines for any unusual characters and import again."

I know that's pretty self explainatory, but how do I go about fixing this? I opened up the file in Notepad like it said and looked at line 100 and the others around it and didn't really notice anything unfamiliar compared to other lines. So how do I know what to look for and remove? Any help is appreciated on fixing this problem.

I'm too lazy to open ootp. what are the lines in question?

Jeremy Weimer · 01-17-2005, 11:55 PM

90,"Douglass","Klondike","",L,R,"","USA,PA,BOSTON" ,6,0,200,0,0,2,2,1,1,0,0,29,2,78,5,10,1872,1,0,0,0 ,0,5,0,0,0,0,0,1,1,771429,0,0,0,0,0,46,6,39,12,77, 47,6,40,12,78,47,6,38,11,75,47,16,48,43,93,7,1,20, 0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,1237, 1069,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,4,4,3,1,0 ,3,12,3,0,0,0,0,0,0,5,0,3,0,0,1,2,0,0,0,0,0,0,0,0, 0,0,0,0,0,41,29,23,4,14,Active,0,0,62,72,92,1,3,0, 0,0,0,0,0,0,0,0,0,2.5,7,6,7,0,0
91,"Dowd","Tommy","Buttermilk tommRR ",R,R,"","USA,MA,HOLYOKE",5,8,173,0,0,0,0,0,0,0,1, 32,7,84,4,20,1869,1,0,0,0,0,9,0,0,0,0,0,1,4,175000 0,0,0,0,0,0,48,9,49,31,88,43,9,46,29,86,43,9,55,36 ,91,55,9,53,39,95,7,1,20,0,7,1,20,7,1,20,1,1,20,0, 0,0,0,0,0,0,0,1,0,0,1975,1751,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,4,3,3,4,1,0,3,16,0,0,0,389,322,296,2 ,16,0,3,0,1,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,3,89,95, 0,2,Active,0,0,88,68,80,1,4,0,0,0,0,0,0,0,0,0,0,1. 5,12,10,11,0,0
92,"Dowling","Pete","",R,L,"",",,",5,11,0,0,0,2,0, 0,1,0,0,1901,1,67,0,0,0,2,0,36,0,0,3,0,1,0,0,0,1,4 ,5780000,0,0,0,0,0,19,3,21,1,74,17,3,21,1,74,17,3, 21,1,74,1,1,1,1,105,6,20,39,85,6,20,39,7,22,39,13, 20,38,0,0,0,0,0,0,0,0,0,0,0,578,735,0,0,0,0,0,63,3 ,0,0,0,1,0,0,0,0,0,0,4,2,2,2,1,6,9,5,16,6,6,0,0,0, 0,5,0,1,0,0,0,1,1,5,0,5,0,3,2,2,1,3,0,3,0,2,20,99, 0,6,Active,0,0,33,20,2,1,2,0,1,0,1,1,0,1,1,0,3,2.0 ,4,4,3,0,0
93,"Doyle","Jack","Dirty jack",R,R,"","IRELAND,,KILLORGLIN",5,9,155,0,0,2,0 ,0,0,1,0,31,3,55,10,25,1869,1,0,0,0,0,12,0,0,0,0,0 ,1,2,1240000,0,0,0,0,0,49,6,62,19,91,46,6,61,18,90 ,46,6,65,20,93,64,9,70,40,99,7,1,20,0,7,1,20,7,1,2 0,1,1,20,0,0,0,0,0,0,0,0,1,0,0,2459,2261,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,2,3,4,3,1,0,3,10,0,0,0,0, 0,0,3,9,0,3,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,3,16 ,18,0,11,Active,0,0,87,91,100,1,3,0,0,0,0,0,0,0,0, 0,0,2.5,15,13,14,0,0
94,"Duffy","Hugh","",R,R,"","USA,RI,CRANSTON",5,7, 168,0,0,0,0,0,2,0,0,34,8,77,11,26,1866,1,0,0,0,0,1 3,0,0,0,0,0,1,2,7210000,0,0,0,0,0,47,13,38,10,71,4 2,13,36,9,69,42,13,42,12,74,49,20,41,39,65,7,1,20, 0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,2438, 2438,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,4,1,0 ,3,13,0,0,0,432,0,0,4,13,1,4,0,1,1,4,0,0,0,0,0,0,0 ,0,0,0,0,0,0,1,74,55,0,6,Active,0,0,83,66,63,1,5,0 ,0,0,0,0,0,0,0,0,0,2.0,14,14,14,0,0
95,"Duggleby","Bill","Frosty bill",R,R,"","USA,NY,UTICA",6,3,225,0,0,2,1,0,0,2, 0,27,1,45,3,16,1874,1,0,0,0,0,1,0,1,0,0,0,1,1,3242 857,0,0,0,0,0,17,3,21,1,74,18,3,21,1,74,18,3,21,1, 74,1,1,1,1,105,17,89,90,91,18,90,90,16,88,90,7,86, 96,0,0,0,0,0,0,0,0,1,0,0,377,377,0,0,0,0,0,60,3,0, 0,0,3,0,0,0,0,0,0,5,2,2,3,1,8,8,8,14,7,6,0,0,0,0,8 ,1,3,0,0,1,3,1,4,0,5,0,5,1,5,3,3,0,4,0,4,12,83,0,1 4,Active,0,0,35,20,9,1,2,0,1,0,1,1,0,1,1,0,6,4.5,2 ,2,2,0,0
96,"Dungan","Sam","",R,R,"","USA,CA,FERNDALE",5,11 ,180,0,0,2,2,2,0,0,0,35,9,44,7,29,1866,1,0,0,0,0,4 ,0,0,0,0,0,1,1,3514286,0,0,0,0,0,72,6,63,32,74,68, 6,61,31,73,68,6,67,34,76,72,13,53,40,80,7,1,20,0,7 ,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,902,886, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,4,4,1,0,3,11 ,0,0,0,361,0,0,11,11,0,3,0,1,0,9,0,0,0,0,0,0,0,0,0 ,0,0,0,0,1,97,8,0,8,Active,0,0,61,83,89,1,4,0,0,0, 0,0,0,0,0,0,0,3.0,6,5,5,0,0
97,"Dunn","Jack","",R,R,"","USA,PA,MEADVILLE",5,9, 0,0,0,0,0,0,0,0,0,29,4,59,10,6,1872,1,0,0,0,0,4,0, 0,0,0,0,1,1,100000,0,0,0,0,0,41,13,42,25,97,41,13, 42,24,97,41,13,42,26,97,46,3,44,24,105,1,24,95,7,1 ,46,99,1,1,91,1,1,20,0,0,0,0,0,0,0,0,1,0,0,869,869 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,3,4,4,1,0,3,1 3,1,0,1,501,418,347,0,13,0,7,0,1,0,5,1,1,0,0,1,1,0 ,0,0,0,0,0,0,4,54,94,0,14,Active,0,8,40,68,65,1,5, 0,0,0,0,0,0,0,0,0,0,2.0,5,5,5,0,0
98,"Dupee","Frank","",R,L,"","USA,VT,MONKTON",6,1, 200,0,0,0,0,0,1,0,0,24,1,88,4,29,1877,1,0,0,0,0,1, 0,0,0,0,0,1,1,100000,0,0,0,0,0,18,3,30,11,47,15,3, 29,10,44,15,3,32,13,54,11,1,21,18,105,5,12,92,10,5 ,12,92,5,12,92,1,1,20,0,0,0,0,0,0,0,0,1,0,0,481,39 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,3,3,1,1,3, 11,1,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0 ,0,0,0,4,14,80,0,3,Active,0,0,19,10,20,1,3,0,0,0,0 ,0,0,0,0,0,0,1.0,3,2,2,0,0
99,"Eagan","Truck","",R,R,"","USA,CA,SAN FRANCISCO",5,11,190,0,0,1,0,0,0,1,0,24,4,90,8,10 ,1877,1,0,0,0,0,1,0,0,0,0,0,1,1,100000,0,0,0,0,0,1 8,3,33,9,87,16,3,32,8,86,16,3,36,10,89,13,6,38,16, 105,7,1,20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0, 1,0,0,646,390,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1, 4,3,3,1,0,3,10,0,0,0,0,0,0,0,8,0,2,0,0,0,2,0,0,0,0 ,0,0,0,0,0,0,0,0,0,2,2,79,0,15,Active,0,0,52,13,17 ,1,3,0,0,0,0,0,0,0,0,0,0,1.0,4,2,3,0,0
100,"Eason","Mal","Kid",R,R,"","USA,PA,BROOKVILLE" ,6,0,175,0,0,0,0,0,1,1,0,22,1,36,3,13,1879,1,0,0,0 ,0,1,0,1,0,0,0,1,1,878571,0,0,0,0,0,9,3,21,1,74,9, 3,21,1,74,9,3,21,1,74,1,1,1,1,105,13,70,94,94,13,7 1,94,12,69,94,10,70,94,0,0,0,0,0,0,0,0,1,0,0,377,3 90,0,0,0,0,0,49,3,0,0,0,1,0,0,0,0,0,0,3,2,2,2,1,7, 9,5,14,10,7,0,0,0,0,2,0,2,0,0,0,1,0,4,1,10,3,3,0,5 ,0,3,1,6,1,2,5,85,0,11,Active,0,0,1,20,25,1,2,0,1, 0,1,1,0,1,0,0,3,2.0,3,2,2,0,0
101,"Elberfeld","Kid","The tabasco kidRR",R,R,"","USA,OH,POMEROY",5,7,158,0,2,0,0,0, 2,0,0,26,6,90,4,13,1875,1,0,0,0,0,2,0,0,0,0,0,1,1, 3792857,0,0,0,0,0,64,13,68,58,97,64,13,68,58,97,64 ,13,68,58,97,56,6,55,50,105,7,1,20,0,7,1,20,7,1,20 ,1,1,20,0,0,0,0,0,0,0,0,1,0,0,518,518,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,7,4,5,3,1,0,3,12,0,0,0,425,2 99,0,9,12,0,4,0,1,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,3, 14,73,0,5,Active,0,0,63,68,50,1,5,0,0,0,0,0,0,0,0, 0,0,4.0,3,3,3,0,0
102,"Ely","Bones","",R,R,"","USA,PA,NORTH GIRARD",6,1,160,0,2,1,0,0,0,0,0,38,6,69,6,7,1863,1 ,0,0,0,0,12,0,0,0,0,0,1,1,100000,0,0,0,0,0,26,6,32 ,2,67,23,6,30,1,66,23,6,38,3,70,28,13,35,26,65,7,1 ,20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,2 385,2249,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,3,4 ,1,0,3,12,0,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0, 0,0,0,0,0,0,0,3,17,93,0,15,Active,0,0,76,73,88,1,5 ,0,0,0,0,0,0,0,0,0,0,1.0,14,13,13,0,0
103,"Everitt","Bill","Wild bill",L,R,"","USA,IN,FORT WAYNE",6,0,185,0,0,1,2,0,0,0,1,32,3,30,12,13,1868, 1,0,0,0,0,6,0,0,0,0,0,1,1,100000,0,0,0,0,0,40,9,42 ,19,89,43,9,44,20,91,43,9,36,17,85,82,16,48,44,97, 7,1,20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,0,0, 0,1068,1235,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3, 4,3,1,0,3,11,0,0,0,0,0,0,1,4,0,3,0,0,0,4,0,0,0,0,0 ,0,0,0,0,0,0,0,0,4,16,6,0,7,Active,0,0,85,90,100,1 ,3,0,0,0,0,0,0,0,0,0,0,2.5,8,7,6,0,0
104,"Farrell","Duke","",S,R,"","USA,MA,OAKDALE",6, 1,208,0,0,0,1,0,1,0,0,35,2,42,8,31,1866,1,0,0,0,0, 13,0,0,0,0,0,1,3,4670000,0,0,0,0,0,45,3,49,17,81,4 5,3,49,17,81,45,3,49,17,81,50,8,46,34,82,7,1,20,0, 7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,2412,24 12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,3,3,1,0,3 ,10,0,0,0,327,0,0,0,6,0,4,0,1,0,3,0,0,0,0,0,0,0,0, 0,0,0,0,0,55,3,29,4,10,Active,0,0,64,64,77,1,3,0,0 ,0,0,0,0,0,0,0,0,3.0,14,14,14,0,0
105,"Farrell","John","",R,R,"","USA,KY,COVINGTON", 5,10,160,0,0,0,0,0,0,0,0,24,4,92,12,4,1876,1,0,0,0 ,0,1,0,0,0,0,0,1,1,100000,0,0,0,0,0,50,13,77,47,80 ,50,13,76,47,80,50,13,78,48,81,51,13,79,47,105,7,1 ,20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,3 61,384,0,0,0,0,0,0,0,0,0,0,0,0,1,0,2,0,0,3,3,5,3,1 ,0,3,19,0,0,0,444,384,351,3,19,0,6,0,1,0,8,0,0,0,0 ,0,0,0,0,0,0,0,0,0,4,87,99,0,8,Active,0,0,58,45,53 ,1,3,0,0,0,0,0,0,0,0,0,0,1.5,3,2,2,0,0
106,"Felix","Harry","",R,R,"","USA,NY,BROOKLYN",6, 2,210,0,1,2,0,0,2,0,0,22,1,22,0,0,1879,1,0,83,0,0, 1,0,1,0,0,0,1,1,100000,0,0,0,0,0,1,3,21,1,10,1,3,2 1,1,10,1,3,21,1,10,1,31,1,50,50,6,15,98,43,7,20,98 ,5,9,98,2,79,97,0,0,0,0,0,0,0,0,1,0,0,432,216,0,4, 0,0,0,59,4,0,0,0,2,0,0,0,0,0,0,0,2,2,2,1,6,4,5,12, 6,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,3,4,94,0,13,A,0,0,2,20,31,1,2,0,1,0,0,1,0,1,0,0, 6,1.5,3,1,2,0,0
107,"Ferguson","Charlie","",R,R,"","USA,MI,OKEMOS" ,5,11,0,0,0,2,0,0,0,0,0,26,1,70,5,10,1875,1,0,0,0, 0,1,0,1,0,0,0,1,1,100000,0,0,0,0,0,4,3,21,1,10,5,3 ,21,1,10,5,3,21,1,10,50,31,1,1,50,9,12,106,43,9,12 ,106,9,12,106,1,1,110,0,0,0,0,0,0,0,0,1,0,0,503,38 4,0,0,0,0,0,62,4,0,0,0,2,0,0,0,0,0,0,0,2,2,2,1,8,5 ,5,12,6,7,0,0,0,0,1,0,1,0,0,0,1,0,4,5,5,0,1,3,3,0, 4,2,3,2,2,11,99,0,11,Active,0,0,7,20,23,1,2,0,1,0, 0,0,0,1,0,0,3,1.0,3,2,2,0,0
108,"Ferris","Hobe","",R,R,"","USA,RI,PROVIDENCE", 5,8,162,0,0,1,0,0,0,1,0,23,4,66,12,7,1877,1,0,0,0, 0,1,0,0,0,0,0,1,1,100000,0,0,0,0,0,45,6,55,18,77,4 5,6,55,18,77,45,6,55,18,77,44,22,63,10,105,7,1,20, 0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,418,3 86,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,3,4,1,0,3 ,12,0,0,0,441,0,0,4,12,2,6,0,1,0,4,0,0,0,0,0,0,0,0 ,0,0,0,0,0,5,18,70,0,2,Active,0,0,56,83,99,1,5,0,0 ,0,0,0,0,0,0,0,0,1.0,3,2,2,0,0
109,"Fisher","Chauncey","Peach",R,R,"","USA,IN,AND ERSON",5,11,180,0,0,2,0,0,0,2,1,29,1,1,1,8,1872,2, 0,0,0,0,4,0,1,0,0,0,1,1,1314286,0,0,0,0,0,5,3,21,1 ,10,6,3,21,1,10,6,3,21,1,10,1,1,1,1,50,20,62,87,58 ,20,63,87,19,60,87,1,69,94,0,0,0,0,0,0,0,0,1,0,0,9 05,897,0,0,0,0,0,61,4,0,0,0,2,0,0,0,0,0,0,0,2,2,2, 1,6,11,5,12,7,6,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0, 2,2,1,1,0,0,1,1,4,94,0,13,Active,0,0,40,20,36,1,2, 0,1,0,1,1,0,0,1,0,4,4.5,6,5,5,0,0
110,"Flick","Elmer","",L,R,"","USA,OH,BEDFORD",5,9 ,168,0,0,1,0,2,0,0,1,25,9,39,1,11,1876,1,31,44,1,0 ,3,0,0,0,0,0,1,2,10030000,0,0,0,0,0,76,21,82,48,84 ,80,22,84,49,85,80,19,78,44,82,78,22,82,56,88,7,1, 20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,0,0,0,73 6,736,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,8,4,4,5,1, 0,3,17,0,0,0,373,357,338,0,17,0,8,0,1,0,10,0,0,0,0 ,0,0,0,0,0,0,0,0,0,2,96,59,0,14,DL,5,0,91,60,52,1, 5,0,0,0,0,0,0,0,0,0,0,4.5,4,4,4,0,0

gmo · 01-18-2005, 12:20 AM

Quote:

99,"Eagan","Truck","",R,R,"","USA,CA,SAN FRANCISCO"

Just a shot in the dark here, but those rectangles (supposed to be tabs?) may be the problem. You could probably do a find&replace in notepad or Wordpad to get rid of the all.

Jeremy Weimer · 01-18-2005, 12:25 AM

I thought that might have something to do with it and I took out those ones but then I noticed they appear like throughout the entire file. From 1 all the way down. So I don't see why it would say line 100 is the problem if all the lines before that work fine with those in there.

Jeremy Weimer · 01-18-2005, 12:32 AM

I just went through and removed all the boxes/squares and it still says the same thing.

endgame · 01-18-2005, 12:45 AM

91,"Dowd","Tommy","Buttermilk tommRR ",R,R,"","USA,MA,HOLYOKE",5,8,173,0,0,

this looks like a culprit to me, but I don't know much. It just doesn't seem like that tommRR should be in there before the R,R. Look at the other entries, it doens't jive.

and this one nearer the 'problem' line:

101,"Elberfeld","Kid","The tabasco kidRR",

What's with the entries after kid? Doesn't seem right compared to the others.

Jeremy Weimer · 01-18-2005, 01:13 AM

Anyone else have any suggestions/tips/advice? I just want it to work.

Treches · 01-18-2005, 01:43 AM

Quote:

Originally Posted by endgame

91,"Dowd","Tommy","Buttermilk tommRR ",R,R,"","USA,MA,HOLYOKE",5,8,173,0,0,

this looks like a culprit to me, but I don't know much. It just doesn't seem like that tommRR should be in there before the R,R. Look at the other entries, it doens't jive.

and this one nearer the 'problem' line:

101,"Elberfeld","Kid","The tabasco kidRR",

What's with the entries after kid? Doesn't seem right compared to the others.

I'm pretty sure this is it along with the odd character in the hometown posted earlier. One thing though: you want to fix those within the game and run the exporter again. Otherwise, you'd be having the same trouble all over again.

Jeremy Weimer · 01-18-2005, 03:13 AM

Thanks for the advice guys. I removed the RR and boxes from those two nicknames and everything worked fine. I appreciate the help.

Jeremy Weimer · 01-18-2005, 03:22 AM

This isn't really related to the topic, but is 9 minutes a good time for how long it takes Catobase to totally finish?

Aordolin · 01-18-2005, 03:57 AM

the data imports dont take long 5-10 minutes if that. building the webpages can be time consuming though, the larger your db gets, mine takes atleast an hour now.

endgame · 01-18-2005, 01:08 PM

Quote:

Originally Posted by Aordolin

the data imports dont take long 5-10 minutes if that. building the webpages can be time consuming though, the larger your db gets, mine takes atleast an hour now.

I'm generating a 10 year season, 16 teams, and the html portion runs right at a half an hour.

Aceshigh24 · 01-18-2005, 01:13 PM

Hey endgame....do you have a link to your catobase career, i was wondering if i could check it out??

endgame · 01-18-2005, 05:41 PM

Quote:

Originally Posted by Aceshigh24

Hey endgame....do you have a link to your catobase career, i was wondering if i could check it out??

No, sorry. I don't have my stats hosted. I'm thinking about doing that if I ever take my league into the Dynasty thread, but right now my only audience is my hard drive.

01-17-2005, 11:41 PM	#1 (permalink)
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Mounds View, MN Posts: 3,376 Thanks: 2 Thanked 4x in 2 posts	Catobase Problem: Help Please Alright, I started a solo league in 1901 using the Lahman database. I played out the season and figured it would be cool to use Catobase to keep a running history of my league. So I setup Catobase and all that and then ran it. I hit "Import Stats" to begin the process and it starts doing it's business then a window pops up saying: "There is a problem importing around line 100 in the file \players.csv The most likely causes is an invalid character the Nickname or HomeState fields. Open this file in Notepad and uncheck word wrap (under Edit). Examine the above line and surrounding lines for any unusual characters and import again." I know that's pretty self explainatory, but how do I go about fixing this? I opened up the file in Notepad like it said and looked at line 100 and the others around it and didn't really notice anything unfamiliar compared to other lines. So how do I know what to look for and remove? Any help is appreciated on fixing this problem.

01-18-2005, 12:45 AM	#7 (permalink)
endgame Hall Of Famer Join Date: Aug 2002 Posts: 10,771 Thanks: 893 Thanked 756x in 429 posts	91,"Dowd","Tommy","Buttermilk tommRR ",R,R,"","USA,MA,HOLYOKE",5,8,173,0,0, this looks like a culprit to me, but I don't know much. It just doesn't seem like that tommRR should be in there before the R,R. Look at the other entries, it doens't jive. and this one nearer the 'problem' line: 101,"Elberfeld","Kid","The tabasco kidRR", What's with the entries after kid? Doesn't seem right compared to the others. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________ Last edited by endgame; 01-18-2005 at 12:49 AM.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

01-17-2005, 11:55 PM	#3 (permalink)
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Mounds View, MN Posts: 3,376 Thanks: 2 Thanked 4x in 2 posts	90,"Douglass","Klondike","",L,R,"","USA,PA,BOSTON" ,6,0,200,0,0,2,2,1,1,0,0,29,2,78,5,10,1872,1,0,0,0 ,0,5,0,0,0,0,0,1,1,771429,0,0,0,0,0,46,6,39,12,77, 47,6,40,12,78,47,6,38,11,75,47,16,48,43,93,7,1,20, 0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,1237, 1069,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,4,4,3,1,0 ,3,12,3,0,0,0,0,0,0,5,0,3,0,0,1,2,0,0,0,0,0,0,0,0, 0,0,0,0,0,41,29,23,4,14,Active,0,0,62,72,92,1,3,0, 0,0,0,0,0,0,0,0,0,2.5,7,6,7,0,0 91,"Dowd","Tommy","Buttermilk tommRR ",R,R,"","USA,MA,HOLYOKE",5,8,173,0,0,0,0,0,0,0,1, 32,7,84,4,20,1869,1,0,0,0,0,9,0,0,0,0,0,1,4,175000 0,0,0,0,0,0,48,9,49,31,88,43,9,46,29,86,43,9,55,36 ,91,55,9,53,39,95,7,1,20,0,7,1,20,7,1,20,1,1,20,0, 0,0,0,0,0,0,0,1,0,0,1975,1751,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,4,3,3,4,1,0,3,16,0,0,0,389,322,296,2 ,16,0,3,0,1,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,3,89,95, 0,2,Active,0,0,88,68,80,1,4,0,0,0,0,0,0,0,0,0,0,1. 5,12,10,11,0,0 92,"Dowling","Pete","",R,L,"",",,",5,11,0,0,0,2,0, 0,1,0,0,1901,1,67,0,0,0,2,0,36,0,0,3,0,1,0,0,0,1,4 ,5780000,0,0,0,0,0,19,3,21,1,74,17,3,21,1,74,17,3, 21,1,74,1,1,1,1,105,6,20,39,85,6,20,39,7,22,39,13, 20,38,0,0,0,0,0,0,0,0,0,0,0,578,735,0,0,0,0,0,63,3 ,0,0,0,1,0,0,0,0,0,0,4,2,2,2,1,6,9,5,16,6,6,0,0,0, 0,5,0,1,0,0,0,1,1,5,0,5,0,3,2,2,1,3,0,3,0,2,20,99, 0,6,Active,0,0,33,20,2,1,2,0,1,0,1,1,0,1,1,0,3,2.0 ,4,4,3,0,0 93,"Doyle","Jack","Dirty jack",R,R,"","IRELAND,,KILLORGLIN",5,9,155,0,0,2,0 ,0,0,1,0,31,3,55,10,25,1869,1,0,0,0,0,12,0,0,0,0,0 ,1,2,1240000,0,0,0,0,0,49,6,62,19,91,46,6,61,18,90 ,46,6,65,20,93,64,9,70,40,99,7,1,20,0,7,1,20,7,1,2 0,1,1,20,0,0,0,0,0,0,0,0,1,0,0,2459,2261,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,2,3,4,3,1,0,3,10,0,0,0,0, 0,0,3,9,0,3,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,3,16 ,18,0,11,Active,0,0,87,91,100,1,3,0,0,0,0,0,0,0,0, 0,0,2.5,15,13,14,0,0 94,"Duffy","Hugh","",R,R,"","USA,RI,CRANSTON",5,7, 168,0,0,0,0,0,2,0,0,34,8,77,11,26,1866,1,0,0,0,0,1 3,0,0,0,0,0,1,2,7210000,0,0,0,0,0,47,13,38,10,71,4 2,13,36,9,69,42,13,42,12,74,49,20,41,39,65,7,1,20, 0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,2438, 2438,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,4,1,0 ,3,13,0,0,0,432,0,0,4,13,1,4,0,1,1,4,0,0,0,0,0,0,0 ,0,0,0,0,0,0,1,74,55,0,6,Active,0,0,83,66,63,1,5,0 ,0,0,0,0,0,0,0,0,0,2.0,14,14,14,0,0 95,"Duggleby","Bill","Frosty bill",R,R,"","USA,NY,UTICA",6,3,225,0,0,2,1,0,0,2, 0,27,1,45,3,16,1874,1,0,0,0,0,1,0,1,0,0,0,1,1,3242 857,0,0,0,0,0,17,3,21,1,74,18,3,21,1,74,18,3,21,1, 74,1,1,1,1,105,17,89,90,91,18,90,90,16,88,90,7,86, 96,0,0,0,0,0,0,0,0,1,0,0,377,377,0,0,0,0,0,60,3,0, 0,0,3,0,0,0,0,0,0,5,2,2,3,1,8,8,8,14,7,6,0,0,0,0,8 ,1,3,0,0,1,3,1,4,0,5,0,5,1,5,3,3,0,4,0,4,12,83,0,1 4,Active,0,0,35,20,9,1,2,0,1,0,1,1,0,1,1,0,6,4.5,2 ,2,2,0,0 96,"Dungan","Sam","",R,R,"","USA,CA,FERNDALE",5,11 ,180,0,0,2,2,2,0,0,0,35,9,44,7,29,1866,1,0,0,0,0,4 ,0,0,0,0,0,1,1,3514286,0,0,0,0,0,72,6,63,32,74,68, 6,61,31,73,68,6,67,34,76,72,13,53,40,80,7,1,20,0,7 ,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,902,886, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,4,4,1,0,3,11 ,0,0,0,361,0,0,11,11,0,3,0,1,0,9,0,0,0,0,0,0,0,0,0 ,0,0,0,0,1,97,8,0,8,Active,0,0,61,83,89,1,4,0,0,0, 0,0,0,0,0,0,0,3.0,6,5,5,0,0 97,"Dunn","Jack","",R,R,"","USA,PA,MEADVILLE",5,9, 0,0,0,0,0,0,0,0,0,29,4,59,10,6,1872,1,0,0,0,0,4,0, 0,0,0,0,1,1,100000,0,0,0,0,0,41,13,42,25,97,41,13, 42,24,97,41,13,42,26,97,46,3,44,24,105,1,24,95,7,1 ,46,99,1,1,91,1,1,20,0,0,0,0,0,0,0,0,1,0,0,869,869 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,3,4,4,1,0,3,1 3,1,0,1,501,418,347,0,13,0,7,0,1,0,5,1,1,0,0,1,1,0 ,0,0,0,0,0,0,4,54,94,0,14,Active,0,8,40,68,65,1,5, 0,0,0,0,0,0,0,0,0,0,2.0,5,5,5,0,0 98,"Dupee","Frank","",R,L,"","USA,VT,MONKTON",6,1, 200,0,0,0,0,0,1,0,0,24,1,88,4,29,1877,1,0,0,0,0,1, 0,0,0,0,0,1,1,100000,0,0,0,0,0,18,3,30,11,47,15,3, 29,10,44,15,3,32,13,54,11,1,21,18,105,5,12,92,10,5 ,12,92,5,12,92,1,1,20,0,0,0,0,0,0,0,0,1,0,0,481,39 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,3,3,1,1,3, 11,1,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0 ,0,0,0,4,14,80,0,3,Active,0,0,19,10,20,1,3,0,0,0,0 ,0,0,0,0,0,0,1.0,3,2,2,0,0 99,"Eagan","Truck","",R,R,"","USA,CA,SAN FRANCISCO",5,11,190,0,0,1,0,0,0,1,0,24,4,90,8,10 ,1877,1,0,0,0,0,1,0,0,0,0,0,1,1,100000,0,0,0,0,0,1 8,3,33,9,87,16,3,32,8,86,16,3,36,10,89,13,6,38,16, 105,7,1,20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0, 1,0,0,646,390,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1, 4,3,3,1,0,3,10,0,0,0,0,0,0,0,8,0,2,0,0,0,2,0,0,0,0 ,0,0,0,0,0,0,0,0,0,2,2,79,0,15,Active,0,0,52,13,17 ,1,3,0,0,0,0,0,0,0,0,0,0,1.0,4,2,3,0,0 100,"Eason","Mal","Kid",R,R,"","USA,PA,BROOKVILLE" ,6,0,175,0,0,0,0,0,1,1,0,22,1,36,3,13,1879,1,0,0,0 ,0,1,0,1,0,0,0,1,1,878571,0,0,0,0,0,9,3,21,1,74,9, 3,21,1,74,9,3,21,1,74,1,1,1,1,105,13,70,94,94,13,7 1,94,12,69,94,10,70,94,0,0,0,0,0,0,0,0,1,0,0,377,3 90,0,0,0,0,0,49,3,0,0,0,1,0,0,0,0,0,0,3,2,2,2,1,7, 9,5,14,10,7,0,0,0,0,2,0,2,0,0,0,1,0,4,1,10,3,3,0,5 ,0,3,1,6,1,2,5,85,0,11,Active,0,0,1,20,25,1,2,0,1, 0,1,1,0,1,0,0,3,2.0,3,2,2,0,0 101,"Elberfeld","Kid","The tabasco kidRR",R,R,"","USA,OH,POMEROY",5,7,158,0,2,0,0,0, 2,0,0,26,6,90,4,13,1875,1,0,0,0,0,2,0,0,0,0,0,1,1, 3792857,0,0,0,0,0,64,13,68,58,97,64,13,68,58,97,64 ,13,68,58,97,56,6,55,50,105,7,1,20,0,7,1,20,7,1,20 ,1,1,20,0,0,0,0,0,0,0,0,1,0,0,518,518,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,7,4,5,3,1,0,3,12,0,0,0,425,2 99,0,9,12,0,4,0,1,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,3, 14,73,0,5,Active,0,0,63,68,50,1,5,0,0,0,0,0,0,0,0, 0,0,4.0,3,3,3,0,0 102,"Ely","Bones","",R,R,"","USA,PA,NORTH GIRARD",6,1,160,0,2,1,0,0,0,0,0,38,6,69,6,7,1863,1 ,0,0,0,0,12,0,0,0,0,0,1,1,100000,0,0,0,0,0,26,6,32 ,2,67,23,6,30,1,66,23,6,38,3,70,28,13,35,26,65,7,1 ,20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,2 385,2249,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,3,4 ,1,0,3,12,0,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0, 0,0,0,0,0,0,0,3,17,93,0,15,Active,0,0,76,73,88,1,5 ,0,0,0,0,0,0,0,0,0,0,1.0,14,13,13,0,0 103,"Everitt","Bill","Wild bill",L,R,"","USA,IN,FORT WAYNE",6,0,185,0,0,1,2,0,0,0,1,32,3,30,12,13,1868, 1,0,0,0,0,6,0,0,0,0,0,1,1,100000,0,0,0,0,0,40,9,42 ,19,89,43,9,44,20,91,43,9,36,17,85,82,16,48,44,97, 7,1,20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,0,0, 0,1068,1235,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3, 4,3,1,0,3,11,0,0,0,0,0,0,1,4,0,3,0,0,0,4,0,0,0,0,0 ,0,0,0,0,0,0,0,0,4,16,6,0,7,Active,0,0,85,90,100,1 ,3,0,0,0,0,0,0,0,0,0,0,2.5,8,7,6,0,0 104,"Farrell","Duke","",S,R,"","USA,MA,OAKDALE",6, 1,208,0,0,0,1,0,1,0,0,35,2,42,8,31,1866,1,0,0,0,0, 13,0,0,0,0,0,1,3,4670000,0,0,0,0,0,45,3,49,17,81,4 5,3,49,17,81,45,3,49,17,81,50,8,46,34,82,7,1,20,0, 7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,2412,24 12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,3,3,3,1,0,3 ,10,0,0,0,327,0,0,0,6,0,4,0,1,0,3,0,0,0,0,0,0,0,0, 0,0,0,0,0,55,3,29,4,10,Active,0,0,64,64,77,1,3,0,0 ,0,0,0,0,0,0,0,0,3.0,14,14,14,0,0 105,"Farrell","John","",R,R,"","USA,KY,COVINGTON", 5,10,160,0,0,0,0,0,0,0,0,24,4,92,12,4,1876,1,0,0,0 ,0,1,0,0,0,0,0,1,1,100000,0,0,0,0,0,50,13,77,47,80 ,50,13,76,47,80,50,13,78,48,81,51,13,79,47,105,7,1 ,20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,3 61,384,0,0,0,0,0,0,0,0,0,0,0,0,1,0,2,0,0,3,3,5,3,1 ,0,3,19,0,0,0,444,384,351,3,19,0,6,0,1,0,8,0,0,0,0 ,0,0,0,0,0,0,0,0,0,4,87,99,0,8,Active,0,0,58,45,53 ,1,3,0,0,0,0,0,0,0,0,0,0,1.5,3,2,2,0,0 106,"Felix","Harry","",R,R,"","USA,NY,BROOKLYN",6, 2,210,0,1,2,0,0,2,0,0,22,1,22,0,0,1879,1,0,83,0,0, 1,0,1,0,0,0,1,1,100000,0,0,0,0,0,1,3,21,1,10,1,3,2 1,1,10,1,3,21,1,10,1,31,1,50,50,6,15,98,43,7,20,98 ,5,9,98,2,79,97,0,0,0,0,0,0,0,0,1,0,0,432,216,0,4, 0,0,0,59,4,0,0,0,2,0,0,0,0,0,0,0,2,2,2,1,6,4,5,12, 6,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,3,4,94,0,13,A,0,0,2,20,31,1,2,0,1,0,0,1,0,1,0,0, 6,1.5,3,1,2,0,0 107,"Ferguson","Charlie","",R,R,"","USA,MI,OKEMOS" ,5,11,0,0,0,2,0,0,0,0,0,26,1,70,5,10,1875,1,0,0,0, 0,1,0,1,0,0,0,1,1,100000,0,0,0,0,0,4,3,21,1,10,5,3 ,21,1,10,5,3,21,1,10,50,31,1,1,50,9,12,106,43,9,12 ,106,9,12,106,1,1,110,0,0,0,0,0,0,0,0,1,0,0,503,38 4,0,0,0,0,0,62,4,0,0,0,2,0,0,0,0,0,0,0,2,2,2,1,8,5 ,5,12,6,7,0,0,0,0,1,0,1,0,0,0,1,0,4,5,5,0,1,3,3,0, 4,2,3,2,2,11,99,0,11,Active,0,0,7,20,23,1,2,0,1,0, 0,0,0,1,0,0,3,1.0,3,2,2,0,0 108,"Ferris","Hobe","",R,R,"","USA,RI,PROVIDENCE", 5,8,162,0,0,1,0,0,0,1,0,23,4,66,12,7,1877,1,0,0,0, 0,1,0,0,0,0,0,1,1,100000,0,0,0,0,0,45,6,55,18,77,4 5,6,55,18,77,45,6,55,18,77,44,22,63,10,105,7,1,20, 0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,1,0,0,418,3 86,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,3,4,1,0,3 ,12,0,0,0,441,0,0,4,12,2,6,0,1,0,4,0,0,0,0,0,0,0,0 ,0,0,0,0,0,5,18,70,0,2,Active,0,0,56,83,99,1,5,0,0 ,0,0,0,0,0,0,0,0,1.0,3,2,2,0,0 109,"Fisher","Chauncey","Peach",R,R,"","USA,IN,AND ERSON",5,11,180,0,0,2,0,0,0,2,1,29,1,1,1,8,1872,2, 0,0,0,0,4,0,1,0,0,0,1,1,1314286,0,0,0,0,0,5,3,21,1 ,10,6,3,21,1,10,6,3,21,1,10,1,1,1,1,50,20,62,87,58 ,20,63,87,19,60,87,1,69,94,0,0,0,0,0,0,0,0,1,0,0,9 05,897,0,0,0,0,0,61,4,0,0,0,2,0,0,0,0,0,0,0,2,2,2, 1,6,11,5,12,7,6,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0, 2,2,1,1,0,0,1,1,4,94,0,13,Active,0,0,40,20,36,1,2, 0,1,0,1,1,0,0,1,0,4,4.5,6,5,5,0,0 110,"Flick","Elmer","",L,R,"","USA,OH,BEDFORD",5,9 ,168,0,0,1,0,2,0,0,1,25,9,39,1,11,1876,1,31,44,1,0 ,3,0,0,0,0,0,1,2,10030000,0,0,0,0,0,76,21,82,48,84 ,80,22,84,49,85,80,19,78,44,82,78,22,82,56,88,7,1, 20,0,7,1,20,7,1,20,1,1,20,0,0,0,0,0,0,0,0,0,0,0,73 6,736,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,8,4,4,5,1, 0,3,17,0,0,0,373,357,338,0,17,0,8,0,1,0,10,0,0,0,0 ,0,0,0,0,0,0,0,0,0,2,96,59,0,14,DL,5,0,91,60,52,1, 5,0,0,0,0,0,0,0,0,0,0,4.5,4,4,4,0,0

01-18-2005, 12:25 AM	#5 (permalink)
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Mounds View, MN Posts: 3,376 Thanks: 2 Thanked 4x in 2 posts	I thought that might have something to do with it and I took out those ones but then I noticed they appear like throughout the entire file. From 1 all the way down. So I don't see why it would say line 100 is the problem if all the lines before that work fine with those in there.

01-18-2005, 12:32 AM	#6 (permalink)
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Mounds View, MN Posts: 3,376 Thanks: 2 Thanked 4x in 2 posts	I just went through and removed all the boxes/squares and it still says the same thing.

01-18-2005, 01:13 AM	#8 (permalink)
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Mounds View, MN Posts: 3,376 Thanks: 2 Thanked 4x in 2 posts	Anyone else have any suggestions/tips/advice? I just want it to work.

01-18-2005, 03:13 AM	#10 (permalink)
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Mounds View, MN Posts: 3,376 Thanks: 2 Thanked 4x in 2 posts	Thanks for the advice guys. I removed the RR and boxes from those two nicknames and everything worked fine. I appreciate the help.

01-18-2005, 03:22 AM	#11 (permalink)
Jeremy Weimer Hall Of Famer Join Date: Jun 2003 Location: Mounds View, MN Posts: 3,376 Thanks: 2 Thanked 4x in 2 posts	This isn't really related to the topic, but is 9 minutes a good time for how long it takes Catobase to totally finish?

01-18-2005, 03:57 AM	#12 (permalink)
Aordolin All Star Reserve Join Date: Apr 2004 Location: Houston, TX Posts: 582 Thanks: 0 Thanked 0x in 0 posts	the data imports dont take long 5-10 minutes if that. building the webpages can be time consuming though, the larger your db gets, mine takes atleast an hour now.

01-18-2005, 01:13 PM	#14 (permalink)
Aceshigh24 Major Leagues Join Date: Jan 2002 Location: Brea, CA Posts: 303 Thanks: 2 Thanked 31x in 13 posts	Hey endgame....do you have a link to your catobase career, i was wondering if i could check it out??