Export Bank Transactions Scheduled Process

Friday, 14 January 2022 by Alex McAndrew

The purpose of Exporting Bank Transactions is to generate a file which is then sent to a bank.

When run as a Scheduled Process, i.e., run from Web Services on a Web Server, the file system may not be the appropriate place for a file to be exported to. Therefore, the Export Bank Transactions Scheduled Process gives the User some flexibility on how this file is generated. Because of this, the parameters which can be configured differ somewhat from those in the existing Export Bank Transactions form.

This is supplemental Blog focusing on the Export Bank Transactions Scheduled Process. If you have not yet read the Scheduled Processes overview, we suggest you read it first to understand how Scheduled Processes work; see the Related Blogs section below.


Related Blogs


File Export

The first set of parameters for controlling file export can be found on the second page of the finPOWER Connect Cloud Process wizard.

Export File Immediately

This provides the ability to not generate a file. Consider the scenario where thousands of Bank Transactions need to be processed; configuring the Scheduled Process in this way allows the process to do the heavy-lifting and generate the export, and then leave the file generation for a user to do manually (by selecting the option of exporting an existing batch from the form). This allows the file to be generated in such a way where the file is easily accessible when required.

If generating the file, an option is provided to allow the generated file to be attached to the summary email. This means there is no requirement to access the file system.

The next set of parameters is on the third page:

Export Bank Transactions File Options

File Name

If generating a file, a number of different options are provided to offer the best solution for the user.

Direct File Export

If specified, the path must be accessible from Web Services and a static file name should not be used. It is recommended that tags are used (right click in the file name field to see these options) so that previous exports are not overwritten.

finPOWER Connect Cloud File Package

If only a file name is specified (i.e. no folder information is provided) then the file will be saved as a finPOWER Connect Cloud File Package. This allows the export to be downloaded at will by a user from finPOWER Connect Cloud. Some additional configuration is required for this type of export; see the section below for more information.

Use Service Settings

Use the Copy from Service button to copy the resolved file name from the Export Service. If the button is disabled, the Export Service does not have a default file name configured. This is the equivalent of a direct file export, but note that the file location must be accessible by the Web Server to successfully generate the file.

The tooltip on the Enter the File Name to Export heading in the wizard also includes this information for quick reference.

finPOWER Connect Cloud File Package Downloads

File Packages are saved internally within finPOWER Connect Cloud and do not require a access to the file system. Files are instead stored on the Web Server, and downloaded from finPOWER Connect Cloud directly. These are commonly used in finPOWER Connect Cloud when downloading generated reports, and now when exporting Bank Transactions via the Scheduled Process.

Downloads are filtered by user (i.e., not all downloads are available to everyone) and can be found on the "Downloads" page of the Processes & Procedures page (providing this page has been enabled).

Which users receive the Bank Export file is controlled by the "Export File Sharing" section (refer to the above screenshot). Note that this section of the wizard is only applicable if exporting as a File Package.

By default, the Bank Transaction Export File Package will be saved to the Web Services user. This should be a system user which does not have access to the User Interface. Use the Export File Sharing settings to copy to additional users. There is an option to delete the file from the Web Services User once successfully copied to the specified user(s).

The tooltip on the Export File Sharing heading in the wizard also includes this information for quick reference.