Hi Everyone,
I need a solution on how i can do mapping between entities
i have a entity with foreign key in my source entity which has data in it and i have created another entity in my target space same as the source entity with same attributes and data types including foreign key same as source entitiy. can any one help me out how i can copy the data from source entity and past the same data in target entity.
Thanks,
Daanish Hussain
Hi Daanish,
Do you want to move data to a new table, that's it?
If you have the old and new table just create a timer to migrate the data, is the most easy way to do it.
Regards, Paulo Torres
we have to copy data from one application from qa and we have to paste the data in sandbox environment of the application which contains same entity and attributes and foreign key let me know how i can achieve
Daanish.
Hi Daanish, you can create a timer to copy the data to the new table, as it's the most efficient way especially if you need to copy a large amount of data.
If you are not very familiar with timers, you can check this link below:
https://learn.outsystems.com/training/journeys/async-processing-timers-586
Regards,
Tami
Two people have already answered you, yet you keep asking the same questions. There is no automated way to move data, you'll have to program it. Which means, if it's a single entity, to query all data, loop over it, then create it in the new entity.
If it's multiple entities, it is far more difficult, as you need to keep track of all foreign key relations, and map the foreign keys to the new values.
If your "sandbox environment" is a completely different environment, then the above doesn't work. In that case you can either use a data mover tool like the Cool Data Mover (which costs money, but see the Forge), or you can create something yourself via a REST API.
Note that if you do not know how to do any of the above, the chances that you'll succeed after we explain it in more detail are still not that great. Perhaps you should just tell your boss you/your team is not up to the task, and hire someone who is.