AssetExplorer

    Importing Asset details From CSV

     

     AssetExplorer helps you to import your asset details saved in CSV (Comma Separated values) format. If you have asset details in .XLS files, open it with Microsoft Excel and save it as .CSV files and then import it.

      1. Click on Admin tab -> Click Import From CSV icon in the Configuration Wizard page. This opens Import Wizard page.

      2. Select the Resource Category such as NON-IT from the combo box. This is a mandatory field.

      3. Select the Resource Type such as Components or Assets from the combo box. This is a mandatory field.

      4. Locate the .CSV file using the Browse button.

      5. Click on Step2 button to go to the next page. Click Previous button if you need to go the previous page.

      6. Specify the asset Details. The columns in .CSV file are populated in the select boxes beside each field label. Advent Net Manage Engine Asset Explorer asset field�s needs mapping with the field names from the .CSV file.

      7. Map the Product Type, Product Name, Asset Name from the combo box. All the three are mandatory fields.

      8. Map the Asset Tag, Asset Serial No, Bar Code, Vendor Name, Asset Cost, Warranty Expiry Date, Expiry Date, Location, Assigned to User, Assigned to Department from the combo box.

      9. Map the Acquisition Date field with the relevant field in the .CSV file. Also map the order of the acquisition date i.e. date/month/year available in the .CSV file.

      10. Click Step3 to go the next page. Click Previous button if you need to go the previous page.

      11. Click Import Now button to import the existing data from the .CSV file. Once the data is imported, you can see the Import Wizard page with result break-up.   

     

    Copyright © 2017, ZOHO Corp. All Rights Reserved.