Imported data. It gave an 'undefined' error. It did import over 10,000 lines and created a bunch of duplicates. How do I get rid of the duplicates?

Need help Database
1

Imported data. It gave an ‘undefined’ error. It did import over 10,000 lines and created a bunch of duplicates. How do I get rid of the duplicates?

Screenshot of the db page:

image
image1920×1080 361 KB

2

You will need to create a backend workflow that gets a user email( or combination of fields) and check the count in the database for it, if its > 1 delete the current item. Once that’s done you have to go back to the App Data tab above and click on Bulk then select the recently created backend workflow.

3

Thanks Dialekt.
Yes, I followed AIs advice to do a workflow. It ended up deleting all my data, even though it seemed to be working properly at first.

The data I imported did not have any duplicates, so the fact Bubble created a bunch of duplicates on import means it’s not a platform I can put faith in developing on.

1 Like
4

Could it be you accidentally uploaded the same data twice?

I work with data a lot on Bubble and although I’ve witnessed incomplete uploads (probably due to internet issues) – I’ve never seen Bubble mess up by creating unwanted duplicates.