Fetching a CSV file from a remote server using SSH

To fetch a remote file from another FTP server to a local location on your webserver you can use the following command in terminal. Additionally you can add this to your bash script to fetch daily via a cron script.

wget --user=ftpusername --password='ftppassword' --output-document='/home/website/public_html/fetched_file.csv' ftp://remotehost.com/to_be_fetched_file.csv

Replace ftpuser and ftppassword with your actual username andnpassword. document should be set to the local path and filename where the file is stored.

remotehost.com should be replaced with the FTP hostname.