Publish data to a FTP server
  • Updated on 09 Apr 2020
  • 3 minutes to read
  • Contributors
  • Print
  • Share
  • Dark
    Light

Publish data to a FTP server

  • Print
  • Share
  • Dark
    Light

You can publish the data gathered to a server using FTP (File Transfer Protocol).

  1. Open the agent or collection in the Web Console.
  2. Click .
  3. Select Publishing.
  4. Click FTP and fill out the information.
  • The address of the FTP server. This is an IP address or subdomain (e.g. ftp.yourcompany.com).
  1. Click enter additional FTP settings.

  2. Click OK.

  3. Click SAVE.

Note

If the FTP server has a firewall, whitelist the following IP address range so can Mozenda can publish to it:
69.174.254.193 – 69.174.254.254, 64.19.202.254

FTP Publishing Settings

Computer address

The location of the FTP site. This can either be an IP address or a URL. An example would be customerdata.mozenda.com. Make sure to include the full path or IP address.

Setting Description
Folder The folder where you want to store the data. (This usually starts with a forward slash /).
Username Used to log in and connect to the FTP site.
Password Used to log in and connect to the FTP site.
Port The port that the system uses to connect to the FTP site. (The default is port 21.)
Use passive transfer mode Dependent on the FTP server’s configuration.
Use a secure connection Dependent on the FTP server’s configuration.
Test FTP Settings Check that the system can successfully connect and has the permissions to add new files.

Generic Publish Settings

What to include in the file

This setting allows the user to choose a view as the publishing view of the data. The default will be the default view.

File format

Choose whether the published file should be in CSV, TSV, JSON, or XML format.

Filename

This allows the user to specify the name of the file that will be sent via FTP. If it is left blank then the name of the file will be set as the Collection name and the view name in the format %Collection Name%-%View Name%

If the file exists when the system publishes the file, the existing file will be overwritten.

Format Effect
%DateTime% This will insert a date time value in the format of YYYY-MM-DD-HHMMSS.
%Date% This will insert a date value in the format of YYYY-MM-DD.
%YYYY% This will insert the current year in the format of YYYY.
%MM% This will insert the current month in the format MM.
%DD% This will insert the current day of the month in the file name.
%CollectionName% This will insert the name of the collection.
%CollectionID% This will insert the ID of the collection.
%AgentID% This will insert the ID of the agent (when applicable).
%ViewName% This will insert the name of the view.
%ViewID% This will insert the ID of the view.

An example of a file name that would use the Datetime variable is CNN-%Date%. If this were published in CSV format and the date when the file was created was 2019-01-18 then the file’s name would be CNN-2019-01-18.csv.

Include field names in the first row

This setting will place the field names of the data in the first line of the file.

When to publish the file

This setting provides two options: Either the file will be published every time the agent finishes, or the user can specify a certain schedule when the data will be published. (This publishing schedule is completely independent of when an agent runs.)

Was this article helpful?