How to Automatically Assign CSV Imports to existing database entries

Need help Database
1

Hello everyone,

I’m building a flashcard app and want to upload a .csv file directly into the database (via the editor, not by users). I understand how to map the question and answer fields correctly.

Now my question is:

Is there a way to automatically assign each card to its corresponding Parent Deck so that I can later retrieve all cards belonging to a specific deck via a query? How can I implement this efficiently in Bubble?

Thanks for your help! :blush:

2

I assume you have a data field in your card that links to the parent deck? if so you just add the parent deck as a column in your csv and map it

3

So I export them from anki so the csv file really only has the question, answer and name of the deck als columns. And now in bubble I want to create a deck (manually) and then import the csv file and add all these cards and link the deck “within” the cards database.

4

you’d be best to setup a backend workflow to process the csv data

OR use something like make.com to process the csv data into the right places in bubble