Hello Bubble Community, I am currently working on a project where I need to upload data from JSON/CSV files into a custom database structure that I have created in Bubble. The database, named CSVFILE, contains the following fields: USER_ID DATA_ID COLUMN_NAME COLUMN_VALUE DATA_TYPE My goal is to…

[image] Netanelyasi: I would like each row from this table to be entered into my database in the following manner: user_id, data_id, column_name, column_value, data_type 1, 01, name, john, text 1, 01, age, 30, number 1, 01, email, john@example.com , text Such database structure is known as…

I greatly appreciate your reply. As you indicated, I am compelled to utilize this structure since I have no idea which table the edge user would upload. Since the bubble database is constrained, I need to come up with a method for dynamically saving user tables. Do you know how to accomplish this?…

Check this plugin @Netanelyasi [image] Take data from an excel Need help Yes Simply download the file (Save as) as a .CSV file. Then use the 1T CSV Uploader plugin in your Bubble app to upload the file and create a list of things as demonstrated there by Eli…

Hey. I know the plugin. It is still limited. I want to do this in JS or a structured foundation Do you know? Netanel

Does the upload need be done in the front end or can it be done via the editor’s data base? For this you can upload CSVs via the upload option in the editor. Then you can establish a database trigger that detects new entries and does the parsing you need to dynamically assign the data_type which I …

Uploading JSON/CSV Data into a Custom Database Structure

Need help

cmarchan December 30, 2023, 10:58pm 4

Check this plugin @Netanelyasi

Topic		Replies	Views
Import CSV to Database? Questions	7	7850	November 23, 2021
"Upload Data" as JSON Idea	8	1631	November 16, 2022
Complex CSV/Sheet import to DB (Recreate table in Bubble) Database	6	2935	July 26, 2022
Upload A csv file for database Database	1	476	March 18, 2022
Automatically importing CSV files to Bubble Database APIs	4	3386	August 8, 2022

Uploading JSON/CSV Data into a Custom Database Structure

Related topics