Hi there,
I need to export data to an excel file shown below. I know it's easy to use "Export Data Store Entity to Excel" smart service to export the material list at the bottom, but could anyone know how to combine the upper and bottom parts together to export to an excel file?
regards,
L
Discussion posts and replies are publicly visible
CDT to Excel found in the Excel Tools plug-in can do this (it's marked as deprecated but still works just fine AFAIK)
Appian would not recommend to use deprecated plugins, though it works fine. We had an issue in earlier working deprecated plugin. when it start failing it will be hard to get any support.
so use "Export DSE to Excel", you have to save the data into database table, then export, right? that's really inconvenient as I need to export data which comes from more than one table.
so if that's the case, I have create a new table contains all the data, and save the data into this new table, then export, right?
Abhay Dalsaniya said:Appian would not recommend to use deprecated plugins
Appian has never seen fit to provide a fully acceptable replacement for the CDT to Excel Smart Service - once they do that, they can get back to me (/half joking but half very serious). But on a more serious note, I agree, the deprecated smart services should be used with greater caution than others.
linp0001 said:I need to export data which comes from more than one table
The official Appian answer to this would likely be that you need to create a specialized View just for the use case of this export, since then you'd (presumably) be able to join data from as many different tables as you want to be included in the export. My qualms with the Export DSE to Excel Node are mostly other issues, fwiw.
Mike Schmitt said:Appian has never seen fit to provide a fully acceptable replacement for the CDT to Excel Smart Service - once they do that, they can get back to me (/half joking but half very serious). But on a more serious note, I agree, the deprecated smart services should be used with greater caution than others.
+1, also still a heavy user of the deprecated Export CDT to Excel service, as there are no other services that provide anywhere close to the level of functionality of this node. I have probably 50 of these in production today, and will be quite happy to upgrade them as soon as the functionality is available in a fully supported service.
If I were to remove them, I would have a team of unhappy executives who are quite used to receiving their cleanly formatted excel reports.
This is the single exception (currently) to my rule of "never use deprecated functionality".
Chris said:If I were to remove them, I would have a team of unhappy executives who are quite used to receiving their cleanly formatted excel reports.
I hope you have / will continue to appropriately bump my Feature Request thread linked above (and leave frustrated replies to all the Appian engineering folks who weigh in with their "but why do you actually NEED that?!?" replies...)
Mike Schmitt said:I hope you have / will continue to appropriately bump my Feature Request thread linked above (and leave frustrated replies to all the Appian engineering folks who weigh in with their "but why do you actually NEED that?!?" replies...)
;)