We have just released a new plugin for CSV / XLSX Export! It allows you to export any data and even supports export of images for XLSX. It can be triggered with simple workflow action.
Just search for the WB Export (CSV / XLSX) plugin and add it to your Bubble app.
Hello @ryanck ! Yes, there is a monthly option for the subscribtion, but there is no free option though. I hope the demo page give a good introduction in what to expect. Thanks or the interest and have a good day!
Hello @metricsense ! I am so happy to hear that! Have checked out your web site - good job, I need some translation though
Regarding the milestones, here is the plan for further development:
Custom scaling per image on export (dynamic width/height).
Download from new tab (open a new tab checkbox parameter).
To be determined.
We plan to finalise the first 2 points this year.
Thank you for this useful plugin ! I have a bug with it though, when using it in a back-end workflow. Apparently, the workflow returns an error when the data set exceeds a certain number of rows. And this number isn’t that much, not more than a thousand object.
Hello, sorry for the late response. Apparently, this is a server-side plugin. Since it is running on Bubble, does not utilize external app API, it may hit some limitations. This is something to solve yet. But one thousand objects sounds rather less. Could you maybe give more detailed insight on your setup, so that we could reproduce the issue? Or should it be enough to have 1k+ rows repeating group with 1 text column? We have done some stress-tests which worked fine. How much data do you export approx?
I export 94 iteams using external API. export , i think, worked correctly, but in debuger mode i see, that next step “download” is not. the file is empty
Hello, nice to hear from you. Is the data for the file present on previous step, like on the example screenshot below? I’ve attached the “non-empty file” debug view just for a reference as well. File contents are from the previous step in the example.
Hi, one question, would it be possible to “protect” some colums?
My idea : Protect a few colums so the user doesn’t mess with them, make an empty one where my user can input data… and then, import the data back into Bubble.
this is not yet possible unfortunately, but still a very good idea indeed. Would require to have more control over the xlsx generation - we could think of it for the future update.
I was trying to use the demo exporting to XLSX but it takes so much time to get downloaded, more than 10 or 15 seconds and at the end, it downloads a .csv.
Is there any other source to see it working properly?
Great plugin. I just have a problem with xlsx exports. They show up as text (see screenshot). When I use the same workflow to generate a csv and then open with Excel there is no issue.
Hello,
One more issue. Because it takes a bit of time to process the Export functionality, i placed it in an API workflow and was going to generate an email to notify user when download is complete. However the “Download” element does not seem to appear in an API workflow. See screenshot.
Great plugin and works well with me, i just don’t know how to use the row delimiter. I add a delimiter in the data field, and it successfully exported two rows, but in the future i will not know how much rows the repeating group will have so how to make the plugin automatically define the number of rows?
Regarding this issue, it is unf. a Bubble limitation and you are getting a timeout. And “Download” action can only be used on frontend.
Still the result of the “Export” step is a base64-encoded file. Thus, you may use it in the backend workflow and have the resulting file saved somewhere when the export is done (you can save e.g. full base64 text value or save it as a file and eventually have a link to it). For this approach, you may need to come up with some UI solution on the list of exports, which then can represent “in progress” and “completed” exports.
I know it’s been a while, sorry for that. But maybe it will help others with the same issue.
