Hitachi

JP1 Version 12 JP1/IT Desktop Management 2 - Asset Console Configuration and Administration Guide


2.1.1 Importing data from another system into the asset management database

You can register the data migrated from other systems in a batch operation by importing the data into the asset management database. Provided you are working in a system environment that allows you to log in to Asset Console, you can import data from any location.

You can use the Import window to import data from a CSV file.

To import data, you must first create conditions and then import the data based on the conditions. Samples of import conditions are provided for each type of information. For details on the asset types used in these samples, see 16.10.2(1) Selecting the asset type.

In addition to using the Import window, you can also import data by executing jamCsvImport.bat or the jamimport command. For details about these data import methods, see 9.1.1 Import flow.

The procedure below explains how to import information managed by another system into the asset management database. In the example, the device information being managed includes machine numbers (a unique value assigned to each IT asset), names, PC statuses (Used or Unused), and MAC addresses.

Figure 2‒1: Workflow for importing information regarding devices managed by another system

[Figure]

  1. Create a CSV file.

    Only CSV data can be imported into the asset management database. As such, you must first create a CSV file containing the data you want to import. You can use any character strings for the item names in the CSV file. For details about the CSV file format, see 16.10.1(1) CSV file format.

    The following figure shows an example of a created CSV file.

    Figure 2‒2: Example of a created CSV file

    [Figure]

  2. Change the Used and Unused character strings under PC Status.

    To unify the statuses with those already being used in Asset Console, the PC statuses Used and Unused in the CSV file must be changed to Active and Stock, respectively.

    To inherit the pre-migration names, use the Code window to change the character strings used as the statuses. For details about how to use the Code window, see 16.8.2 Changing a code's display value.

  3. Create import conditions.

    To register data into the asset management database, create import conditions and assign the item names in the CSV file to the managed items. To create import conditions, first click the Pattern button in the Import window to display the Select Category dialog box. After that, select Device information in the Category column. Next, click the Browse button for the managed items to display the Setting Assignment dialog box.

    When specifying the import conditions, assign information to the managed items as shown below.

    Table 2‒1: Settings for assigned items when the conditions are created

    Managed items

    Setting for assigned items

    Asset information.Asset No.

    Specify Machine No. for CSV items.

    Asset information.User name

    Specify Name for CSV items.

    Asset information.Usage management

    Specify Used for Constant value.

    Asset information.Status

    • Specify PC Status for CSV items.

    • Select the Assigned items check box, and select Active.

    Asset information.Reg. date

    Specify 2006/01/01 for Constant value.

    Hardware information.MAC address

    Specify MAC Address for CSV items.

    Note the following when specifying the import conditions:

    • A star ([Figure]) indicates an item that must be specified.

    • If each asset is assigned a unique value as its asset number, the value that was used to manage the asset in another system can then be used as the asset number in Asset Console. If you do not register any values, asset numbers are provided automatically.

    • When you import MAC addresses, the management information collected from JP1/IT Desktop Management 2 - Manager is assigned as the information of the imported devices.

    For details about how to create import conditions, see 16.10.2 Creating import conditions.

    After you save the conditions, click the Back button to return to the previous window.

  4. Import the data.

    In the Import window, specify the created conditions, and import the data. For details about how to import data, see 16.10.3 Executing imports.

  5. Check the import results.

    In the Result Import window, check the results of the import operation. For details about how to check the import results, see 16.12 Checking the import results (Result Import).

  6. Manage the devices.

    By using the Device Totals window, you can calculate the total number of devices you own, change device information from the Batch Update window, and perform other device management operations.

Repeat steps 1 to 4 of the import procedure until you have imported all of the information.