Generate .csv file from data grid columns

Flow Classic
1

Dear All,

I need a help for below.

Is there any way where I can export all columns of a data grid into a .csv or .xls file from flow studio?

BR,

Bhaski

2

Hi Bhaski,

Within the app there’s no such native support. However, it can easily be achieved by adding an “Export” button (user step exit) that runs a script to generate the CSV contents and then writes it to some kind of storage (File System connector). That file can then be presented directly to the user for download in a File Gallery within a user step.

Portal tables have XSL and CSV export built in into the portlet.

3

Are you on connect or in Classic? In classic Studio you can just copy the value of the table from the debug variables. You manually need to paste it somewhere and store it if you want the actual file. But this here should do the trick for most scenarios:

image
image518×176 8.41 KB

4

Hi All,

Thanks for the reply.

I want to give user (who i using system as a user) a option where whatever fields they have in data grid , they can generate a .csv file in local desktop.

As of now if I generate this it goes to server to save , how I can provide an option that user can download in local.

BR,

Bhaski

5

In Classic, it is a 8 step process:

  1. Use flowscript to create the CSV contents
  2. Write CSV to server
  3. Zip CSV file to server
  4. Use Zip to Stream to convert zip contents to binary format
  5. Convert this record to a file gallery compliant table
  6. Delete the Zip
  7. Delete the CSV
  8. Show the stream data to user in a File Gallery user step