How To: Upload Reports to a Specific FTP Folder on a Regular Basis
Data Query is an Advanced User feature. |
It is possible to upload reports to a specific FTP folder on a regular basis.
- Open the
[ Reports ]
by clicking on the black and white printer icon in the menu button area. - Ensure that the SQL report exists or create a new report.
- Select the report to be uploaded.
- Click the button.
- Define the trigger as normal making sure that Send Immediately is ticked.
- Click on the FTP checkbox.
- Click on the button.
- Define the following settings:
- Host URL / IP Address for the FTP Server.
- Username
- Password
- Enter the Folder (or folder path on the FTP server) or leave blank if the files are to be uploaded to the root folder.
- Tick the Passive checkbox if the connection is to be passive else leave it unticked if not required.
- If the connection is to be FTPS then tick the SSL checkbox else leave unticked if not required.
- Click on OK to close the Supplier FTP.
- Click OK to close the Email Trigger dialog.