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 !
Discussion posts and replies are publicly visible
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.
can you please explain or give me a summary of using update constant plug in ? Or any link to understand that
https://docs.appian.com/suite/help/24.2/Update_Constant_Smart_Service.html
It's an smart service that you can use in your PM for updating constant values..
Do it as bhargavip7872 explain in his message...
When updating the constant value, take care of permissions
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.
there is another question also . Is there any plugin or smart services in appian for creating constant ?
I searched in process model but did not get that .
If there is any can you please give me a reference to read more about that ?
I don't think so, you can update or increment the constant.
what the scenario is , I will check for a constant if it is there in my application or not . If there is no constant then create a new one .
how to achieve this ?
Yeah, I can understand that and I don't think so that any smart service is there to create constant.
It is saying an error , Can you please guide me where i am missing anything ?
That's because you are trying to read a document which is not yet stored in Appian ,Initially it's gonna get stored in Temporary folder . Have a look into my reply where i explained how to read a document in the same interface.
venkat Avuluri said:where you gonna upload a File , use SubmitUploadedFiles
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.
what if I want the form as a process start form ?
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.