Dictionary to Excel/CSV

Question

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 DSE 2nd 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.

Mathieu Drouin · Answer

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.

antoniol0008 · Answer

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"

fredlcl · Answer

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.