How to save attachments from the WEBCON BPS form to a hard drive or network share.
This post was inspired by an article found on the web “Export Documents saved as Blob / Binary from SQL Server“. The article shows how to use the T-SQL language to save a file stored in the database on the hard disk. Let’s use this knowledge in our WEBCON BPS environment.
First of all, to enable file export you must enable the “Ole Automation Procedures” option. To do this, run the script below. Note – the option is disabled by default for security reasons. Make sure its inclusion can be done in your company.
Below there is a T-SQL script that allows you to export attachments with a specific ID from the WEBCON database. NOTE: In my example, the attachment database is in the WEBCON BPS content database. In your case, attachments may be in the attachment database or another dedicated attachment database. Verify where your files are stored before creating a routine.
NOTE: Remember that the implementation of unauthorized changes on the WEBCON database may result in the loss of the warranty!
You need to add 2 actions to the transition path:
The queries executed from WEBCON platform are run executed as IIS Application Pool account. In the procedure above, there are used procedures that are executed on the master database. It is therefore necessary to grant the account permissions to run them on dat database. Below is a script to grant the appropriate permissions. For me it is “ALTERPATHS\SP_WEB” account. In case you do not know which account to enter, see this article for information how to check which account is configured as an IIS application pool account.
WEBCON BPS local groups management using simple process. Adding and removal of multiple group users…
The article describes how to use the FOR EACH ROW form rule in practice on…
A video tutorial on how to set up a WEBON BPS home laboratory from scratch…
How to use the OPENJSON tabular function to handle a data import to WEBCON BPS…
How to configure and use REST Web Service connections using WEBCON BPS Authentication. Examples of…
How to upgrade standalone version of WEBCON BPS 2020 to 2021. The article describes the…