UCMDB and UD Practitioners Forum (Previously CMS)
cancel

UCMDB - Import from CSV trouble

SOLVED
Go to solution
Highlighted
GiuBal
Collector

UCMDB - Import from CSV trouble

Hello guys,

probably I'm posting a dumb question ...
After host discovering I need to add supplemental information that discovery is not able to retrieve like Accounting data.
To do that I added a new attribute manually and made a new import job based on the out-of-the-box sample csv import.

The csv file has 2 columns:
0:host_key, 1:cespite

ciType is "host"

for every row in file column 0 is mac-address obtained from previous host discovery.

Running the job I get success but host CIs are not update.

Is it possible from the csv file adding a value to a previous discovered object, or is possible create a new one only ?

Thanks for your answer

 

 

 

P.S. This thread has been moevd from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp Forum Moderator

7 REPLIES
Alexander Arkhi
Honored Contributor

Re: UCMDB - Import from CSV trouble

As long as you discover hosts, you need to follow this guideline:
* If your host_key is defined as " DomainName", you should set host_iscomplete to false
* If your host_key is defined as lowest mac address of machine (used as host_key on already created CI), you should set host_iscomplete to true

The same goes for "import from ***" jobs.
GiuBal
Collector

Re: UCMDB - Import from CSV trouble

hello Alexander,

thanks for your answer, so if I have understood I must add a new column to the csv file with host_iscomplete attribute equal true.

Cheers

Alexander Arkhi
Honored Contributor
Solution

Re: UCMDB - Import from CSV trouble

You are totally correct, just note that attribute type is boolean.
And whenever your host key in UCMDB is defined as " DomainName", corresponding row in CSV file should contain false for host_iscomplete
GiuBal
Collector

Re: UCMDB - Import from CSV trouble

Great !!! It works, thank you Alexander, 10 points for you.
Colin Blignault
Occasional Contributor

Re: UCMDB - Import from CSV trouble

hi GiuBal can you please contact me regarding this. email address is accessible via my profile

thx
GiuBal
Collector

Re: UCMDB - Import from CSV trouble

Hi Colin, I don't see any e-mail address on your profile.
Colin Blignault
Occasional Contributor

Re: UCMDB - Import from CSV trouble

ok, try colinb_69@hotmail.com

i would like to have some correspondence around this post, without clutering up the forum

thx
//Add this to "OnDomLoad" event