Import asset from Excel, update CI

[Russell Abbott]

All,

I get an Excel file from a Computer vendor containing all the fields I need to create assets from that file. Each new Asset also creates a record on CMDB_CI_COMPUTER and all of the fields we need are populated.

I have an issue with the Cost field.

If the Cost field contains a value in the Excel file, that also gets populated on the CI.

If the Cost field contains a value of $0 or is empty, the cost on the CI is blank.

How can I make sure that the CI cost value is inherited from the Asset Model in this situation?

That would match what happens currently if I do manual import of an Excel file using our Import Wizard, or manually create an Asset.

Thanks!

[shloke04]

Hi @Russell Abbott ,

1. Navigate to the module named "Asset-CI Field Mapping" as shown below:

2. You can define the attribute here which you want to sync from Asset to CI and then when ever a update or insert happens whether manually or through Import the same will get moved to CI as well as shown below:

[Russell Abbott]

Here's the outcome I get from adding this field mapping.

For an import with blank or $0 in the cost field, the Asset takes the cost from the Model. The CI has $0.

When I make a further update to the Asset record, by changing any field and clicking 'Save', then the CI takes the cost from $0 to what I have on the Asset record, so it's almost there, it sounds like an extra save operation may be needed on the asset record after it's been imported?

Thanks