Importing Workstation Details from CSV

You can import your workstation 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. From the Assets list view page click the Import from CSV link on the top right hand side of the page. This opens the Resource Import Wizard page.

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

3. Select the Resource Type such as Components or IT- Assets (Workstation & Other IT 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 workstation 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. Select the Workstation Name from the combo box. This is a mandatory field.

8. Note: Use FQD Names (Fully Qualified Domain Name) for workstations. While scanning Asset Explorer can identify only the FDQ Names else the existing workstation will be added as a new workstation (duplicate copy).

9. Workstation Name will be the identifier for workstations. i.e. no two workstation can have the same name if so it will be replaced by the new name.

10. Select the Service Tag, Model, Manufacturer, Operating System, Location, and Assigned to   User and Assigned to Department from the combo box.

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

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