Linking FTP Server in DataSight

Linking FTP Server in DataSight

You can link DataSight with an FTP Server, which allows you to:

  • Import data files from the FTP Server.
  • Export your data to the FTP Server.
  • Generate and save Reports to the FTP Server.

 

FTP URL String

When entering a File Name and path, or Target location, the FTP URL string should be specified as follows:

ftp://<username>:<password>@<host>:<port>/<path>/<filename.extension> (e.g. ftp://TestUser:TestPassword@ftp.seveno.com:1234/ExampleFolder/TestData.csv).

Where:

  • <username> is the username of the user account being used to access the FTP Server (TestUser).
  • <password> is the password for the user account (TestPassword).
  • <host> is the server hosting the FTP service (ftp.seveno.com).
  • <port> is the TCP port used for accessing the FTP Server, and is only required to be specified if you are not using the standard port (TCP Port 21). If you are using the standard port, omit the preceding semicolon from the FTP URL string (1234).
  • <path> is the folder location being accessed (ExampleFolder).
  • <filename.extension> is the name of the file being accessed (TestData.csv).

 

 It is possible to specify a file name with a wildcard (*) attached, for example: ftp://TestUser:TestPassword@ftp.seveno.com/ExampleFolder/*.csv).

Note

Some FTP Servers may not allow the use of a wildcard, please check this with your FTP Service Provider if you require this.

When using the 'After Import: Move' option for Automated Import Tasks accessing an FTP Server, a copy of the imported file is created in the new location, and then the original file is deleted. This is different from locally accessed locations (e.g. C:\...), which moves the original file and does not create a copy.



    • Related Articles

    • Linking DSApp to DataSight

      This topic contains the default settings for the Saved Views and automated Tasks used to link DSApp to your DataSight database. When DSApp is provisioned for your DataSight database and upgrades are run specific to DSApp, the requisite DSApp files ...

    • Linking URL String in DataSight

      You can link DataSight to systems, either local or on the cloud, via a URL string in any File Dialog window within DataSight. This allows you to download human readable files for import, or upload data and reports to these systems. The types of ...

    • Linking Excel to DataSight

      DataSight has been designed to use Microsoft SQL as the fundamental database behind the application. This provides real benefits for DataSight users. The following procedure shows you how to link DataSight with Microsoft Excel. The same procedure can ...

    • Linking Web API in DataSight

      DataSight supports ingesting data from Web APIs. An API key is required to connect to the API Server in order to request the data. Currently DataSight supports requesting data (ie. a PULL operation) in an Automated Task, which requests data from the ...

    • Linking DataSight

      DataSight has been designed to ensure that data stored within DataSight can easily be shared or disseminated to other systems. Our design focuses on data management and pulling data in human readable format from instruments and other systems to ...