Changes

Jump to: navigation, search

Scheduled Report Export

1,170 bytes added, 20:57, 19 February 2020
Configuration - Essentials
: Note that the file extension should not be included in this section i.e. '''PaymentDetails_[YYYY]-[MM]_[DD] '''  and NOT "PaymentDetails_[YYYY]-[MM]_[DD].csv"  The extension of the file should be specified in the a.) ''Export Format'' dropdown in the [[Exporting_Reports|'''File Export''']] tab  for standard File Export or b.) ''File Extension'' textbox in the [[Custom_Export|'''Custom Export''']] tab for custom export reports.
<span style="color: #ff0000;">Available Settings below are available after the March 2020 upgrade.</span>
* '''Export toFolder''' - the file can be exported to ** '''Folder Type''' - select a folder type where the file will be exported to.*** '''Configuration Folder'''*** '''SmartFolder'''** '''Folder''' - - select the subfolder where you want would like the file to be saved.* '''Export to sftp'''** '''Integration Key''' - select an existing integration key from the [[Integration Key Management]] from the dropdown list or click the "+" icon to create a new integration key.** '''Path''' - sftp folder location where the files will be pushed i.e. /in or /out or /Payments/inbound* '''Process On Every Record After Export'''** '''Update Status''' - updates the status of every record in the report to the selected status from the drop down list. Note that a status change will trigger any workflows associated with the status being changed to. workflows will be triggered with this change of the status** '''Trigger Workflow''' - workflow selected will be triggered to all records after export .Note that '''Update Status''' will be processed first before '''Trigger Workflow''' is triggered.** '''Send Email Notification On Completion''' - ability to email a list of users and or roles that will be emailed the exported file as an attachment.<!--94110 - Report Export - Scheduled Email Subscriptions-->*** '''Email Template''' - select an email template for the emails sent to selected users*** '''Roles''' - send emails to users based on their roles*** '''Select Users''' - select users tosend the email to*** '''Attach Exported File in Email''' - option to attach the exported file on to the email sent out. Applicable only when the file is exported to a SmartFolder or a Configuration Folder** '''Send Email Notification When Export Failed''' - select users to send notification to** '''Scheduled Export Status'''*** '''Last Scheduled Exported''' - time and date of the last scheduled export.*** '''Last Run''' - time and date of the last run.*** '''Ad-Hoc Run''' - time and date of the last Ad-Hoc run
: ''Options:'':* '''Configuration Folder''' - Select a Configuration Folder where you would like the file to be saved.:* '''SmartFolder''' - Select a [[SmartFolders_Overview|SmartFolder]] where you would like the file Example to be saved.:* '''sftp''':** '''URL''' - enter the url of the sftp site i.e. ''34.234.21.159'' or my.sftp.com or my.sftp.com:2222'''Update Status After Export''' - status of the records will changed to the selected status after export.:** '''Username''' - username to allow access to the sftp:** '''Password''' - password to allow access to the sftp:** '''Path''' - sftp folder location where the files will be pushed i.e. /in or /out or /Payments/inbound'''Trigger Workflow After Export''' - workflow selected will be triggered to all records after export.'''Last Exported''' - date of the last export .  '''Exampleconfigure schedule'''
* Export Every Monday of the week @ 0900
** Choose a future date that falls on a Monday for the '''Start Date''', '''Weekly''' for the '''Frequency''' and select the '''Time of Export''' dropdown list.
* Export Every 15th of the month** Choose '''15th''' (future date) for the '''Start Date''' and '''Monthly''' for the '''Frequency''' and select the '''Time of Export''' dropdown list.** Export Every 15th of the month
=History Log=
Smartstaff
1,385
edits

Navigation menu