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
5 subscribers
Views
7182 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
We are using Export Report Data to Excel v2 (Export SQL and Report Data to EXCEL
rupakj
A Score Level 1
over 9 years ago
We are using Export Report Data to Excel v2 (Export SQL and Report Data to EXCEL - V2_3.0.6) to transfer portal report to excel. We are getting blank (no data) for Assignee Column in excel report. All other columns generating correctly. .Any help would be appreciated.
Regards,
Rupak Jha
OriginalPostID-156173
OriginalPostID-156173
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 9 years ago
forum.appian.com/.../e-154326
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Hi Sathya,
Thank you for the response. By converting the names to a string using "toString", it is populating the userid/groupid to excel report not User Name /Group Name. Our requirement is to show Names/ Group Name in the excel report. Kindly suggest.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Download the latest version. This has been fixed.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Hi Eduardo,
I have updated the the jar file to 3.0.11 from 3.0.6 but still getting blank (no data) for Assignee Column in excel report. Please find enclosed screen.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Hi Eduardo - Kindly suggest.
Regards,
Rupak Jha
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
1. I suggest you reproduce the issue and review the application-server.log to see if there's any error that might point out the root cause.
2. What's the name of the smart service you're using? Version 3.0.11 fixed this issue in the one called "Export to Excel"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Hi Eduardo - I have reproduced and check the log file. Error message - "2015-07-15 07:47:39,993 [ajp-/0.0.0.0:8009-3] ERROR com.appiancorp.servlet.custom.ExportReportDataToExcelServlet - cannot print this type: com.appiancorp.suiteapi.common.LocalObject".
2. Smart Service name - 'Export SQL and Report Data to EXCEv2L-3.0.11'
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Ah but it seems you're not using a model, but the servlet. Is that correct? How are you downloading/generating the file? It seems the servlet needs to be fixed too
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Please find enclosed.
RepairReport.txt
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Ok I confirmed you're using the servlet and not the smart service. It seems the servlet has a similar bug to the one that was fixed for the smart service.
The last person who updated the plug-in has been notified and he'll investigate and upload a fix if this turns out to be a bug in the plug-in
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>