Need help in updating data

[rpnocode]

I have a pet table which has close to 20k records, I am trying to clean up these records as users have created duplicate pets. The reason I am doing is that I am sending birthday wishes to pets and do not want to send multiple wishes, and I am using the data in pet table to do that. Since there are more than 20k records I cannot manually edit/delete the records from bubble editor. I have to take an export, clean up the excel and reupload them again.

My question is that these pets are linked to user table and several other tables, When I take an export of the table delete the table contents and reupload the sanitised data. Will these links (link to user table etc) still exist? or will they be removed once the records in pet table are deleted?

[dtempest006]

If you delete all pets and reupload, Bubble will give them new IDs, so your user links won’t know who’s who anymore. Basically, the connections will break.The safer move is to export, clean, re-import as an update so the same IDs stay intact. I’ve run into this with big datasets before, and trust me, rebuilding 20k links is not fun . If you want, I can share how to set it up so you don’t lose those relationships.