Skip to Content (Press Enter)
2020-12-15 20-51-49
Josep Chaqués Ojeda
956Views
11Comments
Solved
Export aggregate (data) in CSV or TXT
Question
File
Import/Export Data


Hello,

I would like to download, with a button, the information of the aggregate, in .csv or .txt format, is it possible? with the following separation ";" to import it into another tool.


Can you give me a screenshot of how the Screen Action would look?

Thanks.


Regards

0
0
05 May 2020
Copy Link
2022-02-25 19-42-59
Srinivas K Singadi
Solution

Hello Josep Chaqués Ojeda

yes it's possible, I am attaching the screenshots, please take a look 



For converting Record list to CSV file you can use this component:https://www.outsystems.com/forge/component-overview/636/csvutil , even I used the same in the above example I showed you, 


I hope this helps you,


cheers

Srinivas

2
0
05 May 2020
Copy Link
2020-12-15 20-51-49
Josep Chaqués Ojeda

Srinivas Singadi wrote:

Hello Josep Chaqués Ojeda

yes it's possible, I am attaching the screenshots, please take a look 



For converting Record list to CSV file you can use this component:https://www.outsystems.com/forge/component-overview/636/csvutil , even I used the same in the above example I showed you, 


I hope this helps you,


cheers

Srinivas

Perfect! but I have a question, in the Download Widget, What could I add in "File content"? Attachment screenshot

Thanks!

Regards,

Josep

Captura.JPG
0
0
06 May 2020
Copy Link
2022-02-25 19-42-59
Srinivas K Singadi

Hello Josep Chaqués Ojeda

In download file content you need to add the output of the ExportRecordlist



1
0
06 May 2020
Copy Link
2022-02-25 19-42-59
Srinivas K Singadi

For Example in the above example its like this :

SyntaxEditor Code Snippet

TextToBinaryData(ExportRecordList2CSV.Csv,Encoding:)

and also here I am attaching the screenshot here,

I think you got a solution for your problem if  you got the solution then plz mark the solution so others will will also get to known

cheers

Srinivas


2
0
06 May 2020
Copy Link
2020-12-15 20-51-49
Josep Chaqués Ojeda

Srinivas Singadi wrote:

For Example in the above example its like this :

SyntaxEditor Code Snippet

TextToBinaryData(ExportRecordList2CSV.Csv,Encoding:)

and also here I am attaching the screenshot here,

I think you got a solution for your problem if  you got the solution then plz mark the solution so others will will also get to known

cheers

Srinivas


Perfect, but...where is the TextToBinaryData?


Thanks you.

Regards

Captura.JPG
0
0
06 May 2020
Copy Link
2022-02-25 19-42-59
Srinivas K Singadi

Hello Josep Chaqués Ojeda

you will get that component in Forge

for example its look like this :


1
0
06 May 2020
Copy Link
2020-12-15 20-51-49
Josep Chaqués Ojeda

Srinivas Singadi wrote:

Hello Josep Chaqués Ojeda

you will get that component in Forge

for example its look like this :


Now!!! Thank you!!!

Ragards,


0
0
06 May 2020
Copy Link
2021-08-12 11-00-27
Nordin Ahdi
 
MVP

Hi Josep,

You can reference the BinaryData API from your Manage Dependencies screen in Service Studio. No need to download it from the Forge as it is already built-in.

Regards,

Nordin

1
0
06 May 2020
Copy Link
2022-02-25 19-42-59
Srinivas K Singadi

Yes Nordin is right, I forgot that you need to just add the reference for the dependencies, thanks Nordin  

3
0
06 May 2020
Copy Link
2025-09-23 14-57-37
Sopan Vaidya

Hello Srinivas,

i went throw the source code of the extension and didnt find  attribute AttrFilter available there to pass the column names to export.

Can you suggest/share the path of the extension/source where i get the RecordListToCsv function with AttrFilter attribute?

0
0
23 Dec 2022
Copy Link
2023-05-30 19-50-24
Fernando Ferreira

Good afternoon Sopan Vaidya !

you can find this RecordListToCsv function with AttrFilter attribute here:

https://www.outsystems.com/forge/component-overview/636/csvutil


0
0
12 Jan 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.