CSV Upload - CRUD

jamie.robson.89 · 2024-12-10T11:48:14.260Z

Hi all,

My users need to be able to upload a CSV file, and have that file either create new records, or update/delete existing records, where a unique ID in the CSV, matches the unique ID in the database.

All I’ve been able to do so far, is allow users to create new records, but not overwrite existing ones.

Any ideas on how I can do this?

hi.luisacosta · 2024-12-10T15:31:44.546Z

Your CSV upload must have the uniqueID of the bubble object you’re working on.

Let’s say this is “events”
Events with NO uniqueID are considered new, parse those out and send them to the creation workflow

Events WITH a uniqueID are existing, parse those out and send them to an update workflow.

jamie.robson.89 · 2024-12-10T15:58:54.260Z

Is there any way to force Bubble to look at a different unique identifier?

hi.luisacosta · 2024-12-10T16:13:04.187Z

No, you cannot override or manage the bubble UniqueID.

If you want to manage this on your own, you would probably have to create a datatype that processes the CSV upload. then every time you upload via CSV, for each row you create this “Process_Row” object with all of your fields. Then for each object, you could look up your own ID and see if it’s new or existing and do the 2 workflows I mentioned above.

It depends if your csv plugin allows you to do some of this, but I’ve never seen it yet.

system · 2025-02-18T11:49:12.138Z

This topic was automatically closed after 70 days. New replies are no longer allowed.