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
7199 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
Tom Ryan
Appian Employee
over 9 years ago
It looks like you are now getting the expected result. To format your output, you will need to use a rule to map the user and group names to string values (as discussed in your last post here
forum.appian.com/.../e-154326
). Since this is a portal report, you will need to do this inside the process and store the string result as a process variable. Then, include the process variable as column of type 'Normal Text' in the report.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Hi Tom - If I export the report in designer it is showing the Group Name as required but using plug-ins it is showing groupid not the Group Name. Please find enclosed screenshots in attached pdf file.
Report in Designer.pdf
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
That's the expected behavior. The plug-in exports the raw data. The raw data for a group is a group ID. The plug-in comes with the source code and can be enhanced by anyone to meet this requirement.
Since other people are already using this plug-in I wouldn't recommend updating the servlet one but creating a new one or adding a flag to say whether you want formatted names for objects (e.g. group names vs goupd ids) to avoid breaking any logic other people are using already to workaround the fact that the servlet returns the ID. This is just in case you decide to modify the servlet.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<