Data Import - File Location (FTP / SFTP)

Overview
Setting Data Import to select a file from either an FTP or SFTP location

What is FTP / SFTP

FTP stands for "File Transfer Protocol". It is an Internet service specially designed to establish a connection to a particular Internet server (or computer), so that users are able to transfer files (download) to their computer or to transfer (upload) their own files to the server (computer). The FTP protocol also includes commands that can be used to execute operations on a remote computer; e.g., to show folder contents, change directories, create folders or delete files

SFTP stands for "Secure File Transfer Protocol". The Secure File Transfer Protocol ensures that data is securely transferred using a private and safe data stream. It is the standard data transmission protocol for use with the SSH2 protocol. WISE-FTP implements a reliable and user-friendly version of the client side of this protocol.

The SFTP protocol's main purpose is to transfer data, but it is also used to obtain general access to the FTP server's file system. The SFTP protocol runs on a secure channel - no clear text passwords or file data are transferred

  FTP settings configuration

  • Method
    • This will be set to FTP as the selected method for File Location
  • Server
    • The address for the location of the FTP server, eg: ftp://myserver.com
  • Port
    • The FTP protocol is handled using ports 20 and 21 by default.
  • User name
    • The username that is required when logging into the the FTP server, this will be provided by the server administrator
  • Password
    • The password to be used in conjunction with the username, this will be provided by the server administrator
  • File path
    • The directory structure on the FTP server in which the required file is located. Leading and trailing '/' characters are not required. This box will be populated automatically if the search box for file selection is used
  • File name
    • The name (including file extension) of the import file
    • The search box (Magnifying glass) can be used to browse your FTP server and select the file
  • Use SSL
    • A toggle switch OFF/ON to set an encrypted connection between your web server and Linnworks allowing for private information to be transmitted
    • The default state is OFF
    • Your FTP server administrator will inform you if this is required
  • Passive
    • Linnworks will only accept servers with Passive FTP enabled
  • Encoding
    • Use the drop-down list to select the format that was used when the file was saved to the FTP server
      • Default
      • ASCII
      • UTF7
      • UTF32
      • Unicode
      • BigEndianUnicode
      • ANSI (Windows-1252)
  • File address
    • This is auto-populated based on the Account / File path / File name settings
  • After each download
    • Nothing - The original file in the FTP server will remain untouched by the Data Import
    • Delete the file - The original file in the FTP server will be automatically removed
    • Rename the file - The original file in the FTP server will be renamed using the format "FILENAME_DATETIME.csv" where FILENAME is the original file name and DATETIME is when the renaming took place
    • Move the file - Select a new location in the FTP server that the file will be moved to automatically after the import has completed
    • Move and rename the file - Select a new location in the FTP server that the file will be moved to automatically after the import has completed. The file will also be renamed as detailed above

  SFTP settings configuration

The SFTP settings are mostly the same as the FTP settings detailed above, this section of the guide will only cover the modified / additional fields required by SFTP

  • Server
    • The address for the location of the SFTP server, eg: sftp://myserver.com
  • Port
    • The FTP protocol is handled using port 22 by default
  • Compression
    • A toggle switch OFF/ON to enable file compression. With this option enabled, data sent to from Linnworks is compressed before sending, and decompressed when received by the server. This can help to speed up file transfers, especially with low-bandwidth connections
    • The default state is OFF