question Sys ID is changing while moving data from one instance to another in ITSM forum

Sys ID is changing while moving data from one instance to another

Ajai S Nair — Tue, 23 Jun 2015 07:16:35 GMT

Hi All,

When we are trying to move data from one instance to another by uploading through Excel sheet, the Sys ID is changed. If we are using XML then there is no change in Sys IDs.Can anyone help me out to find out the reason?

Regards,

Ajai

Re: Sys ID is changing while moving data from one instance to another

Pradeep Sharma — Tue, 23 Jun 2015 07:20:10 GMT

Hi Ajai,

That is the expected behavior. You have to add a script to change the behavior. Please see the section 5.4 for more info.

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

Re: Sys ID is changing while moving data from one instance to another

bernyalvarado — Tue, 23 Jun 2015 07:21:51 GMT

Hi Ajai, the following thread should help you: Data Import Transform Map with sys_id

I hope it's useful!

Thanks,

Berny

Re: Sys ID is changing while moving data from one instance to another

Deepak Ingale1 — Tue, 23 Jun 2015 07:24:19 GMT

If that is a single record, you can always export that in XML and then import it in destination. It will keep your sys_id intact.

In Eureka, you have to do import operation with elevated privileges. In Fuji, normal admin login is sufficient to import it.

Re: Sys ID is changing while moving data from one instance to another

Ajai S Nair — Tue, 23 Jun 2015 07:26:13 GMT

Hi Pradeep,

Thanks for the link.

I am trying to load the data directly in a list by right click->import. It is not through transform map. So is there anything for this?

Regards,

Ajai

Re: Sys ID is changing while moving data from one instance to another

Deepak Ingale1 — Tue, 23 Jun 2015 07:31:34 GMT

Risk associated with solution I suggested is, if there is any Reference field and that 'sys_id' is not listed in destination, it will not throw any error of missing sys_id , rather once you are done with manual import, you will see just a 'sys_id' present on the reference field.

Re: Sys ID is changing while moving data from one instance to another

Anurag Tripathi — Tue, 23 Jun 2015 08:23:59 GMT

This is the expected behavior, as when you export in excel the sys_id does not get exported. Now when you import this , new sys_id's will be generated for these records.

Re: Sys ID is changing while moving data from one instance to another

Ashish Kumar Ag — Tue, 23 Jun 2015 08:47:54 GMT

I think you are confused with update set and Import of excel.

During you committee any update set it also holds the sys_id. so in different instance you have same sys_id.(Like through XML)

Importing through excel is just like creating a record manually, so sys_id is random.

This is expected.