1T - CSV Creator 3.0

Showcase
399

Use the format as JSON-safe operator instead of double quotes. This will default to JSON safe values when no value is given as well as escape any JSON breaking characters in your data.

400

@rico.trevisan Like this:

401

Thank you @eli
But I am unable to actually see the results of reformatting the JSON because I am still getting the outage issue anytime I use the action Create a CSV from JSON (again, this does not happen with Create a Dynamic CSV file).

Sorry, we are experiencing a temporary outage and were unable to complete your request. We’re working to get it right, please try again in a while!

It would be helpful if you could update the plugin page because that is what I followed to get my original, incorrect JSON formatting.

402

@april I will often build out my expression for creating the JSON in a text element on a test page so I can see the results. You can then copy that into something like JSON Lint and see if there are any errors. Probably the next step to trouble shoot here.

The actual error of a ‘temporary outage’ i haven’t seen before. That seems like a Bubble error.

And noted on the documentation. I see exactly what you are saying there. Will update.

403

Yup. Fixed that :pray: thks

404

Thanks. It has worked this time with your suggestion. Since it was working earlier too and breaking sometimes, I need. to see if it continues working. I hope it does.

Important point to remember for others who are reading this is that format as json safe should be done on individual fields and remove the double quotes around them. Not to do format as json-safe on the generated JSON.

405

Cant find this video, not working for me.

Im trying to ad headers to CSV from the create CSV from JSON action

406

@eli or @davidb or anyone else. I must be missing something obvious, but on the server side action, after “CSV Creator - New File from Base64” whether private or not I am stuck with a link to the file that doesn’t work when I try to download it because it has the following text prepended to the file url and then a " after the file url.

https://bubble.io/"// [file_url].csv "

image
NOTE: in file manager the file is there with the proper link

I would appreciate it if anyone could point me to what might be causing the file url to be messed up like this.

407

I don’t follow all the details of what you’re seeking to accomplish or have tried. Also, I don’t have experience using this plugin’s base64-related actions. Nonetheless, in case it’s helpful, here’s my implementation for using JSON to create a CSV file, a copy of whic is then attached to a thing, followed by the original CSV file being deleted.

  1. Send JSON to CSV Creator action from this plugin.

    image
    image338×593 47.4 KB

    (I annotated the property names because they’re not appearing correctly on their own.)

  2. When CSV Creator has created your file event from this plugin.
    image

  3. File Upload action from File Uploader Bubble API plugin, currently maintained by @Thimo (see also forum thread).

    image
    image340×569 30.1 KB

  4. Delete an uploaded file standard Bubble action.
    image

408

thanks that is very very helpful. Appreciated.

1 Like
409

The quotes is simply how Bubble returns the created file. Simplest solution is to add a find & replace action that finds a double quote and replaces it with nothing.

1 Like
410

Thanks, @eli and @davidb. Resolve the file issue with your suggestions and then tossing out the ZQ download plugin that was acting up.

2 Likes
411

Awesome plugin @eli

Do you think that the many times requested solution of handling UTF-8 characters is soon going to be supported? I also have problems with German “Umlaute” and special characters like Ă¶Ă€ĂŒ or ß

Forking and maintaining the plugin could work but brings in some overhead I think could be avoided.

Thank you very much!
Cheers

413

@hi_bubble This is now live. Please update to version 3.8.

I’ve tested with the following JSON and its exporting all characters correctly. Cheers!

[
  {
    "name": "Françoise",
    "language": "Français"
  },
  {
    "name": "Björn",
    "language": "Svensk"
  },
  {
    "name": "MĂĄrio",
    "language": "PortuguĂȘs"
  },
  {
    "name": "MĂŒller",
    "language": "Deutsch"
  },
  {
    "name": "SĂžren",
    "language": "Dansk"
  },
  {
    "name": "Ɓukasz",
    "language": "Polski"
  },
  {
    "name": "Pǐng",
    "language": "äž­ć›œ"
  },
  {
    "name": "à€°à€Ÿà€œà„‡à€¶",
    "language": "à€čà€żà€šà„à€Šà„€"
  },
  {
    "name": "ΕλέΜη",
    "language": "ΕλληΜÎčÎșÎŹ"
  },
  {
    "name": "Đ€Ń‘ĐŽĐŸŃ€",
    "language": "РуссĐșĐžĐč"
  },
  {
    "name": "NĂșñez",
    "language": "Español"
  },
  {
    "name": "Çağrı",
    "language": "TĂŒrkçe"
  }
]
414

Hey there @eli

I’ve been trying to use CREATE CSV FROM JSON without success.

The user should be able to download a financial projection of sales of diferente (ROWS) products and services.

Whats odd is that the CSV won’t generate more than 3 columns .

Here is a screenshot of my workflow and JSON

Screenshot 2024-06-10 at 13.46.41
Screenshot 2024-06-10 at 13.46.411574×1092 183 KB

This is the result of the CSV downloaded:

Screenshot 2024-06-10 at 13.45.27
Screenshot 2024-06-10 at 13.45.27844×390 40.2 KB

I’m getting month 1 and month 5 of my financial projection but not everysingle column for each month as I’ve requested in screenshot one.

And this what the JSON looks like when using the DEBUGGER step-by-step

Screenshot 2024-06-10 at 13.47.13
Screenshot 2024-06-10 at 13.47.132880×596 115 KB

The financial projection goes up to 12 months.

Any ideas?

I saw the video “Bubble - CSV Creator - How to avoid timeouts by building your JSON using backend workflows.” But don’t think is necessary for my use case.

415

The reason it’s only generating 3 columns is that you have the same key defined for months 2-5 which is simply a space. When that json is parsed into columns there’s only three results.

You’ll need to define each month with a unique key.

416

Thank you @eli! Sometimes one does not see the obvious things.
Now working well.

1 Like
417

Love this plugin. After struggling with CSV export solutions and coming up with hacky methods to make them work, I wish I would have found this years ago. Thank you

1 Like
418

Hey @stephencharles,

Were you able to figure this one out?

419

Hi @eli ,

First thank you for this amazing plugin!!
Once my user import the csv file, I want to calculate the distance between two geographic places that they would input in the CSV. Do you know how I can do that? I can’t find a way of getting data with geographic format when importing the csv in bubble