I have to convert a data table fetched from database into csv format and user should be download this csv file. How will i be able to do that

2 answers

1
0
-1

Hello,
You have two possibilities.

1/ create the CSV in a connector (or a Groovy connector) and save it in a Bonita Document. For the user, use a Download to get the information.

==> More code to do

Document to save in the process variable

more robust if the list is big

2/ via a REST API, produce the value on the form, then use the ALASQL widget: user can collect the information from the browser

https://community.bonitasoft.com/project/widgetalasqloperation

Ps: in this option, you saved the information in a Process Variable (List of Map), then use the REST API Context to get this information to the browser

https://community.bonitasoft.com/project/restapicontext

==> easiest

Attention, if the number of records is over 500, the REST API needs time to get all theses information to the browser, and the browser should not display a such big list. So, you have to use the first options

PS: a video explaining how to use the REST API CONTEXT : https://youtu.be/M9Y8xaHZFRo

Best,

1
0
-1
Notifications