Import .csv files in sths utility problem

Any questions related to version 2 or version 3 should be ask here. / Toutes les questions sur la version 2 ou la version 3 devraient être demandées ici.
Post Reply
CBSHL
The Accomplished One / L'Accompli
Posts: 62
Joined: Sun Jun 19, 2011 10:44 pm

Import .csv files in sths utility problem

Post by CBSHL »

Hi I would like to edit the coaches so I took coaches.csv and tried to change some things and then import it in the utility to convert the files but I get an error telling me
18 Coach(s) on 18 were not imported correctly!
First there are 222 of them...

Then I tried to take the backup file that I had, so the original coaches.csv that STHS outputs... and this one won't load either due to:
259 Coach(s) on 260 were not imported correctly!
Coaches Import Done at 2017-07-15 15:02:55
Line # 2 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 3 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 4 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 5 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 6 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 7 of Coaches CSV file was not imported. Unknown field didn't pass the validation test.
Line # 8 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 9 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 10 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 11 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 12 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 13 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 14 of Coaches CSV file was not imported. Unknown field didn't pass the validation test.
Line # 15 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 16 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 17 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 18 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 19 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 20 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 21 of Coaches CSV file was not imported. Unknown field didn't pass the validation test.
Line # 22 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 23 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 24 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 25 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 26 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 27 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 28 of Coaches CSV file was not imported. Unknown field didn't pass the validation test.
Line # 29 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 30 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 31 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 32 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 33 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 34 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 36 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 37 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 38 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 39 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 40 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 41 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 43 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 44 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 45 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 46 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 47 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 48 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 50 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 51 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 52 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 53 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 54 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 55 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 57 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 58 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 59 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 60 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 61 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 62 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 64 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 65 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 66 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 67 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 68 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 69 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 71 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 72 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 73 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 74 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 75 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 76 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 78 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 79 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 80 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 81 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 82 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 83 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 85 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 86 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 87 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 88 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 89 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 90 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 92 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 93 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 94 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 95 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 96 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 97 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 99 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 100 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 101 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 102 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 103 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 104 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 105 of Coaches CSV file was not imported. Unknown field didn't pass the validation test.
Line # 106 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 107 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 108 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 109 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 110 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 111 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 113 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 114 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 115 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 116 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 117 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 118 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 120 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 121 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 122 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 123 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 124 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 125 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 127 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 128 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 129 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 130 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 131 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 132 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 134 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 135 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 136 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 137 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 138 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 139 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 141 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 142 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 143 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 144 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 145 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 146 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 147 of Coaches CSV file was not imported. Unknown field didn't pass the validation test.
Line # 148 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 149 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 150 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 151 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 152 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 153 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 155 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 156 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 157 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 158 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 159 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 160 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 162 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 163 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 164 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 165 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 166 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 167 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 169 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 170 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 171 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 172 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 173 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 174 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 176 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 177 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 178 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 179 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 180 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 181 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 183 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 184 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 185 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 186 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 187 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 188 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 190 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 191 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 192 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 193 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 194 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 195 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 197 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 198 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 199 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 200 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 201 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 202 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 204 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 205 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 206 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 207 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 208 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 209 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 211 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 212 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 213 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 214 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 215 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 216 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 218 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 219 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 220 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 221 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 222 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 223 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 225 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 226 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 227 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 228 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 229 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 230 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 232 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 233 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 234 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 235 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 236 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 237 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 239 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 240 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 241 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 242 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 243 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 244 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 246 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 247 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 248 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 249 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 250 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 251 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 253 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 254 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 255 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 256 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 257 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 258 of Coaches CSV file was not imported. Country field didn't pass the validation test.
You have 2 coaches with the name 0
Line # 260 of Coaches CSV file was not imported. Country field didn't pass the validation test.
Line # 261 of Coaches CSV file was not imported. Unknown field didn't pass the validation test.
259 Coach(s) on 260 were not imported correctly!
Cant see why it isnt working even with the original file created by STHS
Help me please!
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Import .csv files in sths utility problem

Post by SimonT »

The CSV create by the STHS are not same that you need to import. Please look at CSV Rating File for coach already existing to know the format or export one from the STHS.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
CBSHL
The Accomplished One / L'Accompli
Posts: 62
Joined: Sun Jun 19, 2011 10:44 pm

Re: Import .csv files in sths utility problem

Post by CBSHL »

ok thank you. and for the players rosters.. if I modify it in excel, will the overall be a problem when I import? Cause it wont be the good one if I change the other ratings
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Import .csv files in sths utility problem

Post by SimonT »

The CSVs (Both Coaches and Players) create by the STHS are not same that you need to import.

The players CSVs for rating doesn't have overall. This is calculated by the STHS.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Post Reply