11.4.1 Importing hardware asset information
Importing hardware asset information in a CSV file allows you to add or collectively edit hardware asset information.
You can import hardware asset information by using the Import Assets wizard.
- Tip
-
You can also import hardware asset information by executing the ioutils importasset command. We recommend that you use this command if you need to regularly import hardware asset information from CSV files.
The Import Assets wizard relates items in a CSV file to the items managed in JP1/IT Desktop Management 2 after the CSV file is uploaded. In addition, the wizard specifies a key (mapping key) that is used to check whether the information to be imported corresponds to any existing information. After import settings are complete, check the settings, and if there are no problems, import the information.
To import hardware asset information:
-
Display the Assets module.
-
In the menu area, from Hardware Asset Information, select any group.
-
Select Import Hardware Asset List from Action, and then start the Import Assets wizard.
-
In the What is this Wizard? view, check the import procedure, and then click the Next button.
-
In the Upload CSV file view, specify a CSV file that you want to import, and then click the Next button.
You can download a sample CSV file from this view. Use it as a reference when creating a CSV file.
-
In the Map Fields view, specify Mapping Key, CSV Fields, Header Line, and Import Starting Line, and then click the Next button.
You can also select a template that has already been created from Template Name.
You can update only registered assets by selecting the Import only the asset information that matches the mapping key value check box.
-
In the Save Template dialog box, specify the template name and description, and then click the Yes button.
If you do not want to save the template, click the No button.
-
In the Confirm Settings view, check the settings, and then click the Import button.
If part of the data fails to be imported, details are displayed in Check Result Details. Before importing the data again, we recommend that you first modify the CSV file by checking Check Result Details, and then upload the CSV file again by clicking the Upload and Pre-Check CSV File button. To output the results of the check, click the Export button.
- Tip
-
When the Import only the asset information that matches the mapping key value check box is selected in the Map Fields view, asset information that is not registered is not imported. The number of rows that are not imported is displayed in Skipped of Check Result Summary.
-
In the Complete view, check the import results, and then click the Close button.
The data in the CSV file is imported. To check the import status, click the Go to Last Import Log button.
Check whether the imported information is correctly registered. If an incorrect record exists, modify the CSV file, and then import the information again.
- Tip
-
You can also start the Import Assets wizard from the Settings module by selecting Assets and then Last Import Log. If you started the wizard from the Settings module, in the Upload CSV file view, specify Hardware Asset Information for Asset Type.
- Note
-
If a device corresponding to the mapping key exists in a detected device when the list of hardware assets is imported, an update is performed for the asset information of the device. However, this asset information is not displayed in the hardware asset list window until the device is set to be managed.
Related Topics: