Import Assets from CSV (Comma Separated Value) Files
You have an option to import all resource data from csv file to AssetExplorer.
To import data from CSV file,
Login to the AssetExplorer application using user name and password.
Click the Admin tab in the header pane. This opens the configurations wizard page.
Under the Asset Management block, click the Import from CSV file icon. This opens the Resource Import Wizard page.
Step 1: Specify the Resource Category & Type
Select the Resource Category to be imported, from the combo box. Ex IT or Non-IT.
Select the Resource Type from the combo box. Say Components, Other IT Assets, Workstations and so on.
Step 2: Locate the CSV file
Click the Browse button in the wizard.
Select the CSV file in the file chooser window and click Open.
Click Step 2 button.
Step 3: Customize Mapping
The CSV column names are populated in the select boxes beside each label. Map the AssetExplorer requester fields with the field names from the CSV file.
Click Step 3 button.
Step 4: Import
Click Import Now button. The values from the CSV file will be imported to the requester details. Once the import is complete, you get the data on number of records were added, records overwritten, and resource failed on import will be displayed.
If at any point you wish to stop importing from the CSV file, click the Close button.