Skip to main content
July 29, 2021
Question

Reading the data from a uploaded file before submitting the form

  • July 29, 2021
  • 4 replies
  • 0 views

Hi Team,

We have a requirement to upload a file, read data from it and display the data on a button click in an interface.

We have tried this in a two-step method by orchestrating this in a process model:

1. Uploaded the file using "fileUploadField" component and submitted the form.

2. Reading data in script task and navigating back to the same interface.

But here the drawback is until unless the form has been submitted the file won't store on Appian KC so we can't read it. Also, the user has to perform two actions 1. upload the file and 2. click on the "Import data" submit button. Find the below image for reference.

 

Is there any way to implement this task with a single click?

Thanks in advance,

Mahesh

4 replies

selvakumark
Participating Frequently
July 29, 2021

Hi [mention:0a910ffbd81c455a8c64fb7afff12e0e:e9ed411860ed4f2ba0265705b8793d05],

As far as I know, it is not possible to process a document without submitting a form. As you said, only on form submit, the document gets stored in Appian.

nless the form has been submitted the file won't store on Appian KC so we can't read i
stewart.burchell
July 29, 2021

This is just the limitation of the way files are uploaded to Appian. You could re-think the User Experience. Have the form as you've designed it but re-name the 'Import Data' button to 'Review File Contents' which would then submit the form, load the file, and then use the loaded file in a second (chained) form to present the file contents for review.

csteward
July 29, 2021

Additionally here I'll typically chain the form back to itself when an Import type button is clicked, to the user it doesn't appear as the form has been submitted.  Otherwise as others have mentioned, you will not be able to process/read the document until the form is submitted.

July 30, 2021

Thank you for your inputs. Based on inputs, there is no way to implement this task without submitting the form so proceeding with the existing flow only.