Difference between revisions of "Scheduled Report Export"

From SmartWiki
Jump to: navigation, search
Line 1: Line 1:
 
=Overview=
 
=Overview=
In case a record set of a report needs to be stamped on a regular basis, feature it is possible with the '''Scheduled Export''' to save the exported file to a SmartFolder, or transfer it via SSH File Transfer Protocol (SFTP) to another server.
+
In case a record set of a report needs to be stamped on a regular basis, feature it is possible with the '''Scheduled Export''' to save the exported file to a SmartFolder [[SmartFolders_Overview|SmartFolder]], or transfer it via SSH File Transfer Protocol (SFTP) to another server.
 
=Configuration=
 
=Configuration=
On the Edit Report page, go to the File Export tab.
+
On the Edit Report page, go to the File Export tab.<br>
In the Scheduled Export the following needs to be set
+
In the Scheduled Export the following needs to be set:
  
 
==Export to SmartFolder==
 
==Export to SmartFolder==
Line 34: Line 34:
 
* '''Time of Export''' - The file export will happen at this hour and minute.
 
* '''Time of Export''' - The file export will happen at this hour and minute.
 
* '''Last Exported''' - Indicates when this report export ran last.
 
* '''Last Exported''' - Indicates when this report export ran last.
 +
 +
 +
[[Category:Reports]]

Revision as of 07:05, 28 May 2018

Overview

In case a record set of a report needs to be stamped on a regular basis, feature it is possible with the Scheduled Export to save the exported file to a SmartFolder SmartFolder, or transfer it via SSH File Transfer Protocol (SFTP) to another server.

Configuration

On the Edit Report page, go to the File Export tab.
In the Scheduled Export the following needs to be set:

Export to SmartFolder

  • Frequency - How often should the report be exported.
Options:
  • Disabled
  • Daily
  • Weekly
  • Monthly
  • Export to - Select SmartFolder in order to save the file there.
  • SmartFolder - Look up the SmartFolder, where you would like the files to be saved.
  • Start Date - The file export will start from this date.
  • Time of Export - The file export will happen at this hour and minute.
  • Last Exported - Indicates when this report export ran last.

Export via SFTP

  • Frequency - How often should the report be exported.
Options:
  • Disabled
  • Daily
  • Weekly
  • Monthly
  • Export to - Select SFTP in order to transfer the file to another server.
  • URL - Enter the URL of the remote server.
  • Username - Used for authentication on the remote server.
  • Password - Used for authentication on the remote server.
  • Path - Default path on the remote server to transfer the file to.
  • Start Date - The file export will start from this date.
  • Time of Export - The file export will happen at this hour and minute.
  • Last Exported - Indicates when this report export ran last.