• Resolved musiclandplay

    (@musiclandplay)


    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;fff1

    2) 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;fff1

    the 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]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The reason for this is that the quotation mark " has a special meaning in CSV files. It’s the escaping character.
    To use it as a normal character, you will always have to duplicate it, like "".

    The best way for that is to use search/replace in a text editor with your CSV file.

    Regards,
    Tobias

    Thread Starter musiclandplay

    (@musiclandplay)

    OK Thanks.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    sure, no problem!

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘double quotes ” import csv problem’ is closed to new replies.