Existing database imported with own Unique ID's

Need help Database
1

Hi,
I have exported a database from my existing CRM and imported into my ‘under-development’ CRM on bubble.

The existing databases has unique ID’s linking it to other parts of the old CRM, when I import it to me bubble database, I am creating a field for the old unique references numbers to try to link it all back together, bot obviously the new databases in bubble have their own unique IDs.

My old CRM has customer records, tickets and invoices. The new one will have the same and I am hoping to use the same data.

Does anyone know how I would look for the old unique IDs that are in all the old records and somehow link them to relate to the new unique ID’s of the new databases?

Thanks for any help of advice.

2

If I’m understanding your question correctly, as long as you have both fields stored on the row level you will always be able to link it back to the original id.

Customer id | _id (Bubble id)
12345 | 23433223x34232323

So now anytime you have an old CRM record with Customer Id you can look up the new Bubble Id. And any time you have a new record (lets say you create a new address data type) you can store the new id like this:

Address CustomerBubbleId
1245 Customer Lane. 23433223x34232323

Now if you need to connect the address back to the Customer you can use the CustomerBubbleId column.

Hopefully that makes sense to you.