Overwriting Formatted Excel Temp While Generating Excel by Export Data from Data store entities smart service.

Question

Hi Appian Community, 
 
 I am using Export Data Store Entity to Excel Smart Service to export DSE data in excel format using formatted template , 
 Issue is it is overwriting the template, and suppose two user requested to generate excel, so excel doc generated has overwritten the previous users data. 
 This issue would be fixed in case this smart service generate new doc every time using formatted template . 
 is there any way we can fix this issue?, 
 
 Please help what to do in this scenario. 
 
 Thanks in Advance. 
 Shree Krishna Tiwari

Mike Schmitt · Answer

Unfortunately that's how the Export Excel to DSE smart service works . 
 To clarify on one bit: it does NOT "overwrite a template" because it does not accept a "template" . What you're doing is having it update an existing document (the closest you can get with this node), and as you've found, it completely overwrites all formatting etc. 
 If you need to use a base template (which is something I always require for customer-facing exports also), the best you're going to be able to get is to use the Excel Tools plug-in and use the (deprecated, but still working) "CDT to Excel" node.

Overwriting Formatted Excel Temp While Generating Excel by Export Data from Data store entities smart service.

Top Replies