Trading Networks 10.7 | Administering and Monitoring B2B Transactions | Managing File Transfers with ActiveTransfer | Administering ActiveTransfer with Command Central | Managing Actions | Task Configuration Definitions | Write File to Database Task Configuration
 
Write File to Database Task Configuration
You can configure the following properties for the Write file to database task:
Field
Description
Task name
Type a unique name for the task.
File filter
Type the name of the file if you want to filter files with specific names. By default, ActiveTransfer Server considers all files. If you want to use regular expression, specify a valid regular expression in File filter and select Use regular expression option.
Note:
You can use wildcard characters to filter the file names. For example, type *.zip to trigger the action only when ZIP files are uploaded or downloaded. To trigger an action based on a name string in the ZIP files, use the name string in the File filter box, preceded and followed by wildcard characters. For example, type *invoice*.zip to trigger the action based on the file URLs, when ZIP files containing the character string invoice in their file names are uploaded or downloaded. If you define a File filter for a task, the task acts only on files that are filtered out.
Few examples for regular expressions are:
*(.(?!purchaseorder))*: Excludes files with the file URL containing purchaseorder.
**/out/.*: Include files with the file URL containing the folder out.
*^abc(.*)123$: Includes anything that starts with abc and ends with 123. Matches abc123, abcxyz123, but not abcxyz123def.
*NEW-((*.doc)|(*_backup_*)): Includes anything starting with NEW- that either ends in .doc, or is followed by the string _backup_.
Service
Select the Integration Server package that contains the service you want to execute from the list.
Include file path
Select this option if you want ActiveTransfer to provide the path of the target file to the respective service. The file path information is passed to the service as input parameter filePath.
Include file content
Select this option to pass the contents of the file to the service and select the transmission method (As bytes or As stream). The file content is passed to the service as input parameters fileContent and fileBytes, or as fileContent and fileStream. Code your input parameter as fileContent + fileBytes or fileContent + fileStream.
Note:
You can ignore this option if your service does not require the file content as input (for example, if the service only writes the name of the files being uploaded, or the names of the users who uploaded them).
Execute error task
Select this option to execute an error task if the file operation fails. For more details, see Error Task Configuration.
The Write file to database task delivers the contents of a file to an Integration Server service for the purpose of writing the content to the database. ActiveTransfer Server provides the content in bytes or stream form to the service according to the format that the service’s input signature requires. This task does not modify the list of files from the previous task.