Hi,
I want to migrate IDs from another database to sugar IDs. How can I do this?
Just migrate them. If you put unique values in the database keys, whatever they look like, they should work in SuiteCRM. It is not a requirement to make them look like those GUID’s something like “aaaa-aaaa-aaaaaaaaaa-aaa-aaa”.
So if I migrate them I should see my data in the UI?
I’ve tried that with my salesforce IDs a few month ago and that didn’t work.
Yes you can put data in the database and it will show in the UI. But you need to respect the database structure (ids, foreign keys, relationships, etc).
For some tables this is more straight-forward, for others it requires some investigation. If SuiteCRM is not showing your data it’s because the query it’s using is not picking up your records. This could have many reasons but the most obvious would be that it is using a JOIN with another related table, and you didn’t put the records there (you only put them in the main table). Another possible cause would be a required field that’s missing; or a status field that is expected to have a certain value.
The way to get this right is to examine what SuiteCRM does in the database when you do things from the UI, and then replicating that in your migration work.
This might also help you navigate the DB:
https://schema–suitecrm-docs.netlify.com/schema/