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

    • FIPS Compliance

      What is FIPS? Federal Information Processing Standards (FIPS) is established by the US government to enhance the security posture of organizations. It provides guidelines and best practices for securing data, employing strong cryptographic methods, ...

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

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

    • Scheduling Reports

      Using Schedule Report Settings, you can automate generating multiple reports, in various formats, at scheduled times. These reports can be generated in PDF, XLS, XLSX, HTML, Inline HTML, CSV, DOC, DOCX, or XML formats and shared via email or saved to ...