I’m trying to migrate data from our current site to our new bubble site but I’m having a lot of trouble migrating the data because we have so many Things that relate to one another. When I try to use the Upload function in the Database, it keeps throwing errors because of the relationships between Things.
User things has a Provider
Provider thing has a User and an Organization
Organization things has a Provider and List of Programs
Programs things has an Organization
When I try to upload a .csv of Users, it throws an error because it cannot find Provider thing in the db yet. Similarly, when I try to upload a .csv for Providers, it throws an error because it cannot find the Organization thing in the DB yet.
I’m uploading around 1,000 rows, so it is not very feasible to have to go into each Thing to manually update their relational data fields.
I’d be open to for example uploading thing User while ignoring Provider field, then uploading Provider thing while ignoring Organization field and then going back and doing an upload update to User thing to add in Provider after that thing has been created in the DB, but that doesn’t seem to be an option in Bubble.
Also, when I have a field that is a list in the .csv, it is not uploading correctly, even though in the csv the list in the given cell is [Category One , Category Two , Category Three]. In the DB it visually looks like the list was uploaded correctly, but when I preview the site, the new entries don’t show up in their respective Category and Subcategory.
Can anyone please help? I’m not able to use my bubble site unless I can get this figured out. Many thanks in advance!!