Hey everyone,
Hoping someone can offer some insight into data uploads/linking tables. No matter what I try, it keeps failing/not linking properly/using a ton of WUs.
My app is similar to an invoicing software and to onboard clients, we have to pull their data from their current software into a CSV and upload it in Bubble.
Each “invoice” has a series of packages/bundles and each package/bundle has a series of line items within it. Each invoice also has a client attached to it and a client project attached to it.
Since they have to be linked, my first thought was to upload their client list into Bubble and then export the table to include the Bubble Unique IDs, add them to the other CSVs, and then map the fields in the upload.
This immediately didn’t work, my first client has ~8000 clients and the export only allowed for 5000 records to be exported.
Second, I tried creating UUIDs in the CSV and mapping those in the upload. For example, each client was given a UUID and that client UUID was added to the invoice CSV. When uploading invoices, I used that UUID to map the client to the invoice, but no dice. Upload kept failing after ~1000 or so records.
Then, I tried uploading all the data into Bubble with the UUIDS and created a few backend workflows to link everything together. The workflows were set up to do a search for all invoices that had a client UUID but no client attached to them, then add the client to the invoice using Do a Search For:first item.
This worked for like 60-70% of the records but the rest were not linked (it also ate up 750k WUs in the process). I tried running the workflow a couple of more times on the rest of the unlinked records but it won’t find them.
I dove into a bunch of the records to see what happened and have no idea why they aren’t linking. Using the same search as the workflow, I’m able to find the records just fine in the App Data tab, but for whatever reason they’re not being picked up in the workflow.
Aside from moving to an external database like Xano, I have no idea what can be done here. If anyone has any suggestions, I’m all ears.
Thanks