Transform Maps

[Shikhar Srivast]

i'm using a transform map to create some new records all of them get a unique number after creation as expected but my concern is if i move these records via xml to prod and suppose there already exist a record with same number so it will clash how to deal with this situation? what is the best practice here

[SN_Learn]

Hi @Shikhar Srivast ,

The best way will be to create/update those records using the import set/transform map, although the history of the tickets will be lost in this scenario for the records which will be inserted/newly created.

In order to avoid the above scenario you can use XML export and import. Once export is done, you need to change the 'number' in XML file according to the target table's latest number, save it and then import the XML in target instance.

[Community Alums]

Hi @Shikhar Srivast ,

If you move the records via XML prod would ideally have 2 records if sys_ids are different.

To ensure you are not duplicating the records please reconcile the records which are not present in prod and only move those which don't exist.

Hope this helps.

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

Thanks & Regards,

Sanjay Kumar