FICHIER CSV

[Webal]

Salut !

j'aimerais que quelqu'un m'explique comment créer un fichier CSV, pour que les stats soit séparer par une virgule ?
j'enregistre mon fichier excel en CVS, mais les cotes sont toujours dans de différentes cellule !!!

Merci !

[SimonT]

Dans Excel, tu as simplement à faire un Save As et choisir "Save as Type" = CSV (Comma delimited)

[Webal]

exactement ce que je fais mais toujours la même chose les chiffre sont dans différente cellule !!!

et moi j'ai pas comma delimited, j'ai CSV (séparateur: point-virgule) ????

[Webal]

Salut Simon

j'ai un autre problème avec un vieux fichiers CSV je veux le saver en STR mais le STHS Utility-V@ me donne des erreur qui sont inexistante??

voici quelque lignes si tu veux essayer !

Marcus Kruger,1,SWE,Y,1990,5,27,172,71,0,1000000,,55,50,73,67,54,71,71,52,57,50,50,65,55,67,64,55
Mark Arcobello,4,USA,N,1988,8,12,165,69,0,1000000,,50,50,62,68,60,65,55,51,60,51,50,47,50,57,57,50
Mark Barberio,8,CAN,Y,1990,3,23,197,73,0,1000000,,55,50,62,66,61,72,70,48,50,51,48,54,48,56,56,55
Mark Cundari,8,CAN,Y,1990,4,23,195,70,0,1000000,,55,62,57,62,64,72,70,48,50,50,48,57,48,56,61,55
Mark Fayne,8,USA,Y,1987,5,15,215,75,0,1000000,,62,52,80,71,73,78,78,69,50,64,62,73,61,62,61,40
Martin Jones,16,CAN,Y,1990,4,10,187,76,0,1000000,,57,65,76,86,59,55,55,59,59,57,57,72,78,55,0,0
Martin Marincin,8,SLO,Y,1992,2,18,196,77,0,1000000,,55,50,50,50,59,60,45,45,50,45,46,51,46,54,54,80
Matt Bartkowski,8,USA,Y,1988,6,4,196,73,0,1000000,,59,50,66,64,59,58,58,60,50,50,50,58,56,66,65,45
Matt Calvert,2,CAN,Y,1989,12,24,187,70,0,1000000,,68,50,79,72,68,73,73,69,50,59,71,64,70,64,61,55
Matt Campanale,8,USA,Y,1988,2,14,200,71,0,1000000,,50,50,39,63,54,57,57,55,50,50,50,52,56,58,58,45
Matt Frattin,4,CAN,Y,1988,1,3,200,72,0,1000000,,58,50,89,70,53,75,75,50,50,50,50,54,55,58,58,50
Matt Hackett,16,CAN,Y,1990,3,7,170,74,0,1000000,,61,67,80,82,60,56,56,60,60,58,58,72,79,65,0,0
Mattias Tedenby,6,SWE,Y,1990,2,21,175,70,0,1000000,,54,50,79,76,62,77,77,62,50,60,61,62,68,73,65,75
Maxim Goncharov,8,RUS,Y,1989,6,15,215,76,0,1000000,,52,50,66,52,82,50,50,50,40,45,63,56,53,80
Maxime Macenauer,1,CAN,Y,1989,1,4,188,72,0,1000000,,53,50,61,63,57,75,75,48,75,50,48,47,48,57,57,60
Michael Hutchinson,16,CAN,Y,1990,3,2,192,75,0,1000000,,50,62,69,84,53,49,49,53,53,51,51,72,76,65,0,0
Michael Latta,1,CAN,Y,1991,5,25,209,72,0,1000000,,57,50,57,50,56,60,45,47,75,48,46,46,46,55,55,70
Michael Stone,8,CAN,Y,1990,6,7,210,75,0,1000000,,58,50,62,50,61,73,71,46,50,48,46,54,46,55,55,70
Michal Jordan,8,CZE,Y,1990,7,17,196,73,0,1000000,,55,50,61,57,64,72,70,47,50,49,47,58,47,55,55,60
Milan Kytnar,1,SLO,Y,1989,5,19,190,72,0,1000000,,54,50,63,61,58,75,75,48,75,49,48,51,48,57,57,50
Nick Crawford,8,CAN,Y,1990,2,23,188,73,0,1000000,,53,50,63,63,62,74,74,48,50,51,48,54,48,56,56,55
Nick Leddy,8,USA,Y,1991,3,20,179,71,0,1000000,,59,50,83,74,67,71,71,66,50,54,62,68,62,62,59,80

et voici e LOG

Players Import Done at 2011-07-23 11:47:02
Line # 15 of Player CSV file was not imported. Stat 18 field didn't pass the validation test.
Line # 16 of Player CSV file was not imported. Position field didn't pass the validation test.
Line # 17 of Player CSV file was not imported. Position field didn't pass the validation test.
Line # 18 of Player CSV file was not imported. Position field didn't pass the validation test.
Line # 19 of Player CSV file was not imported. Position field didn't pass the validation test.
Line # 20 of Player CSV file was not imported. Position field didn't pass the validation test.
Line # 21 of Player CSV file was not imported. Position field didn't pass the validation test.
Line # 22 of Player CSV file was not imported. Position field didn't pass the validation test.
Line # 23 of Player CSV file was not imported. Unknown field didn't pass the validation test.
9 Player(s) on 22 were not imported correctly!

Merci !

[SimonT]

Tu as une erreur à la ligne 18 qui selon moi est que tu as un stat de trop ou il manque un et ça fuck le reste des lignes.

[Str_QNHL]

Maxim Goncharov,8,RUS,Y,1989,6,15,215,76,0,1000000,,52,50,66,52,82,50,50,50,40,45,63,56,53,80

voila le joueur qui est a la ligne 15 (ou tu recois l'erreur)
ce joueur a 14 stats alors que les autres en ont 16

[Webal]

excellent merci je check ça !