Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Data Import Transform Map with sys_id

brycegodfrey
Kilo Contributor

I'm trying to import some data from one instance to another using the XML data source (table.do?XML).   I have a transform map that tries to set the sys_id on the target from the import table u_sys_id field.   I can see the import table get populated with the sys_id of the source table, but the records are being created with a generated sys_id every time.   I have set the coalesce field, and the mapping looks proper... I'm just not sure what I'm missing or if this is possible on the core_company table?

1 ACCEPTED SOLUTION

adiddigi
Tera Guru

If you want to set the same sys_id, co-lease isn't enough. You will have to follow the steps in the below page:



http://wiki.servicenow.com/index.php?title=Importing_from_Another_ServiceNow_Instance#Add_a_Field_Ma...


View solution in original post

6 REPLIES 6

sumeet_n
Mega Guru

Bryce Godfrey Abhiram Bharadwaj Diddigi



Hi Both, I am trying to do this exact thing but with custom table. I have followed all above instructions but still not able to get this working.



Post Transformation - Source Instance sys_id of the record, import table sys_id of the record and target table sys_id of the record are different.



I am trying to maintain the sys_ids of the records in this custom table in sync across both instances. Is there anything i am missing?


The import set sys_ids will always be different. I need to see your code, to identify if you are doing something wrong.