Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
23 replies
Subscribers
9 subscribers
Views
11541 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
download excel report from temporary community document folder to local drive
sudhirp712
over 8 years ago
Hi ,
We have created a process model which will extract the report from querydatabase and export it to excel and save it under temporary document folder in community section.
We need to add this to report tab in tempo page as XYZ Report. Users needs to click on XYZ Report and the excel generated report could be downloadable and save this to local drive.
Could anyone help us and let us know how to do it.
Attached the process model.
OriginalPostID-255357
Discussion posts and replies are publicly visible
0
georgej
over 8 years ago
If you look at third screen shot pv!exportdata ; fieldlabels,fieldNames,fileName all are empty. Make sure the entire ac!exportData is saved to pv!exportData,it will start working
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sudhirp712
over 8 years ago
Thanks george. I have followed up the same process but still I am getting 500 error when I click on the download link. In the background the process run successfully and process variable values are showing correctly. Please note the attached screenshots.
This is what I am getting in the application.log
"2017-01-10 04:45:52,529 [http-/0.0.0.0:8080-8] ERROR com.appiancorp.ps.exceltools.util.ExcelHelperUtils - There is a fieldname mismatch between field(s) in the expression and those in the datasubset on - WorkFlowName
2017-01-10 04:45:52,530 [http-/0.0.0.0:8080-8] ERROR com.appiancorp.ps.exceltools.servlet.ExportDataSubsetToExcelFromProcessServlet - There is a fieldname mismatch between those specified in the expression, and those in the datasubset.
java.lang.IllegalStateException: There is a fieldname mismatch between those specified in the expression, and those in the datasubset.
at com.appiancorp.ps.exceltools.util.ExcelHelperUtils.convertDataToExcel(ExcelHelperUtils.java:141)
at com.appiancorp.ps.exceltools.util.ExcelHelperUtils.convertDataToExcel(ExcelHelperUtils.java:93)
at com.appiancorp.ps.exceltools.servlet.ExportDataSubsetToExcelFromProcessServlet.doGet(ExportDataSubsetToExcelFromProcessServlet.java:99)"
Download option is also not coming getting 500 errror.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
georgej
over 8 years ago
You are almost there , the fix is simple. If you look at your "fieldNames" and data returned by your query rule ,the names doesn't match. For example WORKFLOWNAME, this "workFlowName" in data and "WorkFlowName" in fieldNames. These names should match ,of course you can have what ever descriptive names you wish in "fieldLabels". But "fieldNames" should have the exact name of the field in data
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<