Discussion :

[freija]

Bonjour,

J'espère que je post au bon endroit!

Je dois faire un catalogue en ligne et le fournisseur m'envoi un fichier csv.
Seulement quand je veux l'importer ds phpmyadmin il me met un message d'erreur que je ne comprend pas:


ERROR: Identificateur invalide @ 5067
STR: 000.0000.
SQL: "C","FUJI ","1850 ","A151323 ","FINEPIX A400/+256 XD CARD ","SUPER CDD/4MP/ NS","MSD ","10217KT1 ",00000107.74,00000120.00,"Y"," "," ","3660662012024","1703","FR",000.47


MySQL a répondu:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"C","FUJI ","1850 ","A151323 ","FI' at line 1



Quelqu'un pourrait-il m'éclairer, j'espère que cela ne viens pas du fichier car il y a plus de 4000 references et je ne me vois pas tous retaper!!

Merci d'avance à tous ceux pourraient m'aider.

[Biglo]

Salut,

Donne-nous quelques lignes de ton fichier CSV si ce n'est pas confidentiel.

Je n'ai jamais importé de CSV avec phpmyadmin. Y a-t-il des options paramétrables ? Sinon tu peux le faire manuellement avec la commande LOAD DATA INFILE (voir documentation officielle).

[freija]

Voilà un extrait de mon fichier csv, j'ai rajouté un point rouge pour que vous puissiez visualiser la fin de la ligne:


"C","FUJI ","1850 ","A151323 ","FINEPIX A400/+256 XD CARD ","SUPER CDD/4MP/ NS","MSD ","10217KT1 ",00000107.74,00000120.00,"Y"," "," ","3660662012024","1703","FR",000.47.
"A","AXIS COMMUNICATION ","7245 ","B090521 ","VANDAL-RESISTANT HOUSING ","F/ 206/207 NS","MSD ","5006-001 ",00000156.57,00000179.00," "," "," "," ","0486","FR",000.00.
"C","EXABYTE - SUPPLIES ","8284 ","B32Z179 ","M2-150M AME WITH SMARTCLEAN "," NS","MSD ","00573 ",00000044.65,00000062.48," "," "," "," ","1021","FR",000.00.
"C","EXABYTE - SUPPLIES ","8284 ","B32Z180 ","M2-75M AME WITH SMARTCLEAN "," NS","MSD ","00572 ",00000029.77,00000041.52," "," "," "," ","1021","FR",000.00.
"C","EXABYTE - SUPPLIES ","8284 ","B32Z183 ","D8-160 8MM (160M XL LENGTH) ","EXATAPE NS","MSD ","307265 ",00000007.36,00000012.96," "," "," "," ","1023","FR",000.00.
"C","EXABYTE - SUPPLIES ","8284 ","B32Z199 ","EXABYTE MAMMOTH-2 LVD WIDE ","DRIVE IN CARRIER FOR X80 NS","NMS ","1002699 ",00004037.35,00005921.71," "," "," "," ","0205","FR",000.00.
"C","EXABYTE - SUPPLIES ","8284 ","B32Z291 ","M2 LVD DRIVE CARRIER ","F/ 430/215 LIBRARY NS","MSD ","1005831 ",00003658.95,00005366.47," "," "," "," ","0205","FR",000.00.

[gerald2545]

ton csv semble avoir des retours chariot au sein de tes valeurs (entre guillemets), ce qui fait que le csv n'est pas "valide".
Il faut que tu les remplaces par autre chose (espace?)

[freija]

Je vais essayer
Merci

[freija]

9a ne marche toujours pas il met le meme message d'erreur!

[Biglo]

Tu n'as pas répondu à ma question de tout à l'heure. Est-ce que PhpMyAdmin te demande des paramètres pour faire l'import (ex : séparateur de champs, fin de ligne, ...) ?

Est-ce que tu vois la requête qu'il exécute ?

[gerald2545]

tu peux nous donner ton message d'erreur et la partie de ton csv qui pose problème STP.
Mieux, tu peux le mettre pièce jointe?