sftp import settings

Closed

Import WP Pro Updated 1 year ago 3 Replies

ED
Edward asked 1 year ago on July 26, 2023 at 7:41 pm

Hi james,

I am trying to import another csv file from another supplier who use sftp but I am getting unable to login to ftp server. I spoke with them but got told we only supply the feed and don\’t  deal with importing the feed to my website.

They told me I must not let you see the full details so I have had to use generic words BUT the sftp is .host!  It annoys me they don\’t want me giving out the details but won\’t help me sort out the problem!

This is how I worked it out how it should go into the url box

sftp://e_and_s_computers:<6WjD7t2b2WT+Q%%P>@sftp.server.host/filename.csv 

They use port 2222 (That is real password)

Regards

Eddie

Jump to latest response Sign in to Reply
J

James replied Support Agent

1 year ago on July 26, 2023 at 7:55 pm

Hi Eddie,

just to confirm you have url encoded both the username and password (you can use an online tool e.g. https://www.urlencoder.org/) ?

For example

user: username
pass: password
host: ftp.server.host
port: 2222
protocol: sftp
path: filename.csv

so the connection string would be:

sftp://username:password@sftp.server.host:2222/filename.csv
J

James replied Support Agent

1 year ago on July 26, 2023 at 8:34 pm

Hi Edward,

Can you tried these ftp details in a ftp client to confirm they work? e.g. filezilla

James

J

James replied Support Agent

1 year ago on July 30, 2023 at 7:54 pm

sftp://e_and_s_computers:6WjD7t2b2WT+Q%%P@sftp.exertis.host:2222/out/Exertis_UK.csv

I would paste in the raw username, and password individually to the url encoder (if you paste in the whole url it will break, as all special characters would be converted e.g. /@: ) , which would turn it into ( i am presuming that the password in your url is the raw password:

sftp://e_and_s_computers:6WjD7t2b2WT%2BQ%25%25P@sftp.exertis.host:2222/out/Exertis_UK.csv