Where can I find an educational guide on getting information into the Bubble database from a CSV?
I’m building an educational game for sound engineers. It already exists as a Google Sheet. I just need to figure out how to make it into a web app. I have already taken a Udemy course and read much of the forum here. From what I understand so far I need to: Use the file uploader to trigger a workflow that includes the Data Parser and Upload Data as CSV.
I have read the Data Parser instructions, but I don’t understand them.
Block Size: set this to the size of each block of data
But every column of my CSV files is of different size. For example, here’s the beginning of the file:
Is this a one-time upload? You can upload via the editor: Data > App Data > CSV. You do have to be on a paid plan, but this will let you upload your entire file in one go. This will also let you map your CSV columns to the data type fields, so your file doesn’t have to be perfectly labeled.
My clients currently use the .csv file uploader on a daily basis. I give them instructions on how to modify their .csv to ensure that the fields are all in the database. I then allow them to modify any date and time fields once uploaded. I found that duration and date/time fields kept causing headaches and a terrible UX, so I just have them clear those fields upload and then created workflow solutions to modify as necessary.
So long story short, as long as the fields match perfectly, the file will upload without issue. If you have any other specific questions let me know.
Integromat has Bubble modules that let you insert a bunch of database records or run a workflow. I insert my records from the processed text/csv file into the database with the “Create the bulk of new Data Things” module in Integromat, then I use the Bubble Run a Workflow module in Integromat to trigger a backend API endpoint in my bubble APP to tell me that the process has been completed.
Still working out kinks and bugs, but that’s the basic flow.
No, I actually abandoned this path and stopped using integromat. I hired a developer to build a PHP API endpoint on a basic hosting account. Now I send the csv files directly from bubble to that custom API, which then uses the bubble data API to place the parsed data directly into the Bubble database.