• Resolved simon_a6

    (@simon_a6)


    Hi there.

    I am trying to use a CSV to import over 200 rows, but it fails.

    If I save a columned Excel as CSV, it says it has imported it, but it doesn’t show up.

    If I concatenate it so it is 123,456 proper CSV, it fails to import it at all.

    Can you please assist? Maybe send me a sample of the format please.

    Simon

Viewing 15 replies - 1 through 15 (of 24 total)
  • Plugin Author John Godley

    (@johnny5)

    The format is shown on the import page. It is also on the support site https://redirection.me/support/import-export-redirects/

    Thread Starter simon_a6

    (@simon_a6)

    Should the domain side of the URL be removed, or within it?
    I tried it in that format, with the full URLs but it failed to import.

    Plugin Author John Godley

    (@johnny5)

    It doesn’t make any difference. Most likely your file format is wrong.

    Thread Starter simon_a6

    (@simon_a6)

    Hence why I am stuck.

    Tried it as Excel and save as CSV. Saved as CSV Comma Separated. Concatenated the rows with a comma, and then as CSV Comma Sep.
    None are working.

    What else can I do?

    Plugin Author John Godley

    (@johnny5)

    Sure. However, most people who have problems importing CSV aren’t actually using a CSV file. Can you upload a sample somewhere?

    Thread Starter simon_a6

    (@simon_a6)

    https://we.tl/t-buwyVeAzyP

    Here you go. Just the domain and elements edited, but same format.

    Plugin Author John Godley

    (@johnny5)

    Yeah that’s not a valid format. You have two columns enclosed within quotes, making it a single column.

    Thread Starter simon_a6

    (@simon_a6)

    So each part of it, separated by the comma, has to be in quotes:

    “/test/”,”/test-2/”

    Like that?

    Plugin Author John Godley

    (@johnny5)

    It only needs quotes if there are commas inside the column, which seems unlikely as a URL. But yes.

    Thread Starter simon_a6

    (@simon_a6)

    Sorry John, I need the definite on this, as I have tried what I thought was everything. How SHOULD it be?

    Plugin Author John Godley

    (@johnny5)

    I answered above – yes in quotes per column. You don’t even need the quotes. Excel knows how to export CSV properly so I don’t know what you have done.

    Thread Starter simon_a6

    (@simon_a6)

    John…sorry but you said they need to be in quotes. So I did then. Then you said something else and now you say “you don’t even need the quotes”.

    Can you see why I am confused?

    Plugin Author John Godley

    (@johnny5)

    I didn’t say they need to be in quotes. I said your CSV is two columns enclosed in quotes, which is wrong. You asked if each column needs quotes, separated by a comma. I said yes, and also it’s not even necessary to put quotes (they are optional). I then repeated this in a different way.

    “/test/”,”/test-2/” is correct. /test/,/test-2/ is correct, "/test/,/test-2/" is not.

    This is also explained on the referenced support page, and the plugin has an example.

    Thread Starter simon_a6

    (@simon_a6)

    What I Sent you was like your /test/ ,/test-2/ format, which you said was wrong?

    Plugin Author John Godley

    (@johnny5)

    What you sent is:

    "https://dummy.com/portfolio-items/dummy/,https://dummy-com/product/dummy/"

    It is two columns enclosed in quotes, which is wrong.

    I’m not sure why the discussion is now fixated on this point. The correct format has been shown above.

Viewing 15 replies - 1 through 15 (of 24 total)

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