Error XLS

Error XLS

If an entry fails, an error is reported, and all the other entries are processed. It is assumed that all CIs in the XLS already exist. In case of IT assets, the user can specify the CI name as a simple Host name and FQDN is not required. Only the first sheet in the xls file is considered. The errors are generated in XLS format as given below:

Name of CI1
Relationship
Name of CI2
Description of the error
 
The File name will be Failed_Rows.xls. The file is stored in '/bin/Attachments/CMDB/<user_id>/'. Only the latest files uploaded are stored and the older files are deleted, whenever new files are uploaded.

While importing the CI relationships for the first time, the header fields are asked from the user and stored in the database so that the user doesn't have to give header fields on the subsequent imports.

Once the import is done, an entry is made in the system log, titled Import CI Relationships that contains the count of successful and failed imports.  

    • Related Articles

    • Import Contracts

      You can import contracts in bulk from Microsoft Excel files. Go to Contracts and click Import from XLS. Locate the XLS file on your device. Click Submit. Map the Excel columns with the relevant fields. Click Import. After the contracts are imported, ...

    • 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. ...

    • Scheduling Reports

      Schedule report settings allow you to automatically generate multiple reports at a scheduled time. These reports can be generated in PDF, XLS, XLSX, HTML, Inline HTML, or CSV formats and can be sent via email. Role Required: SDAdmin, Technicians with ...

    • System Log Viewer

      View the error logs generated by AssetExplorer. To view performance logs and to schedule performance monitoring click on performance monitoring tool View Error Logs Click the Community tab in the header pane. Click System Log Viewer under ...

    • Edit, Export, or Delete a License

      Role Required: SDAdmin, Technicians with Complete Access to Assets. Edit a License Go to Software > Software Licenses. Click your preferred software name to view its details. Click Edit and make changes as required. Finally, click Save. The software ...