Hi Alll,
1.I have a requirement where the user will be having an option to upload any number of files of any format from the UI, Pleaes let us know what would be best way to handle it?2.Is there any way to store Blob/Clob type ?3. Is there is size limit or Number of files limit for bulk upload? 4. If we store file in DB how to read and get files downloaded?
Thanks,
Deepak
Discussion posts and replies are publicly visible
Hello Deepak,
1.) i am pretty happy with a!fileUploadField()
a!fileUploadField()
https://docs.appian.com/suite/help/20.3/File_Upload_Component.html
2.) what is the technical requirement. Clob and Blob are not really supported. Clob is nothing else then a pretty large string. perhaps we find another solution for your requirement? CLOB and Blob are just oracle and DB2 supported.
-> for blob you can perhaps use this plugin:
https://community.appian.com/b/appmarket/posts/rdbms-blob-utility
3.) what are the targeted numbers? I uploaded around 90 mb of 58 files in the same time. no issue. appian is just loading one doc after the next until finished.
4.) How do you want to store the file in DB exactly?
Objective is to store an image and download it, I can store uploads in folder.
i had refered 20.3 documenation but that was not clear about how ri! variable is used to store documentId, i tried but getting docID stored in ri! or local! variable.
There is no training video on this to see practically upload and download.
i need to use appian DB to get image doc id stored into and use for download
Thank you for the addition. Some inputs, which might help.
1.)try to upload your document with
and save the documentIds in a local or ri variable.
You can create a new cdt or extend an existing one with "documentid" of type integer.
There you can save the documentid of the document you uploaded (you can even save arrays of integer here)
so you just store the reference in your DB.
to call it:user a a!queryEntity with the suitable filters -> the result is a datasubset.
you can adress the document id by the ."data" section of the datasubset and "documentId"
perhaps a todocument() around the "documentId" is necessary to get a clean type "document".
https://docs.appian.com/suite/help/20.3/fnc_conversion_todocument.html
https://docs.appian.com/suite/help/20.3/fnc_system_a_queryentity.html
then perhaps create a link or icon and use "a!documentDownloadLink() to download it.
the parameter "document" needs just the previous loaded "documentId".
https://docs.appian.com/suite/help/20.3/Document_Link_Component.html
Does this help your case?
i postet a long comment but somebody marked it as spam -> ?
you can
does this help?
yes, this helps
It would be awesome to get a confirmation as valid answer. if you have questions dont hestiate to ask if something stays unclear.
hint: perhaps you need some transformation with tointeger() before saving and/or todocument() after loading to have proper formats.