import data from excel sheet to 5 different cmdb tables

Nilofer1
Giga Expert

I have data in an excel sheet which contains 5 columns. Each column represents a cmdb class. I want to upload the excel sheet using transform maps and then upload first column data into one target cmdb class and second column data into another cmdb class and so on. 

 

How do i achieve this?

1 ACCEPTED SOLUTION

ersureshbe
Giga Sage
Giga Sage

Hi, In the import set table you should select the target table as cmdb_ci and the excel sheet column name should sync with cmdb_ci tables database name i.e, sys_class_name column should hold the class name of CI.

Regards,
Suresh.

View solution in original post

2 REPLIES 2

SatyakiBose
Mega Sage

Hello @Nilofer1 

Can you attach a screenshot of how your excel looks like, or can you attach the excel to this case, and describe your requirements in details.

ersureshbe
Giga Sage
Giga Sage

Hi, In the import set table you should select the target table as cmdb_ci and the excel sheet column name should sync with cmdb_ci tables database name i.e, sys_class_name column should hold the class name of CI.

Regards,
Suresh.