Asset imports and CI updates

eschoon
Kilo Contributor

‎11-29-2016 07:47 PM

I've built a basic transform map to import assets into the hardware assets and it works ok.   This also creates a CI for the asset (fantastic) but i'd like to autofill some of the CI data from the excel file data import.   I tried mapping to Computer CI in the map but that's not working as i don't believe you can make to multiple destination tables in 1 transform map.   I created a 2nd map for CI and ran it but it just inserts a new CI record not linked to the Asset (so i end up with duplicates).

What is the best method to use a csv data load for assets but then populate more data for the corresponding CI created with the asset?

Labels:
0 Helpfuls
  • 4,070 Views
16 REPLIES 16

amaradiswamy
Kilo Sage

‎11-29-2016 08:49 PM

Hi Eric,



You can change the AssetandCIsynchronizer script include to autopopulate some CI fields. This is the best process as this will work   when we are importing data through servicenow/ creating assets manually.



Thanks and regards


Swamy


0 Helpfuls

akash_mehta
ServiceNow Employee
ServiceNow Employee

‎11-30-2016 12:30 PM

Eric:   The other possibility (and more complex than the 2nd transform map as mentioned earlier) is using a onAfter Transform Script.   Use target.sys_id to get the current record that as been inserted and you can do a gliderecord lookup in the configuration item table where asset = target.sys_id.



There is some info in the following wiki article:   http://wiki.servicenow.com/?title=Transform_Map_Scripts#gsc.tab=0



Hope that helps.


0 Helpfuls