HomeGeneral Q & A

Upload files in database Messages in this topic - RSS add reply

jbalta
jbalta
Posts: 13


8/25/2021
jbalta
jbalta
Posts: 13
Hi,
I need to build a decision integration with a form where users have the option to upload data files.
I want to upload these files in the database and not SFTP/FTP as is presented in documentation.

Files are not supposed to be big in file’s size, size is not a problem.
Perhaps I should not mention this, users must be able to download these files when they are assigned with a task on the form.

Database that in use by Decision application is MSSQL.
Please let me know if is possible to do this?

Thanks
0 link reply with quote
ethan.price@decisions.com
ethan.price@decisions.com
Administrator
Posts: 25


8/26/2021
ethan.price@decisions.com
ethan.price@decisions.com
Administrator
Posts: 25
Hey!

Yes, this is completely possible! I attached a link to our documentation that details making use of the File Upload/Download form components.

https://documentation.decisions.com/docs/using-the-multiple-file-upload-and-download-components

You can have a database structure built that stores user input in a form, and also store any files that were uploaded as well.

I hope this helps!
0 link reply with quote
jbalta
jbalta
Posts: 13


8/31/2021
jbalta
jbalta
Posts: 13
Hi Ethan,

I have a database structure built to stores the user input in the form but is not clear for me what "Type" to use for the field in charge to store the files in the database structure? in example that you posted “Name" and "Email Address" will be stored in the database structure as "String" fields but for files what type are you going to use?
For MSSQL server we are supposed to use a blob type for the field in charge to store files, but this type is not available in decision’s GUI when we want to create a data structure.

Thanks
John
0 link reply with quote
kshitij@decisions.com
kshitij@decisions.com
Administrator
Posts: 171


9/1/2021
kshitij@decisions.com
kshitij@decisions.com
Administrator
Posts: 171
Hi John,

You can use File Data or File Reference type on the data structure for storing files.

The major difference is with File Data, the files are kept in memory whereas for File References, the Files get stored on the file system and retrieved by a reference id when the file is required. If you are expecting to work with a lot of files and/or large files, it is recommended to use File References.

You can more information on these types at https://documentation.decisions.com/docs/file-type-overview.
0 link reply with quote


(Ctrl+Enter)




Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software