CSV Import

  • Resolved gpinkflamingo

    (@gpinkflamingo)


    6 years, 5 months ago

    Hi! I’m trying to import a new listing from CSV file.

    When I upload the CSV the message here below appears:

    “Line 2 has too many columns

    Line 3 has too many columns

    Line 4 has too many columns”

    Import type is well selected “new listing”.

    The fields in the file are the same as the one I got when I exported my current listing: post_id title level_id directory_id status user description excerpt categories locations address_line_1 address_line_2 zip latitude longitude map_icon_file tags images videos expiration_date contact_email claimable phone website email

    Everything works fine when I just update the existing listing.

    Am I doing something wrong to import a new listing?

    Kind regards.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Shamalli

    (@mihail-chepovskiy)

    6 years, 5 months ago

    Hello,

    this means that you have wrong number of columns in your CSV file. Take a look at the demo CSV file we included into documentation folder.

    Thread Starter gpinkflamingo

    (@gpinkflamingo)

    6 years, 5 months ago

    Thanks for your answer.

    I found the demo CSV file on my FTP access.

    The fields are well separated by comas in the cell A1 (company_name,level_ID,contact_email,expiration_date,…)

    But I notice that the data is split into 5 different cells.
    A2 – Benton, John B Jr,1,[email protected],25.12.2018 12:15,USA > Lousiana
    B2 – Canada > Ottawa > Ottawa,”6649 N Blue Gum St, New Orleans
    C2 – 1210 Stittsville Main Street”,…

    Is 5 the number max of columns for the import?

    Because when I import the same file but with separated cells for each field as such:
    A2 – Benton, John B Jr
    B2 – 1
    C2 – [email protected]
    D2 – 25.12.2018 12:15
    E2 – …

    the error message “Line 2 has too many columns” appears again.

    Thread Starter gpinkflamingo

    (@gpinkflamingo)

    6 years, 5 months ago

    Actually, when I upload the demo CSV file without changing anything, the importation works fine.

    But if I change only 1 character of the data (“Benton” to “Alex”), the error “Line 2 has too many columns” appears.

    How can I solve that issue?

    Plugin Author Shamalli

    (@mihail-chepovskiy)

    6 years, 4 months ago

    This could be because you save the file in wrong format. MS Excel saves CSV in wrong way when you add/change columns. Try to save the file using Google Tables tool.

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

The topic ‘CSV Import’ is closed to new replies.

Tags