How to execute actions on a csv file (as opposed to uploading)

[tbenita]

Hi,
I’d like to create several things in my Bubble DB (and link them) from each line of a csv file as opposed to a straight / basic upload of the csv in a unique given data type.

Context:

• My DB structure (data types): Answers_set (data type 1) linked to “Answer” (datatype 2)
• The csv structure: each column of the csv file relates to a unique “Answer”, each line of the csv file is an “Answers_set”

What I’dl like to do is (recursive):

• Take the first line of the csv file, CREATE one Answers_set, for each column CREATE one “Answer” and ADD that Answer to the relevant “Answers_set”, tag that first line as “done” and move on to the next line in the csv file
• Keep doing it until the csv file count of ‘is not “done”’ lines >0

I can’t figure out how to do this. Any suggestion? Method or plugin?
Thanks

[tbenita]

I am certain @eli would have great ideas about that

[boston85719]

@tbenita

What I’dl like to do is (recursive):

• Take the first line of the csv file, CREATE one Answers_set, for each column CREATE one “Answer” and ADD that Answer to the relevant “Answers_set”, tag that first line as “done” and move on to the next line in the csv file
• Keep doing it until the csv file count of ‘is not “done”’ lines >0

recursive backend workflow

[tbenita]

Yes, this is what I’m thinking… but I don’t know where to start / what action to use to handle my csv without uploading it first to a datatype. Any tip?

[boston85719]

@tbenita

but I don’t know where to start / what action to use to handle my csv without uploading it first to a datatype.

You can not upload data via CSV without uploading it to a data type.

What I usually do if I need to do some searches to make the relationships is create a temporary data type…so if I’m uploading products that will ultimately go to my Product data type, I create a data type called Product Temporary for uploading the CSV file to, then I do the recursive workflows to make the searches etc. for setting up relations to other data types while populating that information to my main Product data type, then I delete the Product Temporary entries.

[tbenita]

Thanks. I thought there could be a way to avoid that using a JSON conversion and then an API to receive that JSON and apply transformations but although this solution might exist I would probably waste more time trying to implement it whereas I only have that one upload to do… so I’ll follow your advice / traditional route

[ankur1]

Use @eli csv uploader plugin that converts each rows of your data to the json.

Loop over each json and extract the data from the json using plugin.
then you can insert it into db based on your requirement.

Ankur@Nocodetalks
Looking for a Bubble Coach?

[eli]

@ankur1

Use @eli csv uploader plugin that converts each rows of your data to the json.

Exactly what @ankur1 said.

@tbenita

I thought there could be a way to avoid that using a JSON conversion and then an API to receive that JSON and apply transformations

The 1T - CSV Uploader plugin also converts your CSV to a JSON array so you can post that directly to an API endpoint in your app.

[recovermuk4all2]

Thanks @eli but is there a way to use the 1t - CSV Uploader without showing the user the mapping options and just use it to handle uploads to backend workflows?

[eli]

@recovermuk4all2 Not currently. Will add that soon.