Good morning,
I want to ask if it is possilbe, using the smart service Export Data Store Entity to Excel, take the datas I want to export to a Excel, from the process and not from Data Store, ie, I will generate the datas in the process, and I dont have it in data base.
Thank you so much.
Regards, Teresa.
Discussion posts and replies are publicly visible
Export data store entity to excel requires Data Store Entity value as a mandatory field. So, this smart service can't be used to generate excel for your use case. You can use Export Process Report to Excel smart service instead.
Thank you for answered.
I saw the smart service:
But I dont know where I have to put my process variable to export to excel, do you know it?
We can't enter process variables directly, but you need to create a process report first with the data you want to export. Visit this to know how to create a process report.
Then just add the process report created, filters needed, report context (Here the process model for which report is created) as well as other input details for the smart service. For more information you can refer Export Process Report to Excel Smart Service documentation.
I believe Appian's current recommended approach is to use Export DSE to Excel anyway. It is possible (despite what the previous commentor said), but requires a bit of a workaround: you would want to create a special database table just to hold this data, and write it there, and then call that table in the Export DSE to Excel smart service. I would suggest making one of the columns "process ID", which you could then use in the query, as I believe process ID will always be unique.
Frankly this use case would be better suited by Export CDT to Excel, which used to be found in the Excel Tools plug-in (until shortly after version 2.0.0), but it's been deprecated for a while now for reasons that were never fully explained.
Hello,
I am trying you said, but I dont know if I could do it.
The data I need it is a list, and each element have 49 variables, but in the node "Execute Process Report" I saw that:
Do you know if I can change the type of my variable? Because I want to pass that data to the "Export Process Report to Excel" beacuse that data is which I want to export to excel.
Thank you so much for your help.
Hello Mike,
I am trying the option Harsha said, but I am having some troubles, maybe I will try your option too, sounds interesting.
Hi MIke , is there a way where in we click on an button and get the excel generated and downloaded in one click? right now on button click we trigger a PM and that PM generates the doc and places in KC gets back a doc id. And then user has to click on another button to download the doc.
please suggest if there is an another way to do it.
ganeshbabuj said:is there a way where in we click on an button and get the excel generated and downloaded in one click?
No. The process is logically 2 steps requiring 2 completely separate types of links, and therefore is not possible to combine in this way.