New records are getting created with sys ids?

Nani6 · ‎11-05-2015

Hi,

I have set up data import from prod to lower environments (Data source is XMLs), everything is fine I mean new records are getting created but some of the records are getting created with sys ids and also sys ids of these records are different in prod and in lower environments. Any help is greatly appreciable.

Thanks in advance.

Gurpreet07 · ‎11-05-2015

Hello Shrikanth,

The sys_id is received in source XMLs for referenced fields.In Field mapping of a reference field , if you haven't put any thing in Referenced value field name then by default system will compare the value from the source table with the display value of the target table's reference field and thus it seems like sys_id from source table is compared with name(display value) of the value in target table's reference field.

you need to do following

1. For Field mappings of referenced fields put sys_id in Referenced value field name. You may need to edit list layout of the field mappings related list to bring this field in the list.

Creating New Transform Maps - ServiceNow Wiki

2. If you want the same sys_id of the target record as in your source instance then you need to create an onBefore transform script with following code.

if (action == "insert"){target.setNewGuidValue(source.u_sys_id);}

Importing from Another ServiceNow Instance - ServiceNow Wiki

View solution in original post

epam · ‎11-05-2015

Hi shrikanth,

sys_id is unique identifier of the record and it is not newly created while importing.

You can open your XML file and see any record's sys_id that will be imported.

Nani6 · ‎11-05-2015

Hi epam,

Thanks for the reply. Yes, sys_id is unique identifier of the record but in our case for newly inserted records sys_id is different when I compared the sys_id of the record. Also some of the field values are populating with sys_ids.

Kalaiarasan Pus · ‎11-05-2015

Is there any specific reason why you are using data source to import XML? You can directly import the XML without using datasource. You data source will created new records and hence sys id's will be new.

Nani6 · ‎11-05-2015

Hi Kalaiarasan,

Thanks for the reply. Our requirement is to automate the process, so I have created a data source to import XML. Can we overcome this issue? If so Pls help me.