configuration data import

[pete_canavan]

As part of starting Change Management, we are attempting to get server hardware items into ServiceNow.

To start this I am taking Servers and have loaded a.csv file in and then built a transformation map, I've also added fields to the server form to accommodate fields that are not on the base template.

I've then run the transform and this has completed with no errors and imported all 270 rows.

The issues i have are:

i) When I select the server link in the modules window it doesn't pick these servers up, in fact the only way i can see them is if i select the All menu option under base servers.

ii) When i try to open one it does not bring up the majority of information pertaining to that server.

When i added fields to the form and then built the transformation map i noted that information from the loaded table was being transformed into fields on multiple tables including Location, Configuration Item, Server and Computer and I am guessing this is where I've messed up?

[Community Alums]

Good luck! Let us know how it goes. You may want to remove that Target table from your Field Map list to avoid temptation to change it.

[Michael Fry1]

Agree with Ben that your target table should be Configuration item as you have set. You can use a script to route CIs to the appropriate table or by adding the Device Type field in your transform map and spreadsheet if you have more than 1 class during import.   The script looks like this:

if (source.u_device_type == 'Windows Server')

    target.sys_class_name = "cmdb_ci_win_server";

Where the device type on your spreadsheet says Windows Server. You can also leave it blank, and make your script like this:

if (source.u_device_type == '')

    target.sys_class_name = "cmdb_ci_win_server";

Hope that helps