Hitachi

JP1 Version 12 JP1/IT Desktop Management 2 Administration Guide


11.1.9 Batch updating stocktaking dates by using a CSV file

You can use a CSV file to batch-update the stocktaking dates of the hardware asset information and software license information.

We recommend this method if you use bar codes, instead of JP1/IT Desktop Management 2, to manage asset numbers. Export the information read by a barcode reader into a CSV file. The CSV file must be in the either of the following:

For hardware asset information

The asset number list of the hardware asset information whose stocktaking date needs to be updated

For software license information

The license number list of the software license information whose stocking date needs to be updated

To batch-update the stocktaking dates by using a CSV file:

  1. Display the Assets module.

  2. From Hardware Asset or Software License in the menu area, select the group that contains the asset information whose stocktaking date needs to be updated.

  3. From Action, select Update Tracked Date (from CSV).

  4. In the displayed dialog box, click the Select button, and then specify the CSV file that was created in advance.

    You can download a sample of the CSV file by clicking the link of Download CSV Sample File.

  5. Enter the stocktaking date, and then click OK.

    If you select Add Notes, information such as the stocktaking date, stocktaking method, and reasons for stocktaking can be recorded. The information entered here will be added to the Notes tab.

The stocktaking dates of the asset information corresponding to the asset numbers and license numbers that are contained in the CSV file are updated in a batch.

Important

If an error occurs when updating the stocktaking date, an asset which is not managed by JP1/IT Desktop Management 2 exists. Check the asset numbers, and register the unmanaged asset.

Tip

For hardware asset information, you can set the stocktaking date to be automatically updated. JP1/IT Desktop Management 2 determines whether a device exists from the network connection of the device or the data entry of the device user. When the existence of the device is confirmed, the stocktaking date is automatically updated.

Tip

You can also batch update the stocktaking dates by importing the hardware asset information and software license information. In this case, you can set a different stocktaking date for the information of each asset.

Related Topics: