Hi good day,
I'm trying to create a download csv/excel file from a list of dictionary from my data.1st Step - Fetch Data from DSE2nd Step - Transform Fetched Data to Specific Dictionary (with Formula).3rd Step - Convert Transformed Data (Dictionary) to CSV/Excel Document.4th Step - Put Document in Document Download Link.Note: This is going to be perform in Interface.
Discussion posts and replies are publicly visible
Hello, The Converted transformed Data (Dictionary) can be saved intp a temporary table and then use that table data in Export SQL to Excel smart service plugin to generate the excel document. Once the file is generated delete the data added in the table.
Harshita's answer is probably the best approach. To further minimize load on Appian, you could also use stored procedures or regular SQL to transform the database within the database itself instead of loading the data in Appian.
Hi you can use Export Data Store Entity to Excel Smart Service or Export Data Store Entity to CSV Smart Service (https://docs.appian.com/suite/help/23.3/Export_To_Excel_Smart_Service.html) in the documentation link you can find an example of how you ca do this in the interface.
If you have your data in a grid in interface or in any other place you can do a button "Generate CSV" that call a start process. In this start process you call first a rule that create a csv string (in the first row all columns name, splitted by , or ; and in the following rows your data splitted with the same convention of first row), then call the Text Doc From Template Smart Service (https://docs.appian.com/suite/help/23.1/Text_Doc_From_Template_Smart_Service.html) and !important! provide as a template file an excel file! At the end of the process, in the interface you call the result, better the id of the generated document using fv!processInfo.pp.generatedDocId (in OnSuccess section of startProcess function you called in terface).
You can save this id in a local on your interface and show a link (show if this local is not null) "Download Csv"
Hi All this question is already answered (research and experiments). I've used Export CDT to Excel which is much more applicable for my target conversion.
Hi this could actually work but I forgot to mention in the question that I have a template in my data and I've used Export CDT to Excel and works perfectly fine for me.