Import CI(s) From CSV

Import CI(s) From CSV

Asset Explorer allows you to import the CI information saved as CSV files from an existing database or from other applications.
In the CMDB tab, go to Import > CI(s) from CSV. Alternatively, you can also navigate to Admin > CMDB > Import CI(s) from CSV.

Step 1: Locating the CSV file
  1. In the CI Import Wizard, select the CI Type to which you want to import the CIs to.
  2. Click Choose File to locate the CSV file on your device.
  3. Click Submit.
Step 2: Mapping the fields
  1. Select the date format for the date fields. Ensure that the date fields in the CSV file are of the same format.
  2. The columns in the CSV fields are displayed as drop-downs. Map the CI fields with the relevant columns.
  3. Click Import.
Additional Pointers:
  1. If the CI Type chosen is a parent and if a CI row in the CSV file corresponds to a sub CI Type, then the same can be mapped during customize mapping. Ensure that the sub CI Type specified in the CSV file is already configured in the application.   
  2. If existing CIs are imported again under a different CI Type, the CIs are grouped under the new CI Type.
If there are any failure records while importing the CIs, do not re-import the same CSV file. Download the FailedCIsList.csv file available in the Imported result page, correct the errors and then import to avoid duplicate CIs.

    • Related Articles

    • Import CI Relationships

      CI Relationships denote the dependencies between CIs. The relationships allow the users to understand the inter-dependencies between the CIs. Asset Explorer allows you to import CI relationships from a XLS file to add relationship between the CIs. ...

    • Import License

      Software managed in the organization and its details can be imported through a CSv file. Role Required: SDAdmin To import licenses, Go to Admin > Software > Import License(s) From CSV. Click Choose File to browse and locate the CSV file. Click ...

    • Modify Software CI Type

      You can modify the CI type of software applications directly from the list view. Role Required: SDAdmin, Technicians with Complete Access to Assets. Go to Software > Scanned Software. Select the software application(s) whose CI type should be ...

    • Adding CI Type

      On the CI Type list view, click Add New CI Type link on the top-right corner. Enter the CI Type Name. This field is mandatory. If the structure of the CI Type is granulated, then you can further drill it into sub-types using the Parent Type ...

    • Change CI as Server

      Convert CIs misidentified as servers in AssetExplorer. Use Cases: An all-in-one PC used as a server was identified by AssetExplorer as a workstation. A server was identified by AssetExplorer as a virtual machine. A server's alternate domain name was ...