@eli I’ve been playing with Server side file generation as this seems to be more reliable when creating files with larger data sets. Is there a way to make the file private? Great plugin btw.
Hi @eli
The action “Send JSON to CSVCreator A” and the event “CSVCreator A has created your file” wouldn’t work on my mobile deveice.
Is it something pluging’s system problem?
1 Like
I am trying to dynamically add columns to the JSON (and the generated CSV) using arrays, but I have spent many hours without getting any result. Does anyone have experience about how to structure a JSON in Bubble so that the number of columns vary depending on the existing number of items ? Thank you for any help.
Hey @eli ,
Thanks for the amazing plugin!
I am trying to use the plugin in the backend workflows.
Step 1: I used the “[beta] CSV from JSON (SSA)”
Step 2: I realized the output of Step 1 is Base64 file. So I used the “CSV Creator - Create File from Base64”
However, in Step 2, it asks for the websiteHome path. I am not sure what to enter there.
I randomly tried entering the website url of my Bubble app and it gave this error
Erli, good morning!
I sent a message in private. could check please.
Just responded in DM
@karthik, you should use the dynamic expression website home url. It will create the file in the file manager of your app.
Hi @KeitaroNakata, make sure the CSVCreator element is visible on the page. But shouldn’t be any issue with running on a mobile device.
@dehacked79 I will add this option to the plugin at some point. In the meantime you could set up the API connector to do this using the settings below.
Here’s the connector setup that I’m using. You would just need to add the following parameters:
private = true
attach_to = things unique id
1 Like
@stefanof, this would require some use of the :format as text within the JSON object. For instance, rather than specifying all the columns manually, you would add a list inside the JSON object.
{
"column 1":"column 1 value",
"column 2":"column 2 value",
Some list:format as text
}
This list would then be formatted as
"new column":"new column value"
with a comma as a delimiter.
Hopefully that helps point you in the right direction. I’ll try to help more if you want to give additional details about the data setup and specific results needed.
Cheers!
Hey @eli, first off THANK YOU for the great plugin and all your continued help.
I’m getting this error message
I’m certain it’s because of the way I’m doing the search in the “JSON CONTENT” section. I’m doing it based on values contained in a multiselect dropdown.
Is it just not capable of doing the search based on a multiselect dropdown or am I just doing it incorrectly?
Also, what are the limitations for the amount of data that can be exported? Is the plugin limited by the overall size of the database?
For instance, trying to export 100 records from 1,000,000 records?
The reason I ask is because i’ve gotten the plugin to work in development mode (using standard dropdowns instead of multiselect), but now that it’s live I only get this error message.
Hi all,
Seems like an amazing plugin that would solve one of my current issues, but I’m getting this error :
The plugin 1T - CSV Creator / action Create CSV from JSON threw the following error: anonymous@PLUGIN_1582601241392x653181519983018000/1T—CSV-Creator-action–Create-CSV-from-JSON-.js:7:18
[302]</S.PluginService</t.prototype._interpret_raw_plugin_def/y</</a.run/</</<@https://dhtiece9044ep.cloudfront.net/package/run_debug_js/451d5a8ec189c891c030dc5d357341c0027f30185ba879c600d3306ef1aaae16/xfalse/x15:6:2244672
[302]</S.PluginService</t.prototype._interpret_raw_plugin_def/B</<@https://dhtiece9044ep.cloudfront.net/package/run_debug_js/451d5a8ec189c891c030dc5d357341c0027f30185ba879c600d3306ef1aaae16/xfalse/x15:6:2229043 (please report this to the plugin author)
This doesn’t really speak to me haha. Is it from something I’m doing wrong ?
I thought I had a rather regular setup, I haven’t even tackled nested lists yet :
Hey @eli
Thanks for your plugin which used to work great. But I’m having an issue since yesterday with that error message.
Could you help me understand what went wrong?
Many thanks
Are you exporting user generated content or any content that might have line breaks or special characters?
If so, try using the :format as JSON on those values.
Oof, yeah, I have not seen that error before. Is it still throwing an error?
It does unfortunately, but I tried on a Chromium browser (I was on Firefox) and I got an error closer to the one from @theoakistopoulos :
I do have UTF-8 characters in there, so I’ll look into “format as JSON” and see what happens.
Reporting back, unfortunately I have tried :format as J-SON safe but no luck.
The error changed on the Chromium browser but still refuses to create the file :
Firefox:
My updated input, I tried applying :format as J-SON safe at field level and/or at the :format as text level, no change
Create a Dynamic CSV File seems to create file just fine, but it doesn’t seem to do lists nested inside of a column field, which I’ll need. Is that possible at the moment ?
Hello @eli and thx for this great plugin. I use it in backend, so my steps are :
Create CSV from JSON (SSA)
CSV Creator - New File from Base64 then
but it is saving with double quote at start and end of the file name, is there somethin I do wrong ?
(the field is a “file” type
thanks for your response
Hi Eli, how are you?
First, thank you for your time and dedication to creating this plugin.
I would like your help, I’ve seen your video tutorial about the plugin several times, but I understand what I’m doing wrong, I’ll leave the images of the properties below, I even named it the same way you do, but for me it doesn’t run, it just divides the files do not matter to Bubble.
Field for Types
Plugin Properties
API Workflow Properties
Workflow Router Properties
Upload-csv Properties
Workflow upload Properties
Upload data CSV Properties
Debugger
As you can see, the debugger doesn’t start the Workflow API on the backend. I use the Personal Plan and it is active in the settings.
Thank you for your attention!
Matthew Faust