Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+2
person also asked this
people also asked this
Replies
7 replies
Answers
1 answer
Subscribers
5 subscribers
Views
7545 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Im using the "Download DataSubset (Cloud)" plugin to generate an excel
benjamins
over 9 years ago
Im using the "Download DataSubset (Cloud)" plugin to generate an excel spreadsheet that we use to import into another application. The template that is required to import into this third party application is to have a custom first line that just has plain text in line 1, column 1.
I then need the column headings on row 2 and the results starting from line 3.
Is this possible with this plugin or should I use something else?
OriginalPostID-183794
OriginalPostID-183794
Discussion posts and replies are publicly visible
0
Rahul Gundu
over 9 years ago
I don't think there is a way to customize the excel by using download data subset plug-in.There is another plug-in in shared components called "Export to Excel", using this we can insert the data into specific cells in excel.
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
hemalathat
A Score Level 1
over 9 years ago
Hi Benny,
You can also achieve this using 'Export SQL and Report Data to EXCEL - V2' plugin. In that plugin, use 'Export CDT To Excel' smart service.
Reference link:
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@benjamins Is this possible with this plugin? - As said by others, it is unable to customise the plugin as of now in terms of how it works.
Should I use something else? - There isn't any alternate to 'Download DataSubset (Cloud)' plugin in terms of equivalent functionality, that is, there isn't any plugin which will trigger a process and makes the report available for download immediately on the sail interface in a report object.
And if you are in a plan to opt for the plugins suggested by other users above, you need to change the current implementation. To me it seems like, you have been using the plugin in a Tempo Report or Task Report object. So if you would like to use the plugins similar to as suggested above, you need to design a process which may accept some inputs, generate the required excel sheet and thereby send it to the user via email(as the process designed by us lacks the ability to make the report available on the interface upon the completion of process). On the whole this approach lacks the OOTB flexibility of making the generated excel sheet available on the interface, with which you may need to discuss with the Business.
I would like to suggest to stick to "Download DataSubset (Cloud)" plugin until and unless there is a good reason to move away from it, for instance exporting huge datasets.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Stefan Helzle
A Score Level 3
over 9 years ago
There is a possible solution. We used the "Start Process Writer" plugin to start a process from a SAIL form in background. The form shows a waiting message and a reload button (Non-Submit). The reload button checks whether the process created the document using a process report. As the document is ready, the form shows a download link. This way you can create any document.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
benjamins837
over 9 years ago
Thanks everyone for your comments. We are looking into the Start Process Writer plugin @stefanh791.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
pallavim
over 7 years ago
in reply to
benjamins837
Stefan Helzle
Could you please share any pointer to Start Process Write plugin?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
+2
Carlos Santander
A Score Level 2
over 7 years ago
in reply to
pallavim
The plugin is no longer necessary. Check out
docs.appian.com/.../Starting_Processes_From_an_Interface.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel