- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-19-2023 08:38 PM - edited 02-19-2023 08:42 PM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2023 05:33 AM
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.
Suresh.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2023 01:12 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2023 05:33 AM
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.
Suresh.