UCMDB and UD Practitioners Forum (Previously CMS)
cancel

I want to import data from excel sheet to HP uCMDB.

Highlighted
VikasTrivedi
Occasional Advisor

I want to import data from excel sheet to HP uCMDB.

Did anybody know how to we import data from excel sheet to uCMDb.

Please let me know thanks in advance.

 

 

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

4 REPLIES
Dmitry Shevchenko
HPE Expert

Re: I want to import data from excel sheet to HP uCMDB.

DDM Content guide from CP7, chapter 21 "Import from Excel Workbook".

If you don't have CP7 installed Import from CSV File Job may also help.
VikasTrivedi
Occasional Advisor

Re: I want to import data from excel sheet to HP uCMDB.

Thanks, may be this is helpful to me.

I will update accordingly.
AshishGupta
Collector

Re: I want to import data from excel sheet to HP uCMDB.

Hi Vikas,

I also have the same requirement , how is it going for you ,can you suggest.


Regards,
Ashish
Edward Gillis
Occasional Advisor

Re: I want to import data from excel sheet to HP uCMDB.

Yes using the CSV import from the Discovery Jobs Under the folder Discovery Tools - Import from CSVfile or the newer CP Excel job. Both show the formatting and labels for columns of data and how to use csv or xls.
Note you'll have to create a New CI for this data but then enrichment rules or other attributes can be used to load this to any CIT.
//Add this to "OnDomLoad" event