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
Discussion posts and replies are publicly visible
Someone Please guide me how i can create duplicate copy of formatted excel Template?
Thinking to generate a duplicate/copy of existing template and passing that document to update the details in new doc?
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.
hi Mike Schmitt
This is very helpful and thanks for the same. Is it considered 'okay' to use deprecated plugins ? Do you know if Appian is working on fixing this perhaps ?