# 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?

**URL:** <https://forum.bubble.io/t/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/365869>\
**Category:** Database\
**Created:** [April 6, 2025, 6:46pm UTC](https://forum.bubble.io/t/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/365869 "2025-04-06T18:46:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dave.evad](https://avatars.discourse-cdn.com/v4/letter/d/3ab097/32.png) [@dave.evad](https://forum.bubble.io/u/dave.evad)\
**Post date:** [April 6, 2025, 6:46pm UTC](https://forum.bubble.io/t/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/365869/1 "2025-04-06T18:46:15Z")

</div>

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](https://us1.discourse-cdn.com/bubble/original/3X/8/5/850f3a083c6889f1b43c8b3bd069966fdebacf92.png)

---

<div class="post-metadata">

**Author:** ![dialekt](https://avatars.discourse-cdn.com/v4/letter/d/49beb7/32.png) [@dialekt](https://forum.bubble.io/u/dialekt)\
**Post date:** [April 6, 2025, 8:51pm UTC](https://forum.bubble.io/t/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/365869/2 "2025-04-06T20:51:45Z")

</div>

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**.

---

<div class="post-metadata">

**Author:** ![dave.evad](https://avatars.discourse-cdn.com/v4/letter/d/3ab097/32.png) [@dave.evad](https://forum.bubble.io/u/dave.evad)\
**Post date:** [April 7, 2025, 5:52pm UTC](https://forum.bubble.io/t/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/365869/3 "2025-04-07T17:52:17Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![aleemansari97](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/aleemansari97/32/219562_2.png) [@aleemansari97](https://forum.bubble.io/u/aleemansari97)\
**Post date:** [April 7, 2025, 9:23pm UTC](https://forum.bubble.io/t/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/365869/4 "2025-04-07T21:23:14Z")

</div>

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.
