double quotes ” import csv problem
-
Hallo, i have a little problem with the import file csv (with ; separator). When inside the description field is a double quote (ad some my articles have this element in reference of inch dimension) the import goes wrong. Example:
http://musicland.altervista.org/violini/1) this csv file is KO (look at the first record of 2)
Immagine;Descrizione;Disponibile;fasciaprezzo
;Violino da studio ” kit 4/4 V11 Clement;cod.463-esaurito;fff1
;Violino da studio kit 3/4 V11 Clement;cod.464-disponibile;fff12) this is OK http://musicland.altervista.org/violini2/
Immagine;Descrizione;Disponibile;fasciaprezzo
;Violino da studio kit 4/4 V11 Clement;cod.463-esaurito;fff1
;Violino da studio kit 3/4 V11 Clement;cod.464-disponibile;fff1the only difference is the presence of this double quote: —-da studio” kit—- in a record inside the violini.csv file -table 10-.
but is enought to introduce another ” ad all goes well (pair ok – no pair ko).
for instance —-da studio “” kit—- or —-da studio ” kit” —-
example http://musicland.altervista.org/violini3/this are the option plugin for all tables:
.tablepress-id-5 .column-1,
.tablepress-id-7 .column-1,
.tablepress-id-9 .column-1 {
width: 50px;
}.tablepress-id-5 .column-2,
.tablepress-id-7 .column-2,
.tablepress-id-9 .column-2 {
width: 800px;
}.tablepress-id-5 .column-5,
.tablepress-id-7 .column-5,
.tablepress-id-9 .column-5 {
width: 300px;
}.tablepress-id-5 .column-6,
.tablepress-id-7 .column-6,
.tablepress-id-9 .column-6 {
width: 400px;
}.tablepress-id-5 .column-1,
.tablepress-id-7 .column-1,
.tablepress-id-10 .column-1,
.tablepress-id-10 .column-2,
.tablepress-id-10 .column-3,
.tablepress-id-14 .column-1,
.tablepress-id-14 .column-2,
.tablepress-id-14 .column-3,
.tablepress-id-15 .column-1,
.tablepress-id-15 .column-2,
.tablepress-id-15 .column-3,
.tablepress-id-9 .column-1 {
text-align: center;
}.tablepress-id-5 .column-3,
.tablepress-id-5 .column-8,.tablepress-id-10 .column-4,
.tablepress-id-14 .column-4,
.tablepress-id-15 .column-4,
.tablepress-id-58 .column-4 {
display: none;
}.tablepress-id-10 .column-1,
.tablepress-id-14 .column-1,
.tablepress-id-15 .column-1,
.tablepress-id-58 .column-1 {
width: 220px;
height: 220px;
}.tablepress-id-10,
.tablepress-id-14,
.tablepress-id-15,
.tablepress-id-58 {
width: 100% !important;
}.tablepress-id-10 .column-2,
.tablepress-id-14 .column-2,
.tablepress-id-15 .column-2,
.tablepress-id-58 .column-2 {
width: 220px;
height: 140px;
white-space: normal;
}
and the used tables are 10 (ko) 14(ok) 15(ok), and are all equals.
Thanks you very much.The page I need help with: [log in to see the link]
The topic ‘double quotes ” import csv problem’ is closed to new replies.