fetch data from uploaded file.

Question

I have a excel file where there are too columns one is constant name and another is constant value . I need to upload a the file in an interface using file upload component and after clicking a submit button in the interface i need to fetch the data in the excel and update the constant values for respected constants . will anyone please guide me to achieve this scenario ?I have also given the snap of the excel sheet ,please find that below. 
 
 Thanks in advance !

bhargavip7872 · Answer

Hi bisheswar01 
 1) Provide a interface where user can update the excel file 
 2) Once user click on the submit button you can read the excel file using the plugin 
 readexcelsheet( excelDocument: cons!OBJECT_LIST_TEST, sheetNumber: 1, startRow: 1 ) 
 it return the ExcelSheetResultSet which contains the data in the excel sheet and success response. 
 3) You can use the ' Update Constant ' plugin to update the value of the constants. use the above result set and call this node as MNI for each value it should update the data. 
 Hope its clear. 
 Thanks, 
 Bhargavi P.

bhargavip7872 · Answer

Hi bisheswar01 This is Appian provided smart service you can check in process model , we need to provide two inputs for this constant one is name and the other is with what value we are going to update, please keep this node in a swim lane and the assignment of it should be run as who ever designed the model to avoid security issues.

Mike Schmitt · Answer

I don't know whether this will work - the Update Constant Smart Service requires a reference to the constant, I don't think you can use a Constant Name instead. 
 
 Edit: sorry I was wrong. The smart service also accepts the constant's ID (as in, its integer-based environment-specific object ID, similar to a Process Model ID). 
 Getting the Constant's ID isn't super easy though - you have to use "get constant or rule UUID by name", then the "get content object details by UUID" function and extract the "ID". The quick-and-dirty expression, which could go directly in the "constant" field of the Update Constant smart service, could look like this: extract( getcontentdetailsbyuuid( getconstantorruleuuidbyname("MY_CONSTANT_NAME")), "Id: ", ", Parent:") 
 You'd simply replace "MY_CONSTANT_NAME" with the actual constant name. You'd need to be sure the constant name actually exists, otherwise I expect the node would error. 
 (If anyone has an easier way to do this, i'd love to hear it.)

Mike Schmitt · Answer

in this screenshot the file has just been uploaded but is not yet Submitted into the system. you'd need to submit it (usually via submitting the form in a process task), and only then call "read excel sheet" on it. some of this was already explained in earlier replies.

Mike Schmitt · Answer

bisheswar01 said: what if I want the form as a process start form ? 
 Then you need to submit the form first before attempting to read the contents of the uploaded file. This is easy enough to do - just make it 2 separate forms; the upload on the start form, and the output on the subsequent User Input Task.

fetch data from uploaded file.

Top Replies