error import csv or xls

PHPMaker General Discussion (PHPMaker)
1

this is the error… in csv and xls and xlsx
Invalid field name: “Remodelacion Tienda Elektra 5047 Victoria de Durango”," 1.005D"," Obras Provisionles"," valores entrantes,“m2”,“200.12”,“300.12”

this is my table

DROP TABLE IF EXISTS catalogo_conceptos;
CREATE TABLE IF NOT EXISTS catalogo_conceptos (
id_catalogo int(10) NOT NULL AUTO_INCREMENT,
nombre_obra varchar(200) NOT NULL,
clave varchar(10) NOT NULL,
conceptos varchar(100) NOT NULL,
especificaciones text NOT NULL,
unidad varchar(20) NOT NULL,
cantidad float NOT NULL,
pu float NOT NULL,
PRIMARY KEY (id_catalogo)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

2

The first line in your file should be field names exactly matching the field names in the database. From the topic “Import Data” in the help file:

The first row of the file should contain the field names to be imported. The field names MUST match the corresponding field names in the table.You can manipulate the field names in the Page_Importing server event (see Server Events for Import) if the file contains pure data only.

3

solved :smiley: