File Upload from UI

Hello Deepak,

1.) i am pretty happy with  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

https://docs.appian.com/suite/help/20.3/File_Upload_Component.html

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

• upload the file via upload field
• save the connected documentId into a local or ri
• you can save this received document id in a cdt as integer and store it into a db.
• load the document id via query entity from DB
• make it available for download via doucmentDownload link (icon,image or link)

does this help?

i postet a long comment but somebody marked it as spam -> ?

you can

• upload the file via upload field
• save the connected documentId into a local or ri
• you can save this received document id in a cdt as integer and store it into a db.
• load the document id via query entity from DB
• make it available for download via doucmentDownload link (icon,image or link)

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.

Hi Richard,

I was looking to test a simple upload via interface. When i have created an interface adding a file upload component and then trying to load a file - its temporary generating a temp variable with the document Id. So the file which is uploaded, where exactly the file goes can i store it locally in a folder(sub folder of the project) and store the id in the DB. 

Is it possible for you to put out all the steps in detail here starting from interface creation and local folder creation and with an example. IT would be really great if this can happen. I am strucked with this from last two to three days.

Regards,

Soumya

soumyan0001 said:

When i have created an interface adding a file upload component and then trying to load a file - its temporary generating a temp variable with the document Id. So the file which is uploaded, where exactly the file goes can i store it locally in a folder(sub folder of the project) and store the id in the DB. 

1.) to get the file available in a appian folder, you need to submit the form.
the function " a!fileUploadField()"  has a parameter available called "target fodler". There you can define the location of your document after submitting

for that, your traget folder has to be created as part of your application and the folder needs the type of "document folder".
one idea:
After submitting the Id of the document can easily stored into the DB. create a cdt with "documentId" (integer) attirbute and save the document Id there. 
if you save your uploaded document into a rule input you can save the uploaded documents into the cdt.dcoumentId directly or create a rule input which will contain automatically your wanted documentIds and update your cdt.documentId via script task output.

check

 https://docs.appian.com/suite/help/20.3/File_Upload_Component.html

https://docs.appian.com/suite/help/20.4/folder-and-document-management.html

2.)

soumyan0001 said:

Is it possible for you to put out all the steps in detail here starting from interface creation and local folder creation and with an example. IT would be really great if this can happen. I am strucked with this from last two to three days.

i can do that aflater, per personal massage. it is waay to detailed for that topic here and in general ;) 
Try it at first with the provided links above :)