How to export data table

[Mukhi]

I have a datatable and the data is getting from mysql. I tried to export data from table in CSV format but it is not working properly. I couldn’t find any proper export docs in Wappler channel.

I have attached the screenshot given below:

[Teodor]

@Mukhi

I tried to export data from table in CSV format but it is not working properly

Can you explain what kind of issues are having with CSV export?

[Mukhi]

You have any proper document to export data into csv format.

which path should I add here.

[Teodor]

Well there you just select the folder/path where the csv should be exported

[Mukhi]

Ok U have any document for export data

[Teodor]

I don’t find any documentation, but it is as simple as you see on your screenshot. You select the export folder and that’s all.

[Mukhi]

Is this Right ?

[Teodor]

You need to select a file, so just create an empty csv file, click it and select open:

[Mukhi]

I took this step.

is this right, Now whats nest step

[Teodor]

What do you mean by “what’s next step”? What else do you need to do?

[Mukhi]

Now how to connect to the export button

[Teodor]

You just run your server action on button click.

[Mukhi]

Now I added new server connection as you can see in screenshot and I was selected " /api/export_files ". Is this right

And on button dynamic event on click action I was connected " serverconnect4 ". As see in Screenshot below:

[Teodor]

@Mukhi

You don’t want to run the server action/export on every page load, so enable the No Auto Load option. this way it will only be called when the button us clicked:

@Mukhi

[Mukhi]

Now when I clicked on button this error show

[Teodor]

Debugging Server Connect Errors

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings. They are located in the Workflows Panel > Server Actions: [Screenshot 2021-09-27 at 10.02.35] And enable the Debug Mode: [Screenshot 2021-09-27 at 10.03.08] Click Save: [Screenshot 2021-09-27 at 10.03.26] In your browser, open the Developer tools. If you don’t k…

[brad]

Welcome to the Wappler community.

Maybe this thread will help you.

Stuck on Downloading CSV file

I have a recordset and a button to export to CVS. The xport works amazingly well. Love Wappler! [Screen Shot 2022-08-30 at 11.46.47 AM] What I want to do is when that button is clicked on to export and then download the file. I can’t get the download to work. What am I doing wrong? [Screen Shot 2022-08-30 at 11.46.35 AM]

I also have mine link/button set up completly different. I think you have your API action set up correctly as far as I can tell.

What I had to do was create a route to my action file.

And then use an anchor button for the link and link it to the new route.

[Mukhi]

Hi Brad,
You Shared this steps. This is working from your site ?

[brad]

Yes, those screenshots were taken from my main project. Works real slick. Made me look like a genius to our staff that use the dashboard.

[Mukhi]

Hi Teodor,
I Check Error in Network menu. I attached the screenshort below :

What should I do now?