CSV Import redirection fails

#329397
  • Resolved Holm Hänsel

    2 years, 12 months ago

    Rank Math free

    Hi,

    i tried to import all my redirection for relaunch but rankmath denies my files all the time. i did it like in the video from you. It say one or more columns missing or #181 not found. can you have look in my file please?

    Cheers

    Holm

Viewing 10 replies - 1 through 10 (of 10 total)
  • Anas

    2 years, 12 months ago

    Rank Math business

    Hello,

    Thank you for contacting Rank Math, and sorry for any inconvenience caused.

    We are not able to access the CSV file.

    Please upload the file on https://wetransfer.com/ and share the link with us in the sensitive data section.

    Also, make sure that your CSV file matches columns like this image
    coulmn

    If they are non-existing redirects on your site, you should leave the id column values blank.

    Hope that helps.

    Looking forward to helping you.

    Holm Hänsel

    2 years, 12 months ago

    Rank Math free

    https://we.tl/t-wG7hEcqbyR

    here the file

    Jaideep Asrani

    2 years, 12 months ago

    Hello,

    The CSV you are using has incorrect entries in the columns:

    The destination column should have the complete URL and the source column should only have the part after your domain. Also please change the order to first source then destination column.

    Let us know how that goes. Looking forward to your update.

    Thanks.

    Holm

    2 years, 12 months ago

    Rank Math pro

    but when im inserting that in this scheme it works in the redirection form of rankmath. my new domain is till as subdomain an will switch to the main domain later.

    Holm

    2 years, 12 months ago

    Rank Math pro

    “Missing one or more required columns.” again i tried what you suggested.
    Im working on https://neue2.yogamachtstark.de but this will become later https://yogamachtstark.de. I need to redirect the urls before i go online again. So i was hoping i can do this just without the domain it the URLs

    Jeremy

    2 years, 12 months ago

    Hello,

    Another issue is that you must have edited it in a spreedsheet editor such as Excel and changed the format of CSV. Instead of comma (,) you are using a semi column (;) which will not work since CSV needs to be in comma hence the name “Comma Separated Value”.

    comma

    Hope that helps you with your situation. Looking forward to helping you on this one.

    Holm

    2 years, 12 months ago

    Rank Math pro

    Hi Jeremy, ok that is strange because i selected the comma separated export. But i just found that we in germany need to set the location to US to get comma seperated export out of excel. Can you maybe change the import in rankmath to more csv varities pls? It took me a real long way to get this right. At they and i inserted it by hand. Which is sad because i was happy about the mass import in rankmath.

    Jeremy

    2 years, 11 months ago

    Hello,

    I have fixed it for you. I also tested importing it in my local installation and it works.

    Please download the file from here: https://i.rankmath.com/J4medO

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

    Holm Hänsel

    2 years, 11 months ago

    Rank Math free

    Ok thanks a lot for this help, how did you edit it then. Just to know for the next time. Thanks a lot Jeremy.

    Jeremy

    2 years, 11 months ago

    Hello,

    I just opened the old CSV in an editor and replaced all semicolons with commas or you can refer to this guide: https://help.salesforce.com/s/articleView?id=000331030&type=1

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

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

You must be logged in to reply to this ticket.