Hey @eli, does Create CSV from JSON (SSA) help if the data is large and timing out?
And after the Create CSV step, I pass the base64 text to “New file from base64” and then download the output of step 2 using the download file plugin of airdev. The result, however, is a text file and not a CSV.
It is. You need to use the Create CSV from JSON (SSA) action along with the CSV Creator - New File from Base64.
Try adding ‘.csv’ as the extension on the file name. That should solve your issue.
I tried doing that, but then I got an error “There was an issue generating your file. Please check your file type and try again.”
Which action is giving the error. The CSV Creator action or the action from the Airdev plugin?
To answer the question about the SSA action helping for large data sets, there’s no real benefit to using it on the front end.
What I’ve seen is timeouts generally occur because of the time it takes to search the data and create the JSON text. If you can create that json using a native Bubble feature (like a custom state) and then pass just the text value to the plugin I have yet to see it timeout creating the actual file.
Hi @eli
Thanks for that awesome plugin !
I succeeded in exporting a CSV from JSON for one table using page workflow, now im trying to export two lists at the same time using backend workflow.
Here is my database structure.
invoices
lineItems contains an invoice field of type invoices
subLineItems contains an invoice field of type invoices and a lineItem field of type lineItems
Every invoice contains at least 1 lineItem.
A lineItem contains between 0 and n subLineItem.
An example of what im trying to achieve :
| invoice | name | amount |
|---|---|---|
| invoice 1 | lineItem 1.1 | 100 |
| invoice 1 | sublineItem 1.1.1 | 50 |
| invoice 1 | sublineItem 1.1.2 | 50 |
| invoice 2 | lineItem 2.1 | 150 |
| invoice 2 | … | … |
I don’t really know where to start or if that’s even possible? Using JSON array maybe?
An idea of the direction I should take would be nice 
Hey, @eli,
Love the plugin.
Is there any way you can add 10 more Headers (Header 26, Header 27, etc…)
Thanks in advance 
I think if you use the Create CSV from JSON action instead of the Create a Dynamic CSV file you wont be limited in the number of columns your CSV can contain.
Hey @hacker,
The Create a Dynamic CSV file action is no longer being maintained but as @pierre6 mentioned, the Create CSV from JSON will let you create an infinite number of columns.
I really struggled with this too just now and after reading the response I thought I had it figured out. Still ran into a bunch of issues with what I was trying to do, which was to first save the file to my DB as an entry on a datatype and also send it via email as an attachment…neither were working until I saved the file to my DB with the find and replace.
Now I can create the file via backend and also save it properly and send it via email.
@boston85719 you should be able to email it without saving first by adding https: in front of the value.
Thank you for that tip. Will check it out on a future project. Really excited to see the SSA action for creating the CSVs; opens up so many nice features.
In the particular project I am doing this in now, it is something I’d like to save as a historical record in the event the email fails to send, as it will be simple enough to retrieve the saved file from the DB and resend.
Thanks again for this plugin.
Hi I loved your plug-in, I`m using the Create a Dynamic CSV File function. I would ask to you add a option to change the Delimiter.
Anouter issue is when I try Create a Dynamic CSV File with a list with 3500+. It crush and when I click again the file is generated. Tranks for you plugin
Does anyone know what this is?
I got this same error message for 2 separate JSON to CSV plugins
I had a similar problem.
After spend several time of research, I found ‘tab’ in data.
So I change the data to ‘some_field:trimmed’. Now It works very fine.
Just in case this isn’t intuitive to anyone, when using :format as JSON-safe, you need to remove any double quotes you had there before, as this function will wrap your text in double quotes!
Hi Guys,
I am so close to making this work for me.
I am getting this to print a list of deliveries I have every day as a backup in case bubble goes down.
I have everything working, but can only print all deliveries, not just future deliveries which is what I need.
I have tried adding a constraint that delivery date > Current date/time but this throws an error everytime.
Any help would be appreciated.
Thanks,
Ben
Guys I need some help here. When i put a date in the search like below, I get an error. when i take it off, the csv displays without any problem. (also see error below) . It works fine in dev mode, but throws the error in live mode
Here’s the error i get.
@eli I know you are busy, but could you possibly provide an editor version for reference? This thread has become rather long and I would like to see it in practice.
If you are too busy, I totally understand!
same issue there. I’ve searched for the " caracter in text but not found. @eli maybe you’ve an idea?
